?? readerinfo.cs
字號:
this.groupBox1.Controls.Add(this.txt3);
this.groupBox1.Location = new System.Drawing.Point(0, 48);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(696, 56);
this.groupBox1.TabIndex = 32;
this.groupBox1.TabStop = false;
//
// btnSearch
//
this.btnSearch.Image = ((System.Drawing.Image)(resources.GetObject("btnSearch.Image")));
this.btnSearch.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.btnSearch.Location = new System.Drawing.Point(16, 24);
this.btnSearch.Name = "btnSearch";
this.btnSearch.Size = new System.Drawing.Size(72, 23);
this.btnSearch.TabIndex = 0;
this.btnSearch.Text = " 搜索";
this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
//
// txt1
//
this.txt1.Location = new System.Drawing.Point(168, 24);
this.txt1.Name = "txt1";
this.txt1.TabIndex = 2;
this.txt1.Text = "";
//
// label2
//
this.label2.Location = new System.Drawing.Point(104, 28);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(56, 16);
this.label2.TabIndex = 1;
this.label2.Text = "條形碼";
//
// label1
//
this.label1.Location = new System.Drawing.Point(328, 28);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(32, 16);
this.label1.TabIndex = 1;
this.label1.Text = "編號";
//
// txt2
//
this.txt2.Location = new System.Drawing.Point(360, 24);
this.txt2.Name = "txt2";
this.txt2.TabIndex = 2;
this.txt2.Text = "";
//
// label3
//
this.label3.Location = new System.Drawing.Point(520, 28);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(32, 16);
this.label3.TabIndex = 1;
this.label3.Text = "姓名";
//
// txt3
//
this.txt3.Location = new System.Drawing.Point(552, 24);
this.txt3.Name = "txt3";
this.txt3.TabIndex = 2;
this.txt3.Text = "";
//
// dataGrid1
//
this.dataGrid1.CaptionVisible = false;
this.dataGrid1.DataMember = "讀者信息";
this.dataGrid1.DataSource = this.dataSet11;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(0, 104);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.ReadOnly = true;
this.dataGrid1.Size = new System.Drawing.Size(696, 216);
this.dataGrid1.TabIndex = 34;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// da1
//
this.da1.DeleteCommand = this.sqlDeleteCommand1;
this.da1.InsertCommand = this.sqlInsertCommand1;
this.da1.SelectCommand = this.sqlSelectCommand1;
this.da1.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.da1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 讀者信息 WHERE (編號 = @Original_編號) AND (出生日期 = @Original_出生日期 OR @Original_出生日期 IS NULL AND 出生日期 IS NULL) AND (圖書借閱次數 = @Original_圖書借閱次數 OR @Original_圖書借閱次數 IS NULL AND 圖書借閱次數 IS NULL) AND (備注 = @Original_備注 OR @Original_備注 IS NULL AND 備注 IS NULL) AND (姓名 = @Original_姓名 OR @Original_姓名 IS NULL AND 姓名 IS NULL) AND (性別 = @Original_性別 OR @Original_性別 IS NULL AND 性別 IS NULL) AND (操作員 = @Original_操作員 OR @Original_操作員 IS NULL AND 操作員 IS NULL) AND (是否掛失 = @Original_是否掛失) AND (有效證件 = @Original_有效證件 OR @Original_有效證件 IS NULL AND 有效證件 IS NULL) AND (有限期至 = @Original_有限期至 OR @Original_有限期至 IS NULL AND 有限期至 IS NULL) AND (期刊借閱次數 = @Original_期刊借閱次數 OR @Original_期刊借閱次數 IS NULL AND 期刊借閱次數 IS NULL) AND (條形碼 = @Original_條形碼 OR @Original_條形碼 IS NULL AND 條形碼 IS NULL) AND (登記日期 = @Original_登記日期 OR @Original_登記日期 IS NULL AND 登記日期 IS NULL) AND (類型 = @Original_類型) AND (聯系方式 = @Original_聯系方式 OR @Original_聯系方式 IS NULL AND 聯系方式 IS NULL) AND (證件號碼 = @Original_證件號碼 OR @Original_證件號碼 IS NULL AND 證件號碼 IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_編號", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "編號", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_出生日期", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "出生日期", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_圖書借閱次數", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "圖書借閱次數", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_備注", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "備注", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_性別", System.Data.SqlDbType.VarChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "性別", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_操作員", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "操作員", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否掛失", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否掛失", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_有效證件", System.Data.SqlDbType.VarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "有效證件", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_有限期至", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "有限期至", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_期刊借閱次數", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "期刊借閱次數", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_條形碼", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "條形碼", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_登記日期", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "登記日期", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_類型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "類型", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_聯系方式", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "聯系方式", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_證件號碼", System.Data.SqlDbType.VarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "證件號碼", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=libbook;";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO 讀者信息(條形碼, 編號, 姓名, 性別, 類型, 出生日期, 有效證件, 證件號碼, 聯系方式, 登記日期, 有限期至, 操作員, 備注, 圖書借閱次數, 期刊借閱次數, 是否掛失) VALUES (@條形碼, @編號, @姓名, @性別, @類型, @出生日期, @有效證件, @證件號碼, @聯系方式, @登記日期, @有限期至, @操作員, @備注, @圖書借閱次數, @期刊借閱次數, @是否掛失); SELECT 條形碼, 編號, 姓名, 性別, 類型, 出生日期, 有效證件, 證件號碼, 聯系方式, 登記日期, 有限期至, 操作員, 備注, 圖書借閱次數, 期刊借閱次數, 是否掛失 FROM 讀者信息 WHERE (編號 = @編號)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@條形碼", System.Data.SqlDbType.VarChar, 40, "條形碼"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@編號", System.Data.SqlDbType.VarChar, 20, "編號"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@性別", System.Data.SqlDbType.VarChar, 8, "性別"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@類型", System.Data.SqlDbType.VarChar, 20, "類型"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@出生日期", System.Data.SqlDbType.DateTime, 4, "出生日期"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@有效證件", System.Data.SqlDbType.VarChar, 60, "有效證件"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@證件號碼", System.Data.SqlDbType.VarChar, 60, "證件號碼"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@聯系方式", System.Data.SqlDbType.VarChar, 100, "聯系方式"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@登記日期", System.Data.SqlDbType.DateTime, 4, "登記日期"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@有限期至", System.Data.SqlDbType.DateTime, 4, "有限期至"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@操作員", System.Data.SqlDbType.VarChar, 20, "操作員"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@備注", System.Data.SqlDbType.VarChar, 100, "備注"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@圖書借閱次數", System.Data.SqlDbType.Int, 4, "圖書借閱次數"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@期刊借閱次數", System.Data.SqlDbType.Int, 4, "期刊借閱次數"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否掛失", System.Data.SqlDbType.Bit, 1, "是否掛失"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 條形碼, 編號, 姓名, 性別, 類型, 出生日期, 有效證件, 證件號碼, 聯系方式, 登記日期, 有限期至, 操作員, 備注, 圖書借閱次數, " +
"期刊借閱次數, 是否掛失 FROM 讀者信息 WHERE (條形碼 LIKE @Param4) AND (編號 LIKE @Param5) AND (姓名 LI" +
"KE @Param6)";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 40, "條形碼"));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param5", System.Data.SqlDbType.VarChar, 20, "編號"));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param6", System.Data.SqlDbType.VarChar, 20, "姓名"));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 讀者信息 SET 條形碼 = @條形碼, 編號 = @編號, 姓名 = @姓名, 性別 = @性別, 類型 = @類型, 出生日期 = @出生日期, 有效證件 = @有效證件, 證件號碼 = @證件號碼, 聯系方式 = @聯系方式, 登記日期 = @登記日期, 有限期至 = @有限期至, 操作員 = @操作員, 備注 = @備注, 圖書借閱次數 = @圖書借閱次數, 期刊借閱次數 = @期刊借閱次數, 是否掛失 = @是否掛失 WHERE (編號 = @Original_編號) AND (出生日期 = @Original_出生日期 OR @Original_出生日期 IS NULL AND 出生日期 IS NULL) AND (圖書借閱次數 = @Original_圖書借閱次數 OR @Original_圖書借閱次數 IS NULL AND 圖書借閱次數 IS NULL) AND (備注 = @Original_備注 OR @Original_備注 IS NULL AND 備注 IS NULL) AND (姓名 = @Original_姓名 OR @Original_姓名 IS NULL AND 姓名 IS NULL) AND (性別 = @Original_性別 OR @Original_性別 IS NULL AND 性別 IS NULL) AND (操作員 = @Original_操作員 OR @Original_操作員 IS NULL AND 操作員 IS NULL) AND (是否掛失 = @Original_是否掛失) AND (有效證件 = @Original_有效證件 OR @Original_有效證件 IS NULL AND 有效證件 IS NULL) AND (有限期至 = @Original_有限期至 OR @Original_有限期至 IS NULL AND 有限期至 IS NULL) AND (期刊借閱次數 = @Original_期刊借閱次數 OR @Original_期刊借閱次數 IS NULL AND 期刊借閱次數 IS NULL) AND (條形碼 = @Original_條形碼 OR @Original_條形碼 IS NULL AND 條形碼 IS NULL) AND (登記日期 = @Original_登記日期 OR @Original_登記日期 IS NULL AND 登記日期 IS NULL) AND (類型 = @Original_類型) AND (聯系方式 = @Original_聯系方式 OR @Original_聯系方式 IS NULL AND 聯系方式 IS NULL) AND (證件號碼 = @Original_證件號碼 OR @Original_證件號碼 IS NULL AND 證件號碼 IS NULL); SELECT 條形碼, 編號, 姓名, 性別, 類型, 出生日期, 有效證件, 證件號碼, 聯系方式, 登記日期, 有限期至, 操作員, 備注, 圖書借閱次數, 期刊借閱次數, 是否掛失 FROM 讀者信息 WHERE (編號 = @編號)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@條形碼", System.Data.SqlDbType.VarChar, 40, "條形碼"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@編號", System.Data.SqlDbType.VarChar, 20, "編號"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@性別", System.Data.SqlDbType.VarChar, 8, "性別"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@類型", System.Data.SqlDbType.VarChar, 20, "類型"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@出生日期", System.Data.SqlDbType.DateTime, 4, "出生日期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@有效證件", System.Data.SqlDbType.VarChar, 60, "有效證件"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@證件號碼", System.Data.SqlDbType.VarChar, 60, "證件號碼"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@聯系方式", System.Data.SqlDbType.VarChar, 100, "聯系方式"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@登記日期", System.Data.SqlDbType.DateTime, 4, "登記日期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@有限期至", System.Data.SqlDbType.DateTime, 4, "有限期至"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@操作員", System.Data.SqlDbType.VarChar, 20, "操作員"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@備注", System.Data.SqlDbType.VarChar, 100, "備注"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@圖書借閱次數", System.Data.SqlDbType.Int, 4, "圖書借閱次數"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@期刊借閱次數", System.Data.SqlDbType.Int, 4, "期刊借閱次數"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否掛失", System.Data.SqlDbType.Bit, 1, "是否掛失"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_編號", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "編號", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_出生日期", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "出生日期", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_圖書借閱次數", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "圖書借閱次數", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_備注", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "備注", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_性別", System.Data.SqlDbType.VarChar, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "性別", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_操作員", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "操作員", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否掛失", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否掛失", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_有效證件", System.Data.SqlDbType.VarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "有效證件", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_有限期至", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "有限期至", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_期刊借閱次數", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "期刊借閱次數", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_條形碼", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "條形碼", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_登記日期", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "登記日期", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_類型", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "類型", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_聯系方式", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "聯系方式", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_證件號碼", System.Data.SqlDbType.VarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "證件號碼", System.Data.DataRowVersion.Original, null));
//
// label4
//
this.label4.Location = new System.Drawing.Point(32, 336);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(56, 16);
this.label4.TabIndex = 1;
this.label4.Text = "條形碼";
//
// txt4
//
this.txt4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "讀者信息.條形碼"));
this.txt4.Location = new System.Drawing.Point(32, 352);
this.txt4.Name = "txt4";
this.txt4.ReadOnly = true;
this.txt4.TabIndex = 2;
this.txt4.Text = "";
//
// label5
//
this.label5.Location = new System.Drawing.Point(160, 336);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(56, 16);
this.label5.TabIndex = 1;
this.label5.Text = "編號";
//
// txt5
//
this.txt5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "讀者信息.編號"));
this.txt5.Location = new System.Drawing.Point(160, 352);
this.txt5.Name = "txt5";
this.txt5.ReadOnly = true;
this.txt5.TabIndex = 2;
this.txt5.Text = "";
//
// txt6
//
this.txt6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "讀者信息.姓名"));
this.txt6.Location = new System.Drawing.Point(288, 352);
this.txt6.Name = "txt6";
this.txt6.ReadOnly = true;
this.txt6.TabIndex = 2;
this.txt6.Text = "";
//
// label6
//
this.label6.Location = new System.Drawing.Point(288, 336);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(56, 16);
this.label6.TabIndex = 1;
this.label6.Text = "姓名";
//
// label7
//
this.label7.Location = new System.Drawing.Point(416, 336);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(56, 16);
this.label7.TabIndex = 1;
this.label7.Text = "性別";
//
// txt7
//
this.txt7.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "讀者信息.聯系方式"));
this.txt7.Location = new System.Drawing.Point(32, 400);
this.txt7.Name = "txt7";
this.txt7.ReadOnly = true;
this.txt7.TabIndex = 2;
this.txt7.Text = "";
//
// label8
//
this.label8.Location = new System.Drawing.Point(528, 336);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(56, 16);
this.label8.TabIndex = 1;
this.label8.Text = "類型";
//
// cmb1
//
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -