worker_customer_systemdataset.designer.cs

用C#语言在VC环境下实现项目实例开发,实现客户管理系统.

                        int AirFilter, 
                        int Remarks) {
                tblJobDetailsRow rowtblJobDetailsRow = ((tblJobDetailsRow)(this.NewRow()));
                rowtblJobDetailsRow.ItemArray = new object[] {
                        parenttblCustomerRowByFK_tblJobDetails_tblCustomer[0],
                        JobDate,
                        parenttblWorkerRowByFK_tblJobDetails_tblWorker[0],
                        KMs,
                        Tuning,
                        Alingnment,
                        Balancing,
                        Tires,
                        Weights,
                        OilChanged,
                        OilQty,
                        OilFilter,
                        GearOil,
                        GearOilQty,
                        Point,
                        Condenser,
                        Plug,
                        PlugQty,
                        FuelFilter,
                        AirFilter,
                        Remarks};
                this.Rows.Add(rowtblJobDetailsRow);
                return rowtblJobDetailsRow;
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public tblJobDetailsRow FindByCarNoWorkerId(string CarNo, int WorkerId) {
                return ((tblJobDetailsRow)(this.Rows.Find(new object[] {
                            CarNo,
                            WorkerId})));
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public virtual System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public override System.Data.DataTable Clone() {
                tblJobDetailsDataTable cln = ((tblJobDetailsDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override System.Data.DataTable CreateInstance() {
                return new tblJobDetailsDataTable();
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            internal void InitVars() {
                this.columnCarNo = base.Columns["CarNo"];
                this.columnJobDate = base.Columns["JobDate"];
                this.columnWorkerId = base.Columns["WorkerId"];
                this.columnKMs = base.Columns["KMs"];
                this.columnTuning = base.Columns["Tuning"];
                this.columnAlingnment = base.Columns["Alingnment"];
                this.columnBalancing = base.Columns["Balancing"];
                this.columnTires = base.Columns["Tires"];
                this.columnWeights = base.Columns["Weights"];
                this.columnOilChanged = base.Columns["OilChanged"];
                this.columnOilQty = base.Columns["OilQty"];
                this.columnOilFilter = base.Columns["OilFilter"];
                this.columnGearOil = base.Columns["GearOil"];
                this.columnGearOilQty = base.Columns["GearOilQty"];
                this.columnPoint = base.Columns["Point"];
                this.columnCondenser = base.Columns["Condenser"];
                this.columnPlug = base.Columns["Plug"];
                this.columnPlugQty = base.Columns["PlugQty"];
                this.columnFuelFilter = base.Columns["FuelFilter"];
                this.columnAirFilter = base.Columns["AirFilter"];
                this.columnRemarks = base.Columns["Remarks"];
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            private void InitClass() {
                this.columnCarNo = new System.Data.DataColumn("CarNo", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnCarNo);
                this.columnJobDate = new System.Data.DataColumn("JobDate", typeof(System.DateTime), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnJobDate);
                this.columnWorkerId = new System.Data.DataColumn("WorkerId", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnWorkerId);
                this.columnKMs = new System.Data.DataColumn("KMs", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnKMs);
                this.columnTuning = new System.Data.DataColumn("Tuning", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnTuning);
                this.columnAlingnment = new System.Data.DataColumn("Alingnment", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnAlingnment);
                this.columnBalancing = new System.Data.DataColumn("Balancing", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnBalancing);
                this.columnTires = new System.Data.DataColumn("Tires", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnTires);
                this.columnWeights = new System.Data.DataColumn("Weights", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnWeights);
                this.columnOilChanged = new System.Data.DataColumn("OilChanged", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnOilChanged);
                this.columnOilQty = new System.Data.DataColumn("OilQty", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnOilQty);
                this.columnOilFilter = new System.Data.DataColumn("OilFilter", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnOilFilter);
                this.columnGearOil = new System.Data.DataColumn("GearOil", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnGearOil);
                this.columnGearOilQty = new System.Data.DataColumn("GearOilQty", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnGearOilQty);
                this.columnPoint = new System.Data.DataColumn("Point", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnPoint);
                this.columnCondenser = new System.Data.DataColumn("Condenser", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnCondenser);
                this.columnPlug = new System.Data.DataColumn("Plug", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnPlug);
                this.columnPlugQty = new System.Data.DataColumn("PlugQty", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnPlugQty);
                this.columnFuelFilter = new System.Data.DataColumn("FuelFilter", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnFuelFilter);
                this.columnAirFilter = new System.Data.DataColumn("AirFilter", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnAirFilter);
                this.columnRemarks = new System.Data.DataColumn("Remarks", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnRemarks);
                this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
                                this.columnCarNo,
                                this.columnWorkerId}, true));
                this.columnCarNo.AllowDBNull = false;
                this.columnCarNo.MaxLength = 15;
                this.columnJobDate.AllowDBNull = false;
                this.columnWorkerId.AllowDBNull = false;
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public tblJobDetailsRow NewtblJobDetailsRow() {
                return ((tblJobDetailsRow)(this.NewRow()));
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
                return new tblJobDetailsRow(builder);
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override System.Type GetRowType() {
                return typeof(tblJobDetailsRow);
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.tblJobDetailsRowChanged != null)) {
                    this.tblJobDetailsRowChanged(this, new tblJobDetailsRowChangeEvent(((tblJobDetailsRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.tblJobDetailsRowChanging != null)) {
                    this.tblJobDetailsRowChanging(this, new tblJobDetailsRowChangeEvent(((tblJobDetailsRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.tblJobDetailsRowDeleted != null)) {
                    this.tblJobDetailsRowDeleted(this, new tblJobDetailsRowChangeEvent(((tblJobDetailsRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.tblJobDetailsRowDeleting != null)) {
                    this.tblJobDetailsRowDeleting(this, new tblJobDetailsRowChangeEvent(((tblJobDetailsRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public void RemovetblJobDetailsRow(tblJobDetailsRow row) {
                this.Rows.Remove(row);
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
                System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
                System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
                Worker_Customer_SystemDataSet ds = new Worker_Customer_SystemDataSet();
                xs.Add(ds.GetSchemaSerializable());
                System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
                any1.Namespace = "http://www.w3.org/2001/XMLSchema";
                any1.MinOccurs = new decimal(0);
                any1.MaxOccurs = decimal.MaxValue;
                any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
                sequence.Items.Add(any1);
                System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
                any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
                any2.MinOccurs = new decimal(1);
                any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
                sequence.Items.Add(any2);
                System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
                attribute1.Name = "namespace";
                attribute1.FixedValue = ds.Namespace;
                type.Attributes.Add(attribute1);
                System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
                attribute2.Name = "tableTypeName";
                attribute2.FixedValue = "tblJobDetailsDataTable";
                type.Attributes.Add(attribute2);
                type.Particle = sequence;
                return type;
            }
        }
        
        [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
        [System.Serializable()]
        [System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
        public partial class tblWorkerDataTable : System.Data.DataTable, System.Collections.IEnumerable {
            
            private System.Data.DataColumn columnWorkId;
            
            private System.Data.DataColumn columnName;
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public tblWorkerDataTable() {
                this.TableName = "tblWorker";
                this.BeginInit();
                this.InitClass();
                this.EndInit();
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            internal tblWorkerDataTable(System.Data.DataTable table) {
                this.TableName = 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;
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected tblWorkerDataTable(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context) : 
                    base(info, context) {
                this.InitVars();
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public System.Data.DataColumn WorkIdColumn {
                get {
                    return this.columnWorkId;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public System.Data.DataColumn NameColumn {
                get {
                    return this.columnName;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [System.ComponentModel.Browsable(false)]
            public int Count {
                get {
                    return this.Rows.Count;
                }