📄 form3.cs
字号:
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// textBox5
//
this.textBox5.Location = new System.Drawing.Point(112, 144);
this.textBox5.Name = "textBox5";
this.textBox5.Size = new System.Drawing.Size(88, 21);
this.textBox5.TabIndex = 4;
this.textBox5.Text = "";
this.textBox5.TextChanged += new System.EventHandler(this.textBox5_TextChanged);
//
// label6
//
this.label6.Location = new System.Drawing.Point(40, 144);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(56, 16);
this.label6.TabIndex = 3;
this.label6.Text = "查询条件";
//
// label5
//
this.label5.Location = new System.Drawing.Point(16, 40);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(80, 16);
this.label5.TabIndex = 2;
this.label5.Text = "选择查询类型";
//
// 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("设备名", "设备名"),
new System.Data.Common.DataColumnMapping("状态", "状态")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 种类编号, 设备号, 设备名, 状态 FROM 设备表";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// 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, 10, "种类编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备号", System.Data.SqlDbType.VarChar, 10, "设备号"));
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, 10, "状态"));
//
// 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_设备名); SELECT 种类编号, 设备号, 设备名, 状态 FROM 设备表 WHERE (设备号 = @设备号)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@种类编号", System.Data.SqlDbType.VarChar, 10, "种类编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备号", System.Data.SqlDbType.VarChar, 10, "设备号"));
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, 10, "状态"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_设备号", System.Data.SqlDbType.VarChar, 10, 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, 10, 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, 10, 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));
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 设备表 WHERE (设备号 = @Original_设备号) AND (状态 = @Original_状态 OR @Original_状" +
"态 IS NULL AND 状态 IS NULL) AND (种类编号 = @Original_种类编号 OR @Original_种类编号 IS NULL A" +
"ND 种类编号 IS NULL) AND (设备名 = @Original_设备名)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_设备号", System.Data.SqlDbType.VarChar, 10, 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, 10, 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, 10, 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));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=s0184;packet size=4096;integrated security=SSPI;data source=s0184;" +
"persist security info=False;initial catalog=设备管理系统";
//
// aaa1
//
this.aaa1.DataSetName = "aaa";
this.aaa1.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// sqlDataAdapter2
//
this.sqlDataAdapter2.DeleteCommand = this.sqlDeleteCommand2;
this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand2;
this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;
this.sqlDataAdapter2.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("状态", "状态")})});
this.sqlDataAdapter2.UpdateCommand = this.sqlUpdateCommand2;
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT 种类编号, 设备号, 设备名, 状态 FROM 设备表";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = "INSERT INTO 设备表(种类编号, 设备号, 设备名, 状态) VALUES (@种类编号, @设备号, @设备名, @状态); SELECT 种类编号," +
" 设备号, 设备名, 状态 FROM 设备表 WHERE (设备号 = @设备号)";
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@种类编号", System.Data.SqlDbType.VarChar, 10, "种类编号"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备号", System.Data.SqlDbType.VarChar, 10, "设备号"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备名", System.Data.SqlDbType.VarChar, 20, "设备名"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 10, "状态"));
//
// sqlUpdateCommand2
//
this.sqlUpdateCommand2.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_设备名); SELECT 种类编号, 设备号, 设备名, 状态 FROM 设备表 WHERE (设备号 = @设备号)";
this.sqlUpdateCommand2.Connection = this.sqlConnection1;
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@种类编号", System.Data.SqlDbType.VarChar, 10, "种类编号"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备号", System.Data.SqlDbType.VarChar, 10, "设备号"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备名", System.Data.SqlDbType.VarChar, 20, "设备名"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 10, "状态"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_设备号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "设备号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "状态", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_种类编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "种类编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.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));
//
// sqlDeleteCommand2
//
this.sqlDeleteCommand2.CommandText = "DELETE FROM 设备表 WHERE (设备号 = @Original_设备号) AND (状态 = @Original_状态 OR @Original_状" +
"态 IS NULL AND 状态 IS NULL) AND (种类编号 = @Original_种类编号 OR @Original_种类编号 IS NULL A" +
"ND 种类编号 IS NULL) AND (设备名 = @Original_设备名)";
this.sqlDeleteCommand2.Connection = this.sqlConnection1;
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_设备号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "设备号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "状态", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_种类编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "种类编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.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));
//
// bbb1
//
this.bbb1.DataSetName = "bbb";
this.bbb1.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// sqlDataAdapter3
//
this.sqlDataAdapter3.DeleteCommand = this.sqlDeleteCommand3;
this.sqlDataAdapter3.InsertCommand = this.sqlInsertCommand3;
this.sqlDataAdapter3.SelectCommand = this.sqlSelectCommand3;
this.sqlDataAdapter3.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("状态", "状态")})});
this.sqlDataAdapter3.UpdateCommand = this.sqlUpdateCommand3;
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "SELECT 种类编号, 设备号, 设备名, 状态 FROM 设备表";
this.sqlSelectCommand3.Connection = this.sqlConnection1;
//
// sqlInsertCommand3
//
this.sqlInsertCommand3.CommandText = "INSERT INTO 设备表(种类编号, 设备号, 设备名, 状态) VALUES (@种类编号, @设备号, @设备名, @状态); SELECT 种类编号," +
" 设备号, 设备名, 状态 FROM 设备表 WHERE (设备号 = @设备号)";
this.sqlInsertCommand3.Connection = this.sqlConnection1;
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@种类编号", System.Data.SqlDbType.VarChar, 10, "种类编号"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备号", System.Data.SqlDbType.VarChar, 10, "设备号"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备名", System.Data.SqlDbType.VarChar, 20, "设备名"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 10, "状态"));
//
// sqlUpdateCommand3
//
this.sqlUpdateCommand3.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_设备名); SELECT 种类编号, 设备号, 设备名, 状态 FROM 设备表 WHERE (设备号 = @设备号)";
this.sqlUpdateCommand3.Connection = this.sqlConnection1;
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@种类编号", System.Data.SqlDbType.VarChar, 10, "种类编号"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备号", System.Data.SqlDbType.VarChar, 10, "设备号"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备名", System.Data.SqlDbType.VarChar, 20, "设备名"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@状态", System.Data.SqlDbType.VarChar, 10, "状态"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_设备号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "设备号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "状态", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_种类编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "种类编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand3.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));
//
// sqlDeleteCommand3
//
this.sqlDeleteCommand3.CommandText = "DELETE FROM 设备表 WHERE (设备号 = @Original_设备号) AND (状态 = @Original_状态 OR @Original_状" +
"态 IS NULL AND 状态 IS NULL) AND (种类编号 = @Original_种类编号 OR @Original_种类编号 IS NULL A" +
"ND 种类编号 IS NULL) AND (设备名 = @Original_设备名)";
this.sqlDeleteCommand3.Connection = this.sqlConnection1;
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_设备号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "设备号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_状态", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "状态", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_种类编号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "种类编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.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));
//
// ccc1
//
this.ccc1.DataSetName = "ccc";
this.ccc1.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// sqlDataAdapter4
//
this.sqlDataAdapter4.DeleteCommand = this.sqlDeleteCommand4;
this.sqlDataAdapter4.InsertCommand = this.sqlInsertCommand4;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -