1

llj

1 天以前 4c2d6fc7aeb7fe0cc44b2735514d47ff2ace18fa

 WebAPI/Controllers/MJGL/Sc_MouldProdBackBillController.cs

@@ -398,6 +398,7 @@
        #region 器具领用退库单 - 托数变更功能
        [Route("Sc_MouldProdBackBillController/UpdatePallet")]
        [HttpPost]

        public object UpdatePallet([FromBody] JObject data)
        {
            try
@@ -412,27 +413,31 @@
                if (newPallet <= 0)
                    return new { code = "0", count = 0, Message = "托数必须大于0！" };

                // 检查是否已审核

                string checkAuditSql = $@"
                    SELECT COUNT(*) as HasAudit 
                    SELECT HBillStatus 
                    FROM Sc_MouldStockBillMain 
                    WHERE HInterID = {hmainid} 
                    AND HChecker IS NOT NULL 
                    AND HCheckDate IS NOT NULL";
                    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_MouldStockBillMain 
                    UPDATE Sc_MouldStockBillMain  
                    SET HPackQtys = {newPallet} 
                    WHERE HInterID = {hmainid}";