| | |
| | | } |
| | | else |
| | | { |
| | | locs = queryable.Where((a, b, c) => c.S_FLTYPE == powderType && c.S_BS_TYPE == "余料").ToList(); |
| | | locs = queryable.Where((a, b, c) => (c.S_FLTYPE == powderType||string.IsNullOrEmpty(c.S_FLTYPE)) && c.S_BS_TYPE == "余料").ToList(); |
| | | } |
| | | |
| | | //没有余料则寻找全部物料 |
| | |
| | | queryable = db.Queryable<Location>() |
| | | .LeftJoin<LocCntrRel>((a, b) => a.S_CODE == b.S_LOC_CODE) |
| | | .LeftJoin<CntrItemDetail>((a, b, c) => b.S_CNTR_CODE == c.S_CNTR_CODE) |
| | | .Where((a, b, c) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode && c.S_FLTYPE == powderType); |
| | | .Where((a, b, c) => a.N_CURRENT_NUM > 0 && a.N_LOCK_STATE == 0 && a.S_AREA_CODE == areaCode ); |
| | | //六位码匹配前六位,其他的全部配置 |
| | | if (ItemCode.Trim().Length == 6) |
| | | { |
| | |
| | | } |
| | | else |
| | | { |
| | | locs = queryable.Where((a, b, c) => c.S_FLTYPE == powderType ).ToList(); |
| | | locs = queryable.Where((a, b, c) => c.S_FLTYPE == powderType || string.IsNullOrEmpty(c.S_FLTYPE)).ToList(); |
| | | } |
| | | LogHelper.Info($"GetLocByItemCode=>无余料,查找全部{JsonConvert.SerializeObject(locs)}"); |
| | | } |