📄 系统维护.cs
字号:
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_流水号", System.Data.SqlDbType.BigInt, 8, 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.DateTime, 8, 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.Int, 4, 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.DateTime, 8, 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, 50, 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, 50, 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.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "花费", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = "INSERT INTO 流水帐表(条形码, 上机时间, 下机时间, 花费, 上机状态, 上机区域, 值班教师) VALUES (@条形码, @上机时间, @下机时" +
"间, @花费, @上机状态, @上机区域, @值班教师); SELECT 流水号, 条形码, 上机时间, 下机时间, 花费, 上机状态, 上机区域, 值班教师 " +
"FROM 流水帐表 WHERE (流水号 = @@IDENTITY)";
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@条形码", System.Data.SqlDbType.VarChar, 50, "条形码"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上机时间", System.Data.SqlDbType.DateTime, 8, "上机时间"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@下机时间", System.Data.SqlDbType.DateTime, 8, "下机时间"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@花费", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "花费", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上机状态", System.Data.SqlDbType.Int, 4, "上机状态"));
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, 50, "值班教师"));
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT 流水号, 条形码, 上机时间, 下机时间, 花费, 上机状态, 上机区域, 值班教师 FROM 流水帐表";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// 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_上机状态 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.sqlUpdateCommand2.Connection = this.sqlConnection1;
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@条形码", System.Data.SqlDbType.VarChar, 50, "条形码"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上机时间", System.Data.SqlDbType.DateTime, 8, "上机时间"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@下机时间", System.Data.SqlDbType.DateTime, 8, "下机时间"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@花费", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "花费", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上机状态", System.Data.SqlDbType.Int, 4, "上机状态"));
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, 50, "值班教师"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_流水号", System.Data.SqlDbType.BigInt, 8, 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.DateTime, 8, 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.Int, 4, 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.DateTime, 8, 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, 50, 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, 50, 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.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "花费", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@流水号", System.Data.SqlDbType.BigInt, 8, "流水号"));
//
// 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("ID", "ID"),
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;
//
// sqlDeleteCommand3
//
this.sqlDeleteCommand3.CommandText = @"DELETE FROM 收费流水表 WHERE (ID = @Original_ID) 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.sqlDeleteCommand3.Connection = this.sqlConnection1;
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.BigInt, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.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.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_充值", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "充值", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_收费", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "收费", 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, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "条形码", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand3
//
this.sqlInsertCommand3.CommandText = "INSERT INTO 收费流水表(时间, 条形码, 值班教师, 收费, 充值) VALUES (@时间, @条形码, @值班教师, @收费, @充值); SEL" +
"ECT ID, 时间, 条形码, 值班教师, 收费, 充值 FROM 收费流水表 WHERE (ID = @@IDENTITY)";
this.sqlInsertCommand3.Connection = this.sqlConnection1;
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, 50, "条形码"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@值班教师", System.Data.SqlDbType.VarChar, 50, "值班教师"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@收费", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "收费", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@充值", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "充值", System.Data.DataRowVersion.Current, null));
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "SELECT ID, 时间, 条形码, 值班教师, 收费, 充值 FROM 收费流水表";
this.sqlSelectCommand3.Connection = this.sqlConnection1;
//
// sqlUpdateCommand3
//
this.sqlUpdateCommand3.CommandText = @"UPDATE 收费流水表 SET 时间 = @时间, 条形码 = @条形码, 值班教师 = @值班教师, 收费 = @收费, 充值 = @充值 WHERE (ID = @Original_ID) 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 ID, 时间, 条形码, 值班教师, 收费, 充值 FROM 收费流水表 WHERE (ID = @ID)";
this.sqlUpdateCommand3.Connection = this.sqlConnection1;
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, 50, "条形码"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@值班教师", System.Data.SqlDbType.VarChar, 50, "值班教师"));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@收费", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "收费", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@充值", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "充值", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.BigInt, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand3.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.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_充值", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "充值", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_收费", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "收费", 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, 50, 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("@ID", System.Data.SqlDbType.BigInt, 8, "ID"));
//
// 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("机器数", "机器数")})});
this.sqlDataAdapter4.UpdateCommand = this.sqlUpdateCommand4;
//
// sqlDeleteCommand4
//
this.sqlDeleteCommand4.CommandText = "DELETE FROM 系统表 WHERE (机房 = @Original_机房) AND (定价 = @Original_定价 OR @Original_定价 " +
"IS NULL AND 定价 IS NULL) AND (机器数 = @Original_机器数 OR @Original_机器数 IS NULL AND 机器" +
"数 IS NULL)";
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.Money, 8, 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));
//
// sqlInsertCommand4
//
this.sqlInsertCommand4.CommandText = "INSERT INTO 系统表(机房, 定价, 机器数) VALUES (@机房, @定价, @机器数); SELECT 机房, 定价, 机器数 FROM 系统表" +
" WHERE (机房 = @机房)";
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.Money, 8, "定价"));
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@机器数", System.Data.SqlDbType.VarChar, 10, "机器数"));
//
// sqlSelectCommand4
//
this.sqlSelectCommand4.CommandText = "SELECT 机房, 定价, 机器数 FROM 系统表";
this.sqlSelectCommand4.Connection = this.sqlConnection1;
//
// sqlUpdateCommand4
//
this.sqlUpdateCommand4.CommandText = "UPDATE 系统表 SET 机房 = @机房, 定价 = @定价, 机器数 = @机器数 WHERE (机房 = @Original_机房) AND (定价 =" +
" @Original_定价 OR @Original_定价 IS NULL AND 定价 IS NULL) AND (机器数 = @Original_机器数 O" +
"R @Original_机器数 IS NULL AND 机器数 IS NULL); SELECT 机房, 定价, 机器数 FROM 系统表 WHERE (机房 " +
"= @机房)";
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.Money, 8, "定价"));
this.sqlUpdateCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@机器数", System.Data.SqlDbType.VarChar, 10, "机器数"));
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.Money, 8, 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));
//
// 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("优惠系数", "优惠系数")})});
this.sqlDataAdapter5.UpdateCommand = this.sqlUpdateCommand5;
//
// sqlDeleteCommand5
//
this.sqlDeleteCommand5.CommandText = "DELETE FROM 优惠表 WHERE (金额限 = @Original_金额限) AND (优惠系数 = @Original_优惠系数 OR @Origin" +
"al_优惠系数 IS NULL AND 优惠系数 IS NULL)";
this.sqlDeleteCommand5.Connection = this.sqlConnection1;
this.sqlDeleteCommand5.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.sqlDeleteCommand5.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));
//
// 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, 50, "金额限"));
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@优惠系数", System.Data.SqlDbType.VarChar, 50, "优惠系数"));
//
// sqlSelectCommand5
//
this.sqlSelectCommand5.CommandText = "SELECT 金额限, 优惠系数 FROM 优惠表";
t⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -