datasetuser.cs

Csharp SQL图书馆管理系统 Csharp SQL图书馆管理系统源码

            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                UserDataTable cln = ((UserDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new UserDataTable();
            }
            
            internal void InitVars() {
                this.columnUserID = this.Columns["UserID"];
                this.columnUserName = this.Columns["UserName"];
                this.columnUserPassword = this.Columns["UserPassword"];
                this.columnUserSort = this.Columns["UserSort"];
                this.columnUserDepart = this.Columns["UserDepart"];
                this.columnUserPhone = this.Columns["UserPhone"];
            }
            
            private void InitClass() {
                this.columnUserID = new DataColumn("UserID", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnUserID);
                this.columnUserName = new DataColumn("UserName", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnUserName);
                this.columnUserPassword = new DataColumn("UserPassword", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnUserPassword);
                this.columnUserSort = new DataColumn("UserSort", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnUserSort);
                this.columnUserDepart = new DataColumn("UserDepart", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnUserDepart);
                this.columnUserPhone = new DataColumn("UserPhone", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnUserPhone);
                this.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.columnUserID}, true));
                this.columnUserID.AllowDBNull = false;
                this.columnUserID.Unique = true;
            }
            
            public UserRow NewUserRow() {
                return ((UserRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new UserRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(UserRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.UserRowChanged != null)) {
                    this.UserRowChanged(this, new UserRowChangeEvent(((UserRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.UserRowChanging != null)) {
                    this.UserRowChanging(this, new UserRowChangeEvent(((UserRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.UserRowDeleted != null)) {
                    this.UserRowDeleted(this, new UserRowChangeEvent(((UserRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.UserRowDeleting != null)) {
                    this.UserRowDeleting(this, new UserRowChangeEvent(((UserRow)(e.Row)), e.Action));
                }
            }
            
            public void RemoveUserRow(UserRow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class UserRow : DataRow {
            
            private UserDataTable tableUser;
            
            internal UserRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tableUser = ((UserDataTable)(this.Table));
            }
            
            public string UserID {
                get {
                    return ((string)(this[this.tableUser.UserIDColumn]));
                }
                set {
                    this[this.tableUser.UserIDColumn] = value;
                }
            }
            
            public string UserName {
                get {
                    try {
                        return ((string)(this[this.tableUser.UserNameColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableUser.UserNameColumn] = value;
                }
            }
            
            public string UserPassword {
                get {
                    try {
                        return ((string)(this[this.tableUser.UserPasswordColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableUser.UserPasswordColumn] = value;
                }
            }
            
            public string UserSort {
                get {
                    try {
                        return ((string)(this[this.tableUser.UserSortColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableUser.UserSortColumn] = value;
                }
            }
            
            public string UserDepart {
                get {
                    try {
                        return ((string)(this[this.tableUser.UserDepartColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableUser.UserDepartColumn] = value;
                }
            }
            
            public string UserPhone {
                get {
                    try {
                        return ((string)(this[this.tableUser.UserPhoneColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableUser.UserPhoneColumn] = value;
                }
            }
            
            public bool IsUserNameNull() {
                return this.IsNull(this.tableUser.UserNameColumn);
            }
            
            public void SetUserNameNull() {
                this[this.tableUser.UserNameColumn] = System.Convert.DBNull;
            }
            
            public bool IsUserPasswordNull() {
                return this.IsNull(this.tableUser.UserPasswordColumn);
            }
            
            public void SetUserPasswordNull() {
                this[this.tableUser.UserPasswordColumn] = System.Convert.DBNull;
            }
            
            public bool IsUserSortNull() {
                return this.IsNull(this.tableUser.UserSortColumn);
            }
            
            public void SetUserSortNull() {
                this[this.tableUser.UserSortColumn] = System.Convert.DBNull;
            }
            
            public bool IsUserDepartNull() {
                return this.IsNull(this.tableUser.UserDepartColumn);
            }
            
            public void SetUserDepartNull() {
                this[this.tableUser.UserDepartColumn] = System.Convert.DBNull;
            }
            
            public bool IsUserPhoneNull() {
                return this.IsNull(this.tableUser.UserPhoneColumn);
            }
            
            public void SetUserPhoneNull() {
                this[this.tableUser.UserPhoneColumn] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class UserRowChangeEvent : EventArgs {
            
            private UserRow eventRow;
            
            private DataRowAction eventAction;
            
            public UserRowChangeEvent(UserRow row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public UserRow Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
    }
}