EmpBaseData.cs
上传用户:autodoor
上传日期:2022-08-04
资源大小:9973k
文件大小:6k
- 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();
-
- }
- }
- }