lss
2025-07-07 95c865c03a9cb128af51ac4b7d7f9d7149441efd
HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/ContainerHelper.cs
@@ -61,7 +61,7 @@
        /// <param name="prdData">到期时间</param>
        /// <returns></returns>
        internal static bool CreateCntrItem(string loc, string cntr, string itemcode, string itemname, string itemtype, string cntrtype,
            string batch, string wmslot, string weight, string unit, string tyreType, string supplier, string receiveLot, string subpool, string expData = "", string prdData = "", string level = "")
            string batch, string wmslot, string weight, string unit, string tyreType, string supplier, string receiveLot, string subpool, string expData = "", string prdData = "", string level = "",int qty =0, int qtycfg = 0)
        {
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
@@ -99,7 +99,9 @@
                            ReceiveLot = receiveLot,
                            Subpool = subpool,
                            D_EXP_DATE = prdData,
                            D_PRD_DATE = expData
                            D_PRD_DATE = expData,
                            F_WEIGHT1= qty.ToString(),
                            F_QTY1= qtycfg.ToString()
                        };
                        db.Insertable<CntrItemDetail>(cir).ExecuteCommand();
                    }
@@ -120,7 +122,8 @@
                        cntritem.Subpool = subpool;
                        cntritem.D_EXP_DATE = prdData;
                        cntritem.D_PRD_DATE = expData;
                        cntritem. F_WEIGHT1 = qty.ToString();
                        cntritem. F_QTY1 = qtycfg.ToString();
                        if (db.Updateable<CntrItemDetail>(cntritem).ExecuteCommand() > 0)
                        {
                            LogHelper.Info($"托盘{cntr}:更新物料{itemcode}绑定关系成功");
@@ -164,7 +167,7 @@
        /// <param name="expData">生产时间</param>
        /// <param name="prdData">到期时间</param>
        /// <returns></returns>
        internal static bool CreateCntrItem(string cntr, string itemcode, string itemname, string batch, string weight, int qty, string expData = "", string prdData = "")
        internal static bool CreateCntrItemTray(string cntr, string itemcode, string itemname, string batch, string weight, int qty, string expData = "", string prdData = "",string powderType="")
        {
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
@@ -185,7 +188,8 @@
                        S_BATCH_NO = batch,
                        F_QTY = qty,
                        D_EXP_DATE = prdData,
                        D_PRD_DATE = expData
                        D_PRD_DATE = expData,
                        S_FLTYPE = powderType
                    };
                    if (db.Insertable<CntrItemDetail>(cir).ExecuteCommand() > 0)
                    {
@@ -195,6 +199,7 @@
                    else
                    {
                        LogHelper.Info($"托盘{cntr}:添加物料{itemcode}绑定关系失败");
                        res = false;
                    }
                }
@@ -206,6 +211,7 @@
                    cntritem.S_BATCH_NO = batch;
                    cntritem.D_EXP_DATE = prdData;
                    cntritem.D_PRD_DATE = expData;
                    cntritem.S_FLTYPE = powderType;
                    if (db.Updateable<CntrItemDetail>(cntritem).ExecuteCommand() > 0)
                    {
@@ -215,6 +221,7 @@
                    else
                    {
                        LogHelper.Info($"托盘{cntr}:更新物料{itemcode}绑定关系失败");
                        res = false;
                    }
                }
                var con = db.Queryable<Container>().Where(a => a.S_CODE.Trim() == cntr).First();