| | |
| | | db.Updateable(InventoryCntr).UpdateColumns(it => new { it.N_B_STATE }).ExecuteCommand(); |
| | | } |
| | | |
| | | var InventoryCntr2 = db.Queryable<PlanInventory>().Where(a => a.S_CNTR_CODE == task.S_CNTR_CODE && a.N_B_STATE == 3).First(); |
| | | if (InventoryCntr2 != null && task.S_TYPE == "盘点回") |
| | | { |
| | | InventoryCntr2.N_B_STATE = 4; |
| | | db.Updateable(InventoryCntr2).UpdateColumns(it => new { it.N_B_STATE }).ExecuteCommand(); |
| | | } |
| | | //var InventoryCntr2 = db.Queryable<PlanInventory>().Where(a => a.S_CNTR_CODE == task.S_CNTR_CODE && a.N_B_STATE == 3).First(); |
| | | //if (InventoryCntr2 != null && task.S_TYPE == "盘点回") |
| | | //{ |
| | | // InventoryCntr2.N_B_STATE = 4; |
| | | // db.Updateable(InventoryCntr2).UpdateColumns(it => new { it.N_B_STATE }).ExecuteCommand(); |
| | | //} |
| | | } |
| | | |
| | | |
| | |
| | | { |
| | | LogHelper.Info($"该料框无特殊规格 不需区分高低货位"); |
| | | } |
| | | |
| | | if (a.S_END_AREA == "11TLKQ") |
| | | { |
| | | //托盘高度从物料表中获取 |
| | | var itemList = db.Queryable<CntrItemRel>().Where(it => it.S_CNTR_CODE == a.S_CNTR_CODE).ToList(); |
| | | foreach (var item in itemList) |
| | | { |
| | | var itemInfo = db.Queryable<TN_Material>().Where(it => it.S_ITEM_CODE == item.S_ITEM_CODE).First(); |
| | | if (itemInfo != null) |
| | | { |
| | | loctype = itemInfo.S_HEIGHT; |
| | | if (loctype == "高货位") |
| | | { |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | //终点为立库的任务 |
| | | result = GetLiKuLocationIn(a.S_END_AREA, 0, loctype); |
| | | if (result != null) |