public async Task <ApiResult> ListLogByParm(ImportExcelLogParm 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.ListLogByParm(parm);
return(ret);
}
catch (Exception ex)
{
ret.code = Code.Failure;
ret.msg = ex.Message;
return(ret);
}
}
public async Task <Object> ListLogByParm(ImportExcelLogParm parm)
{
return(await WithConnection(async c =>
{
StringBuilder sql = new StringBuilder();
sql.Append("SELECT distinct a.*,u2.user_name as CreatedName FROM import_excel_log a ")
.Append(" left join user u2 on a.created_by=u2.id ");
StringBuilder whereSql = new StringBuilder();
whereSql.Append(" WHERE 1=1 ");
if (!string.IsNullOrWhiteSpace(parm.FileName))
{
whereSql.Append(" and a.file_name like '%" + parm.FileName + "%'");
}
sql.Append(whereSql)
.Append(" order by a." + parm.sort + " " + parm.order)
.Append(" limit " + (parm.page - 1) * parm.rows + "," + parm.rows);
List <ImportExcelLog> ets = (await c.QueryAsync <ImportExcelLog>(sql.ToString())).ToList();
sql.Clear();
sql.Append("select count(*) FROM import_excel_log a ");
int total = await c.QueryFirstOrDefaultAsync <int>(
sql.ToString() + whereSql.ToString());
return new { rows = ets, total = total };
}));
}
