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