scheduledata.cs

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

using System;
using System.Data;

namespace qminoa.Common.Data
{
	public class ScheduleData:DataSet
	{
		public const string SCHEDULE_TABLE="ScheduleTable";
		public const string SCHID_FIELD="SchID";
		public const string EMPID_FIELD="EmpID";
		public const string SUBJECT_FIELD="Subject";
		public const string SCHTYPE_FIELD="SchType";
		public const string PLACE_FIELD="Place";
		public const string CONTENT_FIELD="Content";
		public const string PRIVFLAG_FIELD="PrivFlag";
		public const string REPEATFLAG_FIELD="RepeatFlag";
		public const string REQUENCATE_FIELD="RequenCate";
		public const string UPTODATE_FIELD="UpToDate";
		public const string REMINDFLAG_FIELD="RemindFlag";
		public const string REMINDDAY_FIELD="RemindDay";
		public const string FDATE_FIELD="FDate";
		public const string TDATE_FIELD="TDate";
		public const string CDATE_FIELD="cdate";
		public ScheduleData()
		{
			BuildDataTables();
		}
		protected void BuildDataTables()
		{
			DataTable table=new DataTable(SCHEDULE_TABLE);
			DataColumnCollection columns=table.Columns;
			columns.Add(SCHID_FIELD,typeof(System.Int16));
			columns.Add(EMPID_FIELD,typeof(System.Int16));
			columns.Add(SUBJECT_FIELD,typeof(System.String));
			columns.Add(SCHTYPE_FIELD,typeof(System.String));
			columns.Add(PLACE_FIELD,typeof(System.String));
			columns.Add(CONTENT_FIELD,typeof(System.String));
			columns.Add(PRIVFLAG_FIELD,typeof(System.Boolean));
			columns.Add(REPEATFLAG_FIELD,typeof(System.Boolean));
			columns.Add(REQUENCATE_FIELD,typeof(System.String));
			columns.Add(UPTODATE_FIELD,typeof(System.DateTime));
			columns.Add(REMINDFLAG_FIELD,typeof(System.Boolean));
			columns.Add(REMINDDAY_FIELD,typeof(System.Int16));
			columns.Add(FDATE_FIELD,typeof(System.DateTime));
			columns.Add(TDATE_FIELD,typeof(System.DateTime));
			columns.Add(CDATE_FIELD,typeof(System.DateTime));
			this.Tables.Add(table);
		}
	}
}