?? filedata.cs
字號:
namespace qminoa.Common
{
/// <summary>
/// FileData 的摘要說明。
/// </summary>
///
using System;
using System.Data;
using System.Runtime.Serialization;
using qminoa;
[SerializableAttribute]
public class FileData:DataSet
{
public const string FMDOCFOLDER_TABLE="fmDocFolder";
public const string FOLDER_ID_FIELD = "FolderID"; //文件夾主鍵
public const string DOC_ID_FIELD ="DocID";//文檔的主鍵
public const string HIFOLDER_ID_FIELD = "HiFolderID"; //上一級的ID號
public const string FOLDER_TYPEID_FIELD="TypeId";
public const string FOLDERNAME_FIELD = "FName";//文件名
public const string NOTE_FIELD = "Note"; //備注
public const string IHERCTR_FIELD = "IherCtr"; //是否權限繼承
public const string CDATE_FIELD = "CDate";//創建日期
public const string UDATE_FIELD = "UDate";//更新日期
public const string EMPID_FIELD = "EmpID";//創建者的ID
public const string DDATE_FIELD = "DDate";//刪除日期
public const string STATUS_FIELD = "Status";//文件刪除后標識
public const string DEMP_ID_FIELD = " dempid ";//刪除者的ID，有管理權的人才能刪文件
//附加兩個子段
public const string ICOPATH_FIELD = "ico";
public const string TYPENAME_FIELD = "TypeName";//文件夾或文檔類型
//定義表fmDoc(文件夾中的文擋)
public const String FMDOC_TABLE = "fmDoc";
//public const String ID_FIELD3 = "ID";//主鍵
public const String DOC_ID_FIELD3 ="DocID";//文檔的主鍵
public const String FOLDER_ID_FIELD3 = "FolderID";//文件夾的id
public const String FNAME_FIELD3 = "FName";//文件名
public const String TYPEID_FIELD ="TypeID";//文件類型
public const String KEYWORD_FIELD ="Keyword";//關鍵字
public const String NOTE_FIELD3 = "Note";
public const String IHERCTR_FIELD3 = "IherCtr"; //是否權限繼承
public const String CDATE_FIELD3 = "CDate";//創建日期
public const String UDATE_FIELD3 = "UDate";//更新日期
public const String EMPID_FIELD3 = "EmpID";//創建者的ID
public const String DDATE_FIELD3 = "DDate";//刪除日期
public const String STATUS_FIELD3 = "Status";//文件刪除后標識
public const String DEMP_ID_FIELD3 = " dempid ";//刪除者的ID，有管理權的人才能刪文件
public const String TYPENAME_FIELD3 = "TypeName";
public const String ICOPATH_FIELD3 = "ico";
public const String DEMPID_FIELD="dempid";
public const string FMFILEATT_TABLE = "fmFileAtt";
public const string ID_FIELD4 ="TypeID";//主鍵
public const string ICO_FIELD = "Ico";//圖標
public const string TYPE_FIELD4 = "Type";//類型
public const string TYPENAME_FIELD4 = "TypeName";//中文名
public const string DOCTYPE_FIELD = "DocType";//文檔類型后綴
//定義表fmDocFolderCtr(文件夾權限控制)
public const String FMDOCFOLDERCTR_TABLE = "fmDocFolderCtr";
public const string CON_ID_FIELD = "ConID";//主鍵
public const string FOLDER_ID_FIELD2 = "FolderID";//文件ID
public const string DEP_ID_FIELD ="DepID";//部門ID
public const string EMP_ID_FIELD = "EmpID";//人員ID
public const string ADMIN_FLAG_FIELD = "Adminflag";//管理權限
public const string READ_FLAG_FIELD ="Readflag";//讀權限
public const string WRITE_FLAG_FIELD = "Writeflag";//寫權限
public const string EMPNAME_FIELD = "EmpName";
//定義表FileCont(上傳文件內容)
public const String FILECONT_TABLE = "FileCont";
public const string FID_FIELD ="Fid";//主鍵
public const string DOCID_FIELD = "DocId";//所在文檔的id
public const string FNAMEF_FIELD ="fname";//文件名
public const string FSIZE_FIELD = "size";//文件大小
public const string FTYPE_FIELD = "ftype";//文件類型
public const string FPATH_FIELD = "fpath";//文件路徑
public const string CDATEF_FIELD = "cdate";//創建時間
public const string CONT_FIELD = "cont";//關鍵字
//用戶信息的表
public const string FMEMPINFO_TABLE="fmEmpInfo";
public const string FMEMPINFO_EMPID_FIELD="EmpId";
public const string FMEMPINFO_DEPID_FIELD="DepId";
public const string FMEMPINFO_EMPNAME_FIELD="EmpName";
public const string DOCRIGHTCTR_TABLE="fmDocRightCtr";
public const string DOCRIGHTCTR_CONID_FIELD="ConId";
public const string DOCRIGHTCTR_DOCID_FIELD="docid";
public const string DOCRIGHTCTR_EMPID_FIELD="empid";
public const string DOCRIGHTCTR_EMPNAME_FIELD="empname";
public const string DOCRIGHTCTR_DEPID_FIELD="depid";
public const string DOCRIGHTCTR_DEPNAME_FIELD="depname";
public const string DOCRIGHTCTR_ADMINFLAG_FIELD="adminflag";
public const string DOCRIGHTCTR_WRITEFLAG_FIELD="writeflag";
public const string DOCRIGHTCTR_READFLAG_FIELD="readflag";
public FileData()
{
BuildDataTables();
}
private void BuildDataTables()
{
DataTable table;
DataColumnCollection columns;
//建立fmDocFolder_Table（文件夾表）
table = new DataTable(FMDOCFOLDER_TABLE);
columns = table.Columns;
columns.Add(FOLDER_ID_FIELD,typeof(System.Int32));//
columns.Add(DOC_ID_FIELD,typeof(System.Int32));//
columns.Add(HIFOLDER_ID_FIELD, typeof(System.Int32));
columns.Add(FOLDERNAME_FIELD, typeof(System.String));//
columns.Add(FOLDER_TYPEID_FIELD,typeof(System.Int32));
columns.Add(NOTE_FIELD, typeof(System.String));//
columns.Add(IHERCTR_FIELD, typeof(System.Boolean));
columns.Add(CDATE_FIELD, typeof(System.DateTime));//
columns.Add(UDATE_FIELD, typeof(System.DateTime));
columns.Add(EMPID_FIELD, typeof(System.Int32));//
columns.Add(DDATE_FIELD, typeof(System.DateTime));
columns.Add(STATUS_FIELD, typeof(System.Boolean));//
columns.Add(DEMP_ID_FIELD, typeof(System.Int32));
columns.Add(TYPENAME_FIELD,typeof(System.String));//
columns.Add(ICOPATH_FIELD,typeof(System.String));//
this.Tables.Add(table);
//建立fmDocFolderCtr(文件夾權限表)
table = new DataTable(FMDOCFOLDERCTR_TABLE);
columns = table.Columns;
columns.Add(CON_ID_FIELD,typeof(System.Int32));
columns.Add(FOLDER_ID_FIELD, typeof(System.Int32));
columns.Add(DEP_ID_FIELD, typeof(System.Int16));
columns.Add(EMP_ID_FIELD, typeof(System.Int32));
columns.Add(ADMIN_FLAG_FIELD, typeof(System.Boolean));
columns.Add(READ_FLAG_FIELD, typeof(System.Boolean));
columns.Add(WRITE_FLAG_FIELD, typeof(System.Boolean));
columns.Add(EMPNAME_FIELD,typeof(System.String));
this.Tables.Add(table);
table= new DataTable();
//建立fmDoc表（文件夾中的子文件）
table = new DataTable(FMDOC_TABLE);
columns = table.Columns;
columns.Add(DOC_ID_FIELD3,typeof(System.Int32));
columns.Add(FOLDER_ID_FIELD3,typeof(System.Int32));
columns.Add(FNAME_FIELD3,typeof(System.String));
columns.Add(TYPEID_FIELD,typeof(System.Int32));
columns.Add(KEYWORD_FIELD,typeof(System.String));
columns.Add(NOTE_FIELD3,typeof(System.String));
columns.Add(IHERCTR_FIELD3,typeof(System.Boolean));
columns.Add(CDATE_FIELD3,typeof(System.DateTime));
columns.Add(UDATE_FIELD3,typeof(System.DateTime));
columns.Add(EMPID_FIELD3,typeof(System.Int32));
columns.Add(DDATE_FIELD3,typeof(System.DateTime));
columns.Add(STATUS_FIELD3,typeof(System.Boolean));
columns.Add(DEMP_ID_FIELD3,typeof(System.Int32));
columns.Add(TYPENAME_FIELD3,typeof(System.String));
columns.Add(ICOPATH_FIELD3,typeof(System.String));
this.Tables.Add(table);
//建立fmFileAtt(文件類型表)
table = new DataTable(FMFILEATT_TABLE);
columns = table.Columns;
columns.Add(ID_FIELD4,typeof(System.Int32));
columns.Add(TYPENAME_FIELD4,typeof(System.String));
columns.Add(TYPE_FIELD4,typeof(System.String));
columns.Add(ICO_FIELD,typeof(System.String));
columns.Add(DOCTYPE_FIELD,typeof(System.String));
this.Tables.Add(table);
//建立FileCont(上傳文件表)
table = new DataTable(FILECONT_TABLE);
columns = table.Columns;
columns.Add(FID_FIELD,typeof(System.Int32));
columns.Add(DOCID_FIELD,typeof(System.Int32));
columns.Add(FNAMEF_FIELD,typeof(System.String));
columns.Add(FSIZE_FIELD,typeof(System.Int32));
columns.Add(FTYPE_FIELD,typeof(System.String));
columns.Add(FPATH_FIELD,typeof(System.String));
columns.Add(CDATEF_FIELD,typeof(System.DateTime));
columns.Add(KEYWORD_FIELD,typeof(System.String));
this.Tables.Add(table);
//用戶表
table = new DataTable(FMEMPINFO_TABLE);
columns = table.Columns;
columns.Add(FMEMPINFO_EMPID_FIELD,typeof(System.Int32));//
columns.Add(FMEMPINFO_DEPID_FIELD,typeof(System.Int32));//
columns.Add(FMEMPINFO_EMPNAME_FIELD, typeof(System.String));
this.Tables.Add(table);
table = new DataTable(DOCRIGHTCTR_TABLE);
columns = table.Columns;
columns.Add(DOCRIGHTCTR_CONID_FIELD,typeof(System.Int32));
columns.Add(DOCRIGHTCTR_DOCID_FIELD,typeof(System.Int32));
columns.Add(DOCRIGHTCTR_EMPID_FIELD,typeof(System.Int32));
columns.Add(DOCRIGHTCTR_EMPNAME_FIELD,typeof(System.String));
columns.Add(DOCRIGHTCTR_DEPID_FIELD,typeof(System.Int32));
columns.Add(DOCRIGHTCTR_DEPNAME_FIELD,typeof(System.String));
columns.Add(DOCRIGHTCTR_ADMINFLAG_FIELD,typeof(System.Boolean));
columns.Add(DOCRIGHTCTR_WRITEFLAG_FIELD,typeof(System.Boolean));
columns.Add(DOCRIGHTCTR_READFLAG_FIELD,typeof(System.Boolean));
this.Tables.Add(table);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -