jobdetails.cs

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

																																																						 new System.Data.Common.DataColumnMapping("Tuning", "Tuning"),
																																																						 new System.Data.Common.DataColumnMapping("Alignment", "Alignment"),
																																																						 new System.Data.Common.DataColumnMapping("Balancing", "Balancing"),
																																																						 new System.Data.Common.DataColumnMapping("Tyres", "Tyres"),
																																																						 new System.Data.Common.DataColumnMapping("Weights", "Weights"),
																																																						 new System.Data.Common.DataColumnMapping("OilChanged", "OilChanged"),
																																																						 new System.Data.Common.DataColumnMapping("OilQty", "OilQty"),
																																																						 new System.Data.Common.DataColumnMapping("OilFilter", "OilFilter"),
																																																						 new System.Data.Common.DataColumnMapping("GearOil", "GearOil"),
																																																						 new System.Data.Common.DataColumnMapping("GearOilQty", "GearOilQty"),
																																																						 new System.Data.Common.DataColumnMapping("Point", "Point"),
																																																						 new System.Data.Common.DataColumnMapping("Condenser", "Condenser"),
																																																						 new System.Data.Common.DataColumnMapping("Plug", "Plug"),
																																																						 new System.Data.Common.DataColumnMapping("PlugQty", "PlugQty"),
																																																						 new System.Data.Common.DataColumnMapping("FuelFilter", "FuelFilter"),
																																																						 new System.Data.Common.DataColumnMapping("AirFilter", "AirFilter"),
																																																						 new System.Data.Common.DataColumnMapping("Remarks", "Remarks")})});
			this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
			// 
			// btnLoad
			// 
			this.btnLoad.Location = new System.Drawing.Point(19, 482);
			this.btnLoad.Name = "btnLoad";
			this.btnLoad.Size = new System.Drawing.Size(90, 25);
			this.btnLoad.TabIndex = 0;
			this.btnLoad.Text = "&Load";
			this.btnLoad.Click += new System.EventHandler(this.btnLoad_Click);
			// 
			// btnUpdate
			// 
			this.btnUpdate.Location = new System.Drawing.Point(595, 482);
			this.btnUpdate.Name = "btnUpdate";
			this.btnUpdate.Size = new System.Drawing.Size(90, 25);
			this.btnUpdate.TabIndex = 1;
			this.btnUpdate.Text = "&Update";
			this.btnUpdate.Click += new System.EventHandler(this.btnUpdate_Click);
			// 
			// btnCancelAll
			// 
			this.btnCancelAll.Location = new System.Drawing.Point(480, 482);
			this.btnCancelAll.Name = "btnCancelAll";
			this.btnCancelAll.Size = new System.Drawing.Size(90, 25);
			this.btnCancelAll.TabIndex = 2;
			this.btnCancelAll.Text = "Ca&ncel All";
			this.btnCancelAll.Click += new System.EventHandler(this.btnCancelAll_Click);
			// 
			// lblCarNo
			// 
			this.lblCarNo.Location = new System.Drawing.Point(19, 43);
			this.lblCarNo.Name = "lblCarNo";
			this.lblCarNo.Size = new System.Drawing.Size(120, 25);
			this.lblCarNo.TabIndex = 3;
			this.lblCarNo.Text = "CarNo";
			// 
			// lblJobDate
			// 
			this.lblJobDate.Location = new System.Drawing.Point(19, 78);
			this.lblJobDate.Name = "lblJobDate";
			this.lblJobDate.Size = new System.Drawing.Size(120, 24);
			this.lblJobDate.TabIndex = 4;
			this.lblJobDate.Text = "JobDate";
			// 
			// lblWorkerId
			// 
			this.lblWorkerId.Location = new System.Drawing.Point(19, 112);
			this.lblWorkerId.Name = "lblWorkerId";
			this.lblWorkerId.Size = new System.Drawing.Size(120, 25);
			this.lblWorkerId.TabIndex = 5;
			this.lblWorkerId.Text = "WorkerId";
			// 
			// lblKMs
			// 
			this.lblKMs.Location = new System.Drawing.Point(19, 146);
			this.lblKMs.Name = "lblKMs";
			this.lblKMs.Size = new System.Drawing.Size(120, 25);
			this.lblKMs.TabIndex = 6;
			this.lblKMs.Text = "KMs";
			// 
			// lblTuning
			// 
			this.lblTuning.Location = new System.Drawing.Point(19, 181);
			this.lblTuning.Name = "lblTuning";
			this.lblTuning.Size = new System.Drawing.Size(120, 25);
			this.lblTuning.TabIndex = 7;
			this.lblTuning.Text = "Tuning";
			// 
			// lblAlignment
			// 
			this.lblAlignment.Location = new System.Drawing.Point(19, 224);
			this.lblAlignment.Name = "lblAlignment";
			this.lblAlignment.Size = new System.Drawing.Size(120, 25);
			this.lblAlignment.TabIndex = 8;
			this.lblAlignment.Text = "Alignment";
			// 
			// lblBalancing
			// 
			this.lblBalancing.Location = new System.Drawing.Point(19, 258);
			this.lblBalancing.Name = "lblBalancing";
			this.lblBalancing.Size = new System.Drawing.Size(120, 25);
			this.lblBalancing.TabIndex = 9;
			this.lblBalancing.Text = "Balancing";
			// 
			// lblTyres
			// 
			this.lblTyres.Location = new System.Drawing.Point(19, 293);
			this.lblTyres.Name = "lblTyres";
			this.lblTyres.Size = new System.Drawing.Size(120, 25);
			this.lblTyres.TabIndex = 10;
			this.lblTyres.Text = "Tyres";
			// 
			// lblWeights
			// 
			this.lblWeights.Location = new System.Drawing.Point(19, 327);
			this.lblWeights.Name = "lblWeights";
			this.lblWeights.Size = new System.Drawing.Size(120, 25);
			this.lblWeights.TabIndex = 11;
			this.lblWeights.Text = "Weights";
			// 
			// lblOilChanged
			// 
			this.lblOilChanged.Location = new System.Drawing.Point(19, 362);
			this.lblOilChanged.Name = "lblOilChanged";
			this.lblOilChanged.Size = new System.Drawing.Size(120, 25);
			this.lblOilChanged.TabIndex = 12;
			this.lblOilChanged.Text = "OilChanged";
			// 
			// lblOilQty
			// 
			this.lblOilQty.Location = new System.Drawing.Point(19, 396);
			this.lblOilQty.Name = "lblOilQty";
			this.lblOilQty.Size = new System.Drawing.Size(120, 25);
			this.lblOilQty.TabIndex = 13;
			this.lblOilQty.Text = "OilQty";
			// 
			// editCarNo
			// 
			this.editCarNo.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.objJobDataSet, "tblJobDetails.CarNo"));
			this.editCarNo.Location = new System.Drawing.Point(154, 43);
			this.editCarNo.Name = "editCarNo";
			this.editCarNo.Size = new System.Drawing.Size(201, 21);
			this.editCarNo.TabIndex = 14;
			this.editCarNo.Text = "";
			// 
			// editJobDate
			// 
			this.editJobDate.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.objJobDataSet, "tblJobDetails.JobDate"));
			this.editJobDate.Location = new System.Drawing.Point(154, 78);
			this.editJobDate.Name = "editJobDate";
			this.editJobDate.Size = new System.Drawing.Size(201, 21);
			this.editJobDate.TabIndex = 15;
			this.editJobDate.Text = "";
			// 
			// editWorkerId
			// 
			this.editWorkerId.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.objJobDataSet, "tblJobDetails.WorkerId"));
			this.editWorkerId.Location = new System.Drawing.Point(154, 112);
			this.editWorkerId.Name = "editWorkerId";
			this.editWorkerId.Size = new System.Drawing.Size(201, 21);
			this.editWorkerId.TabIndex = 16;
			this.editWorkerId.Text = "";
			// 
			// editKMs
			// 
			this.editKMs.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.objJobDataSet, "tblJobDetails.KMs"));
			this.editKMs.Location = new System.Drawing.Point(154, 146);
			this.editKMs.Name = "editKMs";
			this.editKMs.Size = new System.Drawing.Size(201, 21);
			this.editKMs.TabIndex = 17;
			this.editKMs.Text = "";
			// 
			// editTuning
			// 
			this.editTuning.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.objJobDataSet, "tblJobDetails.Tuning"));
			this.editTuning.Location = new System.Drawing.Point(154, 181);
			this.editTuning.Name = "editTuning";
			this.editTuning.Size = new System.Drawing.Size(201, 21);
			this.editTuning.TabIndex = 18;
			this.editTuning.Text = "";
			// 
			// editAlignment
			//