托数问题修复

wangyi

昨天 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}";


 WebAPI/Controllers/MJGL/Sc_MouldOutRequestBillController.cs

@@ -503,6 +503,7 @@
        #region 器具出库申请单 - 托数变更功能
        [Route("Sc_MouldOutRequestBillController/UpdatePallet")]
        [HttpPost]
    
        public object UpdatePallet([FromBody] JObject data)
        {
            try
@@ -517,24 +518,28 @@
                if (newPallet <= 0)
                    return new { code = "0", count = 0, Message = "托数必须大于0！" };

                // 检查是否已审核

                string checkAuditSql = $@"
                    SELECT COUNT(*) as HasAudit 
                    SELECT HBillStatus 
                    FROM Sc_MouldOutRequestBillMain 
                    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"]);
                    // ✅ 正确的判断：HBillStatus = 2 表示已审核
                    if (hBillStatus == 2)
                    {
                        return new { code = "0", count = 0, Message = "单据已审核，不能修改托数！" };
                    }
                }
                else
                {
                    return new { code = "0", count = 0, Message = "单据不存在！" };
                }

                // 直接更新托数
                string updateSql = $@"
                    UPDATE Sc_MouldOutRequestBillMain 

 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}";


 WebAPI/Controllers/MJGL/Sc_MouldProdOutBillController.cs

@@ -339,6 +339,7 @@
        #region 器具领用出库单 - 托数变更功能
        [Route("Sc_MouldProdOutBill/UpdatePallet")]
        [HttpPost]
    
        public object UpdatePallet([FromBody] JObject data)
        {
            try
@@ -353,24 +354,28 @@
                if (newPallet <= 0)
                    return new { code = "0", count = 0, Message = "托数必须大于0！" };

                // 检查是否已审核

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