jobdetails.cs

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

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;

namespace Customer_Maintenance_Project
{
	/// <summary>
	/// Summary description for JobDetails.
	/// </summary>
	public class JobDetails : System.Windows.Forms.Form
	{
		private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
		private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
		private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
		private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
		private Customer_Maintenance_Project.JobDataSet objJobDataSet;
		private System.Data.OleDb.OleDbConnection oleDbConnection1;
		private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
		private System.Windows.Forms.Button btnLoad;
		private System.Windows.Forms.Button btnUpdate;
		private System.Windows.Forms.Button btnCancelAll;
		private System.Windows.Forms.Label lblCarNo;
		private System.Windows.Forms.Label lblJobDate;
		private System.Windows.Forms.Label lblWorkerId;
		private System.Windows.Forms.Label lblKMs;
		private System.Windows.Forms.Label lblTuning;
		private System.Windows.Forms.Label lblAlignment;
		private System.Windows.Forms.Label lblBalancing;
		private System.Windows.Forms.Label lblTyres;
		private System.Windows.Forms.Label lblWeights;
		private System.Windows.Forms.Label lblOilChanged;
		private System.Windows.Forms.Label lblOilQty;
		private System.Windows.Forms.TextBox editCarNo;
		private System.Windows.Forms.TextBox editJobDate;
		private System.Windows.Forms.TextBox editWorkerId;
		private System.Windows.Forms.TextBox editKMs;
		private System.Windows.Forms.TextBox editTuning;
		private System.Windows.Forms.TextBox editAlignment;
		private System.Windows.Forms.TextBox editBalancing;
		private System.Windows.Forms.TextBox editTyres;
		private System.Windows.Forms.TextBox editWeights;
		private System.Windows.Forms.TextBox editOilChanged;
		private System.Windows.Forms.TextBox editOilQty;
		private System.Windows.Forms.Label lblOilFilter;
		private System.Windows.Forms.Label lblGearOil;
		private System.Windows.Forms.Label lblGearOilQty;
		private System.Windows.Forms.Label lblPoint;
		private System.Windows.Forms.Label lblCondenser;
		private System.Windows.Forms.Label lblPlug;
		private System.Windows.Forms.Label lblPlugQty;
		private System.Windows.Forms.Label lblFuelFilter;
		private System.Windows.Forms.Label lblAirFilter;
		private System.Windows.Forms.Label lblRemarks;
		private System.Windows.Forms.TextBox editOilFilter;
		private System.Windows.Forms.TextBox editGearOil;
		private System.Windows.Forms.TextBox editGearOilQty;
		private System.Windows.Forms.TextBox editPoint;
		private System.Windows.Forms.TextBox editCondenser;
		private System.Windows.Forms.TextBox editPlug;
		private System.Windows.Forms.TextBox editPlugQty;
		private System.Windows.Forms.TextBox editFuelFilter;
		private System.Windows.Forms.TextBox editAirFilter;
		private System.Windows.Forms.TextBox editRemarks;
		private System.Windows.Forms.Button btnNavFirst;
		private System.Windows.Forms.Button btnNavPrev;
		private System.Windows.Forms.Label lblNavLocation;
		private System.Windows.Forms.Button btnNavNext;
		private System.Windows.Forms.Button btnLast;
		private System.Windows.Forms.Button btnAdd;
		private System.Windows.Forms.Button btnDelete;
		private System.Windows.Forms.Button btnCancel;
		private System.Windows.Forms.Button btnExit;
		/// <summary>
		/// Required designer variable.
		/// </summary>
		private System.ComponentModel.Container components = null;

