111

lss

9 天以前 9ddec4808631025d36d3c5a816d55ef77a29d4c7

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