bluehilldataset.cs

蓝山人事管理系统

            
            internal tblDepartmentRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tabletblDepartment = ((tblDepartmentDataTable)(this.Table));
            }
            
            public int DeptID {
                get {
                    return ((int)(this[this.tabletblDepartment.DeptIDColumn]));
                }
                set {
                    this[this.tabletblDepartment.DeptIDColumn] = value;
                }
            }
            
            public string DeptName {
                get {
                    try {
                        return ((string)(this[this.tabletblDepartment.DeptNameColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblDepartment.DeptNameColumn] = value;
                }
            }
            
            public string Description {
                get {
                    try {
                        return ((string)(this[this.tabletblDepartment.DescriptionColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblDepartment.DescriptionColumn] = value;
                }
            }
            
            public int ManagerID {
                get {
                    try {
                        return ((int)(this[this.tabletblDepartment.ManagerIDColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblDepartment.ManagerIDColumn] = value;
                }
            }
            
            public bool IsDeptNameNull() {
                return this.IsNull(this.tabletblDepartment.DeptNameColumn);
            }
            
            public void SetDeptNameNull() {
                this[this.tabletblDepartment.DeptNameColumn] = System.Convert.DBNull;
            }
            
            public bool IsDescriptionNull() {
                return this.IsNull(this.tabletblDepartment.DescriptionColumn);
            }
            
            public void SetDescriptionNull() {
                this[this.tabletblDepartment.DescriptionColumn] = System.Convert.DBNull;
            }
            
            public bool IsManagerIDNull() {
                return this.IsNull(this.tabletblDepartment.ManagerIDColumn);
            }
            
            public void SetManagerIDNull() {
                this[this.tabletblDepartment.ManagerIDColumn] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class tblDepartmentRowChangeEvent : EventArgs {
            
            private tblDepartmentRow eventRow;
            
            private DataRowAction eventAction;
            
            public tblDepartmentRowChangeEvent(tblDepartmentRow row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public tblDepartmentRow Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class tblEmployeeDataTable : DataTable, System.Collections.IEnumerable {
            
            private DataColumn columnEmployeeID;
            
            private DataColumn columnName;
            
            private DataColumn columnLoginName;
            
            private DataColumn columnPassword;
            
            private DataColumn columnEmail;
            
            private DataColumn columnDeptID;
            
            private DataColumn columnBasicSalary;
            
            private DataColumn columnTitle;
            
            private DataColumn columnTelephone;
            
            private DataColumn columnOnboardDate;
            
            private DataColumn columnSelfIntro;
            
            private DataColumn columnVacationRemain;
            
            private DataColumn columnEmployeeLevel;
            
            private DataColumn columnPhotoImage;
            
            internal tblEmployeeDataTable() : 
                    base("tblEmployee") {
                this.InitClass();
            }
            
            internal tblEmployeeDataTable(DataTable table) : 
                    base(table.TableName) {
                if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
                    this.CaseSensitive = table.CaseSensitive;
                }
                if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
                    this.Locale = table.Locale;
                }
                if ((table.Namespace != table.DataSet.Namespace)) {
                    this.Namespace = table.Namespace;
                }
                this.Prefix = table.Prefix;
                this.MinimumCapacity = table.MinimumCapacity;
                this.DisplayExpression = table.DisplayExpression;
            }
            
            [System.ComponentModel.Browsable(false)]
            public int Count {
                get {
                    return this.Rows.Count;
                }
            }
            
            internal DataColumn EmployeeIDColumn {
                get {
                    return this.columnEmployeeID;
                }
            }
            
            internal DataColumn NameColumn {
                get {
                    return this.columnName;
                }
            }
            
            internal DataColumn LoginNameColumn {
                get {
                    return this.columnLoginName;
                }
            }
            
            internal DataColumn PasswordColumn {
                get {
                    return this.columnPassword;
                }
            }
            
            internal DataColumn EmailColumn {
                get {
                    return this.columnEmail;
                }
            }
            
            internal DataColumn DeptIDColumn {
                get {
                    return this.columnDeptID;
                }
            }
            
            internal DataColumn BasicSalaryColumn {
                get {
                    return this.columnBasicSalary;
                }
            }
            
            internal DataColumn TitleColumn {
                get {
                    return this.columnTitle;
                }
            }
            
            internal DataColumn TelephoneColumn {
                get {
                    return this.columnTelephone;
                }
            }
            
            internal DataColumn OnboardDateColumn {
                get {
                    return this.columnOnboardDate;
                }
            }
            
            internal DataColumn SelfIntroColumn {
                get {
                    return this.columnSelfIntro;
                }
            }
            
            internal DataColumn VacationRemainColumn {
                get {
                    return this.columnVacationRemain;
                }
            }
            
            internal DataColumn EmployeeLevelColumn {
                get {
                    return this.columnEmployeeLevel;
                }
            }
            
            internal DataColumn PhotoImageColumn {
                get {
                    return this.columnPhotoImage;
                }
            }
            
            public tblEmployeeRow this[int index] {
                get {
                    return ((tblEmployeeRow)(this.Rows[index]));
                }
            }
            
            public event tblEmployeeRowChangeEventHandler tblEmployeeRowChanged;
            
            public event tblEmployeeRowChangeEventHandler tblEmployeeRowChanging;
            
            public event tblEmployeeRowChangeEventHandler tblEmployeeRowDeleted;
            
            public event tblEmployeeRowChangeEventHandler tblEmployeeRowDeleting;
            
            public void AddtblEmployeeRow(tblEmployeeRow row) {
                this.Rows.Add(row);
            }
            
            public tblEmployeeRow AddtblEmployeeRow(string Name, string LoginName, System.Byte[] Password, string Email, int DeptID, int BasicSalary, string Title, string Telephone, System.DateTime OnboardDate, string SelfIntro, int VacationRemain, int EmployeeLevel, System.Byte[] PhotoImage) {
                tblEmployeeRow rowtblEmployeeRow = ((tblEmployeeRow)(this.NewRow()));
                rowtblEmployeeRow.ItemArray = new object[] {
                        null,
                        Name,
                        LoginName,
                        Password,
                        Email,
                        DeptID,
                        BasicSalary,
                        Title,
                        Telephone,
                        OnboardDate,
                        SelfIntro,
                        VacationRemain,
                        EmployeeLevel,
                        PhotoImage};
                this.Rows.Add(rowtblEmployeeRow);
                return rowtblEmployeeRow;
            }
            
            public tblEmployeeRow FindByEmployeeID(int EmployeeID) {
                return ((tblEmployeeRow)(this.Rows.Find(new object[] {
                            EmployeeID})));
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                tblEmployeeDataTable cln = ((tblEmployeeDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new tblEmployeeDataTable();
            }
            
            internal void InitVars() {
                this.columnEmployeeID = this.Columns["EmployeeID"];
                this.columnName = this.Columns["Name"];
                this.columnLoginName = this.Columns["LoginName"];
                this.columnPassword = this.Columns["Password"];
                this.columnEmail = this.Columns["Email"];
                this.columnDeptID = this.Columns["DeptID"];
                this.columnBasicSalary = this.Columns["BasicSalary"];
                this.columnTitle = this.Columns["Title"];
                this.columnTelephone = this.Columns["Telephone"];
                this.columnOnboardDate = this.Columns["OnboardDate"];
                this.columnSelfIntro = this.Columns["SelfIntro"];
                this.columnVacationRemain = this.Columns["VacationRemain"];
                this.columnEmployeeLevel = this.Columns["EmployeeLevel"];
                this.columnPhotoImage = this.Columns["PhotoImage"];
            }
            
            private void InitClass() {
                this.columnEmployeeID = new DataColumn("EmployeeID", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnEmployeeID);
                this.columnName = new DataColumn("Name", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnName);
                this.columnLoginName = new DataColumn("LoginName", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnLoginName);
                this.columnPassword = new DataColumn("Password", typeof(System.Byte[]), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnPassword);
                this.columnEmail = new DataColumn("Email", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnEmail);
                this.columnDeptID = new DataColumn("DeptID", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnDeptID);
                this.columnBasicSalary = new DataColumn("BasicSalary", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnBasicSalary);
                this.columnTitle = new DataColumn("Title", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnTitle);
                this.columnTelephone = new DataColumn("Telephone", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnTelephone);
                this.columnOnboardDate = new DataColumn("OnboardDate", typeof(System.DateTime), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnOnboardDate);