| | |
| | | Where(a => a.S_OP_CODE.Trim() == wmsTaskNo |
| | | && a.N_B_STATE == -1 |
| | | ); |
| | | if (anomaly == 1) |
| | | /*if (anomaly == 1) |
| | | { |
| | | updateable = updateable.Where(a => a.S_TYPE.Contains("【异常】")); |
| | | } |
| | | else |
| | | { |
| | | updateable = updateable.Where(a => !a.S_TYPE.Contains("【异常】")); |
| | | } |
| | | }*/ |
| | | return updateable.ExecuteCommand() > 0; |
| | | } |
| | | |
| | |
| | | } |
| | | internal static List<WCSTask> GetWaitingTaskList() { |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | return db.Queryable<WCSTask>().Where(a => a.N_B_STATE == 0).ToList(); |
| | | return db.Queryable<WCSTask>().Where(a => a.N_B_STATE == 0).OrderByDescending(a => a.N_PRIORITY).ToList(); |
| | | } |
| | | } |
| | | } |