EmpArcData.cs
上传用户:autodoor
上传日期:2022-08-04
资源大小:9973k
文件大小:1k
- using System;
- using System.Data;
- namespace qminoa.Common.Data
- {
- /// <summary>
- /// EmpArcData 的摘要说明。
- /// </summary>
- public class EmpArcData : DataSet
- {
- public const string EMPARCHIVE_TABLE_NAME = "mrArchive";
-
- public const string ARCID_FIELD = "ArcID";
- public const string CATETORY_FIELD = "Catetory";
- public const string FDATE_FIELD = "FDate";
- public const string TDATE_FIELD = "TDate";
- public const string BRANAME_FIELD = "BraName";
- public const string DEPNAME_FIELD = "DepName";
- public const string POSITION_FIELD = "Position";
- public const string REASON_FIELD = "Reason";
- public const string ARCNOTE_FIELD = "ArcNote";
- private void BuildTable()
- {
- DataTable table = new DataTable(EMPARCHIVE_TABLE_NAME);
- DataColumnCollection cols = table.Columns;
- cols.Add(ARCID_FIELD,typeof(System.Int32));
- cols.Add(EmpBaseData.EMPID_FIELD,typeof(System.Int32));
- cols.Add(CATETORY_FIELD,typeof(System.String));
- cols.Add(FDATE_FIELD,typeof(System.DateTime));
- cols.Add(TDATE_FIELD,typeof(System.DateTime));
- cols.Add(BRANAME_FIELD,typeof(System.String));
- cols.Add(DEPNAME_FIELD,typeof(System.String));
- cols.Add(POSITION_FIELD,typeof(System.String));
- cols.Add(REASON_FIELD,typeof(System.String));
- cols.Add(ARCNOTE_FIELD,typeof(System.String));
- Tables.Add(table);
- }
- public EmpArcData()
- {
- BuildTable();
- }
- }
- }