| | |
| | | { |
| | | foreach(var a in locList) |
| | | { |
| | | LogHelper.Info($"getFDSXArea:查询到当前货位锁状态:{a.S_LOCK_STATE},货位编码:{a.S_CODE}"); |
| | | if(a.S_LOCK_STATE == "无") |
| | | { |
| | | var cntrInfo = db.Queryable<LocCntrRel>().Where(b => b.S_LOC_CODE == a.S_CODE).First(); |
| | |
| | | var itemInfo = db.Queryable<CntrItemRel>().Where(b => b.S_CNTR_CODE == cntrInfo.S_CNTR_CODE).First(); |
| | | if(itemInfo != null) |
| | | { |
| | | LogHelper.Info($"getFDSXArea:查询到物料编码:{itemInfo.S_ITEM_CODE}"); |
| | | if(itemInfo.S_ITEM_CODE == workInfo.S_ItemCode) |
| | | { |
| | | result = a; |
| | | break; |
| | | } |
| | | } |
| | | |
| | | else |
| | | { |
| | | LogHelper.Info($"getFDSXArea:当前托盘未绑定物料,托盘编码:{cntrInfo.S_CNTR_CODE}"); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | LogHelper.Info($"getFDSXArea:当前货位未绑定托盘"); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | else |
| | | { |
| | | LogHelper.Info($"为查询到可能满托,库区编码:{startArea}"); |
| | | LogHelper.Info($"getFDSXArea:未查询到可用满托,库区编码:{startArea}"); |
| | | } |
| | | return result; |
| | | } |