| | |
| | | && c.N_CURRENT_NUM == 0 && c.C_ENABLE == "Y" |
| | | && SqlFunc.Subqueryable<TN_Loc_Container>().Where(b => b.S_LOC_CODE == c.S_CODE).NotAny()//不能有货 |
| | | ). |
| | | OrderBy(o => o.T_MODIFY, OrderByType.Asc).First();//查询合适的终点货位,直接判断当前数量为0即可 |
| | | OrderBy(o => o.N_LAYER, OrderByType.Asc).First();//查询合适的终点货位,1层先入库 |
| | | |
| | | if (endLoc != null) |
| | | { |
| | |
| | | Where((o, i, s) => o.N_CURRENT_NUM > 0 && o.S_AREA_CODE == Settings.Areas[1] && o.N_LOCK_STATE == 0 && o.S_LOCK_STATE == "无" && o.C_ENABLE == "Y" |
| | | && (s.S_ITEM_SPEC == model.Spe || s.S_SPE == model.Spe)//指定规格 |
| | | && s.N_ITEM_STATE == 0 && s.S_ITEM_STATE == "合格" //合格的 |
| | | && s.T_MODIFY.AddMinutes(waitTime) <= System.DateTime.Now).//根据规格的不同静置不同分钟才能出库 |
| | | && i.T_CREATE.AddMinutes(waitTime) <= System.DateTime.Now).//根据规格的不同静置不同分钟才能出库 |
| | | OrderBy((o, i, s) => s.T_CREATE, OrderByType.Asc).//先进先出 |
| | | First();//筛选有容器货位关系表信息,筛选有容器货品明细表信息 |
| | | } |