| | |
| | | internal static WCSTask GetTaskBySrcNoAndScheduleType(string no ,string scheduleType) |
| | | { |
| | | var db = new SqlHelper<WCSTask>().GetInstance(); |
| | | var task = db.Queryable<WCSTask>().Where(a => a.S_OP_CODE == no && a.S_SCHEDULE_TYPE == scheduleType && a.N_B_STATE < 3).First(); |
| | | var task = db.Queryable<WCSTask>().Where(a => a.S_OP_CODE == no && a.S_SCHEDULE_TYPE == scheduleType).First(); |
| | | return task; |
| | | } |
| | | internal static List<WCSTask> GetTaskListBySrcNo(string no) |
| | |
| | | return db.Queryable<TaskAction>().Where(a => a.S_TASK_CODE == no.Trim() && a.N_ACTION_CODE == code).First(); |
| | | } |
| | | |
| | | internal static bool updateActionRecord(TaskAction taskAction) |
| | | { |
| | | var db = new SqlHelper<TaskAction>().GetInstance(); |
| | | return db.Updateable(taskAction).ExecuteCommand() > 0; |
| | | } |
| | | |
| | | internal static void Begin(WCSTask task) { |
| | | var db = new SqlHelper<WCSTask>().GetInstance(); |
| | | if (task != null) { |