jobdatset.cs

跟踪每个月客户的造访次数

                get {
                    return ((tblJobDetailsRow)(this.Rows[index]));
                }
            }
            
            public event tblJobDetailsRowChangeEventHandler tblJobDetailsRowChanged;
            
            public event tblJobDetailsRowChangeEventHandler tblJobDetailsRowChanging;
            
            public event tblJobDetailsRowChangeEventHandler tblJobDetailsRowDeleted;
            
            public event tblJobDetailsRowChangeEventHandler tblJobDetailsRowDeleting;
            
            public void AddtblJobDetailsRow(tblJobDetailsRow row) {
                this.Rows.Add(row);
            }
            
            public tblJobDetailsRow AddtblJobDetailsRow(
                        string CarNo, 
                        string JobDate, 
                        int WorkerID, 
                        int KMs, 
                        int Tuning, 
                        int Alignment, 
                        int Balancing, 
                        int Tires, 
                        int Weights, 
                        int OilChanged, 
                        int OilQty, 
                        int OilFilter, 
                        int GearOil, 
                        int GearOilQty, 
                        string Point, 
                        int Condenser, 
                        int Plug, 
                        int PlugQty, 
                        int FuelFilter, 
                        int AirFilter, 
                        int Remarks) {
                tblJobDetailsRow rowtblJobDetailsRow = ((tblJobDetailsRow)(this.NewRow()));
                rowtblJobDetailsRow.ItemArray = new object[] {
                        CarNo,
                        JobDate,
                        WorkerID,
                        KMs,
                        Tuning,
                        Alignment,
                        Balancing,
                        Tires,
                        Weights,
                        OilChanged,
                        OilQty,
                        OilFilter,
                        GearOil,
                        GearOilQty,
                        Point,
                        Condenser,
                        Plug,
                        PlugQty,
                        FuelFilter,
                        AirFilter,
                        Remarks};
                this.Rows.Add(rowtblJobDetailsRow);
                return rowtblJobDetailsRow;
            }
            
            public tblJobDetailsRow FindByCarNoJobDate(string CarNo, string JobDate) {
                return ((tblJobDetailsRow)(this.Rows.Find(new object[] {
                            CarNo,
                            JobDate})));
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                tblJobDetailsDataTable cln = ((tblJobDetailsDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new tblJobDetailsDataTable();
            }
            
            internal void InitVars() {
                this.columnCarNo = this.Columns["CarNo"];
                this.columnJobDate = this.Columns["JobDate"];
                this.columnWorkerID = this.Columns["WorkerID"];
                this.columnKMs = this.Columns["KMs"];
                this.columnTuning = this.Columns["Tuning"];
                this.columnAlignment = this.Columns["Alignment"];
                this.columnBalancing = this.Columns["Balancing"];
                this.columnTires = this.Columns["Tires"];
                this.columnWeights = this.Columns["Weights"];
                this.columnOilChanged = this.Columns["OilChanged"];
                this.columnOilQty = this.Columns["OilQty"];
                this.columnOilFilter = this.Columns["OilFilter"];
                this.columnGearOil = this.Columns["GearOil"];
                this.columnGearOilQty = this.Columns["GearOilQty"];
                this.columnPoint = this.Columns["Point"];
                this.columnCondenser = this.Columns["Condenser"];
                this.columnPlug = this.Columns["Plug"];
                this.columnPlugQty = this.Columns["PlugQty"];
                this.columnFuelFilter = this.Columns["FuelFilter"];
                this.columnAirFilter = this.Columns["AirFilter"];
                this.columnRemarks = this.Columns["Remarks"];
            }
            
            private void InitClass() {
                this.columnCarNo = new DataColumn("CarNo", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnCarNo);
                this.columnJobDate = new DataColumn("JobDate", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnJobDate);
                this.columnWorkerID = new DataColumn("WorkerID", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnWorkerID);
                this.columnKMs = new DataColumn("KMs", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnKMs);
                this.columnTuning = new DataColumn("Tuning", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnTuning);
                this.columnAlignment = new DataColumn("Alignment", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnAlignment);
                this.columnBalancing = new DataColumn("Balancing", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnBalancing);
                this.columnTires = new DataColumn("Tires", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnTires);
                this.columnWeights = new DataColumn("Weights", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnWeights);
                this.columnOilChanged = new DataColumn("OilChanged", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnOilChanged);
                this.columnOilQty = new DataColumn("OilQty", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnOilQty);
                this.columnOilFilter = new DataColumn("OilFilter", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnOilFilter);
                this.columnGearOil = new DataColumn("GearOil", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnGearOil);
                this.columnGearOilQty = new DataColumn("GearOilQty", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnGearOilQty);
                this.columnPoint = new DataColumn("Point", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnPoint);
                this.columnCondenser = new DataColumn("Condenser", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnCondenser);
                this.columnPlug = new DataColumn("Plug", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnPlug);
                this.columnPlugQty = new DataColumn("PlugQty", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnPlugQty);
                this.columnFuelFilter = new DataColumn("FuelFilter", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnFuelFilter);
                this.columnAirFilter = new DataColumn("AirFilter", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnAirFilter);
                this.columnRemarks = new DataColumn("Remarks", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnRemarks);
                this.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.columnCarNo,
                                this.columnJobDate}, true));
                this.columnCarNo.AllowDBNull = false;
                this.columnJobDate.AllowDBNull = false;
                this.columnWorkerID.AllowDBNull = false;
            }
            
            public tblJobDetailsRow NewtblJobDetailsRow() {
                return ((tblJobDetailsRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new tblJobDetailsRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(tblJobDetailsRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.tblJobDetailsRowChanged != null)) {
                    this.tblJobDetailsRowChanged(this, new tblJobDetailsRowChangeEvent(((tblJobDetailsRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.tblJobDetailsRowChanging != null)) {
                    this.tblJobDetailsRowChanging(this, new tblJobDetailsRowChangeEvent(((tblJobDetailsRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.tblJobDetailsRowDeleted != null)) {
                    this.tblJobDetailsRowDeleted(this, new tblJobDetailsRowChangeEvent(((tblJobDetailsRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.tblJobDetailsRowDeleting != null)) {
                    this.tblJobDetailsRowDeleting(this, new tblJobDetailsRowChangeEvent(((tblJobDetailsRow)(e.Row)), e.Action));
                }
            }
            
            public void RemovetblJobDetailsRow(tblJobDetailsRow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class tblJobDetailsRow : DataRow {
            
            private tblJobDetailsDataTable tabletblJobDetails;
            
            internal tblJobDetailsRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tabletblJobDetails = ((tblJobDetailsDataTable)(this.Table));
            }
            
            public string CarNo {
                get {
                    return ((string)(this[this.tabletblJobDetails.CarNoColumn]));
                }
                set {
                    this[this.tabletblJobDetails.CarNoColumn] = value;
                }
            }
            
            public string JobDate {
                get {
                    return ((string)(this[this.tabletblJobDetails.JobDateColumn]));
                }
                set {
                    this[this.tabletblJobDetails.JobDateColumn] = value;
                }
            }
            
            public int WorkerID {
                get {
                    return ((int)(this[this.tabletblJobDetails.WorkerIDColumn]));
                }
                set {
                    this[this.tabletblJobDetails.WorkerIDColumn] = value;
                }
            }
            
            public int KMs {
                get {
                    try {
                        return ((int)(this[this.tabletblJobDetails.KMsColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblJobDetails.KMsColumn] = value;
                }
            }
            
            public int Tuning {
                get {
                    try {
                        return ((int)(this[this.tabletblJobDetails.TuningColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblJobDetails.TuningColumn] = value;
                }
            }
            
            public int Alignment {
                get {
                    try {
                        return ((int)(this[this.tabletblJobDetails.AlignmentColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblJobDetails.AlignmentColumn] = value;
                }
            }
            
            public int Balancing {
                get {
                    try {
                        return ((int)(this[this.tabletblJobDetails.BalancingColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblJobDetails.BalancingColumn] = value;
                }
            }
            
            public int Tires {
                get {
                    try {
                        return ((int)(this[this.tabletblJobDetails.TiresColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblJobDetails.TiresColumn] = value;
                }
            }
            
            public int Weights {
                get {
                    try {
                        return ((int)(this[this.tabletblJobDetails.WeightsColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tabletblJobDetails.WeightsColumn] = value;
                }
            }
            
            public int OilChanged {
                get {
                    try {
                        return ((int)(this[this.tabletblJobDetails.OilChangedColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);