lss
2025-05-20 fe442ab8c9ba6648b140f253902b4ef24c5618bf
HH.WCS.Mobox3/HH.WCS.Mobox3.JiaTong/wms/ContainerHelper.cs
@@ -41,11 +41,25 @@
        /// <summary>
        /// 创建托盘物料绑定关系
        /// </summary>
        /// <param name="loc"></param>
        /// <param name="cntr"></param>
        /// <param name="itemcode"></param>
        /// <param name="loc">货位</param>
        /// <param name="cntr">托盘</param>
        /// <param name="itemcode">物料编码</param>
        /// <param name="itemname">物料名称</param>
        /// <param name="itemtype">物料类型</param>
        /// <param name="cntrtype">托盘类型</param>
        /// <param name="batch">批次号</param>
        /// <param name="weight">重量</param>
        /// <param name="unit">单位</param>
        /// <param name="level">物料等级</param>
        /// <param name="tyreType">轮型</param>
        /// <param name="supplier">供应商</param>
        /// <param name="receiveLot">收获批次</param>
        /// <param name="subpool">子库</param>
        /// <param name="expData">生产时间</param>
        /// <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 weight, string unit, string level = "")
        internal static bool CreateCntrItem(string loc, string cntr, string itemcode, string itemname, string itemtype, string cntrtype,
            string batch, string weight, string unit, string tyreType, string supplier, string receiveLot, string subpool, string expData = "", string prdData = "", string level = "")
        {
            var res = false;
            var db = new SqlHelper<object>().GetInstance();
@@ -67,7 +81,23 @@
                    if (cntritem == null && !kts.Contains(itemcode))
                    {
                        var iteminfo = db.Queryable<TN_Material>().Where(a => a.S_ITEM_CODE.Trim() == itemcode && a.S_ITEM_NAME.Trim() == itemname).First();
                        var cir = new CntrItemDetail { S_CNTR_CODE = cntr, S_ITEM_CODE = itemcode, S_ITEM_NAME = itemname, S_ITEM_SPEC = itemtype, S_WU = unit, F_WEIGHT = weight, S_BATCH_NO = batch, LEV = level };
                        var cir = new CntrItemDetail
                        {
                            S_CNTR_CODE = cntr,
                            S_ITEM_CODE = itemcode,
                            S_ITEM_NAME = itemname,
                            S_ITEM_SPEC = itemtype,
                            S_WU = unit,
                            F_WEIGHT = weight,
                            S_BATCH_NO = batch,
                            LEV = level,
                            TyreType = tyreType,
                            S_SUPPLIER_NO = supplier,
                            ReceiveLot = receiveLot,
                            Subpool = subpool,
                            D_EXP_DATE = expData,
                            D_PRD_DATE = prdData
                        };
                        db.Insertable<CntrItemDetail>(cir).ExecuteCommand();
                    }
                    var cntrloc = db.Queryable<LocCntrRel>().Where(a => a.S_CNTR_CODE.Trim() == cntr).First();