depdata.cs

专业的办公oa代码下载 c#语言编写 三层结构

using System;
using System.Data;

namespace qminoa.Common.Data
{
	/// <summary>
	/// DepData 的摘要说明。
	/// </summary>
	public class DepData : DataSet
	{
		public const string DEP_TABLE_NAME = "mrdep";
		public const string BRANCH_TABLE_NAME = "mrbranch";
		public const string SIMPLECODE_FIELD = "SimpleCode";
		public const string BRANCHNAME_FIELD = "BranchName";
 		public const string DEPID_FIELD = "Depid";
		public const string BRANCHID_FIELD = "Branchid";
		public const string DEPNAME_FIELD = "DepName";
		public const string MANAGER_FIELD = "Manager";
		public const string TEL1_FIELD = "Tel1";
		public const string TEL2_FIELD = "Tel2";
		public const string FAX_FIELD = "Fax";
		public const string PROVINCE_FIELD = "Province";
		public const string CITY_FIELD = "City";
		public const string DISTRICT_FIELD = "District";
		public const string STREET_FIELD = "Street";
		public const string POSTCODE_FIELD = "PostCode";
		public const string DELFLAG_FIELD = "DelFlag";

		private void BuildTable()
		{
			DataTable table = new DataTable(DEP_TABLE_NAME);
			DataColumnCollection cols = table.Columns;
			cols.Add(DEPID_FIELD,typeof(System.Int16));
			cols.Add(BRANCHID_FIELD,typeof(System.Int16));
			cols.Add(DEPNAME_FIELD,typeof(System.String));
			cols.Add(MANAGER_FIELD,typeof(System.String));
			cols.Add(TEL1_FIELD,typeof(System.String));
			cols.Add(TEL2_FIELD,typeof(System.String));
			cols.Add(FAX_FIELD,typeof(System.String));
			cols.Add(PROVINCE_FIELD,typeof(System.String));
			cols.Add(CITY_FIELD,typeof(System.String));
			cols.Add(DISTRICT_FIELD,typeof(System.String));
			cols.Add(STREET_FIELD,typeof(System.String));
			cols.Add(POSTCODE_FIELD,typeof(System.String));
			Tables.Add(table);
		}

		public DepData()
		{
			BuildTable();
		}
	}
}