| | |
| | | var task = db.Queryable<WCSTask>().Where(a => a.S_CODE.Trim() == no).First(); |
| | | return task; |
| | | } |
| | | internal static WCSTask GetTaskByEq(string eq) |
| | | { |
| | | var db = new SqlHelper<WCSTask>().GetInstance(); |
| | | var task = db.Queryable<WCSTask>().Where(a => a.S_EQ_NO.Trim() == eq && a.N_B_STATE < 3).OrderByDescending(a => a.T_CREATE).First(); |
| | | return task; |
| | | } |
| | | internal static WCSTask GetTaskBySrcNo(string no) { |
| | | var db = new SqlHelper<WCSTask>().GetInstance(); |
| | | var task = db.Queryable<WCSTask>().Where(a => a.S_OP_CODE== no).First(); |