dataset2.cs

SaleManage.rar 源碼 附詳盡使用說明及數據庫 進銷存管理系統

                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品名 = 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(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column单位);
                this.column供货商号.AllowDBNull = false;
                this.column货号.AllowDBNull = false;
                this.column进货数量.AllowDBNull = false;
                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 {
                    return ((string)(this[this.table进货单.供货商号Column]));
                }
                set {
                    this[this.table进货单.供货商号Column] = value;
                }
            }
            
            public string 货号 {
                get {
                    return ((string)(this[this.table进货单.货号Column]));
                }
                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 System.Decimal 进货数量 {
                get {
                    return ((System.Decimal)(this[this.table进货单.进货数量Column]));
                }
                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 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 string 单位 {
                get {
                    return ((string)(this[this.table进货单.单位Column]));
                }
                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;
            }
            
            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;
                }
            }
        }
    }
}