jobdetailsdataset.cs

这是一个保障消费者合法权益的系统．使用C ＃和SQL Server终于实现了这一功能的系统

            public event tblTransRowChangeEventHandler tblTransRowChanging;
            
            public event tblTransRowChangeEventHandler tblTransRowDeleted;
            
            public event tblTransRowChangeEventHandler tblTransRowDeleting;
            
            public void AddtblTransRow(tblTransRow row) {
                this.Rows.Add(row);
            }
            
            public tblTransRow AddtblTransRow(
                        string CarNo, 
                        System.DateTime JobDate, 
                        int KM, 
                        System.Byte Tuning, 
                        System.Byte Alignment, 
                        System.Byte Balancing, 
                        int Tyres, 
                        int Weights, 
                        System.Byte OilChanged, 
                        System.Double OilQty, 
                        System.Byte OilFilter, 
                        System.Byte GearOil, 
                        System.Double GearOilQty, 
                        System.Byte Point, 
                        System.Byte Condenser, 
                        System.Byte Plug, 
                        int PlugQty, 
                        System.Byte FuelFilter, 
                        System.Byte AirFilter, 
                        System.Byte WADoneBy, 
                        System.Byte STDoneBy, 
                        string Remarks) {
                tblTransRow rowtblTransRow = ((tblTransRow)(this.NewRow()));
                rowtblTransRow.ItemArray = new object[] {
                        CarNo,
                        JobDate,
                        KM,
                        Tuning,
                        Alignment,
                        Balancing,
                        Tyres,
                        Weights,
                        OilChanged,
                        OilQty,
                        OilFilter,
                        GearOil,
                        GearOilQty,
                        Point,
                        Condenser,
                        Plug,
                        PlugQty,
                        FuelFilter,
                        AirFilter,
                        WADoneBy,
                        STDoneBy,
                        Remarks};
                this.Rows.Add(rowtblTransRow);
                return rowtblTransRow;
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                tblTransDataTable cln = ((tblTransDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            internal void InitVars() {
                this.columnCarNo = this.Columns["CarNo"];
                this.columnJobDate = this.Columns["JobDate"];
                this.columnKM = this.Columns["KM"];
                this.columnTuning = this.Columns["Tuning"];
                this.columnAlignment = this.Columns["Alignment"];
                this.columnBalancing = this.Columns["Balancing"];
                this.columnTyres = this.Columns["Tyres"];
                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.columnWADoneBy = this.Columns["WADoneBy"];
                this.columnSTDoneBy = this.Columns["STDoneBy"];
                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(System.DateTime), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnJobDate);
                this.columnKM = new DataColumn("KM", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnKM);
                this.columnTuning = new DataColumn("Tuning", typeof(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnTuning);
                this.columnAlignment = new DataColumn("Alignment", typeof(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnAlignment);
                this.columnBalancing = new DataColumn("Balancing", typeof(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnBalancing);
                this.columnTyres = new DataColumn("Tyres", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnTyres);
                this.columnWeights = new DataColumn("Weights", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnWeights);
                this.columnOilChanged = new DataColumn("OilChanged", typeof(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnOilChanged);
                this.columnOilQty = new DataColumn("OilQty", typeof(System.Double), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnOilQty);
                this.columnOilFilter = new DataColumn("OilFilter", typeof(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnOilFilter);
                this.columnGearOil = new DataColumn("GearOil", typeof(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnGearOil);
                this.columnGearOilQty = new DataColumn("GearOilQty", typeof(System.Double), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnGearOilQty);
                this.columnPoint = new DataColumn("Point", typeof(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnPoint);
                this.columnCondenser = new DataColumn("Condenser", typeof(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnCondenser);
                this.columnPlug = new DataColumn("Plug", typeof(System.Byte), 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(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnFuelFilter);
                this.columnAirFilter = new DataColumn("AirFilter", typeof(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnAirFilter);
                this.columnWADoneBy = new DataColumn("WADoneBy", typeof(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnWADoneBy);
                this.columnSTDoneBy = new DataColumn("STDoneBy", typeof(System.Byte), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnSTDoneBy);
                this.columnRemarks = new DataColumn("Remarks", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnRemarks);
                this.columnCarNo.AllowDBNull = false;
            }
            
            public tblTransRow NewtblTransRow() {
                return ((tblTransRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new tblTransRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(tblTransRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.tblTransRowChanged != null)) {
                    this.tblTransRowChanged(this, new tblTransRowChangeEvent(((tblTransRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.tblTransRowChanging != null)) {
                    this.tblTransRowChanging(this, new tblTransRowChangeEvent(((tblTransRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.tblTransRowDeleted != null)) {
                    this.tblTransRowDeleted(this, new tblTransRowChangeEvent(((tblTransRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.tblTransRowDeleting != null)) {
                    this.tblTransRowDeleting(this, new tblTransRowChangeEvent(((tblTransRow)(e.Row)), e.Action));
                }
            }
            
            public void RemovetblTransRow(tblTransRow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class tblTransRow : DataRow {
            
            private tblTransDataTable tabletblTrans;
            
            internal tblTransRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tabletblTrans = ((tblTransDataTable)(this.Table));
            }
            
            public string CarNo {
                get {
                    return ((string)(this[this.tabletblTrans.CarNoColumn]));
                }
                set {
                    this[this.tabletblTrans.CarNoColumn] = value;
                }
            }
            
            public System.DateTime JobDate {
                get {
                    try {
                        return ((System.DateTime)(this[this.tabletblTrans.JobDateColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tabletblTrans.JobDateColumn] = value;
                }
            }
            
            public int KM {
                get {
                    try {
                        return ((int)(this[this.tabletblTrans.KMColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tabletblTrans.KMColumn] = value;
                }
            }
            
            public System.Byte Tuning {
                get {
                    try {
                        return ((System.Byte)(this[this.tabletblTrans.TuningColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tabletblTrans.TuningColumn] = value;
                }
            }
            
            public System.Byte Alignment {
                get {
                    try {
                        return ((System.Byte)(this[this.tabletblTrans.AlignmentColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tabletblTrans.AlignmentColumn] = value;
                }
            }
            
            public System.Byte Balancing {
                get {
                    try {
                        return ((System.Byte)(this[this.tabletblTrans.BalancingColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tabletblTrans.BalancingColumn] = value;
                }
            }
            
            public int Tyres {
                get {
                    try {
                        return ((int)(this[this.tabletblTrans.TyresColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tabletblTrans.TyresColumn] = value;
                }
            }
            
            public int Weights {
                get {
                    try {
                        return ((int)(this[this.tabletblTrans.WeightsColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tabletblTrans.WeightsColumn] = value;
                }
            }
            
            public System.Byte OilChanged {
                get {
                    try {
                        return ((System.Byte)(this[this.tabletblTrans.OilChangedColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tabletblTrans.OilChangedColumn] = value;
                }
            }
            
            public System.Double OilQty {
                get {
                    try {
                        return ((System.Double)(this[this.tabletblTrans.OilQtyColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tabletblTrans.OilQtyColumn] = value;
                }
            }
            
            public System.Byte OilFilter {
                get {
                    try {
                        return ((System.Byte)(this[this.tabletblTrans.OilFilterColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tabletblTrans.OilFilterColumn] = value;
                }
            }
            
            public System.Byte GearOil {