📄 provider.cs
字号:
this.textName.Location = new System.Drawing.Point(88, 96);
this.textName.Name = "textName";
this.textName.Size = new System.Drawing.Size(120, 23);
this.textName.TabIndex = 11;
this.textName.Text = "";
//
// textId
//
this.textId.Cursor = System.Windows.Forms.Cursors.Arrow;
this.textId.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.objDataSetProvider, "Provider.ProviderId"));
this.textId.Location = new System.Drawing.Point(88, 56);
this.textId.Name = "textId";
this.textId.Size = new System.Drawing.Size(120, 23);
this.textId.TabIndex = 10;
this.textId.Text = "";
//
// objDataSetProvider
//
this.objDataSetProvider.DataSetName = "DataSetProvider";
this.objDataSetProvider.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// groupBox2
//
this.groupBox2.Controls.Add(this.textRemark);
this.groupBox2.Location = new System.Drawing.Point(312, 104);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(240, 160);
this.groupBox2.TabIndex = 9;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "信息备注";
//
// textRemark
//
this.textRemark.Location = new System.Drawing.Point(16, 24);
this.textRemark.Multiline = true;
this.textRemark.Name = "textRemark";
this.textRemark.Size = new System.Drawing.Size(208, 120);
this.textRemark.TabIndex = 0;
this.textRemark.Text = "";
//
// label8
//
this.label8.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label8.Location = new System.Drawing.Point(8, 280);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(72, 23);
this.label8.TabIndex = 7;
this.label8.Text = "公司主页";
//
// label7
//
this.label7.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label7.Location = new System.Drawing.Point(8, 232);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(72, 23);
this.label7.TabIndex = 6;
this.label7.Text = "公司传真";
//
// label5
//
this.label5.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label5.Location = new System.Drawing.Point(8, 192);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(72, 23);
this.label5.TabIndex = 4;
this.label5.Text = "联系电话";
//
// label4
//
this.label4.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label4.Location = new System.Drawing.Point(296, 24);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(72, 23);
this.label4.TabIndex = 3;
this.label4.Text = "公司地址";
//
// label3
//
this.label3.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label3.Location = new System.Drawing.Point(8, 152);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(72, 23);
this.label3.TabIndex = 2;
this.label3.Text = "联系人";
//
// label2
//
this.label2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label2.Location = new System.Drawing.Point(8, 104);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(72, 23);
this.label2.TabIndex = 1;
this.label2.Text = "公司名称";
//
// label1
//
this.label1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label1.Location = new System.Drawing.Point(8, 64);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(72, 23);
this.label1.TabIndex = 0;
this.label1.Text = "供应商编号";
//
// label6
//
this.label6.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label6.Location = new System.Drawing.Point(296, 64);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(72, 23);
this.label6.TabIndex = 5;
this.label6.Text = "邮政编码";
//
// textPostalCode
//
this.textPostalCode.Location = new System.Drawing.Point(376, 56);
this.textPostalCode.Name = "textPostalCode";
this.textPostalCode.Size = new System.Drawing.Size(120, 23);
this.textPostalCode.TabIndex = 16;
this.textPostalCode.Text = "";
//
// btnCancel
//
this.btnCancel.Location = new System.Drawing.Point(24, 56);
this.btnCancel.Name = "btnCancel";
this.btnCancel.Size = new System.Drawing.Size(50, 30);
this.btnCancel.TabIndex = 19;
this.btnCancel.Text = "取消";
this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
//
// btnExit
//
this.btnExit.Location = new System.Drawing.Point(584, 384);
this.btnExit.Name = "btnExit";
this.btnExit.Size = new System.Drawing.Size(72, 24);
this.btnExit.TabIndex = 18;
this.btnExit.Text = "退出";
this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
//
// btnAdd
//
this.btnAdd.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.btnAdd.Location = new System.Drawing.Point(16, 24);
this.btnAdd.Name = "btnAdd";
this.btnAdd.Size = new System.Drawing.Size(56, 24);
this.btnAdd.TabIndex = 2;
this.btnAdd.Text = "添加";
this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
//
// btnDelete
//
this.btnDelete.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.btnDelete.Location = new System.Drawing.Point(240, 344);
this.btnDelete.Name = "btnDelete";
this.btnDelete.Size = new System.Drawing.Size(56, 24);
this.btnDelete.TabIndex = 3;
this.btnDelete.Text = "删除";
this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
//
// btnQuery
//
this.btnQuery.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.btnQuery.Location = new System.Drawing.Point(40, 16);
this.btnQuery.Name = "btnQuery";
this.btnQuery.Size = new System.Drawing.Size(56, 24);
this.btnQuery.TabIndex = 4;
this.btnQuery.Text = "查询";
this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click);
//
// btnModify
//
this.btnModify.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.btnModify.Location = new System.Drawing.Point(88, 24);
this.btnModify.Name = "btnModify";
this.btnModify.Size = new System.Drawing.Size(56, 24);
this.btnModify.TabIndex = 5;
this.btnModify.Text = "修改";
this.btnModify.Click += new System.EventHandler(this.btnModify_Click);
//
// btnPrint
//
this.btnPrint.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.btnPrint.Location = new System.Drawing.Point(320, 344);
this.btnPrint.Name = "btnPrint";
this.btnPrint.Size = new System.Drawing.Size(56, 24);
this.btnPrint.TabIndex = 6;
this.btnPrint.Text = "报表";
//
// btnApply
//
this.btnApply.Location = new System.Drawing.Point(88, 56);
this.btnApply.Name = "btnApply";
this.btnApply.Size = new System.Drawing.Size(50, 30);
this.btnApply.TabIndex = 20;
this.btnApply.Text = "应用";
this.btnApply.Click += new System.EventHandler(this.btnApply_Click);
//
// groupBox3
//
this.groupBox3.Controls.Add(this.btnModify);
this.groupBox3.Controls.Add(this.btnAdd);
this.groupBox3.Controls.Add(this.btnApply);
this.groupBox3.Controls.Add(this.btnCancel);
this.groupBox3.Location = new System.Drawing.Point(24, 320);
this.groupBox3.Name = "groupBox3";
this.groupBox3.Size = new System.Drawing.Size(176, 96);
this.groupBox3.TabIndex = 21;
this.groupBox3.TabStop = false;
this.groupBox3.Text = "添加/修改";
//
// groupBox4
//
this.groupBox4.Controls.Add(this.rbtnName);
this.groupBox4.Controls.Add(this.rbtnId);
this.groupBox4.Controls.Add(this.btnQuery);
this.groupBox4.Location = new System.Drawing.Point(408, 320);
this.groupBox4.Name = "groupBox4";
this.groupBox4.Size = new System.Drawing.Size(152, 96);
this.groupBox4.TabIndex = 22;
this.groupBox4.TabStop = false;
this.groupBox4.Text = "查询";
//
// rbtnName
//
this.rbtnName.Location = new System.Drawing.Point(80, 56);
this.rbtnName.Name = "rbtnName";
this.rbtnName.Size = new System.Drawing.Size(64, 24);
this.rbtnName.TabIndex = 6;
this.rbtnName.Text = "按名称";
this.rbtnName.CheckedChanged += new System.EventHandler(this.rbtnName_CheckedChanged);
//
// rbtnId
//
this.rbtnId.Location = new System.Drawing.Point(8, 56);
this.rbtnId.Name = "rbtnId";
this.rbtnId.Size = new System.Drawing.Size(64, 24);
this.rbtnId.TabIndex = 5;
this.rbtnId.Text = "按编号";
this.rbtnId.CheckedChanged += new System.EventHandler(this.rbtnId_CheckedChanged);
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=\"TSINGHUA-AEBBD5\";packet size=4096;integrated security=SSPI;data s" +
"ource=\"TSINGHUA-AEBBD5\";persist security info=False;initial catalog=Sell";
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Provider", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ProviderId", "ProviderId"),
new System.Data.Common.DataColumnMapping("ProviderName", "ProviderName"),
new System.Data.Common.DataColumnMapping("ProviderPeople", "ProviderPeople"),
new System.Data.Common.DataColumnMapping("ProviderTelNo", "ProviderTelNo"),
new System.Data.Common.DataColumnMapping("ProviderFaxNo", "ProviderFaxNo"),
new System.Data.Common.DataColumnMapping("ProviderWebSite", "ProviderWebSite"),
new System.Data.Common.DataColumnMapping("ProviderAddress", "ProviderAddress"),
new System.Data.Common.DataColumnMapping("ProviderPostalCode", "ProviderPostalCode"),
new System.Data.Common.DataColumnMapping("ProviderRemark", "ProviderRemark")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM Provider WHERE (ProviderId = @Original_ProviderId) AND (ProviderAddress = @Original_ProviderAddress OR @Original_ProviderAddress IS NULL AND ProviderAddress IS NULL) AND (ProviderFaxNo = @Original_ProviderFaxNo OR @Original_ProviderFaxNo IS NULL AND ProviderFaxNo IS NULL) AND (ProviderName = @Original_ProviderName OR @Original_ProviderName IS NULL AND ProviderName IS NULL) AND (ProviderPeople = @Original_ProviderPeople OR @Original_ProviderPeople IS NULL AND ProviderPeople IS NULL) AND (ProviderPostalCode = @Original_ProviderPostalCode OR @Original_ProviderPostalCode IS NULL AND ProviderPostalCode IS NULL) AND (ProviderRemark = @Original_ProviderRemark OR @Original_ProviderRemark IS NULL AND ProviderRemark IS NULL) AND (ProviderTelNo = @Original_ProviderTelNo OR @Original_ProviderTelNo IS NULL AND ProviderTelNo IS NULL) AND (ProviderWebSite = @Original_ProviderWebSite OR @Original_ProviderWebSite IS NULL AND ProviderWebSite IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderId", System.Data.SqlDbType.VarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderId", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderAddress", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderAddress", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderFaxNo", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderFaxNo", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderName", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderPeople", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderPeople", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderPostalCode", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderPostalCode", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderRemark", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderRemark", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderTelNo", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderTelNo", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderWebSite", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderWebSite", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO Provider(ProviderId, ProviderName, ProviderPeople, ProviderTelNo, ProviderFaxNo, ProviderWebSite, ProviderAddress, ProviderPostalCode, ProviderRemark) VALUES (@ProviderId, @ProviderName, @ProviderPeople, @ProviderTelNo, @ProviderFaxNo, @ProviderWebSite, @ProviderAddress, @ProviderPostalCode, @ProviderRemark); SELECT ProviderId, ProviderName, ProviderPeople, ProviderTelNo, ProviderFaxNo, ProviderWebSite, ProviderAddress, ProviderPostalCode, ProviderRemark FROM Provider WHERE (ProviderId = @ProviderId)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderId", System.Data.SqlDbType.VarChar, 3, "ProviderId"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderName", System.Data.SqlDbType.VarChar, 20, "ProviderName"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderPeople", System.Data.SqlDbType.VarChar, 10, "ProviderPeople"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderTelNo", System.Data.SqlDbType.VarChar, 20, "ProviderTelNo"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderFaxNo", System.Data.SqlDbType.VarChar, 20, "ProviderFaxNo"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderWebSite", System.Data.SqlDbType.VarChar, 50, "ProviderWebSite"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderAddress", System.Data.SqlDbType.VarChar, 50, "ProviderAddress"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderPostalCode", System.Data.SqlDbType.VarChar, 20, "ProviderPostalCode"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderRemark", System.Data.SqlDbType.VarChar, 100, "ProviderRemark"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT ProviderId, ProviderName, ProviderPeople, ProviderTelNo, ProviderFaxNo, Pr" +
"oviderWebSite, ProviderAddress, ProviderPostalCode, ProviderRemark FROM Provider" +
"";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE Provider SET ProviderId = @ProviderId, ProviderName = @ProviderName, ProviderPeople = @ProviderPeople, ProviderTelNo = @ProviderTelNo, ProviderFaxNo = @ProviderFaxNo, ProviderWebSite = @ProviderWebSite, ProviderAddress = @ProviderAddress, ProviderPostalCode = @ProviderPostalCode, ProviderRemark = @ProviderRemark WHERE (ProviderId = @Original_ProviderId) AND (ProviderAddress = @Original_ProviderAddress OR @Original_ProviderAddress IS NULL AND ProviderAddress IS NULL) AND (ProviderFaxNo = @Original_ProviderFaxNo OR @Original_ProviderFaxNo IS NULL AND ProviderFaxNo IS NULL) AND (ProviderName = @Original_ProviderName OR @Original_ProviderName IS NULL AND ProviderName IS NULL) AND (ProviderPeople = @Original_ProviderPeople OR @Original_ProviderPeople IS NULL AND ProviderPeople IS NULL) AND (ProviderPostalCode = @Original_ProviderPostalCode OR @Original_ProviderPostalCode IS NULL AND ProviderPostalCode IS NULL) AND (ProviderRemark = @Original_ProviderRemark OR @Original_ProviderRemark IS NULL AND ProviderRemark IS NULL) AND (ProviderTelNo = @Original_ProviderTelNo OR @Original_ProviderTelNo IS NULL AND ProviderTelNo IS NULL) AND (ProviderWebSite = @Original_ProviderWebSite OR @Original_ProviderWebSite IS NULL AND ProviderWebSite IS NULL); SELECT ProviderId, ProviderName, ProviderPeople, ProviderTelNo, ProviderFaxNo, ProviderWebSite, ProviderAddress, ProviderPostalCode, ProviderRemark FROM Provider WHERE (ProviderId = @ProviderId)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderId", System.Data.SqlDbType.VarChar, 3, "ProviderId"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderName", System.Data.SqlDbType.VarChar, 20, "ProviderName"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderPeople", System.Data.SqlDbType.VarChar, 10, "ProviderPeople"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderTelNo", System.Data.SqlDbType.VarChar, 20, "ProviderTelNo"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderFaxNo", System.Data.SqlDbType.VarChar, 20, "ProviderFaxNo"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderWebSite", System.Data.SqlDbType.VarChar, 50, "ProviderWebSite"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderAddress", System.Data.SqlDbType.VarChar, 50, "ProviderAddress"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderPostalCode", System.Data.SqlDbType.VarChar, 20, "ProviderPostalCode"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ProviderRemark", System.Data.SqlDbType.VarChar, 100, "ProviderRemark"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderId", System.Data.SqlDbType.VarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderId", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderAddress", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderAddress", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderFaxNo", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderFaxNo", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderName", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderPeople", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderPeople", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderPostalCode", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderPostalCode", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderRemark", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderRemark", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderTelNo", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderTelNo", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ProviderWebSite", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ProviderWebSite", System.Data.DataRowVersion.Original, null));
//
// Provider
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(664, 417);
this.Controls.Add(this.groupBox4);
this.Controls.Add(this.groupBox3);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.btnDelete);
this.Controls.Add(this.btnPrint);
this.Controls.Add(this.btnExit);
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.MaximizeBox = false;
this.Menu = this.mainMenu1;
this.MinimizeBox = false;
this.Name = "Provider";
this.Text = "供应商管理";
this.Load += new System.EventHandler(this.Provider_Load);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -