📄 读者档案管理.designer.cs
字号:
// button4
//
this.button4.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
this.button4.Image = global::图书馆管理系统.Properties.Resources.尾记录;
this.button4.ImageAlign = System.Drawing.ContentAlignment.TopCenter;
this.button4.Location = new System.Drawing.Point(162, 0);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(54, 47);
this.button4.TabIndex = 2;
this.button4.Text = "尾记录";
this.button4.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
this.button4.UseVisualStyleBackColor = true;
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// button5
//
this.button5.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
this.button5.Image = global::图书馆管理系统.Properties.Resources.新增;
this.button5.ImageAlign = System.Drawing.ContentAlignment.TopCenter;
this.button5.Location = new System.Drawing.Point(216, -1);
this.button5.Name = "button5";
this.button5.Size = new System.Drawing.Size(62, 48);
this.button5.TabIndex = 3;
this.button5.Text = "新增记录";
this.button5.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
this.button5.UseVisualStyleBackColor = true;
this.button5.Click += new System.EventHandler(this.button5_Click);
//
// groupBox1
//
this.groupBox1.Controls.Add(this.button11);
this.groupBox1.Controls.Add(this.textBox1);
this.groupBox1.Controls.Add(this.comboBox1);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Dock = System.Windows.Forms.DockStyle.Top;
this.groupBox1.Location = new System.Drawing.Point(0, 50);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(694, 84);
this.groupBox1.TabIndex = 1;
this.groupBox1.TabStop = false;
//
// button11
//
this.button11.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
this.button11.Image = global::图书馆管理系统.Properties.Resources.搜索;
this.button11.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.button11.Location = new System.Drawing.Point(470, 22);
this.button11.Name = "button11";
this.button11.Size = new System.Drawing.Size(75, 45);
this.button11.TabIndex = 4;
this.button11.Text = "搜索";
this.button11.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
this.button11.UseVisualStyleBackColor = true;
this.button11.Click += new System.EventHandler(this.button11_Click);
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(307, 41);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(100, 21);
this.textBox1.TabIndex = 3;
//
// comboBox1
//
this.comboBox1.FormattingEnabled = true;
this.comboBox1.Items.AddRange(new object[] {
"类型",
"条形码",
"编号",
"姓名",
"性别",
"是否挂失",
"所有记录"});
this.comboBox1.Location = new System.Drawing.Point(95, 43);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(121, 20);
this.comboBox1.TabIndex = 2;
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(270, 25);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(77, 12);
this.label2.TabIndex = 1;
this.label2.Text = "设置查询值：";
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(62, 26);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(89, 12);
this.label1.TabIndex = 0;
this.label1.Text = "选择查询字段：";
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "Data Source=.;Initial Catalog=libbook;Integrated Security=True";
this.sqlConnection1.FireInfoMessageEventOnUserErrors = false;
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 读者信息.*\r\nFROM 读者信息";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "读者信息", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("条形码", "条形码"),
new System.Data.Common.DataColumnMapping("编号", "编号"),
new System.Data.Common.DataColumnMapping("姓名", "姓名"),
new System.Data.Common.DataColumnMapping("性别", "性别"),
new System.Data.Common.DataColumnMapping("类型", "类型"),
new System.Data.Common.DataColumnMapping("出生日期", "出生日期"),
new System.Data.Common.DataColumnMapping("有效证件", "有效证件"),
new System.Data.Common.DataColumnMapping("证件号码", "证件号码"),
new System.Data.Common.DataColumnMapping("联系方式", "联系方式"),
new System.Data.Common.DataColumnMapping("登记日期", "登记日期"),
new System.Data.Common.DataColumnMapping("有限期至", "有限期至"),
new System.Data.Common.DataColumnMapping("操作员", "操作员"),
new System.Data.Common.DataColumnMapping("备注", "备注"),
new System.Data.Common.DataColumnMapping("图书借阅次数", "图书借阅次数"),
new System.Data.Common.DataColumnMapping("期刊借阅次数", "期刊借阅次数"),
new System.Data.Common.DataColumnMapping("是否挂失", "是否挂失")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand;
//
// sqlDeleteCommand
//
this.sqlDeleteCommand.CommandText = resources.GetString("sqlDeleteCommand.CommandText");
this.sqlDeleteCommand.Connection = this.sqlConnection1;
this.sqlDeleteCommand.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@IsNull_条形码", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "条形码", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_条形码", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "条形码", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_编号", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "编号", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_姓名", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "姓名", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "姓名", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_性别", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "性别", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_性别", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "性别", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_类型", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_出生日期", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "出生日期", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_出生日期", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "出生日期", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_有效证件", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "有效证件", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_有效证件", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "有效证件", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_证件号码", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "证件号码", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_证件号码", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "证件号码", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_联系方式", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "联系方式", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_联系方式", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "联系方式", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_登记日期", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "登记日期", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_登记日期", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "登记日期", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_有限期至", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "有限期至", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_有限期至", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "有限期至", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_操作员", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "操作员", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_操作员", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "操作员", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_备注", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "备注", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_备注", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "备注", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_图书借阅次数", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "图书借阅次数", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_图书借阅次数", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "图书借阅次数", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_期刊借阅次数", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "期刊借阅次数", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_期刊借阅次数", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "期刊借阅次数", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_是否挂失", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "是否挂失", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_是否挂失", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "是否挂失", System.Data.DataRowVersion.Original, null)});
//
// sqlInsertCommand
//
this.sqlInsertCommand.CommandText = resources.GetString("sqlInsertCommand.CommandText");
this.sqlInsertCommand.Connection = this.sqlConnection1;
this.sqlInsertCommand.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@条形码", System.Data.SqlDbType.VarChar, 0, "条形码"),
new System.Data.SqlClient.SqlParameter("@编号", System.Data.SqlDbType.VarChar, 0, "编号"),
new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 0, "姓名"),
new System.Data.SqlClient.SqlParameter("@性别", System.Data.SqlDbType.VarChar, 0, "性别"),
new System.Data.SqlClient.SqlParameter("@类型", System.Data.SqlDbType.VarChar, 0, "类型"),
new System.Data.SqlClient.SqlParameter("@出生日期", System.Data.SqlDbType.SmallDateTime, 0, "出生日期"),
new System.Data.SqlClient.SqlParameter("@有效证件", System.Data.SqlDbType.VarChar, 0, "有效证件"),
new System.Data.SqlClient.SqlParameter("@证件号码", System.Data.SqlDbType.VarChar, 0, "证件号码"),
new System.Data.SqlClient.SqlParameter("@联系方式", System.Data.SqlDbType.VarChar, 0, "联系方式"),
new System.Data.SqlClient.SqlParameter("@登记日期", System.Data.SqlDbType.SmallDateTime, 0, "登记日期"),
new System.Data.SqlClient.SqlParameter("@有限期至", System.Data.SqlDbType.SmallDateTime, 0, "有限期至"),
new System.Data.SqlClient.SqlParameter("@操作员", System.Data.SqlDbType.VarChar, 0, "操作员"),
new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 0, "备注"),
new System.Data.SqlClient.SqlParameter("@图书借阅次数", System.Data.SqlDbType.Int, 0, "图书借阅次数"),
new System.Data.SqlClient.SqlParameter("@期刊借阅次数", System.Data.SqlDbType.Int, 0, "期刊借阅次数"),
new System.Data.SqlClient.SqlParameter("@是否挂失", System.Data.SqlDbType.Bit, 0, "是否挂失")});
//
// sqlUpdateCommand
//
this.sqlUpdateCommand.CommandText = resources.GetString("sqlUpdateCommand.CommandText");
this.sqlUpdateCommand.Connection = this.sqlConnection1;
this.sqlUpdateCommand.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@条形码", System.Data.SqlDbType.VarChar, 0, "条形码"),
new System.Data.SqlClient.SqlParameter("@编号", System.Data.SqlDbType.VarChar, 0, "编号"),
new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 0, "姓名"),
new System.Data.SqlClient.SqlParameter("@性别", System.Data.SqlDbType.VarChar, 0, "性别"),
new System.Data.SqlClient.SqlParameter("@类型", System.Data.SqlDbType.VarChar, 0, "类型"),
new System.Data.SqlClient.SqlParameter("@出生日期", System.Data.SqlDbType.SmallDateTime, 0, "出生日期"),
new System.Data.SqlClient.SqlParameter("@有效证件", System.Data.SqlDbType.VarChar, 0, "有效证件"),
new System.Data.SqlClient.SqlParameter("@证件号码", System.Data.SqlDbType.VarChar, 0, "证件号码"),
new System.Data.SqlClient.SqlParameter("@联系方式", System.Data.SqlDbType.VarChar, 0, "联系方式"),
new System.Data.SqlClient.SqlParameter("@登记日期", System.Data.SqlDbType.SmallDateTime, 0, "登记日期"),
new System.Data.SqlClient.SqlParameter("@有限期至", System.Data.SqlDbType.SmallDateTime, 0, "有限期至"),
new System.Data.SqlClient.SqlParameter("@操作员", System.Data.SqlDbType.VarChar, 0, "操作员"),
new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 0, "备注"),
new System.Data.SqlClient.SqlParameter("@图书借阅次数", System.Data.SqlDbType.Int, 0, "图书借阅次数"),
new System.Data.SqlClient.SqlParameter("@期刊借阅次数", System.Data.SqlDbType.Int, 0, "期刊借阅次数"),
new System.Data.SqlClient.SqlParameter("@是否挂失", System.Data.SqlDbType.Bit, 0, "是否挂失"),
new System.Data.SqlClient.SqlParameter("@IsNull_条形码", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "条形码", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_条形码", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "条形码", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_编号", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "编号", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_姓名", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "姓名", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "姓名", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_性别", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "性别", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_性别", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "性别", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_类型", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "类型", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_出生日期", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "出生日期", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_出生日期", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "出生日期", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_有效证件", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "有效证件", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_有效证件", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "有效证件", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_证件号码", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "证件号码", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_证件号码", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "证件号码", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_联系方式", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "联系方式", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_联系方式", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "联系方式", System.Data.DataRowVersion.Original, null),
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -