public async Task <IActionResult> PageData(int page, int limit, string RoleName) { string msg = string.Empty; int code = 0; int total = 0; string sWhere = string.Empty; IEnumerable <ESysRole> list = null; try { var param = new Dapper.DynamicParameters(); if (!string.IsNullOrEmpty(RoleName)) { sWhere += " and RoleName like @RoleName"; param.Add("RoleName", string.Format("%{0}%", RoleName)); } total = await _SysRoleRepository.GetTotalCount(sWhere, param); list = await _SysRoleRepository.GetPageAsync(page, limit, sWhere, param); } catch (Exception ex) { code = -1; msg = ex.Message; } return(Ok(new { code = code, msg = msg, count = total, data = list })); }