public async Task <ApiResult> ListModulePage(PMModuleParm parm)
{
ApiResult ret = new ApiResult();
try
{
ret.data = await _repo.ListModulePage(parm);
}
catch (Exception ex)
{
ret.code = Code.Failure;
ret.msg = ex.Message;
}
return(ret);
}
public async Task <object> ListModulePage(PMModuleParm parm)
{
return(await WithConnection(async c =>
{
object ret = new { total = 0, row = new List <PMModule>() };
string sql = "SELECT m.*,d.name as levelname,u1.user_name " +
" FROM pm_module m " +
" left join dictionary_tree d on d.id=m.level " +
" left join user u1 on u1.id=m.created_by " +
" where 1=1 ";
string sqlwhere = "";
if (!string.IsNullOrWhiteSpace(parm.ModuleName))
{
sqlwhere += " and m.name like '%" + parm.ModuleName + "%' ";
}
if (!string.IsNullOrWhiteSpace(parm.FileName))
{
sqlwhere += " and m.file_name like '%" + parm.FileName + "%' ";
}
if (!string.IsNullOrWhiteSpace(parm.DeviceName))
{
sqlwhere += " and m.device_name like '%" + parm.DeviceName + "%' ";
}
if (!string.IsNullOrWhiteSpace(parm.KeyWord))
{
sqlwhere += " and m.key_word like '%" + parm.KeyWord + "%' ";
}
sql = sql + sqlwhere + " order by " + parm.sort + " " + parm.order
+ " limit " + (parm.page - 1) * parm.rows + "," + parm.rows;
var tmp = await c.QueryAsync <PMModule>(sql);
if (tmp.Count() > 0)
{
sql = "select count(*) FROM pm_module m " + sqlwhere;
ret = new { total = await c.QueryFirstOrDefaultAsync <int>(sql), rows = tmp.ToList() };
}
return ret;
}));
}
public ActionResult ListModulePage([FromQuery] PMModuleParm parm)
{
var ret = _service.ListModulePage(parm);
return(Ok(ret.Result));
}
