📄 addmerch.designer.cs
字号:
namespace 超市信息管理系统.MarketSystem
{
partial class AddMerch
{
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
/// <param name="disposing">如果应释放托管资源,为 true;否则为 false。</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要
/// 使用代码编辑器修改此方法的内容。
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(AddMerch));
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.button2 = new System.Windows.Forms.Button();
this.button1 = new System.Windows.Forms.Button();
this.label12 = new System.Windows.Forms.Label();
this.label11 = new System.Windows.Forms.Label();
this.label10 = new System.Windows.Forms.Label();
this.label9 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.textBox1 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.textBox3 = new System.Windows.Forms.TextBox();
this.textBox4 = new System.Windows.Forms.TextBox();
this.textBox5 = new System.Windows.Forms.TextBox();
this.textBox6 = new System.Windows.Forms.TextBox();
this.textBox7 = new System.Windows.Forms.TextBox();
this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker();
this.dateTimePicker2 = new System.Windows.Forms.DateTimePicker();
this.comboBox1 = new System.Windows.Forms.ComboBox();
this.comboBox2 = new System.Windows.Forms.ComboBox();
this.textBox8 = new System.Windows.Forms.TextBox();
this.label13 = new System.Windows.Forms.Label();
this.label14 = new System.Windows.Forms.Label();
this.label15 = new System.Windows.Forms.Label();
this.label16 = new System.Windows.Forms.Label();
this.label17 = new System.Windows.Forms.Label();
this.dataSet11 = new 超市信息管理系统.MarketSystem.DataSet1();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.SuspendLayout();
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "Data Source=.;Initial Catalog=MarketSystem;Integrated Security=True";
this.sqlConnection1.FireInfoMessageEventOnUserErrors = false;
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT MerchId, merchName, merchPrice, merchNumber, warningNum, memberPrice, " +
"ProsalePrice, ProsaleDateS, ProsaleDateE, allowaBate, allowSale, \r\n " +
" factoryId\r\nFROM merch";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = resources.GetString("sqlInsertCommand1.CommandText");
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@MerchId", System.Data.SqlDbType.VarChar, 0, "MerchId"),
new System.Data.SqlClient.SqlParameter("@merchName", System.Data.SqlDbType.VarChar, 0, "merchName"),
new System.Data.SqlClient.SqlParameter("@merchPrice", System.Data.SqlDbType.SmallMoney, 0, "merchPrice"),
new System.Data.SqlClient.SqlParameter("@merchNumber", System.Data.SqlDbType.Int, 0, "merchNumber"),
new System.Data.SqlClient.SqlParameter("@warningNum", System.Data.SqlDbType.Int, 0, "warningNum"),
new System.Data.SqlClient.SqlParameter("@memberPrice", System.Data.SqlDbType.SmallMoney, 0, "memberPrice"),
new System.Data.SqlClient.SqlParameter("@ProsalePrice", System.Data.SqlDbType.SmallMoney, 0, "ProsalePrice"),
new System.Data.SqlClient.SqlParameter("@ProsaleDateS", System.Data.SqlDbType.DateTime, 0, "ProsaleDateS"),
new System.Data.SqlClient.SqlParameter("@ProsaleDateE", System.Data.SqlDbType.DateTime, 0, "ProsaleDateE"),
new System.Data.SqlClient.SqlParameter("@allowaBate", System.Data.SqlDbType.Char, 0, "allowaBate"),
new System.Data.SqlClient.SqlParameter("@allowSale", System.Data.SqlDbType.Char, 0, "allowSale"),
new System.Data.SqlClient.SqlParameter("@factoryId", System.Data.SqlDbType.VarChar, 0, "factoryId")});
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText");
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@MerchId", System.Data.SqlDbType.VarChar, 0, "MerchId"),
new System.Data.SqlClient.SqlParameter("@merchName", System.Data.SqlDbType.VarChar, 0, "merchName"),
new System.Data.SqlClient.SqlParameter("@merchPrice", System.Data.SqlDbType.SmallMoney, 0, "merchPrice"),
new System.Data.SqlClient.SqlParameter("@merchNumber", System.Data.SqlDbType.Int, 0, "merchNumber"),
new System.Data.SqlClient.SqlParameter("@warningNum", System.Data.SqlDbType.Int, 0, "warningNum"),
new System.Data.SqlClient.SqlParameter("@memberPrice", System.Data.SqlDbType.SmallMoney, 0, "memberPrice"),
new System.Data.SqlClient.SqlParameter("@ProsalePrice", System.Data.SqlDbType.SmallMoney, 0, "ProsalePrice"),
new System.Data.SqlClient.SqlParameter("@ProsaleDateS", System.Data.SqlDbType.DateTime, 0, "ProsaleDateS"),
new System.Data.SqlClient.SqlParameter("@ProsaleDateE", System.Data.SqlDbType.DateTime, 0, "ProsaleDateE"),
new System.Data.SqlClient.SqlParameter("@allowaBate", System.Data.SqlDbType.Char, 0, "allowaBate"),
new System.Data.SqlClient.SqlParameter("@allowSale", System.Data.SqlDbType.Char, 0, "allowSale"),
new System.Data.SqlClient.SqlParameter("@factoryId", System.Data.SqlDbType.VarChar, 0, "factoryId"),
new System.Data.SqlClient.SqlParameter("@Original_MerchId", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MerchId", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_merchName", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "merchName", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_merchPrice", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "merchPrice", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_merchPrice", System.Data.SqlDbType.SmallMoney, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "merchPrice", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_merchNumber", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "merchNumber", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_merchNumber", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "merchNumber", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_warningNum", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "warningNum", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_warningNum", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "warningNum", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_memberPrice", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "memberPrice", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_memberPrice", System.Data.SqlDbType.SmallMoney, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberPrice", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_ProsalePrice", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ProsalePrice", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_ProsalePrice", System.Data.SqlDbType.SmallMoney, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ProsalePrice", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_ProsaleDateS", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ProsaleDateS", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_ProsaleDateS", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ProsaleDateS", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_ProsaleDateE", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ProsaleDateE", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_ProsaleDateE", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ProsaleDateE", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_allowaBate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "allowaBate", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_allowaBate", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "allowaBate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_allowSale", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "allowSale", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_allowSale", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "allowSale", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_factoryId", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "factoryId", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_factoryId", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "factoryId", System.Data.DataRowVersion.Original, null)});
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = resources.GetString("sqlDeleteCommand1.CommandText");
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Original_MerchId", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MerchId", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_merchName", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "merchName", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_merchPrice", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "merchPrice", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_merchPrice", System.Data.SqlDbType.SmallMoney, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "merchPrice", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_merchNumber", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "merchNumber", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_merchNumber", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "merchNumber", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_warningNum", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "warningNum", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_warningNum", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "warningNum", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_memberPrice", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "memberPrice", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_memberPrice", System.Data.SqlDbType.SmallMoney, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberPrice", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_ProsalePrice", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ProsalePrice", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_ProsalePrice", System.Data.SqlDbType.SmallMoney, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ProsalePrice", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_ProsaleDateS", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ProsaleDateS", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_ProsaleDateS", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ProsaleDateS", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_ProsaleDateE", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ProsaleDateE", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_ProsaleDateE", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ProsaleDateE", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_allowaBate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "allowaBate", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_allowaBate", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "allowaBate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_allowSale", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "allowSale", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_allowSale", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "allowSale", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_factoryId", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "factoryId", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_factoryId", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "factoryId", System.Data.DataRowVersion.Original, null)});
//
// 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", "merch1", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("MerchId", "商品编号"),
new System.Data.Common.DataColumnMapping("merchName", "商品名称"),
new System.Data.Common.DataColumnMapping("merchPrice", "商品价格"),
new System.Data.Common.DataColumnMapping("merchNumber", "商品库存量"),
new System.Data.Common.DataColumnMapping("memberPrice", "库存警告量"),
new System.Data.Common.DataColumnMapping("warningNum", "会员价格"),
new System.Data.Common.DataColumnMapping("ProsalePrice", "促销价格"),
new System.Data.Common.DataColumnMapping("ProsaleDateS", "促销起日期"),
new System.Data.Common.DataColumnMapping("ProsaleDateE", "促销止日期"),
new System.Data.Common.DataColumnMapping("allowaBate", "是否打折"),
new System.Data.Common.DataColumnMapping("allowSale", "允许销售"),
new System.Data.Common.DataColumnMapping("factoryId", "厂商编号")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -