1

chenhaozhe

2026-04-13 debfb742b27f7a5e668e6cd3f52db2ee8ddfe815

 WebAPI/Controllers/²Ö´æ¹ÜÀí/ÁìÁÏ·¢»õ/Kf_StockOutRequestBillController.cs

@@ -304,6 +304,7 @@

        #endregion


        #region å‡ºåº“申请单 - æ‰˜æ•°å˜æ›´åŠŸèƒ½
        [Route("Kf_StockOutRequestBill/UpdatePallet")]
        [HttpPost]
@@ -318,35 +319,20 @@
                if (hmainid <= 0)
                    return new { code = "0", count = 0, Message = "单据ID不能为空！" };

                if (newPallet <= 0)
                    return new { code = "0", count = 0, Message = "托数必须大于0！" };
                if (newPallet < 0)
                    return new { code = "0", count = 0, Message = "托数不能为负数！" };

                // æ£€æŸ¥æ˜¯å¦å·²å®¡æ ¸ - æ”¹ä¸ºæ£€æŸ¥å‡ºåº“申请单主表
                string checkAuditSql = $@"
                    SELECT COUNT(*) as HasAudit 
                    FROM Kf_StockOutRequestBillMain 
                    WHERE HInterID = {hmainid} 
                    AND HChecker IS NOT NULL 
                    AND HCheckDate IS NOT NULL";

                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)
                    {
                        return new { code = "0", count = 0, Message = "单据已审核，不能修改托数！" };
                    }
                }

                // ç›´æŽ¥æ›´æ–°æ‰˜æ•° - æ”¹ä¸ºæ›´æ–°å‡ºåº“申请单主表
                // ç›´æŽ¥æ›´æ–°æ‰˜æ•°
                string updateSql = $@"
                    UPDATE Kf_StockOutRequestBillMain 
                    UPDATE  Kf_StockOutRequestBillMain 
                    SET HPackQtys = {newPallet} 
                    WHERE HInterID = {hmainid}";

                oCn.RunProc(updateSql); // ç›´æŽ¥è°ƒç”¨ï¼Œä¸èµ‹å€¼ç»™å˜é‡

                oCn.RunProc(updateSql);

                return new
                {
@@ -367,6 +353,7 @@
        }
        #endregion


        #region å‡ºåº“申请单列表
        [Route("Kf_StockOutRequestBill/cx")]
        [HttpGet]