dataset1.cs

学生公寓管理系统使用说明： 1.服务器运行环境 SQL 2000 .NET FRAMEWORK 1.1 .NET FRAMEWORK 1.1 CHINESE (SIMPL

            public void SetStudent_PhoneNull() {
                this[this.tableStudent.Student_PhoneColumn] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class StudentRowChangeEvent : EventArgs {
            
            private StudentRow eventRow;
            
            private DataRowAction eventAction;
            
            public StudentRowChangeEvent(StudentRow row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public StudentRow Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class ManagerDataTable : DataTable, System.Collections.IEnumerable {
            
            private DataColumn columnManager_UserName;
            
            private DataColumn columnManager_Name;
            
            private DataColumn columnManager_Age;
            
            private DataColumn columnManager_Sex;
            
            private DataColumn columnManager_Tel;
            
            private DataColumn columnFloor_ID;
            
            internal ManagerDataTable() : 
                    base("Manager") {
                this.InitClass();
            }
            
            internal ManagerDataTable(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 Manager_UserNameColumn {
                get {
                    return this.columnManager_UserName;
                }
            }
            
            internal DataColumn Manager_NameColumn {
                get {
                    return this.columnManager_Name;
                }
            }
            
            internal DataColumn Manager_AgeColumn {
                get {
                    return this.columnManager_Age;
                }
            }
            
            internal DataColumn Manager_SexColumn {
                get {
                    return this.columnManager_Sex;
                }
            }
            
            internal DataColumn Manager_TelColumn {
                get {
                    return this.columnManager_Tel;
                }
            }
            
            internal DataColumn Floor_IDColumn {
                get {
                    return this.columnFloor_ID;
                }
            }
            
            public ManagerRow this[int index] {
                get {
                    return ((ManagerRow)(this.Rows[index]));
                }
            }
            
            public event ManagerRowChangeEventHandler ManagerRowChanged;
            
            public event ManagerRowChangeEventHandler ManagerRowChanging;
            
            public event ManagerRowChangeEventHandler ManagerRowDeleted;
            
            public event ManagerRowChangeEventHandler ManagerRowDeleting;
            
            public void AddManagerRow(ManagerRow row) {
                this.Rows.Add(row);
            }
            
            public ManagerRow AddManagerRow(string Manager_UserName, string Manager_Name, int Manager_Age, string Manager_Sex, long Manager_Tel, short Floor_ID) {
                ManagerRow rowManagerRow = ((ManagerRow)(this.NewRow()));
                rowManagerRow.ItemArray = new object[] {
                        Manager_UserName,
                        Manager_Name,
                        Manager_Age,
                        Manager_Sex,
                        Manager_Tel,
                        Floor_ID};
                this.Rows.Add(rowManagerRow);
                return rowManagerRow;
            }
            
            public ManagerRow FindByManager_UserName(string Manager_UserName) {
                return ((ManagerRow)(this.Rows.Find(new object[] {
                            Manager_UserName})));
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                ManagerDataTable cln = ((ManagerDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new ManagerDataTable();
            }
            
            internal void InitVars() {
                this.columnManager_UserName = this.Columns["Manager_UserName"];
                this.columnManager_Name = this.Columns["Manager_Name"];
                this.columnManager_Age = this.Columns["Manager_Age"];
                this.columnManager_Sex = this.Columns["Manager_Sex"];
                this.columnManager_Tel = this.Columns["Manager_Tel"];
                this.columnFloor_ID = this.Columns["Floor_ID"];
            }
            
            private void InitClass() {
                this.columnManager_UserName = new DataColumn("Manager_UserName", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnManager_UserName);
                this.columnManager_Name = new DataColumn("Manager_Name", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnManager_Name);
                this.columnManager_Age = new DataColumn("Manager_Age", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnManager_Age);
                this.columnManager_Sex = new DataColumn("Manager_Sex", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnManager_Sex);
                this.columnManager_Tel = new DataColumn("Manager_Tel", typeof(long), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnManager_Tel);
                this.columnFloor_ID = new DataColumn("Floor_ID", typeof(short), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnFloor_ID);
                this.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.columnManager_UserName}, true));
                this.columnManager_UserName.AllowDBNull = false;
                this.columnManager_UserName.Unique = true;
                this.columnManager_Name.AllowDBNull = false;
                this.columnManager_Sex.AllowDBNull = false;
            }
            
            public ManagerRow NewManagerRow() {
                return ((ManagerRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new ManagerRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(ManagerRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.ManagerRowChanged != null)) {
                    this.ManagerRowChanged(this, new ManagerRowChangeEvent(((ManagerRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.ManagerRowChanging != null)) {
                    this.ManagerRowChanging(this, new ManagerRowChangeEvent(((ManagerRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.ManagerRowDeleted != null)) {
                    this.ManagerRowDeleted(this, new ManagerRowChangeEvent(((ManagerRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.ManagerRowDeleting != null)) {
                    this.ManagerRowDeleting(this, new ManagerRowChangeEvent(((ManagerRow)(e.Row)), e.Action));
                }
            }
            
            public void RemoveManagerRow(ManagerRow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class ManagerRow : DataRow {
            
            private ManagerDataTable tableManager;
            
            internal ManagerRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tableManager = ((ManagerDataTable)(this.Table));
            }
            
            public string Manager_UserName {
                get {
                    return ((string)(this[this.tableManager.Manager_UserNameColumn]));
                }
                set {
                    this[this.tableManager.Manager_UserNameColumn] = value;
                }
            }
            
            public string Manager_Name {
                get {
                    return ((string)(this[this.tableManager.Manager_NameColumn]));
                }
                set {
                    this[this.tableManager.Manager_NameColumn] = value;
                }
            }
            
            public int Manager_Age {
                get {
                    try {
                        return ((int)(this[this.tableManager.Manager_AgeColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableManager.Manager_AgeColumn] = value;
                }
            }
            
            public string Manager_Sex {
                get {
                    return ((string)(this[this.tableManager.Manager_SexColumn]));
                }
                set {
                    this[this.tableManager.Manager_SexColumn] = value;
                }
            }
            
            public long Manager_Tel {
                get {
                    try {
                        return ((long)(this[this.tableManager.Manager_TelColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableManager.Manager_TelColumn] = value;
                }
            }
            
            public short Floor_ID {
                get {
                    try {
                        return ((short)(this[this.tableManager.Floor_IDColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableManager.Floor_IDColumn] = value;
                }
            }
            
            public bool IsManager_AgeNull() {
                return this.IsNull(this.tableManager.Manager_AgeColumn);
            }
            
            public void SetManager_AgeNull() {
                this[this.tableManager.Manager_AgeColumn] = System.Convert.DBNull;
            }
            
            public bool IsManager_TelNull() {
                return this.IsNull(this.tableManager.Manager_TelColumn);
            }
            
            public void SetManager_TelNull() {
                this[this.tableManager.Manager_TelColumn] = System.Convert.DBNull;
            }
            
            public bool IsFloor_IDNull() {
                return this.IsNull(this.tableManager.Floor_IDColumn);
            }
            
            public void SetFloor_IDNull() {
                this[this.tableManager.Floor_IDColumn] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class ManagerRowChangeEvent : EventArgs {
            
            private ManagerRow eventRow;
            
            private DataRowAction eventAction;
            
            public ManagerRowChangeEvent(ManagerRow row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public ManagerRow Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
    }
}