SQL: Update不影响任何行

Question

我想更新DB2/AS400表中的一个数据集。

问题是，如果在参数列表中有字符串参数，命令不会找到要更新的行。

例如:如果只输入公司号，则命令执行成功。如果输入公司号和设施号，命令执行失败。

有人知道吗?

IDbConnection cn = Tools.GetCnApp();
try
{
    StringBuilder sql = new StringBuilder(); 
    sql.AppendLine("UPDATE " + Tools.GetSchemeApp() + "/ChangeReasonAssignments");
    sql.AppendLine("  SET Confirmed = @CONF, Confirmed_By = @CONFBY, Confirmed_At = @CONFAT");
    sql.AppendLine("  WHERE Company = @CONO AND Facility = @FACI AND Department = @DEPT");
    sql.AppendLine("  AND Production_Group = @PRGR AND Manufacturing_Order = @ORDR AND Order_Operation = @OPER");
    sql.AppendLine("  AND Confirmed = 0");
    IDbCommand cmd = cn.CreateCommand();
    cmd.SetParameter("@CONO", this.CompanyNumber);
    cmd.SetParameter("@FACI", this.FacilityNumber);
    cmd.SetParameter("@DEPT", this.ProductionGroup.Department.Name);
    cmd.SetParameter("@PRGR", this.ProductionGroup.Name);
    cmd.SetParameter("@ORDR", this.ManufacturingNumber);
    cmd.SetParameter("@OPER", this.OperationNumber);
    cmd.SetParameter("@CONFBY", Base.User);
    cmd.SetParameter("@CONFAT", DateTime.Now.ToString());
    cmd.SetParameter("@CONF", 1);
    cmd.CommandText = sql.ToString();
    if (cmd.ExecuteNonQuery() > 0)
    {
    }

编辑

数据库中的数据类型为:

• 公司:INTEGER
• Facility: VARCHAR
• 部门:VARCHAR
• Production_Group: VARCHAR
• Manufacturing_Order:整数
• Order_Operation:整数

中的数据类型。:

• CompanyNumber: int
• FacilityNumber:字符串
• Departmentname:字符串
• ProductionGroup:字符串
• Manufacturingorder: int
• OrderOperation: int

sql.ToString()结果:

UPDATE TSAEDBDEV/ChangeReasonAssignments SET Confirmed = @CONF, Confirmed_By = @CONFBY, Confirmed_At = @CONFAT WHERE Company = @CONO AND Facility = @FACI AND Confirmed = 0

Answer 1

尝试将字符串值设置为':cmd.SetParameter("@DEPT", "'" + this.ProductionGroup.Department.Name + "'");