public PagedResultDto <QuartzJobdetailDto> GetList(GetListQuartzJobDetailInput input) { var result = _quartzJobdetailRepository.GetListReturnOrder(input); return(new PagedResultDto <QuartzJobdetailDto> { TotalCount = result.Count, Items = result.Data.ToList() }); }
public IPage <QuartzJobdetailDto> GetListReturnOrder(GetListQuartzJobDetailInput input) { object sqlParam = null; var sql = new StringBuilder(); sql.Append("select * from QuartzJobdetail "); sql.Append(" where 1=1"); var result = DapperContext.Current.DataBase.GetPage <QuartzJobdetailDto>(new PageRequest { PageIndex = input.PageIndex, PageSize = input.PageSize, SqlText = sql.ToString(), SqlParam = sqlParam, OrderFiled = " Id desc ", }); return(result); }