frminitial.cs

汽车销售管理系统,进销存系统典范,值得初学者多多学习

			// 
			// label7
			// 
			this.label7.AutoSize = true;
			this.label7.BackColor = System.Drawing.Color.Transparent;
			this.label7.Location = new System.Drawing.Point(184, 60);
			this.label7.Name = "label7";
			this.label7.Size = new System.Drawing.Size(42, 17);
			this.label7.TabIndex = 22;
			this.label7.Text = "收款单";
			// 
			// txtPay
			// 
			this.txtPay.BackColor = System.Drawing.Color.LightGoldenrodYellow;
			this.txtPay.DataBindings.Add(new System.Windows.Forms.Binding("Text", this._dsOsINI1, "tblOsInit.osiPayCode"));
			this.txtPay.Location = new System.Drawing.Point(230, 88);
			this.txtPay.Name = "txtPay";
			this.txtPay.ReadOnly = true;
			this.txtPay.Size = new System.Drawing.Size(96, 21);
			this.txtPay.TabIndex = 21;
			this.txtPay.Text = "";
			// 
			// txtSelling
			// 
			this.txtSelling.BackColor = System.Drawing.Color.LightGoldenrodYellow;
			this.txtSelling.DataBindings.Add(new System.Windows.Forms.Binding("Text", this._dsOsINI1, "tblOsInit.osiSellCode"));
			this.txtSelling.Location = new System.Drawing.Point(390, 58);
			this.txtSelling.Name = "txtSelling";
			this.txtSelling.ReadOnly = true;
			this.txtSelling.Size = new System.Drawing.Size(96, 21);
			this.txtSelling.TabIndex = 19;
			this.txtSelling.Text = "";
			// 
			// label12
			// 
			this.label12.AutoSize = true;
			this.label12.BackColor = System.Drawing.Color.Transparent;
			this.label12.Location = new System.Drawing.Point(344, 60);
			this.label12.Name = "label12";
			this.label12.Size = new System.Drawing.Size(42, 17);
			this.label12.TabIndex = 18;
			this.label12.Text = "销售单";
			// 
			// txtSellS
			// 
			this.txtSellS.BackColor = System.Drawing.Color.LightGoldenrodYellow;
			this.txtSellS.DataBindings.Add(new System.Windows.Forms.Binding("Text", this._dsOsINI1, "tblOsInit.osiPreCode"));
			this.txtSellS.Location = new System.Drawing.Point(390, 24);
			this.txtSellS.Name = "txtSellS";
			this.txtSellS.ReadOnly = true;
			this.txtSellS.Size = new System.Drawing.Size(96, 21);
			this.txtSellS.TabIndex = 17;
			this.txtSellS.Text = "";
			// 
			// label11
			// 
			this.label11.AutoSize = true;
			this.label11.BackColor = System.Drawing.Color.Transparent;
			this.label11.Location = new System.Drawing.Point(336, 26);
			this.label11.Name = "label11";
			this.label11.Size = new System.Drawing.Size(54, 17);
			this.label11.TabIndex = 16;
			this.label11.Text = "销售订单";
			// 
			// txtGet
			// 
			this.txtGet.BackColor = System.Drawing.Color.LightGoldenrodYellow;
			this.txtGet.DataBindings.Add(new System.Windows.Forms.Binding("Text", this._dsOsINI1, "tblOsInit.osiGatheringCode"));
			this.txtGet.Location = new System.Drawing.Point(230, 58);
			this.txtGet.Name = "txtGet";
			this.txtGet.ReadOnly = true;
			this.txtGet.Size = new System.Drawing.Size(96, 21);
			this.txtGet.TabIndex = 15;
			this.txtGet.Text = "";
			// 
			// txtStock
			// 
			this.txtStock.BackColor = System.Drawing.Color.LightGoldenrodYellow;
			this.txtStock.DataBindings.Add(new System.Windows.Forms.Binding("Text", this._dsOsINI1, "tblOsInit.osiStoCode"));
			this.txtStock.Location = new System.Drawing.Point(230, 24);
			this.txtStock.Name = "txtStock";
			this.txtStock.ReadOnly = true;
			this.txtStock.Size = new System.Drawing.Size(96, 21);
			this.txtStock.TabIndex = 11;
			this.txtStock.Text = "";
			// 
			// label8
			// 
			this.label8.AutoSize = true;
			this.label8.BackColor = System.Drawing.Color.Transparent;
			this.label8.Location = new System.Drawing.Point(176, 26);
			this.label8.Name = "label8";
			this.label8.Size = new System.Drawing.Size(54, 17);
			this.label8.TabIndex = 10;
			this.label8.Text = "采购订单";
			// 
			// txtMove
			// 
			this.txtMove.BackColor = System.Drawing.Color.LightGoldenrodYellow;
			this.txtMove.DataBindings.Add(new System.Windows.Forms.Binding("Text", this._dsOsINI1, "tblOsInit.osiMoveCode"));
			this.txtMove.Location = new System.Drawing.Point(72, 58);
			this.txtMove.Name = "txtMove";
			this.txtMove.ReadOnly = true;
			this.txtMove.Size = new System.Drawing.Size(96, 21);
			this.txtMove.TabIndex = 7;
			this.txtMove.Text = "";
			// 
			// label6
			// 
			this.label6.AutoSize = true;
			this.label6.BackColor = System.Drawing.Color.Transparent;
			this.label6.Location = new System.Drawing.Point(24, 60);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(42, 17);
			this.label6.TabIndex = 6;
			this.label6.Text = "移库单";
			// 
			// txtInDepot
			// 
			this.txtInDepot.BackColor = System.Drawing.Color.LightGoldenrodYellow;
			this.txtInDepot.DataBindings.Add(new System.Windows.Forms.Binding("Text", this._dsOsINI1, "tblOsInit.osiInDepotCode"));
			this.txtInDepot.Location = new System.Drawing.Point(72, 24);
			this.txtInDepot.Name = "txtInDepot";
			this.txtInDepot.ReadOnly = true;
			this.txtInDepot.Size = new System.Drawing.Size(96, 21);
			this.txtInDepot.TabIndex = 5;
			this.txtInDepot.Text = "";
			// 
			// label5
			// 
			this.label5.AutoSize = true;
			this.label5.BackColor = System.Drawing.Color.Transparent;
			this.label5.Location = new System.Drawing.Point(24, 26);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(42, 17);
			this.label5.TabIndex = 4;
			this.label5.Text = "入库单";
			// 
			// label14
			// 
			this.label14.AutoSize = true;
			this.label14.BackColor = System.Drawing.Color.Transparent;
			this.label14.Location = new System.Drawing.Point(24, 90);
			this.label14.Name = "label14";
			this.label14.Size = new System.Drawing.Size(42, 17);
			this.label14.TabIndex = 8;
			this.label14.Text = "代办单";
			// 
			// label15
			// 
			this.label15.AutoSize = true;
			this.label15.BackColor = System.Drawing.Color.Transparent;
			this.label15.Location = new System.Drawing.Point(184, 90);
			this.label15.Name = "label15";
			this.label15.Size = new System.Drawing.Size(42, 17);
			this.label15.TabIndex = 20;
			this.label15.Text = "付款单";
			// 
			// txtCommit
			// 
			this.txtCommit.BackColor = System.Drawing.Color.LightGoldenrodYellow;
			this.txtCommit.DataBindings.Add(new System.Windows.Forms.Binding("Text", this._dsOsINI1, "tblOsInit.osiCommissionCode"));
			this.txtCommit.Location = new System.Drawing.Point(72, 88);
			this.txtCommit.Name = "txtCommit";
			this.txtCommit.ReadOnly = true;
			this.txtCommit.Size = new System.Drawing.Size(96, 21);
			this.txtCommit.TabIndex = 9;
			this.txtCommit.Text = "";
			// 
			// btnConfirm
			// 
			this.btnConfirm.BackColor = System.Drawing.Color.LightSteelBlue;
			this.btnConfirm.Location = new System.Drawing.Point(304, 312);
			this.btnConfirm.Name = "btnConfirm";
			this.btnConfirm.Size = new System.Drawing.Size(75, 24);
			this.btnConfirm.TabIndex = 2;
			this.btnConfirm.Text = "确定(&E)";
			this.btnConfirm.Click += new System.EventHandler(this.btnConfirm_Click);
			// 
			// btnCancel
			// 
			this.btnCancel.BackColor = System.Drawing.Color.LightSteelBlue;
			this.btnCancel.Location = new System.Drawing.Point(408, 312);
			this.btnCancel.Name = "btnCancel";
			this.btnCancel.TabIndex = 2;
			this.btnCancel.Text = "取消(&C)";
			this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
			// 
			// _sqlAdap
			// 
			this._sqlAdap.DeleteCommand = this.sqlDeleteCommand1;
			this._sqlAdap.InsertCommand = this.sqlInsertCommand1;
			this._sqlAdap.SelectCommand = this.sqlSelectCommand1;
			this._sqlAdap.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																							   new System.Data.Common.DataTableMapping("Table", "tblOsInit", new System.Data.Common.DataColumnMapping[] {
																																																			new System.Data.Common.DataColumnMapping("osiCode", "osiCode"),
																																																			new System.Data.Common.DataColumnMapping("osiName", "osiName"),
																																																			new System.Data.Common.DataColumnMapping("osiAdd", "osiAdd"),
																																																			new System.Data.Common.DataColumnMapping("osiTel", "osiTel"),
																																																			new System.Data.Common.DataColumnMapping("osiWeb", "osiWeb"),
																																																			new System.Data.Common.DataColumnMapping("osiInDepotCode", "osiInDepotCode"),
																																																			new System.Data.Common.DataColumnMapping("osiMoveCode", "osiMoveCode"),
																																																			new System.Data.Common.DataColumnMapping("osiSellCode", "osiSellCode"),
																																																			new System.Data.Common.DataColumnMapping("osiGatheringCode", "osiGatheringCode"),
																																																			new System.Data.Common.DataColumnMapping("osiCommissionCode", "osiCommissionCode"),
																																																			new System.Data.Common.DataColumnMapping("osiPayCode", "osiPayCode"),
																																																			new System.Data.Common.DataColumnMapping("osiPreCode", "osiPreCode"),
																																																			new System.Data.Common.DataColumnMapping("osiStoCode", "osiStoCode")})});
			this._sqlAdap.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM tblOsInit WHERE (osiCode = @Original_osiCode) AND (osiAdd = @Original_osiAdd) AND (osiCommissionCode = @Original_osiCommissionCode) AND (osiGatheringCode = @Original_osiGatheringCode) AND (osiInDepotCode = @Original_osiInDepotCode) AND (osiMoveCode = @Original_osiMoveCode) AND (osiName = @Original_osiName) AND (osiPayCode = @Original_osiPayCode) AND (osiPreCode = @Original_osiPreCode) AND (osiSellCode = @Original_osiSellCode) AND (osiStoCode = @Original_osiStoCode) AND (osiTel = @Original_osiTel) AND (osiWeb = @Original_osiWeb)";
			this.sqlDeleteCommand1.Connection = this._sqlCon;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiCode", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiCode", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiAdd", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiAdd", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiCommissionCode", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiCommissionCode", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiGatheringCode", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiGatheringCode", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiInDepotCode", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiInDepotCode", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiMoveCode", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiMoveCode", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiName", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiName", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiPayCode", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiPayCode", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiPreCode", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiPreCode", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiSellCode", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiSellCode", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiStoCode", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiStoCode", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiTel", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiTel", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_osiWeb", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "osiWeb", System.Data.DataRowVersion.Original, null));
			// 
			// _sqlCon
			// 
			this._sqlCon.ConnectionString = "workstation id=Nebular;packet size=4096;user id=sa;data source=\".\";persist securi" +
				"ty info=False;initial catalog=dbCarsys";
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = @"INSERT INTO tblOsInit(osiCode, osiName, osiAdd, osiTel, osiWeb, osiInDepotCode, osiMoveCode, osiSellCode, osiGatheringCode, osiCommissionCode, osiPayCode, osiPreCode, osiStoCode) VALUES (@osiCode, @osiName, @osiAdd, @osiTel, @osiWeb, @osiInDepotCode, @osiMoveCode, @osiSellCode, @osiGatheringCode, @osiCommissionCode, @osiPayCode, @osiPreCode, @osiStoCode); SELECT osiCode, osiName, osiAdd, osiTel, osiWeb, osiInDepotCode, osiMoveCode, osiSellCode, osiGatheringCode, osiCommissionCode, osiPayCode, osiPreCode, osiStoCode FROM tblOsInit WHERE (osiCode = @osiCode)";
			this.sqlInsertCommand1.Connection = this._sqlCon;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiCode", System.Data.SqlDbType.VarChar, 10, "osiCode"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiName", System.Data.SqlDbType.VarChar, 100, "osiName"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiAdd", System.Data.SqlDbType.VarChar, 100, "osiAdd"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiTel", System.Data.SqlDbType.VarChar, 100, "osiTel"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiWeb", System.Data.SqlDbType.VarChar, 100, "osiWeb"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiInDepotCode", System.Data.SqlDbType.VarChar, 10, "osiInDepotCode"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiMoveCode", System.Data.SqlDbType.VarChar, 10, "osiMoveCode"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiSellCode", System.Data.SqlDbType.VarChar, 10, "osiSellCode"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiGatheringCode", System.Data.SqlDbType.VarChar, 10, "osiGatheringCode"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiCommissionCode", System.Data.SqlDbType.VarChar, 10, "osiCommissionCode"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiPayCode", System.Data.SqlDbType.VarChar, 10, "osiPayCode"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiPreCode", System.Data.SqlDbType.VarChar, 10, "osiPreCode"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiStoCode", System.Data.SqlDbType.VarChar, 10, "osiStoCode"));
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT osiCode, osiName, osiAdd, osiTel, osiWeb, osiInDepotCode, osiMoveCode, osi" +
				"SellCode, osiGatheringCode, osiCommissionCode, osiPayCode, osiPreCode, osiStoCod" +
				"e FROM tblOsInit";
			this.sqlSelectCommand1.Connection = this._sqlCon;
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE tblOsInit SET osiCode = @osiCode, osiName = @osiName, osiAdd = @osiAdd, osiTel = @osiTel, osiWeb = @osiWeb, osiInDepotCode = @osiInDepotCode, osiMoveCode = @osiMoveCode, osiSellCode = @osiSellCode, osiGatheringCode = @osiGatheringCode, osiCommissionCode = @osiCommissionCode, osiPayCode = @osiPayCode, osiPreCode = @osiPreCode, osiStoCode = @osiStoCode WHERE (osiCode = @Original_osiCode) AND (osiAdd = @Original_osiAdd) AND (osiCommissionCode = @Original_osiCommissionCode) AND (osiGatheringCode = @Original_osiGatheringCode) AND (osiInDepotCode = @Original_osiInDepotCode) AND (osiMoveCode = @Original_osiMoveCode) AND (osiName = @Original_osiName) AND (osiPayCode = @Original_osiPayCode) AND (osiPreCode = @Original_osiPreCode) AND (osiSellCode = @Original_osiSellCode) AND (osiStoCode = @Original_osiStoCode) AND (osiTel = @Original_osiTel) AND (osiWeb = @Original_osiWeb); SELECT osiCode, osiName, osiAdd, osiTel, osiWeb, osiInDepotCode, osiMoveCode, osiSellCode, osiGatheringCode, osiCommissionCode, osiPayCode, osiPreCode, osiStoCode FROM tblOsInit WHERE (osiCode = @osiCode)";
			this.sqlUpdateCommand1.Connection = this._sqlCon;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiCode", System.Data.SqlDbType.VarChar, 10, "osiCode"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@osiName", System.Data.SqlDbType.VarChar, 100, "osiName"));