📄 querymerch.designer.cs
字号:
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("@memberPrice", System.Data.SqlDbType.SmallMoney, 0, "memberPrice"),
new System.Data.SqlClient.SqlParameter("@warningNum", System.Data.SqlDbType.Int, 0, "warningNum"),
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_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_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_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_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_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_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", "merch", 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;
//
// dataGrid1
//
this.dataGrid1.DataMember = "merch";
this.dataGrid1.DataSource = this.dataSet11;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(12, 91);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(681, 239);
this.dataGrid1.TabIndex = 0;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// QueryMerch
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(705, 424);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.dataGrid1);
this.Name = "QueryMerch";
this.Text = "商品查询";
this.Load += new System.EventHandler(this.QueryMerch_Load);
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.ResumeLayout(false);
}
#endregion
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.RadioButton radioButton2;
private System.Windows.Forms.RadioButton radioButton1;
private System.Data.SqlClient.SqlConnection sqlConnection1;
private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
private DataSet1 dataSet11;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -