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 }; })); }