📄 querymember.designer.cs
字号:
this.label19.Name = "label19";
this.label19.Size = new System.Drawing.Size(72, 16);
this.label19.TabIndex = 8;
this.label19.Text = "是否锁卡";
//
// label18
//
this.label18.AutoSize = true;
this.label18.Location = new System.Drawing.Point(247, 217);
this.label18.Name = "label18";
this.label18.Size = new System.Drawing.Size(72, 16);
this.label18.TabIndex = 7;
this.label18.Text = "登记日期";
//
// label17
//
this.label17.AutoSize = true;
this.label17.Location = new System.Drawing.Point(24, 217);
this.label17.Name = "label17";
this.label17.Size = new System.Drawing.Size(88, 16);
this.label17.TabIndex = 6;
this.label17.Text = "现拥有现金";
//
// label16
//
this.label16.AutoSize = true;
this.label16.Location = new System.Drawing.Point(318, 152);
this.label16.Name = "label16";
this.label16.Size = new System.Drawing.Size(88, 16);
this.label16.TabIndex = 5;
this.label16.Text = "会员身份证";
//
// label15
//
this.label15.AutoSize = true;
this.label15.Location = new System.Drawing.Point(24, 152);
this.label15.Name = "label15";
this.label15.Size = new System.Drawing.Size(72, 16);
this.label15.TabIndex = 4;
this.label15.Text = "会员地址";
//
// label14
//
this.label14.AutoSize = true;
this.label14.Location = new System.Drawing.Point(318, 92);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(72, 16);
this.label14.TabIndex = 3;
this.label14.Text = "会员电话";
//
// label13
//
this.label13.AutoSize = true;
this.label13.Location = new System.Drawing.Point(24, 92);
this.label13.Name = "label13";
this.label13.Size = new System.Drawing.Size(72, 16);
this.label13.TabIndex = 2;
this.label13.Text = "会员名称";
//
// label12
//
this.label12.AutoSize = true;
this.label12.Location = new System.Drawing.Point(318, 33);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(72, 16);
this.label12.TabIndex = 1;
this.label12.Text = "会员卡号";
//
// label11
//
this.label11.AutoSize = true;
this.label11.Location = new System.Drawing.Point(24, 33);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(72, 16);
this.label11.TabIndex = 0;
this.label11.Text = "会员编号";
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT memberID, memberCard, memberName, memberPhone, memberAddress, memberId" +
"entify, NowCash, TotalMoney, regDate, locked\r\nFROM MarketMember";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "Data Source=.;Initial Catalog=MarketSystem;Integrated Security=True";
this.sqlConnection1.FireInfoMessageEventOnUserErrors = false;
//
// 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("@memberID", System.Data.SqlDbType.VarChar, 0, "memberID"),
new System.Data.SqlClient.SqlParameter("@memberCard", System.Data.SqlDbType.VarChar, 0, "memberCard"),
new System.Data.SqlClient.SqlParameter("@memberName", System.Data.SqlDbType.VarChar, 0, "memberName"),
new System.Data.SqlClient.SqlParameter("@memberPhone", System.Data.SqlDbType.Char, 0, "memberPhone"),
new System.Data.SqlClient.SqlParameter("@memberAddress", System.Data.SqlDbType.VarChar, 0, "memberAddress"),
new System.Data.SqlClient.SqlParameter("@memberIdentify", System.Data.SqlDbType.VarChar, 0, "memberIdentify"),
new System.Data.SqlClient.SqlParameter("@NowCash", System.Data.SqlDbType.Int, 0, "NowCash"),
new System.Data.SqlClient.SqlParameter("@TotalMoney", System.Data.SqlDbType.Int, 0, "TotalMoney"),
new System.Data.SqlClient.SqlParameter("@regDate", System.Data.SqlDbType.DateTime, 0, "regDate"),
new System.Data.SqlClient.SqlParameter("@locked", System.Data.SqlDbType.Char, 0, "locked")});
//
// 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("@memberID", System.Data.SqlDbType.VarChar, 0, "memberID"),
new System.Data.SqlClient.SqlParameter("@memberCard", System.Data.SqlDbType.VarChar, 0, "memberCard"),
new System.Data.SqlClient.SqlParameter("@memberName", System.Data.SqlDbType.VarChar, 0, "memberName"),
new System.Data.SqlClient.SqlParameter("@memberPhone", System.Data.SqlDbType.Char, 0, "memberPhone"),
new System.Data.SqlClient.SqlParameter("@memberAddress", System.Data.SqlDbType.VarChar, 0, "memberAddress"),
new System.Data.SqlClient.SqlParameter("@memberIdentify", System.Data.SqlDbType.VarChar, 0, "memberIdentify"),
new System.Data.SqlClient.SqlParameter("@NowCash", System.Data.SqlDbType.Int, 0, "NowCash"),
new System.Data.SqlClient.SqlParameter("@TotalMoney", System.Data.SqlDbType.Int, 0, "TotalMoney"),
new System.Data.SqlClient.SqlParameter("@regDate", System.Data.SqlDbType.DateTime, 0, "regDate"),
new System.Data.SqlClient.SqlParameter("@locked", System.Data.SqlDbType.Char, 0, "locked"),
new System.Data.SqlClient.SqlParameter("@Original_memberID", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberID", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_memberCard", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberCard", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_memberName", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberName", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_memberPhone", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "memberPhone", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_memberPhone", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberPhone", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_memberAddress", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "memberAddress", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_memberAddress", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberAddress", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_memberIdentify", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberIdentify", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_NowCash", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "NowCash", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_NowCash", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NowCash", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_TotalMoney", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "TotalMoney", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_TotalMoney", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "TotalMoney", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_regDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "regDate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_locked", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "locked", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_locked", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "locked", 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_memberID", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberID", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_memberCard", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberCard", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_memberName", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberName", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_memberPhone", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "memberPhone", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_memberPhone", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberPhone", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_memberAddress", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "memberAddress", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_memberAddress", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberAddress", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_memberIdentify", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "memberIdentify", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_NowCash", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "NowCash", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_NowCash", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NowCash", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_TotalMoney", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "TotalMoney", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_TotalMoney", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "TotalMoney", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_regDate", System.Data.SqlDbType.DateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "regDate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_locked", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "locked", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_locked", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "locked", 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", "MarketMember", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("memberID", "会员编号"),
new System.Data.Common.DataColumnMapping("memberCard", "会员卡号"),
new System.Data.Common.DataColumnMapping("memberName", "会员名称"),
new System.Data.Common.DataColumnMapping("memberPhone", "会员电话"),
new System.Data.Common.DataColumnMapping("memberAddress", "会员地址"),
new System.Data.Common.DataColumnMapping("memberIdentify", "会员身份证"),
new System.Data.Common.DataColumnMapping("NowCash", "现拥胡现金"),
new System.Data.Common.DataColumnMapping("TotalMoney", "消费总额"),
new System.Data.Common.DataColumnMapping("regDate", "登记日期"),
new System.Data.Common.DataColumnMapping("locked", "是否锁定")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT memberID, memberCard, memberName, memberPhone, memberAddress, memberId" +
"entify, NowCash, regDate, locked\r\nFROM MarketMember";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = resources.GetString("sqlInsertCommand2.CommandText");
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@memberID", System.Data.SqlDbType.VarChar, 0, "memberID"),
new System.Data.SqlClient.SqlParameter("@memberCard", System.Data.SqlDbType.VarChar, 0, "memberCard"),
new System.Data.SqlClient.SqlParameter("@memberName", System.Data.SqlDbType.VarChar, 0, "memberName"),
new System.Data.SqlClient.SqlParameter("@memberPhone", System.Data.SqlDbType.Char, 0, "memberPhone"),
new System.Data.SqlClient.SqlParameter("@memberAddress", System.Data.SqlDbType.VarChar, 0, "memberAddress"),
new System.Data.SqlClient.SqlParameter("@memberIdentify", System.Data.SqlDbType.VarChar, 0, "memberIdentify"),
new System.Data.SqlClient.SqlParameter("@NowCash", System.Data.SqlDbType.Float, 0, "NowCash"),
new System.Data.SqlClient.SqlParameter("@regDate", System.Data.SqlDbType.DateTime, 0, "regDate"),
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -