empvisadata.cs

来自「一个采用三层架构开放的办公自动化系统」· CS 代码 · 共 44 行

using System;
using System.Data;
using System.Data.SqlClient;


namespace qminoa.Common.Data
{
	/// <summary>
	/// EmpVisaData 的摘要说明。
	/// </summary>
	public class EmpVisaData : DataSet 
	{
		public const string EMPVISA_TABLE_NAME = "mrVisa";
		public const string VISAID_FIELD = "VisaID";
		public const string FDATE_FIELD = "FDate";
		public const string TDATE_FIELD = "TDate";
		public const string COMMPANY_FIELD = "Company";
		public const string DEPNAME_FIELD = "DepName";
		public const string POSITION_FIELD = "Position";
		public const string VISANOTE_FIELD = "VisaNote";

		private void BuildTable()
		{
			DataTable table = new DataTable(EMPVISA_TABLE_NAME);
			DataColumnCollection cols = table.Columns;
				
			cols.Add(VISAID_FIELD,typeof(System.Int32));
			cols.Add(EmpBaseData.EMPID_FIELD,typeof(System.Int32));
			cols.Add(FDATE_FIELD,typeof(System.DateTime));
			cols.Add(TDATE_FIELD,typeof(System.DateTime));
			cols.Add(COMMPANY_FIELD,typeof(System.String));
			cols.Add(DEPNAME_FIELD,typeof(System.String));
			cols.Add(POSITION_FIELD,typeof(System.String));
			cols.Add(VISANOTE_FIELD,typeof(System.String));

			Tables.Add(table);
		}
		public EmpVisaData()
		{
			BuildTable();
		}
	}
}