dataset3.cs

生产管理系统 包括库存管理 销售管理 生产管理 日历管理 等功能

            
            internal mrp物料需求计算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 {
                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计划投入;
                }
            }
            
            public mrp物料需求计算Row this[int index] {
                get {
                    return ((mrp物料需求计算Row)(this.Rows[index]));
                }
            }
            
            public event mrp物料需求计算RowChangeEventHandler mrp物料需求计算RowChanged;
            
            public event mrp物料需求计算RowChangeEventHandler mrp物料需求计算RowChanging;
            
            public event mrp物料需求计算RowChangeEventHandler mrp物料需求计算RowDeleted;
            
            public event mrp物料需求计算RowChangeEventHandler mrp物料需求计算RowDeleting;
            
            public void Addmrp物料需求计算Row(mrp物料需求计算Row row) {
                this.Rows.Add(row);
            }
            
            public mrp物料需求计算Row Addmrp物料需求计算Row(string 物料名称, string 物料编号, int 年份, int 计划期, System.Decimal 期初库存, System.Decimal 毛需求, System.Decimal 预计入库, System.Decimal 预计出库, System.Decimal 预计库存, System.Decimal 净需求, System.Decimal 计划产出, System.Decimal 计划投入) {
                mrp物料需求计算Row rowmrp物料需求计算Row = ((mrp物料需求计算Row)(this.NewRow()));
                rowmrp物料需求计算Row.ItemArray = new object[] {
                        物料名称,
                        物料编号,
                        年份,
                        计划期,
                        期初库存,
                        毛需求,
                        预计入库,
                        预计出库,
                        预计库存,
                        净需求,
                        计划产出,
                        计划投入};
                this.Rows.Add(rowmrp物料需求计算Row);
                return rowmrp物料需求计算Row;
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                mrp物料需求计算DataTable cln = ((mrp物料需求计算DataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new mrp物料需求计算DataTable();
            }
            
            internal void InitVars() {
                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(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(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物料名称.AllowDBNull = false;
                this.column物料编号.AllowDBNull = false;
                this.column年份.AllowDBNull = false;
                this.column计划期.AllowDBNull = false;
            }
            
            public mrp物料需求计算Row Newmrp物料需求计算Row() {
                return ((mrp物料需求计算Row)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new mrp物料需求计算Row(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(mrp物料需求计算Row);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.mrp物料需求计算RowChanged != null)) {
                    this.mrp物料需求计算RowChanged(this, new mrp物料需求计算RowChangeEvent(((mrp物料需求计算Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.mrp物料需求计算RowChanging != null)) {
                    this.mrp物料需求计算RowChanging(this, new mrp物料需求计算RowChangeEvent(((mrp物料需求计算Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.mrp物料需求计算RowDeleted != null)) {
                    this.mrp物料需求计算RowDeleted(this, new mrp物料需求计算RowChangeEvent(((mrp物料需求计算Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.mrp物料需求计算RowDeleting != null)) {
                    this.mrp物料需求计算RowDeleting(this, new mrp物料需求计算RowChangeEvent(((mrp物料需求计算Row)(e.Row)), e.Action));
                }
            }
            
            public void Removemrp物料需求计算Row(mrp物料需求计算Row row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class mrp物料需求计算Row : DataRow {
            
            private mrp物料需求计算DataTable tablemrp物料需求计算;
            
            internal mrp物料需求计算Row(DataRowBuilder rb) : 
                    base(rb) {
                this.tablemrp物料需求计算 = ((mrp物料需求计算DataTable)(this.Table));
            }
            
            public string 物料名称 {
                get {
                    return ((string)(this[this.tablemrp物料需求计算.物料名称Column]));
                }
                set {
                    this[this.tablemrp物料需求计算.物料名称Column] = value;
                }
            }
            
            public string 物料编号 {
                get {
                    return ((string)(this[this.tablemrp物料需求计算.物料编号Column]));
                }
                set {
                    this[this.tablemrp物料需求计算.物料编号Column] = value;
                }
            }
            
            public int 年份 {
                get {
                    return ((int)(this[this.tablemrp物料需求计算.年份Column]));
                }
                set {
                    this[this.tablemrp物料需求计算.年份Column] = value;
                }
            }
            
            public int 计划期 {
                get {
                    return ((int)(this[this.tablemrp物料需求计算.计划期Column]));
                }
                set {
                    this[this.tablemrp物料需求计算.计划期Column] = value;
                }
            }
            
            public System.Decimal 期初库存 {
                get {
                    try {
                        return ((System.Decimal)(this[this.tablemrp物料需求计算.期初库存Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tablemrp物料需求计算.期初库存Column] = value;
                }
            }
            
            public System.Decimal 毛需求 {
                get {
                    try {
                        return ((System.Decimal)(this[this.tablemrp物料需求计算.毛需求Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tablemrp物料需求计算.毛需求Column] = value;
                }
            }