dataset1.cs

进销存管理系统 C#完整源码 内含SQl建库脚本等

                this.Columns.Add(this.column供货商号);
                this.column进货日期 = new DataColumn("进货日期", typeof(System.DateTime), 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税价合计 = 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.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.column编号}, true));
                this.column编号.AllowDBNull = false;
                this.column编号.Unique = true;
                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 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 {
                    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;
                }
            }
        }
    }
}