| | |
| | | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据货位集合获取 没有容器 没有锁的货位 |
| | | /// </summary> |
| | | /// <param name="loc"></param> |
| | | /// <returns></returns> |
| | | internal static List<Location> GetLocListEmptyFree(List<string> loc) |
| | | { |
| | | //1.0 查货位容器表 |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM == 0 && a.S_LOCK_STATE.Trim() == "无").ToList(); |
| | | return list; |
| | | |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 入库锁定终点,出库锁定起点 |
| | |
| | | return db.Queryable<ZoneLoc>().Where(a => a.S_LOC_CODE == loc).ToList(); |
| | | |
| | | } |
| | | |
| | | internal static void Test() |
| | | { |
| | | //多查询一次也是可以的,先查出可用的货位组,然后选择货位组中列比较大的,或者列比较小的 |
| | | var availableRowGroups = new List<Location>().GroupBy(l => l.N_ROW_GROUP).Where(g => !g.Any(l => l.N_LOCK_STATE != 0)).Select(g => g.Key); |
| | | |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | //db.Queryable<Location>().Where(a => a.S_AREA_CODE == "11").Where(a => SqlFunc.Subqueryable<Location>().Where(b => b.)).GroupBy(z => z.N_ROW_GROUP).ToList(); |
| | | } |
| | | |
| | | #region 杭氧货位帮助Helper |
| | | |
| | |
| | | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据货位集合获取 没有容器 没有锁的货位 |
| | | /// </summary> |
| | | /// <param name="loc"></param> |
| | | /// <returns></returns> |
| | | internal static List<Location> GetLocListEmptyFree(List<string> loc) |
| | | { |
| | | //1.0 查货位容器表 |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | var list = db.Queryable<Location>().Where(a => loc.Contains(a.S_CODE) && a.N_CURRENT_NUM == 0 && a.S_LOCK_STATE.Trim() == "无").ToList(); |
| | | return list; |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | #endregion |