form6.cs

CSHARP下编写的数据库设备管理系统 SQL SERVER

			this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@办公室", System.Data.SqlDbType.VarChar, 10, "办公室"));
			// 
			// sqlUpdateCommand2
			// 
			this.sqlUpdateCommand2.CommandText = @"UPDATE 部门表 SET 部门号 = @部门号, 部门名 = @部门名, 负责人 = @负责人, 电话 = @电话, 办公室 = @办公室 WHERE (部门号 = @Original_部门号) AND (办公室 = @Original_办公室) AND (电话 = @Original_电话) AND (负责人 = @Original_负责人) 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, 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, 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, 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));
			// 
			// sqlDeleteCommand2
			// 
			this.sqlDeleteCommand2.CommandText = "DELETE FROM 部门表 WHERE (部门号 = @Original_部门号) AND (办公室 = @Original_办公室) AND (电话 = @" +
				"Original_电话) AND (负责人 = @Original_负责人) 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, 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));
			// 
			// b1
			// 
			this.b1.DataSetName = "b";
			this.b1.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 (员工号 = @员工号) AND (设备号 = @设备号)";
			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.DateTime, 8, "维修日期"));
			this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@维修费用", System.Data.SqlDbType.VarChar, 10, "维修费用"));
			// 
			// sqlUpdateCommand3
			// 
			this.sqlUpdateCommand3.CommandText = "UPDATE 维修表 SET 设备号 = @设备号, 员工号 = @员工号, 维修日期 = @维修日期, 维修费用 = @维修费用 WHERE (员工号 = @O" +
				"riginal_员工号) AND (设备号 = @Original_设备号) AND (维修日期 = @Original_维修日期) AND (维修费用 = @" +
				"Original_维修费用); SELECT 设备号, 员工号, 维修日期, 维修费用 FROM 维修表 WHERE (员工号 = @员工号) AND (设备号" +
				" = @设备号)";
			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.DateTime, 8, "维修日期"));
			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.DateTime, 8, 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));
			// 
			// sqlDeleteCommand3
			// 
			this.sqlDeleteCommand3.CommandText = "DELETE FROM 维修表 WHERE (员工号 = @Original_员工号) AND (设备号 = @Original_设备号) AND (维修日期 =" +
				" @Original_维修日期) 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.DateTime, 8, 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));
			// 
			// c1
			// 
			this.c1.DataSetName = "c";
			this.c1.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// sqlDataAdapter4
			// 
			this.sqlDataAdapter4.DeleteCommand = this.sqlDeleteCommand4;
			this.sqlDataAdapter4.InsertCommand = this.sqlInsertCommand4;
			this.sqlDataAdapter4.SelectCommand = this.sqlSelectCommand4;
			this.sqlDataAdapter4.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.sqlDataAdapter4.UpdateCommand = this.sqlUpdateCommand4;
			// 
			// sqlSelectCommand4
			// 
			this.sqlSelectCommand4.CommandText = "SELECT 设备号, 维护人员, 维护周期, 费用 FROM 维护表";
			this.sqlSelectCommand4.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand4
			// 
			this.sqlInsertCommand4.CommandText = "INSERT INTO 维护表(设备号, 维护人员, 维护周期, 费用) VALUES (@设备号, @维护人员, @维护周期, @费用); SELECT 设备号" +
				", 维护人员, 维护周期, 费用 FROM 维护表 WHERE (维护人员 = @维护人员) AND (设备号 = @设备号)";
			this.sqlInsertCommand4.Connection = this.sqlConnection1;
			this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备号", System.Data.SqlDbType.VarChar, 10, "设备号"));
			this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@维护人员", System.Data.SqlDbType.VarChar, 10, "维护人员"));
			this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@维护周期", System.Data.SqlDbType.VarChar, 10, "维护周期"));
			this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@费用", System.Data.SqlDbType.Int, 4, "费用"));
			// 
			// sqlUpdateCommand4
			// 
			this.sqlUpdateCommand4.CommandText = "UPDATE 维护表 SET 设备号 = @设备号, 维护人员 = @维护人员, 维护周期 = @维护周期, 费用 = @费用 WHERE (维护人员 = @Or" +
				"iginal_维护人员) AND (设备号 = @Original_设备号) AND (维护周期 = @Original_维护周期) AND (费用 = @Or" +
				"iginal_费用); SELECT 设备号, 维护人员, 维护周期, 费用 FROM 维护表 WHERE (维护人员 = @维护人员) AND (设备号 = " +
				"@设备号)";
			this.sqlUpdateCommand4.Connection = this.sqlConnection1;
			this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备号", System.Data.SqlDbType.VarChar, 10, "设备号"));
			this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@维护人员", System.Data.SqlDbType.VarChar, 10, "维护人员"));
			this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@维护周期", System.Data.SqlDbType.VarChar, 10, "维护周期"));
			this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@费用", System.Data.SqlDbType.Int, 4, "费用"));
			this.sqlUpdateCommand4.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.sqlUpdateCommand4.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.sqlUpdateCommand4.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.sqlUpdateCommand4.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));
			// 
			// sqlDeleteCommand4
			// 
			this.sqlDeleteCommand4.CommandText = "DELETE FROM 维护表 WHERE (维护人员 = @Original_维护人员) AND (设备号 = @Original_设备号) AND (维护周期" +
				" = @Original_维护周期) AND (费用 = @Original_费用)";
			this.sqlDeleteCommand4.Connection = this.sqlConnection1;
			this.sqlDeleteCommand4.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.sqlDeleteCommand4.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.sqlDeleteCommand4.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.sqlDeleteCommand4.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));
			// 
			// dd1
			// 
			this.dd1.DataSetName = "dd";
			this.dd1.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// sqlDataAdapter5
			// 
			this.sqlDataAdapter5.DeleteCommand = this.sqlDeleteCommand5;
			this.sqlDataAdapter5.InsertCommand = this.sqlInsertCommand5;
			this.sqlDataAdapter5.SelectCommand = this.sqlSelectCommand5;
			this.sqlDataAdapter5.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.sqlDataAdapter5.UpdateCommand = this.sqlUpdateCommand5;
			// 
			// sqlSelectCommand5
			// 
			this.sqlSelectCommand5.CommandText = "SELECT 厂商, 电话, 地址, 联系人 FROM 厂商情况";
			this.sqlSelectCommand5.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand5
			// 
			this.sqlInsertCommand5.CommandText = "INSERT INTO 厂商情况(厂商, 电话, 地址, 联系人) VALUES (@厂商, @电话, @地址, @联系人); SELECT 厂商, 电话, 地址" +
				", 联系人 FROM 厂商情况 WHERE (厂商 = @厂商)";
			this.sqlInsertCommand5.Connection = this.sqlConnection1;
			this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@厂商", System.Data.SqlDbType.VarChar, 10, "厂商"));
			this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电话", System.Data.SqlDbType.VarChar, 10, "电话"));
			this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@地址", System.Data.SqlDbType.VarChar, 30, "地址"));
			this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@联系人", System.Data.SqlDbType.VarChar, 10, "联系人"));
			// 
			// sqlUpdateCommand5