emparcdata.cs

来自「专业的办公oa代码下载 c#语言编写 三层结构」· CS 代码 · 共 48 行

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();
		}
	}
}