dataset1.cs

蓝山人事管理系统

                            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);
                this.columnSelfIntro = new DataColumn("SelfIntro", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnSelfIntro);
                this.columnVacationRemain = new DataColumn("VacationRemain", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnVacationRemain);
                this.columnEmployeeLevel = new DataColumn("EmployeeLevel", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnEmployeeLevel);
                this.columnPhotoImage = new DataColumn("PhotoImage", typeof(System.Byte[]), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnPhotoImage);
                this.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.columnEmployeeID}, true));
                this.columnEmployeeID.AutoIncrement = true;
                this.columnEmployeeID.AllowDBNull = false;
                this.columnEmployeeID.ReadOnly = true;
                this.columnEmployeeID.Unique = true;
                this.columnName.AllowDBNull = false;
                this.columnLoginName.AllowDBNull = false;
                this.columnEmail.AllowDBNull = false;
                this.columnOnboardDate.AllowDBNull = false;
            }
            
            public tblEmployeeRow NewtblEmployeeRow() {
                return ((tblEmployeeRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new tblEmployeeRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(tblEmployeeRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.tblEmployeeRowChanged != null)) {
                    this.tblEmployeeRowChanged(this, new tblEmployeeRowChangeEvent(((tblEmployeeRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.tblEmployeeRowChanging != null)) {
                    this.tblEmployeeRowChanging(this, new tblEmployeeRowChangeEvent(((tblEmployeeRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.tblEmployeeRowDeleted != null)) {
                    this.tblEmployeeRowDeleted(this, new tblEmployeeRowChangeEvent(((tblEmployeeRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.tblEmployeeRowDeleting != null)) {
                    this.tblEmployeeRowDeleting(this, new tblEmployeeRowChangeEvent(((tblEmployeeRow)(e.Row)), e.Action));
                }
            }
            
            public void RemovetblEmployeeRow(tblEmployeeRow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class tblEmployeeRow : DataRow {
            
            private tblEmployeeDataTable tabletblEmployee;
            
            internal tblEmployeeRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tabletblEmployee = ((tblEmployeeDataTable)(this.Table));
            }
            
            public int EmployeeID {
                get {
                    return ((int)(this[this.tabletblEmployee.EmployeeIDColumn]));
                }
                set {
                    this[this.tabletblEmployee.EmployeeIDColumn] = value;
                }
            }
            
            public string Name {
                get {
                    return ((string)(this[this.tabletblEmployee.NameColumn]));
                }
                set {
                    this[this.tabletblEmployee.NameColumn] = value;
                }
            }
            
            public string LoginName {
                get {
                    return ((string)(this[this.tabletblEmployee.LoginNameColumn]));
                }
                set {
                    this[this.tabletblEmployee.LoginNameColumn] = value;
                }
            }
            
            public System.Byte[] Password {
                get {
                    try {
                        return ((System.Byte[])(this[this.tabletblEmployee.PasswordColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblEmployee.PasswordColumn] = value;
                }
            }
            
            public string Email {
                get {
                    return ((string)(this[this.tabletblEmployee.EmailColumn]));
                }
                set {
                    this[this.tabletblEmployee.EmailColumn] = value;
                }
            }
            
            public int DeptID {
                get {
                    try {
                        return ((int)(this[this.tabletblEmployee.DeptIDColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblEmployee.DeptIDColumn] = value;
                }
            }
            
            public int BasicSalary {
                get {
                    try {
                        return ((int)(this[this.tabletblEmployee.BasicSalaryColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblEmployee.BasicSalaryColumn] = value;
                }
            }
            
            public string Title {
                get {
                    try {
                        return ((string)(this[this.tabletblEmployee.TitleColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblEmployee.TitleColumn] = value;
                }
            }
            
            public string Telephone {
                get {
                    try {
                        return ((string)(this[this.tabletblEmployee.TelephoneColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblEmployee.TelephoneColumn] = value;
                }
            }
            
            public System.DateTime OnboardDate {
                get {
                    return ((System.DateTime)(this[this.tabletblEmployee.OnboardDateColumn]));
                }
                set {
                    this[this.tabletblEmployee.OnboardDateColumn] = value;
                }
            }
            
            public string SelfIntro {
                get {
                    try {
                        return ((string)(this[this.tabletblEmployee.SelfIntroColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblEmployee.SelfIntroColumn] = value;
                }
            }
            
            public int VacationRemain {
                get {
                    try {
                        return ((int)(this[this.tabletblEmployee.VacationRemainColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblEmployee.VacationRemainColumn] = value;
                }
            }
            
            public int EmployeeLevel {
                get {
                    try {
                        return ((int)(this[this.tabletblEmployee.EmployeeLevelColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblEmployee.EmployeeLevelColumn] = value;
                }
            }
            
            public System.Byte[] PhotoImage {
                get {
                    try {
                        return ((System.Byte[])(this[this.tabletblEmployee.PhotoImageColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblEmployee.PhotoImageColumn] = value;
                }
            }
            
            public bool IsPasswordNull() {
                return this.IsNull(this.tabletblEmployee.PasswordColumn);
            }
            
            public void SetPasswordNull() {
                this[this.tabletblEmployee.PasswordColumn] = System.Convert.DBNull;
            }
            
            public bool IsDeptIDNull() {
                return this.IsNull(this.tabletblEmployee.DeptIDColumn);
            }
            
            public void SetDeptIDNull() {
                this[this.tabletblEmployee.DeptIDColumn] = System.Convert.DBNull;
            }
            
            public bool IsBasicSalaryNull() {
                return this.IsNull(this.tabletblEmployee.BasicSalaryColumn);
            }
            
            public void SetBasicSalaryNull() {
                this[this.tabletblEmployee.BasicSalaryColumn] = System.Convert.DBNull;
            }
            
            public bool IsTitleNull() {
                return this.IsNull(this.tabletblEmployee.TitleColumn);
            }
            
            public void SetTitleNull() {
                this[this.tabletblEmployee.TitleColumn] = System.Convert.DBNull;
            }
            
            public bool IsTelephoneNull() {
                return this.IsNull(this.tabletblEmployee.TelephoneColumn);
            }
            
            public void SetTelephoneNull() {
                this[this.tabletblEmployee.TelephoneColumn] = System.Convert.DBNull;
            }
            
            public bool IsSelfIntroNull() {
                return this.IsNull(this.tabletblEmployee.SelfIntroColumn);
            }
            
            public void SetSelfIntroNull() {