		public JobDetails()
		{
			//
			// Required for Windows Form Designer support
			//
			InitializeComponent();

			//
			// TODO: Add any constructor code after InitializeComponent call
			//
		}

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows Form Designer generated code
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
			this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
			this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
			this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
			this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
			this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
			this.objJobDataSet = new Customer_Maintenance_Project.JobDataSet();
			this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
			this.btnLoad = new System.Windows.Forms.Button();
			this.btnUpdate = new System.Windows.Forms.Button();
			this.btnCancelAll = new System.Windows.Forms.Button();
			this.lblCarNo = new System.Windows.Forms.Label();
			this.lblJobDate = new System.Windows.Forms.Label();
			this.lblWorkerId = new System.Windows.Forms.Label();
			this.lblKMs = new System.Windows.Forms.Label();
			this.lblTuning = new System.Windows.Forms.Label();
			this.lblAlignment = new System.Windows.Forms.Label();
			this.lblBalancing = new System.Windows.Forms.Label();
			this.lblTyres = new System.Windows.Forms.Label();
			this.lblWeights = new System.Windows.Forms.Label();
			this.lblOilChanged = new System.Windows.Forms.Label();
			this.lblOilQty = new System.Windows.Forms.Label();
			this.editCarNo = new System.Windows.Forms.TextBox();
			this.editJobDate = new System.Windows.Forms.TextBox();
			this.editWorkerId = new System.Windows.Forms.TextBox();
			this.editKMs = new System.Windows.Forms.TextBox();
			this.editTuning = new System.Windows.Forms.TextBox();
			this.editAlignment = new System.Windows.Forms.TextBox();
			this.editBalancing = new System.Windows.Forms.TextBox();
			this.editTyres = new System.Windows.Forms.TextBox();
			this.editWeights = new System.Windows.Forms.TextBox();
			this.editOilChanged = new System.Windows.Forms.TextBox();
			this.editOilQty = new System.Windows.Forms.TextBox();
			this.lblOilFilter = new System.Windows.Forms.Label();
			this.lblGearOil = new System.Windows.Forms.Label();
			this.lblGearOilQty = new System.Windows.Forms.Label();
			this.lblPoint = new System.Windows.Forms.Label();
			this.lblCondenser = new System.Windows.Forms.Label();
			this.lblPlug = new System.Windows.Forms.Label();
			this.lblPlugQty = new System.Windows.Forms.Label();
			this.lblFuelFilter = new System.Windows.Forms.Label();
			this.lblAirFilter = new System.Windows.Forms.Label();
			this.lblRemarks = new System.Windows.Forms.Label();
			this.editOilFilter = new System.Windows.Forms.TextBox();
			this.editGearOil = new System.Windows.Forms.TextBox();
			this.editGearOilQty = new System.Windows.Forms.TextBox();
			this.editPoint = new System.Windows.Forms.TextBox();
			this.editCondenser = new System.Windows.Forms.TextBox();
			this.editPlug = new System.Windows.Forms.TextBox();
			this.editPlugQty = new System.Windows.Forms.TextBox();
			this.editFuelFilter = new System.Windows.Forms.TextBox();
			this.editAirFilter = new System.Windows.Forms.TextBox();
			this.editRemarks = new System.Windows.Forms.TextBox();
			this.btnNavFirst = new System.Windows.Forms.Button();
			this.btnNavPrev = new System.Windows.Forms.Button();
			this.lblNavLocation = new System.Windows.Forms.Label();
			this.btnNavNext = new System.Windows.Forms.Button();
			this.btnLast = new System.Windows.Forms.Button();
			this.btnAdd = new System.Windows.Forms.Button();
			this.btnDelete = new System.Windows.Forms.Button();
			this.btnCancel = new System.Windows.Forms.Button();
			this.btnExit = new System.Windows.Forms.Button();
			((System.ComponentModel.ISupportInitialize)(this.objJobDataSet)).BeginInit();
			this.SuspendLayout();
			// 
			// oleDbSelectCommand1
			// 
			this.oleDbSelectCommand1.CommandText = "SELECT CarNo, JobDate, WorkerId, KMs, Tuning, Alignment, Balancing, Tyres, Weight" +
				"s, OilChanged, OilQty, OilFilter, GearOil, GearOilQty, Point, Condenser, Plug, P" +