?? 讀者檔案管理.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 + -