| | |
| | | var task = db.Queryable<WCSTask>().Where(a => a.S_EQ_NO == eqNo).OrderByDescending(a => a.T_CREATE).First(); |
| | | return task; |
| | | } |
| | | internal static List<WCSTask> GetTaskListByEqNo(string eqNo) |
| | | { |
| | | var db = new SqlHelper<WCSTask>().GetInstance(); |
| | | return db.Queryable<WCSTask>().Where(a => a.S_EQ_NO == eqNo).OrderByDescending(a => a.T_CREATE).ToList(); |
| | | } |
| | | |
| | | internal static List<WCSTask> GetTaskByStart(string bit) { |
| | | var db = new SqlHelper<WCSTask>().GetInstance(); |
| | |
| | | N_SCHEDULE_TYPE=1, |
| | | S_B_STATE = "等待", |
| | | S_CNTR_CODE = cntrInfo, |
| | | N_START_LAYER = startLayer, |
| | | N_END_LAYER = endLayer, |
| | | N_CNTR_COUNT = cntrCount |
| | | |
| | | }; |
| | | |
| | |
| | | if (task != null) |
| | | { |
| | | task.N_B_STATE = 4; |
| | | if (WCSHelper.CheckActionRecordExist(task.S_CODE, 4)) |
| | | WCSHelper.UpdateStatus(task, "取消"); |
| | | |
| | | var mst = WMSHelper.GetWmsTask(task.S_OP_CODE); |
| | | if (mst != null) |
| | | { |
| | | WCSHelper.UpdateStatus(task, "强制完成"); |
| | | } |
| | | else { |
| | | WCSHelper.UpdateStatus(task, "取消"); |
| | | LocationHelper.UnLockLoc(mst.S_END_LOC); |
| | | |
| | | mst.N_B_STATE = 3; |
| | | mst.S_B_STATE = "取消"; |
| | | WMSHelper.UpdateTaskState(mst); |
| | | } |
| | | } |
| | | } |