📄 图书类型设置.designer.cs
字号:
//
// label2
//
this.label2.AutoSize = true;
this.label2.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.label2.Location = new System.Drawing.Point(215, 34);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(120, 16);
this.label2.TabIndex = 2;
this.label2.Text = "(或)类型名称：";
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(99, 32);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(100, 21);
this.textBox1.TabIndex = 3;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.label1.Location = new System.Drawing.Point(6, 34);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(88, 16);
this.label1.TabIndex = 1;
this.label1.Text = "类型编号：";
//
// button10
//
this.button10.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.button10.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.button10.Image = global::图书馆管理系统.Properties.Resources.搜索;
this.button10.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.button10.Location = new System.Drawing.Point(461, 23);
this.button10.Name = "button10";
this.button10.Size = new System.Drawing.Size(72, 38);
this.button10.TabIndex = 0;
this.button10.Text = "搜索";
this.button10.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
this.button10.UseVisualStyleBackColor = true;
this.button10.Click += new System.EventHandler(this.button10_Click);
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(355, 153);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(65, 12);
this.label3.TabIndex = 4;
this.label3.Text = "类型编号：";
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(355, 217);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(65, 12);
this.label4.TabIndex = 5;
this.label4.Text = "类型名称：";
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(355, 285);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(65, 12);
this.label5.TabIndex = 6;
this.label5.Text = "可借天数：";
//
// textBox3
//
this.textBox3.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "图书类型.类型编号", true));
this.textBox3.Location = new System.Drawing.Point(421, 178);
this.textBox3.Name = "textBox3";
this.textBox3.Size = new System.Drawing.Size(100, 21);
this.textBox3.TabIndex = 7;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// textBox4
//
this.textBox4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "图书类型.类型名称", true));
this.textBox4.Location = new System.Drawing.Point(421, 248);
this.textBox4.Name = "textBox4";
this.textBox4.Size = new System.Drawing.Size(100, 21);
this.textBox4.TabIndex = 8;
//
// textBox5
//
this.textBox5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "图书类型.可借天数", true));
this.textBox5.Location = new System.Drawing.Point(421, 314);
this.textBox5.Name = "textBox5";
this.textBox5.Size = new System.Drawing.Size(100, 21);
this.textBox5.TabIndex = 9;
//
// 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;
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO [图书类型] ([类型编号], [类型名称], [可借天数]) VALUES (@类型编号, @类型名称, @可借天数);\r\nSELECT" +
" 类型编号, 类型名称, 可借天数 FROM 图书类型 WHERE (类型编号 = @类型编号)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.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.Int, 0, "可借天数")});
//
// 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("@类型编号", 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("@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)});
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM [图书类型] WHERE (([类型编号] = @Original_类型编号) AND ((@IsNull_类型名称 = 1 AND [类" +
"型名称] IS NULL) OR ([类型名称] = @Original_类型名称)) AND ((@IsNull_可借天数 = 1 AND [可借天数] IS" +
" NULL) OR ([可借天数] = @Original_可借天数)))";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
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)});
//
// 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", "图书类型", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("类型编号", "类型编号"),
new System.Data.Common.DataColumnMapping("类型名称", "类型名称"),
new System.Data.Common.DataColumnMapping("可借天数", "可借天数")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// dataGrid1
//
this.dataGrid1.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.dataGrid1.CaptionBackColor = System.Drawing.SystemColors.Control;
this.dataGrid1.DataMember = "图书类型";
this.dataGrid1.DataSource = this.dataSet11;
this.dataGrid1.Dock = System.Windows.Forms.DockStyle.Left;
this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGrid1.Location = new System.Drawing.Point(0, 114);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(293, 301);
this.dataGrid1.TabIndex = 10;
//
// button12
//
this.button12.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.button12.Location = new System.Drawing.Point(320, 359);
this.button12.Name = "button12";
this.button12.Size = new System.Drawing.Size(122, 44);
this.button12.TabIndex = 11;
this.button12.Text = "浏览所有记录";
this.button12.UseVisualStyleBackColor = true;
this.button12.Click += new System.EventHandler(this.button12_Click);
//
// 图书类型设置
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(576, 415);
this.Controls.Add(this.button12);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.textBox5);
this.Controls.Add(this.textBox4);
this.Controls.Add(this.textBox3);
this.Controls.Add(this.label5);
this.Controls.Add(this.label4);
this.Controls.Add(this.label3);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.panel1);
this.Name = "图书类型设置";
this.Text = "图书类型设置";
this.Load += new System.EventHandler(this.图书类型设置_Load);
this.panel1.ResumeLayout(false);
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
#endregion
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.Button button4;
private System.Windows.Forms.Button button5;
private System.Windows.Forms.Button button6;
private System.Windows.Forms.Button button7;
private System.Windows.Forms.Button button8;
private System.Windows.Forms.Button button9;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Button button10;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.TextBox textBox5;
private DataSet1 dataSet11;
private System.Data.SqlClient.SqlConnection sqlConnection1;
private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
private System.Windows.Forms.Button button11;
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.Button button12;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -