public PagedResults <RPTJOBCONFIGOutput> PagingConfigQuery(RPTJOBCONFIGPagingInput paging)
{
string sql = @" SELECT t.sysid,
t.procedurename,
t.trigger_type,
t.max_retry_count,
t.is_stop_when_failed,
t.job_state,
b.process_status,
b.cycle_start_time,
b.retry_count,
c.next_cycle_time,
T.SEQUENCE,
@rowNumber, @recordCount
FROM rpt_tbl_job_config t
left join rpt_tbl_job_circle_status b
on t.current_cycle_job_status_id = b.sysid
left join rpt_tbl_job_trigger_history c
on b.job_trigger_hist_id = c.sysid
@where";
return(PagingQuery <RPTJOBCONFIGOutput>(sql.ToString(), paging));
}
public PagedResults <RPTJOBCONFIGOutput> PagingConfigQuery(RPTJOBCONFIGPagingInput paging)
{
return(_rPTTBLJOBCONFIGRepository.PagingConfigQuery(paging));
}
public JsonResult PagingConfigQuery(RPTJOBCONFIGPagingInput paging)
{
return(JsonForGridPaging(_rPTTBLJOBCONFIGLogic.PagingConfigQuery(paging)));
}