📄 booksubscribe.cs
字号:
this.tBtnEdit.ImageIndex = 5;
this.tBtnEdit.Text = "修改";
this.tBtnEdit.ToolTipText = "修改";
//
// tBtnDelete
//
this.tBtnDelete.ImageIndex = 6;
this.tBtnDelete.Text = "删除";
this.tBtnDelete.ToolTipText = "删除";
//
// tBtnSubmit
//
this.tBtnSubmit.ImageIndex = 7;
this.tBtnSubmit.Text = "提交";
this.tBtnSubmit.ToolTipText = "提交";
//
// tBtnCancel
//
this.tBtnCancel.ImageIndex = 8;
this.tBtnCancel.Text = "取消";
this.tBtnCancel.ToolTipText = "取消";
//
// tBtnQuit
//
this.tBtnQuit.ImageIndex = 9;
this.tBtnQuit.Text = "退出";
this.tBtnQuit.ToolTipText = "退出";
//
// 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(616, 216);
this.dataGrid1.TabIndex = 42;
//
// groupBox2
//
this.groupBox2.Controls.Add(this.checkBox1);
this.groupBox2.Controls.Add(this.cmb1);
this.groupBox2.Controls.Add(this.txt3);
this.groupBox2.Controls.Add(this.label3);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.txt4);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Controls.Add(this.txt5);
this.groupBox2.Controls.Add(this.label6);
this.groupBox2.Controls.Add(this.txt6);
this.groupBox2.Controls.Add(this.label7);
this.groupBox2.Controls.Add(this.txt7);
this.groupBox2.Controls.Add(this.label8);
this.groupBox2.Controls.Add(this.label9);
this.groupBox2.Controls.Add(this.txt8);
this.groupBox2.Controls.Add(this.txt9);
this.groupBox2.Controls.Add(this.label11);
this.groupBox2.Controls.Add(this.label12);
this.groupBox2.Controls.Add(this.txt10);
this.groupBox2.Location = new System.Drawing.Point(0, 318);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(616, 176);
this.groupBox2.TabIndex = 43;
this.groupBox2.TabStop = false;
//
// checkBox1
//
this.checkBox1.DataBindings.Add(new System.Windows.Forms.Binding("Checked", this.dataSet11, "图书征订.是否验收"));
this.checkBox1.Enabled = false;
this.checkBox1.Location = new System.Drawing.Point(192, 142);
this.checkBox1.Name = "checkBox1";
this.checkBox1.TabIndex = 4;
this.checkBox1.Text = "是否验收";
//
// cmb1
//
this.cmb1.Enabled = false;
this.cmb1.ItemHeight = 12;
this.cmb1.Location = new System.Drawing.Point(336, 40);
this.cmb1.Name = "cmb1";
this.cmb1.Size = new System.Drawing.Size(192, 20);
this.cmb1.TabIndex = 3;
this.cmb1.DropDown += new System.EventHandler(this.cmb1_DropDown);
//
// label4
//
this.label4.Location = new System.Drawing.Point(184, 24);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(64, 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(184, 40);
this.txt4.Name = "txt4";
this.txt4.ReadOnly = true;
this.txt4.Size = new System.Drawing.Size(120, 21);
this.txt4.TabIndex = 2;
this.txt4.Text = "";
this.txt4.TextChanged += new System.EventHandler(this.txt4_TextChanged);
//
// label5
//
this.label5.Location = new System.Drawing.Point(336, 24);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(72, 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(48, 96);
this.txt5.Name = "txt5";
this.txt5.ReadOnly = true;
this.txt5.TabIndex = 2;
this.txt5.Text = "";
//
// label6
//
this.label6.Location = new System.Drawing.Point(48, 80);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(48, 16);
this.label6.TabIndex = 1;
this.label6.Text = "订购者";
//
// txt6
//
this.txt6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "图书征订.操作员"));
this.txt6.Location = new System.Drawing.Point(176, 96);
this.txt6.Name = "txt6";
this.txt6.ReadOnly = true;
this.txt6.TabIndex = 2;
this.txt6.Text = "";
//
// label7
//
this.label7.Location = new System.Drawing.Point(176, 80);
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(304, 96);
this.txt7.Name = "txt7";
this.txt7.ReadOnly = true;
this.txt7.TabIndex = 2;
this.txt7.Text = "";
//
// label8
//
this.label8.Location = new System.Drawing.Point(304, 80);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(72, 16);
this.label8.TabIndex = 1;
this.label8.Text = "订购数量";
//
// label9
//
this.label9.Location = new System.Drawing.Point(432, 80);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(80, 16);
this.label9.TabIndex = 1;
this.label9.Text = "订购单价";
//
// txt8
//
this.txt8.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "图书征订.订购单价"));
this.txt8.Location = new System.Drawing.Point(430, 96);
this.txt8.Name = "txt8";
this.txt8.ReadOnly = true;
this.txt8.TabIndex = 2;
this.txt8.Text = "";
//
// txt9
//
this.txt9.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "图书征订.订购日期"));
this.txt9.Location = new System.Drawing.Point(48, 144);
this.txt9.Name = "txt9";
this.txt9.ReadOnly = true;
this.txt9.TabIndex = 2;
this.txt9.Text = "";
//
// label11
//
this.label11.Location = new System.Drawing.Point(48, 128);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(72, 16);
this.label11.TabIndex = 1;
this.label11.Text = "订购日期";
//
// label12
//
this.label12.Location = new System.Drawing.Point(336, 128);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(128, 16);
this.label12.TabIndex = 1;
this.label12.Text = "订购者联系方式";
//
// txt10
//
this.txt10.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "图书征订.订购者联系方式"));
this.txt10.Location = new System.Drawing.Point(336, 144);
this.txt10.Name = "txt10";
this.txt10.ReadOnly = true;
this.txt10.Size = new System.Drawing.Size(192, 21);
this.txt10.TabIndex = 2;
this.txt10.Text = "";
//
// btnSusbribe
//
this.btnSusbribe.Location = new System.Drawing.Point(451, 4);
this.btnSusbribe.Name = "btnSusbribe";
this.btnSusbribe.Size = new System.Drawing.Size(141, 35);
this.btnSusbribe.TabIndex = 44;
this.btnSusbribe.Text = "提交征订（验收）";
this.btnSusbribe.Click += new System.EventHandler(this.btnSusbribe_Click);
//
// 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("操作员", "操作员")})});
this.da1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 图书征订 WHERE (征订编号 = @Original_征订编号) 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_订购者 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)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_征订编号", System.Data.SqlDbType.VarChar, 50, 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, 50, 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.Money, 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.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.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, 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, 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.DateTime, 4, 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 图书征订(征订编号, 图书编号, 订购者, 订购者联系方式, 订购数量, 订购单价, 订购日期, 是否验收, 验收日期, 操作员) VAL" +
"UES (@征订编号, @图书编号, @订购者, @订购者联系方式, @订购数量, @订购单价, @订购日期, @是否验收, @验收日期, @操作员); SEL" +
"ECT 征订编号, 图书编号, 订购者, 订购者联系方式, 订购数量, 订购单价, 订购日期, 是否验收, 验收日期, 操作员 FROM 图书征订 WHERE " +
"(征订编号 = @征订编号)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@征订编号", System.Data.SqlDbType.VarChar, 50, "征订编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@图书编号", System.Data.SqlDbType.VarChar, 50, "图书编号"));
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.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.Money, 8, "订购单价"));
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.Bit, 1, "是否验收"));
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, "操作员"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 征订编号, 图书编号, 订购者, 订购者联系方式, 订购数量, 订购单价, 订购日期, 是否验收, 验收日期, 操作员 FROM 图书征订 WHER" +
"E (是否验收 = \'0\') AND (征订编号 LIKE @Param3) AND (图书编号 LIKE @Param4)";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 50, "征订编号"));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 50, "图书编号"));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 图书征订 SET 征订编号 = @征订编号, 图书编号 = @图书编号, 订购者 = @订购者, 订购者联系方式 = @订购者联系方式, 订购数量 = @订购数量, 订购单价 = @订购单价, 订购日期 = @订购日期, 是否验收 = @是否验收, 验收日期 = @验收日期, 操作员 = @操作员 WHERE (征订编号 = @Original_征订编号) 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_订购者 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); SELECT 征订编号, 图书编号, 订购者, 订购者联系方式, 订购数量, 订购单价, 订购日期, 是否验收, 验收日期, 操作员 FROM 图书征订 WHERE (征订编号 = @征订编号)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -