empbasedata.cs

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

using System;
using System.Data;



namespace qminoa.Common.Data
{
	/// <summary>
	/// EmpBaseData 的摘要说明。
	/// </summary>
	public class EmpBaseData : DataSet
	{
		public const string SESSION_KEY_EMPGRP = "Session:EmpGrp";
		public const string SESSION_KEY_EMPID = "Session:empID";
		public const string SESSION_KEY_FILEID = "Session:FileID";
		public const string SESSION_KEY_PREPAGE = "Session:PrePage";

//		public const string EMPPHOTO_TABLE_NAME  = "mrPhoto";
		public const string EMP_TABLE_NAME = "mrBaseInf";

		public const string PHOTO_SIZE_FIELD = "PhotoSize";
		public const string PHOTO_TYPE_FIELD = "PhotoType";
		public const string PHOTO_PATH_FIELD = "PhotoPath";
		public const string PHOTO_CONTENT_FIELD = "PhotoCont";

		public const string EMPID_FIELD = "EmpID";
		public const string EMPNAME_FIELD = "EmpName";
		public const string LOGINID_FIELD = "LoginID";
		public const string PASSWORD_FIELD = "Password";
		public const string SEX_FIELD = "Sex";
		public const string EMPCODE_FIELD = "EmpCode";
		public const string EMAIL_FIELD = "Email";
		public const string OFFICETEL_FIELD = "OfficeTel";
		public const string OFFICEFAX_FIELD = "OfficeFax";
		public const string MOBILE_FIELD = "Mobile";
		public const string POSITION_FIELD = "Position";

		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 TEL1_FIELD = "Tel1";
		public const string TEL2_FIELD = "Tel2";

		public const string BIRTHDAY_FIELD = "BirthDay";
		public const string IDCARDNO_FIELD = "IDCardNo";
		public const string NAPLACE_FIELD = "NaPlace";
		public const string PARTY_FIELD = "Party";

		public const string EDUCAT1_FIELD = "Educat1";
		public const string SCHOOL1_FIELD = "School1";
		public const string SPECIAL1_FIELD = "Special1";
		public const string GERTIME1_FIELD = "GerTime1";

		public const string EDUCAT2_FIELD = "Educat2";
		public const string SCHOOL2_FIELD = "School2";
		public const string SPECIAL2_FIELD = "Special2";
		public const string GERTIME2_FIELD = "GerTime2";

		public const string QULI1_FIELD = "Quli1";
		public const string QULI2_FIELD = "Quli2";
		public const string QULI3_FIELD = "Quli3";
		public const string QULI4_FIELD = "Quli4";

		public const string POSILEVL_FIELD = "PosiLevl";
		public const string SALALEVL_FIELD = "SalaLevl";
		public const string ENTERDATE_FIELD = "EnterDate";
		public const string ENTERMODE_FIELD = "EnterMode";
		public const string ENDOFLAG_FIELD = "EndoFlag";
		public const string HOUSFLAG_FIELD = "HousFlag";
		public const string HOSPFLAG_FIELD = "HospFlag";
		public const string UNEMFLAG_FIELD = "UnemFlag";
		public const string GRAVFLAG_FIELD = "GravFlag";

		public const string WELNOTE_FIELD = "WelNote";
		public const string PERSNOTE_FIELD= "PersNote";
		public const string EDUNOTE_FIELD = "EduNote";
		public const string ALLOWLOGIN_FIELD = "AllowLogin";
		



		private void BuildTable()
		{
			DataTable table = new DataTable(EMP_TABLE_NAME);

			DataColumnCollection cols = table.Columns;

			cols.Add(DepData.BRANCHID_FIELD,typeof(System.Int16));
			cols.Add(DepData.DEPID_FIELD,typeof(System.Int16));
			cols.Add(DepData.DEPNAME_FIELD,typeof(System.String));

			cols.Add(EMPID_FIELD,typeof(System.Int16));
			cols.Add(EMPNAME_FIELD,typeof(System.String));
			cols.Add(LOGINID_FIELD,typeof(System.String));
			cols.Add(PASSWORD_FIELD,typeof(System.String));
			cols.Add(SEX_FIELD,typeof(System.Boolean));
			cols.Add(EMPCODE_FIELD,typeof(System.String));
			cols.Add(EMAIL_FIELD,typeof(System.String));
			cols.Add(OFFICETEL_FIELD,typeof(System.String));
			cols.Add(OFFICEFAX_FIELD,typeof(System.String));
			cols.Add(MOBILE_FIELD,typeof(System.String));
			cols.Add(POSITION_FIELD,typeof(System.String));

			cols.Add(EmpBaseData.PROVINCE_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.CITY_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.DISTRICT_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.STREET_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.POSTCODE_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.TEL1_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.TEL2_FIELD,typeof(System.String));

			cols.Add(EmpBaseData.BIRTHDAY_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.IDCARDNO_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.NAPLACE_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.PARTY_FIELD,typeof(System.String));

			cols.Add(EmpBaseData.EDUCAT1_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.SCHOOL1_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.SPECIAL1_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.GERTIME1_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.EDUCAT2_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.SCHOOL2_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.SPECIAL2_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.GERTIME2_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.QULI1_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.QULI2_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.QULI3_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.QULI4_FIELD,typeof(System.String));

			cols.Add(EmpBaseData.ENTERDATE_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.ENTERMODE_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.ENDOFLAG_FIELD,typeof(System.Boolean));
			cols.Add(EmpBaseData.HOSPFLAG_FIELD,typeof(System.Boolean));
			cols.Add(EmpBaseData.HOUSFLAG_FIELD,typeof(System.Boolean));
			cols.Add(EmpBaseData.GRAVFLAG_FIELD,typeof(System.Boolean));
			cols.Add(EmpBaseData.UNEMFLAG_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.POSILEVL_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.SALALEVL_FIELD,typeof(System.String));

			cols.Add(EmpBaseData.EDUNOTE_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.PERSNOTE_FIELD,typeof(System.String));
			cols.Add(EmpBaseData.WELNOTE_FIELD,typeof(System.String));

			cols.Add(ALLOWLOGIN_FIELD,typeof(System.Boolean));
			Tables.Add(table);
		}

 

		public EmpBaseData()
		{
			BuildTable();
			
		}
	}
}