dataset2.cs

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

//------------------------------------------------------------------------------
// <autogenerated>
//     This code was generated by a tool.
//     Runtime Version: 1.1.4322.573
//
//     Changes to this file may cause incorrect behavior and will be lost if 
//     the code is regenerated.
// </autogenerated>
//------------------------------------------------------------------------------

namespace 进销存管理系统 {
    using System;
    using System.Data;
    using System.Xml;
    using System.Runtime.Serialization;
    
    
    [Serializable()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Diagnostics.DebuggerStepThrough()]
    [System.ComponentModel.ToolboxItem(true)]
    public class DataSet2 : DataSet {
        
        private 进货单DataTable table进货单;
        
        public DataSet2() {
            this.InitClass();
            System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
            this.Tables.CollectionChanged += schemaChangedHandler;
            this.Relations.CollectionChanged += schemaChangedHandler;
        }
        
        protected DataSet2(SerializationInfo info, StreamingContext context) {
            string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
            if ((strSchema != null)) {
                DataSet ds = new DataSet();
                ds.ReadXmlSchema(new XmlTextReader(new System.IO.StringReader(strSchema)));
                if ((ds.Tables["进货单"] != null)) {
                    this.Tables.Add(new 进货单DataTable(ds.Tables["进货单"]));
                }
                this.DataSetName = ds.DataSetName;
                this.Prefix = ds.Prefix;
                this.Namespace = ds.Namespace;
                this.Locale = ds.Locale;
                this.CaseSensitive = ds.CaseSensitive;
                this.EnforceConstraints = ds.EnforceConstraints;
                this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
                this.InitVars();
            }
            else {
                this.InitClass();
            }
            this.GetSerializationData(info, context);
            System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
            this.Tables.CollectionChanged += schemaChangedHandler;
            this.Relations.CollectionChanged += schemaChangedHandler;
        }
        
        [System.ComponentModel.Browsable(false)]
        [System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Content)]
        public 进货单DataTable 进货单 {
            get {
                return this.table进货单;
            }
        }
        
        public override DataSet Clone() {
            DataSet2 cln = ((DataSet2)(base.Clone()));
            cln.InitVars();
            return cln;
        }
        
        protected override bool ShouldSerializeTables() {
            return false;
        }
        
        protected override bool ShouldSerializeRelations() {
            return false;
        }
        
        protected override void ReadXmlSerializable(XmlReader reader) {
            this.Reset();
            DataSet ds = new DataSet();
            ds.ReadXml(reader);
            if ((ds.Tables["进货单"] != null)) {
                this.Tables.Add(new 进货单DataTable(ds.Tables["进货单"]));
            }
            this.DataSetName = ds.DataSetName;
            this.Prefix = ds.Prefix;
            this.Namespace = ds.Namespace;
            this.Locale = ds.Locale;
            this.CaseSensitive = ds.CaseSensitive;
            this.EnforceConstraints = ds.EnforceConstraints;
            this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
            this.InitVars();
        }
        
        protected override System.Xml.Schema.XmlSchema GetSchemaSerializable() {
            System.IO.MemoryStream stream = new System.IO.MemoryStream();
            this.WriteXmlSchema(new XmlTextWriter(stream, null));
            stream.Position = 0;
            return System.Xml.Schema.XmlSchema.Read(new XmlTextReader(stream), null);
        }
        
        internal void InitVars() {
            this.table进货单 = ((进货单DataTable)(this.Tables["进货单"]));
            if ((this.table进货单 != null)) {
                this.table进货单.InitVars();
            }
        }
        
        private void InitClass() {
            this.DataSetName = "DataSet2";
            this.Prefix = "";
            this.Namespace = "http://www.tempuri.org/DataSet2.xsd";
            this.Locale = new System.Globalization.CultureInfo("zh-CN");
            this.CaseSensitive = false;
            this.EnforceConstraints = true;
            this.table进货单 = new 进货单DataTable();
            this.Tables.Add(this.table进货单);
        }
        
        private bool ShouldSerialize进货单() {
            return false;
        }
        
        private void SchemaChanged(object sender, System.ComponentModel.CollectionChangeEventArgs e) {
            if ((e.Action == System.ComponentModel.CollectionChangeAction.Remove)) {
                this.InitVars();
            }
        }
        
        public delegate void 进货单RowChangeEventHandler(object sender, 进货单RowChangeEvent e);
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class 进货单DataTable : DataTable, System.Collections.IEnumerable {
            
            private DataColumn column供货商号;
            
            private DataColumn column货号;
            
            private DataColumn column进货日期;
            
            private DataColumn column业务员;
            
            private DataColumn column制单人;
            
            private DataColumn column进货数量;
            
            private DataColumn column进价;
            
            private DataColumn column税价合计;
            
            private DataColumn column税率;
            
            private DataColumn column不含税价;
            
            private DataColumn column税额;
            
            private DataColumn column名称;
            
            private DataColumn column品名;
            
            private DataColumn column仓库;
            
            private DataColumn column单位;
            
            internal 进货单DataTable() : 
                    base("进货单") {
                this.InitClass();
            }
            
            internal 进货单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名称;
                }
            }
            
            internal DataColumn 品名Column {
                get {
                    return this.column品名;
                }
            }
            
            internal DataColumn 仓库Column {
                get {
                    return this.column仓库;
                }
            }
            
            internal DataColumn 单位Column {
                get {
                    return this.column单位;
                }
            }
            
            public 进货单Row this[int index] {
                get {
                    return ((进货单Row)(this.Rows[index]));
                }
            }
            
            public event 进货单RowChangeEventHandler 进货单RowChanged;
            
            public event 进货单RowChangeEventHandler 进货单RowChanging;
            
            public event 进货单RowChangeEventHandler 进货单RowDeleted;
            
            public event 进货单RowChangeEventHandler 进货单RowDeleting;
            
            public void Add进货单Row(进货单Row row) {
                this.Rows.Add(row);
            }
            
            public 进货单Row Add进货单Row(string 供货商号, string 货号, System.DateTime 进货日期, string 业务员, string 制单人, System.Decimal 进货数量, System.Decimal 进价, System.Decimal 税价合计, System.Decimal 税率, System.Decimal 不含税价, System.Decimal 税额, string 名称, string 品名, string 仓库, string 单位) {
                进货单Row row进货单Row = ((进货单Row)(this.NewRow()));
                row进货单Row.ItemArray = new object[] {
                        供货商号,
                        货号,
                        进货日期,
                        业务员,
                        制单人,
                        进货数量,
                        进价,
                        税价合计,
                        税率,
                        不含税价,
                        税额,
                        名称,
                        品名,
                        仓库,
                        单位};
                this.Rows.Add(row进货单Row);
                return row进货单Row;
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                进货单DataTable cln = ((进货单DataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new 进货单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["名称"];
                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(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(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不含税价);