| | |
|---|
| | | return result.OrderBy(a => a.taskCount).ToList(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 返回当前接驳位执行任务数量 |
|---|
| | | /// </summary> |
|---|
| | | internal static int GetConnectionTaskCount(string connection) |
|---|
| | | { |
|---|
| | | var db = new SqlHelper<object>().GetInstance(); |
|---|
| | | |
|---|
| | | |
|---|
| | | var ConnectionList = 0; |
|---|
| | | ConnectionList = db.Queryable<WMSTask>().Where(a => (a.S_END_LOC.Contains(connection) || a.S_START_LOC.Contains(connection)) && a.S_B_STATE != "完成" && a.S_B_STATE != "取消" && a.S_B_STATE != "失败" && a.S_B_STATE != "已完成" && a.S_B_STATE != "未执行").ToList().Count(); |
|---|
| | | return ConnectionList; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 找终点巷道可用空货位 |
|---|
