📄 图书盘点.designer.cs
字号:
"现存量",
"库存总量",
"借出次数",
"是否注销"});
this.comboBox1.Location = new System.Drawing.Point(240, 30);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(121, 20);
this.comboBox1.TabIndex = 2;
this.comboBox1.Text = "所有记录";
this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged);
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(145, 33);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(89, 12);
this.label1.TabIndex = 1;
this.label1.Text = "选择查询字段:";
//
// button1
//
this.button1.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
this.button1.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
this.button1.Image = global::图书馆管理系统.Properties.Resources.搜索;
this.button1.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.button1.Location = new System.Drawing.Point(637, 45);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(69, 47);
this.button1.TabIndex = 0;
this.button1.Text = "搜索";
this.button1.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// 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 = resources.GetString("sqlInsertCommand1.CommandText");
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.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("@ISBN", System.Data.SqlDbType.VarChar, 0, "ISBN"),
new System.Data.SqlClient.SqlParameter("@出版社", System.Data.SqlDbType.VarChar, 0, "出版社"),
new System.Data.SqlClient.SqlParameter("@价格", System.Data.SqlDbType.Money, 0, "价格"),
new System.Data.SqlClient.SqlParameter("@页码", System.Data.SqlDbType.Int, 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.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.Bit, 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.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("@ISBN", System.Data.SqlDbType.VarChar, 0, "ISBN"),
new System.Data.SqlClient.SqlParameter("@出版社", System.Data.SqlDbType.VarChar, 0, "出版社"),
new System.Data.SqlClient.SqlParameter("@价格", System.Data.SqlDbType.Money, 0, "价格"),
new System.Data.SqlClient.SqlParameter("@页码", System.Data.SqlDbType.Int, 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.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.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("@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_ISBN", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ISBN", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_ISBN", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ISBN", 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.Money, 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.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.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("@Original_是否注销", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "是否注销", 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("@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),
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -