| | |
| | | { |
| | | foreach (var item in list) |
| | | { |
| | | var cir2 = db.Queryable<CGRels>().Where(a => a.S_ITEM_CODE == item.S_ITEM_CODE).First(); |
| | | var cir2 = db.Queryable<CGRels>().Where(a => a.S_ITEM_CODE == item.S_ITEM_CODE&&a.S_CNTR_TYPE=="半托").First(); |
| | | var S_CNTR_CODE = ""; |
| | | if (cir2 != null) |
| | | { |
| | | S_CNTR_CODE=cir2.S_CNTR_CODE; |
| | | } |
| | | |
| | | var lcr = db.Queryable<LocCntrRel>().Where(c => c.S_CNTR_CODE == S_CNTR_CODE).First(); |
| | | if (lcr != null) |
| | | { |
| | | //起始库位 |
| | | var startloc = db.Queryable<Location>().Where(it => it.S_CODE == lcr.S_LOC_CODE).First(); |
| | | var wsc= db.Queryable<WCSTask>().Where(it => it.S_CODE == lcr.S_LOC_CODE&&it.N_B_STATE<3).First(); |
| | | var wsc = db.Queryable<WCSTask>().Where(it => it.S_CNTR_CODE == S_CNTR_CODE && it.N_B_STATE < 3).First(); |
| | | if (wsc!=null) |
| | | { |
| | | item.N_B_STATE = 2; |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | | else |
| | | { |
| | | LogHelper.Info($"配盘生成作业容器未绑定货位"); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | LogHelper.Info($"未找到物料{item.S_ITEM_CODE}对应的容器"); |
| | | } |
| | | |
| | | } |
| | | |