托数问题修复

wangyi

1 天以前 29b96ccc6047d2234aa042bb38f1c1e0b5505901

 WebAPI/Controllers/MJGL/Sc_MouldInRequestBillController.cs

@@ -353,27 +353,31 @@
                if (newPallet <= 0)
                    return new { code = "0", count = 0, Message = "托数必须大于0！" };

                // 检查是否已审核
       
                string checkAuditSql = $@"
                    SELECT COUNT(*) as HasAudit 
                    FROM Sc_MouldInRequestBillMain 
                    WHERE HInterID = {hmainid} 
                    AND HChecker IS NOT NULL 
                    AND HCheckDate IS NOT NULL";
                    SELECT HBillStatus 
                    FROM  Sc_MouldInRequestBillMain 
                    WHERE HInterID = {hmainid}";

                DataSet dsAudit = oCn.RunProcReturn(checkAuditSql, "CheckAudit");

                if (dsAudit != null && dsAudit.Tables[0].Rows.Count > 0)
                {
                    int hasAudit = Convert.ToInt32(dsAudit.Tables[0].Rows[0]["HasAudit"]);
                    if (hasAudit > 0)
                    int hBillStatus = Convert.ToInt32(dsAudit.Tables[0].Rows[0]["HBillStatus"]);
                 
                    if (hBillStatus == 2)
                    {
                        return new { code = "0", count = 0, Message = "单据已审核，不能修改托数！" };
                    }
                }
                else
                {
                    return new { code = "0", count = 0, Message = "单据不存在！" };
                }

                // 直接更新托数
                string updateSql = $@"
                    UPDATE Sc_MouldInRequestBillMain 
                    UPDATE  Sc_MouldInRequestBillMain 
                    SET HPackQtys = {newPallet} 
                    WHERE HInterID = {hmainid}";