dataset1.cs

数据库的课程设计作业。管理有关学生、课程的基本信息

            private 学生表DataTable table学生表;
            
            internal 学生表Row(DataRowBuilder rb) : 
                    base(rb) {
                this.table学生表 = ((学生表DataTable)(this.Table));
            }
            
            public string 学号 {
                get {
                    return ((string)(this[this.table学生表.学号Column]));
                }
                set {
                    this[this.table学生表.学号Column] = value;
                }
            }
            
            public string 姓名 {
                get {
                    try {
                        return ((string)(this[this.table学生表.姓名Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table学生表.姓名Column] = value;
                }
            }
            
            public string 性别 {
                get {
                    try {
                        return ((string)(this[this.table学生表.性别Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table学生表.性别Column] = value;
                }
            }
            
            public System.DateTime 出生日期 {
                get {
                    try {
                        return ((System.DateTime)(this[this.table学生表.出生日期Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table学生表.出生日期Column] = value;
                }
            }
            
            public string 班级名称 {
                get {
                    try {
                        return ((string)(this[this.table学生表.班级名称Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table学生表.班级名称Column] = value;
                }
            }
            
            public string 所属院系 {
                get {
                    try {
                        return ((string)(this[this.table学生表.所属院系Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table学生表.所属院系Column] = value;
                }
            }
            
            public int 年级 {
                get {
                    try {
                        return ((int)(this[this.table学生表.年级Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table学生表.年级Column] = value;
                }
            }
            
            public int 学制 {
                get {
                    try {
                        return ((int)(this[this.table学生表.学制Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table学生表.学制Column] = value;
                }
            }
            
            public bool Is姓名Null() {
                return this.IsNull(this.table学生表.姓名Column);
            }
            
            public void Set姓名Null() {
                this[this.table学生表.姓名Column] = System.Convert.DBNull;
            }
            
            public bool Is性别Null() {
                return this.IsNull(this.table学生表.性别Column);
            }
            
            public void Set性别Null() {
                this[this.table学生表.性别Column] = System.Convert.DBNull;
            }
            
            public bool Is出生日期Null() {
                return this.IsNull(this.table学生表.出生日期Column);
            }
            
            public void Set出生日期Null() {
                this[this.table学生表.出生日期Column] = System.Convert.DBNull;
            }
            
            public bool Is班级名称Null() {
                return this.IsNull(this.table学生表.班级名称Column);
            }
            
            public void Set班级名称Null() {
                this[this.table学生表.班级名称Column] = System.Convert.DBNull;
            }
            
            public bool Is所属院系Null() {
                return this.IsNull(this.table学生表.所属院系Column);
            }
            
            public void Set所属院系Null() {
                this[this.table学生表.所属院系Column] = System.Convert.DBNull;
            }
            
            public bool Is年级Null() {
                return this.IsNull(this.table学生表.年级Column);
            }
            
            public void Set年级Null() {
                this[this.table学生表.年级Column] = System.Convert.DBNull;
            }
            
            public bool Is学制Null() {
                return this.IsNull(this.table学生表.学制Column);
            }
            
            public void Set学制Null() {
                this[this.table学生表.学制Column] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class 学生表RowChangeEvent : EventArgs {
            
            private 学生表Row eventRow;
            
            private DataRowAction eventAction;
            
            public 学生表RowChangeEvent(学生表Row row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public 学生表Row 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上课开始日期;
            
            private DataColumn column上课结束日期;
            
            internal 历史表DataTable() : 
                    base("历史表") {
                this.InitClass();
            }
            
            internal 历史表DataTable(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 学号Column {
                get {
                    return this.column学号;
                }
            }
            
            internal DataColumn 姓名Column {
                get {
                    return this.column姓名;
                }
            }
            
            internal DataColumn 课程名Column {
                get {
                    return this.column课程名;
                }
            }
            
            internal DataColumn 成绩Column {
                get {
                    return this.column成绩;
                }
            }
            
            internal DataColumn 上课开始日期Column {
                get {
                    return this.column上课开始日期;
                }
            }
            
            internal DataColumn 上课结束日期Column {
                get {
                    return this.column上课结束日期;
                }
            }
            
            public 历史表Row this[int index] {
                get {
                    return ((历史表Row)(this.Rows[index]));
                }
            }
            
            public event 历史表RowChangeEventHandler 历史表RowChanged;
            
            public event 历史表RowChangeEventHandler 历史表RowChanging;
            
            public event 历史表RowChangeEventHandler 历史表RowDeleted;
            
            public event 历史表RowChangeEventHandler 历史表RowDeleting;
            
            public void Add历史表Row(历史表Row row) {
                this.Rows.Add(row);
            }
            
            public 历史表Row Add历史表Row(string 学号, string 姓名, string 课程名, int 成绩, System.DateTime 上课开始日期, System.DateTime 上课结束日期) {
                历史表Row row历史表Row = ((历史表Row)(this.NewRow()));
                row历史表Row.ItemArray = new object[] {
                        学号,
                        姓名,
                        课程名,
                        成绩,
                        上课开始日期,
                        上课结束日期};
                this.Rows.Add(row历史表Row);
                return row历史表Row;
            }
            
            public 历史表Row FindBy学号(string 学号) {
                return ((历史表Row)(this.Rows.Find(new object[] {
                            学号})));
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                历史表DataTable cln = ((历史表DataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new 历史表DataTable();
            }
            
            internal void InitVars() {
                this.column学号 = this.Columns["学号"];