dataset1.cs

财务管理系统采用C#语言和SQL Server数据库 适合于一般小公司的使用

        }
        
        [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本期贷方合计;
            
            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本期贷方合计;
                }
            }
            
            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 科目代码, int 会计期间, System.Decimal 期初余额, System.Decimal 本期借方合计, System.Decimal 本期贷方合计, System.Decimal 本年借方累计, System.Decimal 本年贷方累计, System.Decimal 余额, string 余额方向) {
                本期汇总账簿Row row本期汇总账簿Row = ((本期汇总账簿Row)(this.NewRow()));
                row本期汇总账簿Row.ItemArray = new object[] {
                        科目名称,
                        科目代码,
                        会计期间,
                        期初余额,
                        本期借方合计,
                        本期贷方合计,
                        本年借方累计,
                        本年贷方累计,
                        余额,
                        余额方向};
                this.Rows.Add(row本期汇总账簿Row);
                return row本期汇总账簿Row;
            }
            
            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["科目名称"];
                this.column科目代码 = this.Columns["科目代码"];
                this.column会计期间 = this.Columns["会计期间"];
                this.column期初余额 = this.Columns["期初余额"];
                this.column本期借方合计 = this.Columns["本期借方合计"];
                this.column本期贷方合计 = this.Columns["本期贷方合计"];
                this.column本年借方累计 = this.Columns["本年借方累计"];
                this.column本年贷方累计 = this.Columns["本年贷方累计"];
                this.column余额 = this.Columns["余额"];
                this.column余额方向 = this.Columns["余额方向"];
            }
            
            private void InitClass() {
                this.column科目名称 = new DataColumn("科目名称", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column科目名称);
                this.column科目代码 = new DataColumn("科目代码", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column科目代码);
                this.column会计期间 = new DataColumn("会计期间", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column会计期间);
                this.column期初余额 = new DataColumn("期初余额", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column期初余额);
                this.column本期借方合计 = new DataColumn("本期借方合计", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column本期借方合计);
                this.column本期贷方合计 = new DataColumn("本期贷方合计", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column本期贷方合计);
                this.column本年借方累计 = new DataColumn("本年借方累计", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column本年借方累计);
                this.column本年贷方累计 = new DataColumn("本年贷方累计", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column本年贷方累计);
                this.column余额 = new DataColumn("余额", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column余额);
                this.column余额方向 = new DataColumn("余额方向", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column余额方向);
                this.column科目代码.AllowDBNull = false;
            }
            
            public 本期汇总账簿Row New本期汇总账簿Row() {
                return ((本期汇总账簿Row)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new 本期汇总账簿Row(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(本期汇总账簿Row);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.本期汇总账簿RowChanged != null)) {
                    this.本期汇总账簿RowChanged(this, new 本期汇总账簿RowChangeEvent(((本期汇总账簿Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.本期汇总账簿RowChanging != null)) {
                    this.本期汇总账簿RowChanging(this, new 本期汇总账簿RowChangeEvent(((本期汇总账簿Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.本期汇总账簿RowDeleted != null)) {
                    this.本期汇总账簿RowDeleted(this, new 本期汇总账簿RowChangeEvent(((本期汇总账簿Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.本期汇总账簿RowDeleting != null)) {
                    this.本期汇总账簿RowDeleting(this, new 本期汇总账簿RowChangeEvent(((本期汇总账簿Row)(e.Row)), e.Action));
                }
            }
            
            public void Remove本期汇总账簿Row(本期汇总账簿Row row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class 本期汇总账簿Row : DataRow {
            
            private 本期汇总账簿DataTable table本期汇总账簿;
            
            internal 本期汇总账簿Row(DataRowBuilder rb) : 
                    base(rb) {
                this.table本期汇总账簿 = ((本期汇总账簿DataTable)(this.Table));
            }
            
            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 {
                    return ((string)(this[this.table本期汇总账簿.科目代码Column]));
                }
                set {
                    this[this.table本期汇总账簿.科目代码Column] = value;
                }
            }
            
            public int 会计期间 {
                get {
                    try {