| | |
|---|
| | | { |
|---|
| | | // 1、查询当前库区-排-物料 有托盘的货位 |
|---|
| | | var db = new SqlHelper<object>().GetInstance(); |
|---|
| | | result = db.Queryable<Location>() |
|---|
| | | .Where(l => l.N_CURRENT_NUM > 0 && l.S_AREA_CODE == area && l.N_ROW == row && l.N_LOCK_STATE == 0 && (l.C_ENABLE != "禁用" && l.C_ENABLE != "N")) |
|---|
| | | .Includes(l => l.LocCntrRel, l => l.CntrItemRel) |
|---|
| | | .OrderByDescending(l => l.N_COL) |
|---|
| | | .First(); |
|---|
| | | var isLock = db.Queryable<Location>().Where(a => a.S_AREA_CODE == area && a.N_ROW == row && a.N_LOCK_STATE != 0).Count()> 0; |
|---|
| | | if (!isLock) |
|---|
| | | { |
|---|
| | | result = db.Queryable<Location>() |
|---|
| | | .Where(l => l.N_CURRENT_NUM > 0 && l.S_AREA_CODE == area && l.N_ROW == row && l.N_LOCK_STATE == 0 && (l.C_ENABLE != "禁用" && l.C_ENABLE != "N")) |
|---|
| | | .Includes(l => l.LocCntrRel, l => l.CntrItemRel) |
|---|
| | | .OrderByDescending(l => l.N_COL) |
|---|
| | | .First(); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | catch (Exception ex) |
|---|
| | | { |
|---|
