📄 userinfomanange.designer.cs
字号:
//
// readersexDataGridViewTextBoxColumn
//
this.readersexDataGridViewTextBoxColumn.DataPropertyName = "Readersex";
this.readersexDataGridViewTextBoxColumn.HeaderText = "Readersex";
this.readersexDataGridViewTextBoxColumn.Name = "readersexDataGridViewTextBoxColumn";
//
// readerdeptDataGridViewTextBoxColumn
//
this.readerdeptDataGridViewTextBoxColumn.DataPropertyName = "Readerdept";
this.readerdeptDataGridViewTextBoxColumn.HeaderText = "Readerdept";
this.readerdeptDataGridViewTextBoxColumn.Name = "readerdeptDataGridViewTextBoxColumn";
//
// logindateDataGridViewTextBoxColumn
//
this.logindateDataGridViewTextBoxColumn.DataPropertyName = "Logindate";
this.logindateDataGridViewTextBoxColumn.HeaderText = "Logindate";
this.logindateDataGridViewTextBoxColumn.Name = "logindateDataGridViewTextBoxColumn";
//
// logoutdateDataGridViewTextBoxColumn
//
this.logoutdateDataGridViewTextBoxColumn.DataPropertyName = "Logoutdate";
this.logoutdateDataGridViewTextBoxColumn.HeaderText = "Logoutdate";
this.logoutdateDataGridViewTextBoxColumn.Name = "logoutdateDataGridViewTextBoxColumn";
//
// certificateTypeDataGridViewTextBoxColumn
//
this.certificateTypeDataGridViewTextBoxColumn.DataPropertyName = "CertificateType";
this.certificateTypeDataGridViewTextBoxColumn.HeaderText = "CertificateType";
this.certificateTypeDataGridViewTextBoxColumn.Name = "certificateTypeDataGridViewTextBoxColumn";
//
// certificateNumDataGridViewTextBoxColumn
//
this.certificateNumDataGridViewTextBoxColumn.DataPropertyName = "CertificateNum";
this.certificateNumDataGridViewTextBoxColumn.HeaderText = "CertificateNum";
this.certificateNumDataGridViewTextBoxColumn.Name = "certificateNumDataGridViewTextBoxColumn";
//
// islostDataGridViewCheckBoxColumn
//
this.islostDataGridViewCheckBoxColumn.DataPropertyName = "Islost";
this.islostDataGridViewCheckBoxColumn.HeaderText = "Islost";
this.islostDataGridViewCheckBoxColumn.Name = "islostDataGridViewCheckBoxColumn";
//
// userDataSet11
//
this.userDataSet11.DataSetName = "UserDataSet1";
this.userDataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "select * from UserInfoManange";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "Data Source=HUKING;Initial Catalog=library;Integrated Security=True;Workstation I" +
"D=localhost";
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("@ReaderID", System.Data.SqlDbType.VarChar, 0, "ReaderID"),
new System.Data.SqlClient.SqlParameter("@Readername", System.Data.SqlDbType.VarChar, 0, "Readername"),
new System.Data.SqlClient.SqlParameter("@Readertype", System.Data.SqlDbType.VarChar, 0, "Readertype"),
new System.Data.SqlClient.SqlParameter("@Readersex", System.Data.SqlDbType.VarChar, 0, "Readersex"),
new System.Data.SqlClient.SqlParameter("@Readerdept", System.Data.SqlDbType.VarChar, 0, "Readerdept"),
new System.Data.SqlClient.SqlParameter("@Logindate", System.Data.SqlDbType.SmallDateTime, 0, "Logindate"),
new System.Data.SqlClient.SqlParameter("@Logoutdate", System.Data.SqlDbType.SmallDateTime, 0, "Logoutdate"),
new System.Data.SqlClient.SqlParameter("@CertificateType", System.Data.SqlDbType.VarChar, 0, "CertificateType"),
new System.Data.SqlClient.SqlParameter("@CertificateNum", System.Data.SqlDbType.VarChar, 0, "CertificateNum"),
new System.Data.SqlClient.SqlParameter("@Islost", System.Data.SqlDbType.Bit, 0, "Islost")});
//
// 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("@ReaderID", System.Data.SqlDbType.VarChar, 0, "ReaderID"),
new System.Data.SqlClient.SqlParameter("@Readername", System.Data.SqlDbType.VarChar, 0, "Readername"),
new System.Data.SqlClient.SqlParameter("@Readertype", System.Data.SqlDbType.VarChar, 0, "Readertype"),
new System.Data.SqlClient.SqlParameter("@Readersex", System.Data.SqlDbType.VarChar, 0, "Readersex"),
new System.Data.SqlClient.SqlParameter("@Readerdept", System.Data.SqlDbType.VarChar, 0, "Readerdept"),
new System.Data.SqlClient.SqlParameter("@Logindate", System.Data.SqlDbType.SmallDateTime, 0, "Logindate"),
new System.Data.SqlClient.SqlParameter("@Logoutdate", System.Data.SqlDbType.SmallDateTime, 0, "Logoutdate"),
new System.Data.SqlClient.SqlParameter("@CertificateType", System.Data.SqlDbType.VarChar, 0, "CertificateType"),
new System.Data.SqlClient.SqlParameter("@CertificateNum", System.Data.SqlDbType.VarChar, 0, "CertificateNum"),
new System.Data.SqlClient.SqlParameter("@Islost", System.Data.SqlDbType.Bit, 0, "Islost"),
new System.Data.SqlClient.SqlParameter("@Original_ReaderID", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ReaderID", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Readername", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Readername", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Readertype", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Readertype", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Readersex", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Readersex", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Readerdept", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Readerdept", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Logindate", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Logindate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Logoutdate", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Logoutdate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_CertificateType", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CertificateType", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_CertificateNum", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CertificateNum", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Islost", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Islost", 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_ReaderID", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ReaderID", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Readername", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Readername", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Readertype", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Readertype", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Readersex", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Readersex", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Readerdept", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Readerdept", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Logindate", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Logindate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Logoutdate", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Logoutdate", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_CertificateType", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CertificateType", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_CertificateNum", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CertificateNum", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Islost", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Islost", 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", "UserInfoManange", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ReaderID", "ReaderID"),
new System.Data.Common.DataColumnMapping("Readername", "Readername"),
new System.Data.Common.DataColumnMapping("Readertype", "Readertype"),
new System.Data.Common.DataColumnMapping("Readersex", "Readersex"),
new System.Data.Common.DataColumnMapping("Readerdept", "Readerdept"),
new System.Data.Common.DataColumnMapping("Logindate", "Logindate"),
new System.Data.Common.DataColumnMapping("Logoutdate", "Logoutdate"),
new System.Data.Common.DataColumnMapping("CertificateType", "CertificateType"),
new System.Data.Common.DataColumnMapping("CertificateNum", "CertificateNum"),
new System.Data.Common.DataColumnMapping("Islost", "Islost")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(21, 259);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(29, 12);
this.label3.TabIndex = 3;
this.label3.Text = "编号";
this.label3.Click += new System.EventHandler(this.label3_Click);
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(138, 259);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(29, 12);
this.label4.TabIndex = 4;
this.label4.Text = "姓名";
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(364, 259);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(29, 12);
this.label5.TabIndex = 5;
this.label5.Text = "性别";
//
// textBox3
//
this.textBox3.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.userDataSet11, "UserInfoManange.ReaderID", true));
this.textBox3.Location = new System.Drawing.Point(23, 274);
this.textBox3.Name = "textBox3";
this.textBox3.ReadOnly = true;
this.textBox3.Size = new System.Drawing.Size(86, 21);
this.textBox3.TabIndex = 6;
//
// textBox4
//
this.textBox4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.userDataSet11, "UserInfoManange.Readername", true));
this.textBox4.Location = new System.Drawing.Point(140, 274);
this.textBox4.Name = "textBox4";
this.textBox4.ReadOnly = true;
this.textBox4.Size = new System.Drawing.Size(83, 21);
this.textBox4.TabIndex = 7;
//
// comboBox1
//
this.comboBox1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.userDataSet11, "UserInfoManange.Readersex", true));
this.comboBox1.Enabled = false;
this.comboBox1.FormattingEnabled = true;
this.comboBox1.Items.AddRange(new object[] {
"男",
"女"});
this.comboBox1.Location = new System.Drawing.Point(366, 275);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(66, 20);
this.comboBox1.TabIndex = 8;
//
// label6
//
this.label6.AutoSize = true;
this.label6.Location = new System.Drawing.Point(251, 259);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(29, 12);
this.label6.TabIndex = 9;
this.label6.Text = "类型";
//
// comboBox2
//
this.comboBox2.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.userDataSet11, "UserInfoManange.Readertype", true));
this.comboBox2.DisplayMember = "Typename";
this.comboBox2.Enabled = false;
this.comboBox2.FormattingEnabled = true;
this.comboBox2.Location = new System.Drawing.Point(253, 274);
this.comboBox2.Name = "comboBox2";
this.comboBox2.Size = new System.Drawing.Size(75, 20);
this.comboBox2.TabIndex = 10;
this.comboBox2.ValueMember = "Typename";
//
// readertypeDataSet1
//
this.readertypeDataSet1.DataSetName = "ReadertypeDataSet1";
this.readertypeDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -