/// <summary>
/// The GetList.
/// </summary>
/// <param name="models">The models<see cref="SickQueryDTO"/>.</param>
/// <returns>The <see cref="Task{BaseResult{SickEntity}}"/>.</returns>
public async Task <BaseResult <SickEntity> > GetList(SickQueryDTO models)
{
string tableName = "tbSick";
string where = " IsDelete=0";
string orderby = "id ";
if (models.sortRule == 1)
{
orderby += " DESC";
}
else
{
orderby += " ASC";
}
if (models.title != null)
{
where = where + "AND title LIKE '%" + models.title + "%'";
}
int skip = (models.pageIndex - 1) * models.pageSize + 1;
StringBuilder sb = new StringBuilder();
//sb.AppendFormat(@"SELECT * FROM(SELECT ROW_NUMBER() OVER(ORDER BY {0}) AS RowNum,*FROM {1} WHERE IsDelete=0) AS result WHERE RowNum >= {2} AND RowNum <= {3} ORDER BY id desc", orderby, tableName, skip, models.pageIndex * models.pageSize);
sb.AppendFormat("SELECT COUNT(1) FROM {0} WHERE {1};", tableName, where);
sb.AppendFormat(@"SELECT *
FROM(SELECT ROW_NUMBER() OVER(ORDER BY {2}) AS RowNum,*
FROM {0}
WHERE {1}
) AS result
WHERE RowNum >= {3} AND RowNum <= {4}
ORDER BY {2}", tableName, where, orderby, skip, models.pageIndex * models.pageSize);
var result = new BaseResult <SickEntity>();
try
{
var pageData = await GetPageList(sb.ToString());
if (pageData.total > -1)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.data = pageData;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
public async Task<BaseResult<SickEntity>> GetList(SickQueryDTO models)
{
var list = await sickRepository.GetList(models);
return list;
}
