dataset2.cs

进销存管理系统软件

                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销售价1 = new DataColumn("销售价1", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column销售价1);
                this.column销售价2 = new DataColumn("销售价2", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column销售价2);
                this.column最低售价 = new DataColumn("最低售价", typeof(System.Decimal), 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 {
                    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 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.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 销售价1 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table商品清单.销售价1Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table商品清单.销售价1Column] = value;
                }
            }
            
            public System.Decimal 销售价2 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table商品清单.销售价2Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table商品清单.销售价2Column] = 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 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销售价1Null() {
                return this.IsNull(this.table商品清单.销售价1Column);
            }
            
            public void Set销售价1Null() {
                this[this.table商品清单.销售价1Column] = System.Convert.DBNull;
            }
            
            public bool Is销售价2Null() {
                return this.IsNull(this.table商品清单.销售价2Column);
            }
            
            public void Set销售价2Null() {
                this[this.table商品清单.销售价2Column] = 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;
                }
            }
        }
    }
}