dataset1.cs

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

                        return ((int)(this[this.table本期汇总账簿.会计期间Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table本期汇总账簿.会计期间Column] = value;
                }
            }
            
            public System.Decimal 期初余额 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table本期汇总账簿.期初余额Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table本期汇总账簿.期初余额Column] = value;
                }
            }
            
            public System.Decimal 本期借方合计 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table本期汇总账簿.本期借方合计Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table本期汇总账簿.本期借方合计Column] = value;
                }
            }
            
            public System.Decimal 本期贷方合计 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table本期汇总账簿.本期贷方合计Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table本期汇总账簿.本期贷方合计Column] = value;
                }
            }
            
            public System.Decimal 本年借方累计 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table本期汇总账簿.本年借方累计Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table本期汇总账簿.本年借方累计Column] = value;
                }
            }
            
            public System.Decimal 本年贷方累计 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table本期汇总账簿.本年贷方累计Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table本期汇总账簿.本年贷方累计Column] = value;
                }
            }
            
            public System.Decimal 余额 {
                get {
                    try {
                        return ((System.Decimal)(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 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;
            }
            
            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借方;
            
            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 {