dataset2.cs

Visual C#.NET数据库开发经典案例解析,这里有1到3的案例

                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["指定供货商"];
                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(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(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物料特性a = new DataColumn("物料特性a", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column物料特性a);
                this.column物料特性b = new DataColumn("物料特性b", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column物料特性b);
                this.column物料特性c = new DataColumn("物料特性c", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column物料特性c);
                this.column物料特性d = new DataColumn("物料特性d", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column物料特性d);
                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颜色 = 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(int), 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(int), 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(int), 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.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.column物料编号}, true));
                this.column物料编号.AllowDBNull = false;
                this.column物料编号.Unique = true;
                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 {
                    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 {
                    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 {
                    try {
                        return ((string)(this[this.table物料主文件.价值类别Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table物料主文件.价值类别Column] = value;
                }
            }
            
            public string 物料特性a {
                get {
                    try {
                        return ((string)(this[this.table物料主文件.物料特性aColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table物料主文件.物料特性aColumn] = value;
                }
            }
            
            public string 物料特性b {
                get {
                    try {
                        return ((string)(this[this.table物料主文件.物料特性bColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table物料主文件.物料特性bColumn] = value;
                }
            }
            
            public string 物料特性c {
                get {
                    try {
                        return ((string)(this[this.table物料主文件.物料特性cColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }