111

lss

2025-07-09 00ecab4ee5cec0d04665ca16d0eb30c1ba4ea1f3

 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();