dataset1.cs

本文介绍了一个基于Client/Server模式的高校图书管理系统的设计与实现。运用Visual Basic.Net结合Microsoft SQL Server 2000开发的登录模块主要用于验证用户

                        booknum,
                        readerclass};
                this.Rows.Add(rowsystem_readerRow);
                return rowsystem_readerRow;
            }
            
            public system_readerRow FindByreaderid(string readerid) {
                return ((system_readerRow)(this.Rows.Find(new object[] {
                            readerid})));
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                system_readerDataTable cln = ((system_readerDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new system_readerDataTable();
            }
            
            internal void InitVars() {
                this.columnreaderid = this.Columns["readerid"];
                this.columnreadername = this.Columns["readername"];
                this.columnreadersex = this.Columns["readersex"];
                this.columnregdate = this.Columns["regdate"];
                this.columnbooknum = this.Columns["booknum"];
                this.columnreaderclass = this.Columns["readerclass"];
            }
            
            private void InitClass() {
                this.columnreaderid = new DataColumn("readerid", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnreaderid);
                this.columnreadername = new DataColumn("readername", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnreadername);
                this.columnreadersex = new DataColumn("readersex", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnreadersex);
                this.columnregdate = new DataColumn("regdate", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnregdate);
                this.columnbooknum = new DataColumn("booknum", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnbooknum);
                this.columnreaderclass = new DataColumn("readerclass", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnreaderclass);
                this.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.columnreaderid}, true));
                this.columnreaderid.AllowDBNull = false;
                this.columnreaderid.Unique = true;
            }
            
            public system_readerRow Newsystem_readerRow() {
                return ((system_readerRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new system_readerRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(system_readerRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.system_readerRowChanged != null)) {
                    this.system_readerRowChanged(this, new system_readerRowChangeEvent(((system_readerRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.system_readerRowChanging != null)) {
                    this.system_readerRowChanging(this, new system_readerRowChangeEvent(((system_readerRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.system_readerRowDeleted != null)) {
                    this.system_readerRowDeleted(this, new system_readerRowChangeEvent(((system_readerRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.system_readerRowDeleting != null)) {
                    this.system_readerRowDeleting(this, new system_readerRowChangeEvent(((system_readerRow)(e.Row)), e.Action));
                }
            }
            
            public void Removesystem_readerRow(system_readerRow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class system_readerRow : DataRow {
            
            private system_readerDataTable tablesystem_reader;
            
            internal system_readerRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tablesystem_reader = ((system_readerDataTable)(this.Table));
            }
            
            public string readerid {
                get {
                    return ((string)(this[this.tablesystem_reader.readeridColumn]));
                }
                set {
                    this[this.tablesystem_reader.readeridColumn] = value;
                }
            }
            
            public string readername {
                get {
                    try {
                        return ((string)(this[this.tablesystem_reader.readernameColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tablesystem_reader.readernameColumn] = value;
                }
            }
            
            public string readersex {
                get {
                    try {
                        return ((string)(this[this.tablesystem_reader.readersexColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tablesystem_reader.readersexColumn] = value;
                }
            }
            
            public string regdate {
                get {
                    try {
                        return ((string)(this[this.tablesystem_reader.regdateColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tablesystem_reader.regdateColumn] = value;
                }
            }
            
            public string booknum {
                get {
                    try {
                        return ((string)(this[this.tablesystem_reader.booknumColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tablesystem_reader.booknumColumn] = value;
                }
            }
            
            public string readerclass {
                get {
                    try {
                        return ((string)(this[this.tablesystem_reader.readerclassColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tablesystem_reader.readerclassColumn] = value;
                }
            }
            
            public bool IsreadernameNull() {
                return this.IsNull(this.tablesystem_reader.readernameColumn);
            }
            
            public void SetreadernameNull() {
                this[this.tablesystem_reader.readernameColumn] = System.Convert.DBNull;
            }
            
            public bool IsreadersexNull() {
                return this.IsNull(this.tablesystem_reader.readersexColumn);
            }
            
            public void SetreadersexNull() {
                this[this.tablesystem_reader.readersexColumn] = System.Convert.DBNull;
            }
            
            public bool IsregdateNull() {
                return this.IsNull(this.tablesystem_reader.regdateColumn);
            }
            
            public void SetregdateNull() {
                this[this.tablesystem_reader.regdateColumn] = System.Convert.DBNull;
            }
            
            public bool IsbooknumNull() {
                return this.IsNull(this.tablesystem_reader.booknumColumn);
            }
            
            public void SetbooknumNull() {
                this[this.tablesystem_reader.booknumColumn] = System.Convert.DBNull;
            }
            
            public bool IsreaderclassNull() {
                return this.IsNull(this.tablesystem_reader.readerclassColumn);
            }
            
            public void SetreaderclassNull() {
                this[this.tablesystem_reader.readerclassColumn] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class system_readerRowChangeEvent : EventArgs {
            
            private system_readerRow eventRow;
            
            private DataRowAction eventAction;
            
            public system_readerRowChangeEvent(system_readerRow row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public system_readerRow Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class 读者表DataTable : DataTable, System.Collections.IEnumerable {
            
            private DataColumn column读者号;
            
            private DataColumn column读者姓名;
            
            private DataColumn column读者性别;
            
            private DataColumn column读者班级;
            
            private DataColumn column借阅数目;