public async Task <ImportExcelConfigView> GetPageByParm(ImportExcelConfigParm parm)
{
return(await WithConnection(async c =>
{
StringBuilder sql = new StringBuilder();
sql.Append("SELECT distinct a.*,u2.user_name as UpdatedName,iec.show_name FROM import_excel_config a ")
.Append(" left join user u2 on a.updated_by=u2.id ")
.Append(" left join import_excel_class iec on a.class=iec.id");
StringBuilder whereSql = new StringBuilder();
whereSql.Append(" WHERE 1=1 ");
if (!string.IsNullOrWhiteSpace(parm.SearchName))
{
whereSql.Append(" and a.file_name like '%" + parm.SearchName + "%'");
}
if (parm.SearchClass != null)
{
whereSql.Append(" and a.class=" + parm.SearchClass);
}
sql.Append(whereSql)
.Append(" order by a." + parm.sort + " " + parm.order)
.Append(" limit " + (parm.page - 1) * parm.rows + "," + parm.rows);
List <ImportExcelConfig> ets = (await c.QueryAsync <ImportExcelConfig>(sql.ToString())).ToList();
sql.Clear();
sql.Append("select count(*) FROM import_excel_config a ");
int total = await c.QueryFirstOrDefaultAsync <int>(
sql.ToString() + whereSql.ToString());
ImportExcelConfigView ret = new ImportExcelConfigView();
ret.rows = ets;
ret.total = total;
return ret;
}));
}
public async Task <ApiResult> GetPageByParm(ImportExcelConfigParm parm)
{
ApiResult ret = new ApiResult();
try
{
parm.page = parm.page == 0 ? 1 : parm.page;
parm.rows = parm.rows == 0 ? PAGESIZE : parm.rows;
parm.sort = string.IsNullOrWhiteSpace(parm.sort) ? "id" : parm.sort;
parm.order = parm.order.ToLower() == "desc" ? "desc" : "asc";
ret.data = await _importExcelConfigRepo.GetPageByParm(parm);
return(ret);
}
catch (Exception ex)
{
ret.code = Code.Failure;
ret.msg = ex.Message;
return(ret);
}
}
