合并

yusijie

2 天以前 6866dbd4b0b8703811872669179a68841eea803d

 WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs

@@ -1,6 +1,5 @@
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using NPOI.SS.Formula.Functions;
using Pub_Class;
using System;
using System.Collections;
@@ -9,6 +8,7 @@
using System.Data.SqlClient;
using System.Web.Http;
using WebAPI.Models;
using System.Windows.Forms;
using SyntacticSugar.constant;

namespace WebAPI.Controllers
@@ -617,7 +617,6 @@
            }
        }
        #endregion

        #region 采购入库单 - 托数变更功能
        [Route("Kf_POStockInBill/UpdatePallet")]
        [HttpPost]
@@ -635,32 +634,17 @@
                if (newPallet <= 0)
                    return new { code = "0", count = 0, Message = "托数必须大于0！" };

                // 检查是否已审核
                string checkAuditSql = $@"
                    SELECT COUNT(*) as HasAudit 
                    FROM Kf_ICStockBillMain 
                    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_ICStockBillMain 
                    UPDATE  Kf_ICStockBillMain 
                    SET HPackQtys = {newPallet} 
                    WHERE HInterID = {hmainid}";

                oCN.RunProc(updateSql); // 直接调用，不赋值给变量

                oCN.RunProc(updateSql);

                return new
                {
@@ -680,6 +664,55 @@
            }
        }
        #endregion
        #region 采购入库单 - 贴标签数变更功能
        [Route("Kf_POStockInBill/UpdateHTagCount")]
        [HttpPost]
        public object UpdateHTagCount([FromBody] JObject data)
        {
            try
            {
                long hmainid = data["hmainid"]?.ToObject<long>() ?? 0;
                int newPallet = data["newPallet"]?.ToObject<int>() ?? 0;
                string operatorName = data["operator"]?.ToString() ?? "";

                if (hmainid <= 0)
                    return new { code = "0", count = 0, Message = "单据ID不能为空！" };

                if (newPallet <= 0)
                    return new { code = "0", count = 0, Message = "贴标签数必须大于0！" };




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


                oCN.RunProc(updateSql);

                return new
                {
                    code = "1",
                    count = 1,
                    Message = "托数修改成功！"
                };
            }
            catch (Exception e)
            {
                return new
                {
                    code = "0",
                    count = 0,
                    Message = "修改失败：" + e.Message
                };
            }
        }
        #endregion



        #region 查找记录功能
        /// <summary>