empcondata.cs

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

using System;
using System.Data;

namespace qminoa.Common.Data
{
	/// <summary>
	/// EmpConData 的摘要说明。
	/// </summary>
	public class EmpConData :DataSet
	{
		public const string EMPCONTACT_TABLE_NAME = "MrContact";
		public const string CONID_FIELD = "ConID";
		public const string CATETORY_FIELD = "Catetory";
		public const string FDATE_FIELD = "FDate";
		public const string TDATE_FIELD = "TDate";
		public const string POSILEVL_FIELD = "PosiLevl";
		public const string SALALEVL_FIELD = "SalaLevl";
		public const string ANNSALA_FIELD = "AnnSala";
		public const string STATUS_FIELD = "Status";
		public const string CONNOTE_FIELD = "ConNote";

		private void BuildTable()
		{
			DataTable table = new DataTable(EMPCONTACT_TABLE_NAME);
			DataColumnCollection cols = table.Columns;

			cols.Add(CONID_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(POSILEVL_FIELD,typeof(System.String));
			cols.Add(SALALEVL_FIELD,typeof(System.String));
			cols.Add(ANNSALA_FIELD,typeof(System.String));
			cols.Add(STATUS_FIELD,typeof(System.String));
			cols.Add(CONNOTE_FIELD,typeof(System.String));

			Tables.Add(table);
		}


		public EmpConData()
		{
			BuildTable();
		}
	}
}