public async Task <ActionResult> Index(SystemUserRoleSM sm) { var Dtos = userRoleRepo.GetListDto(sm); var Vms = Mapper.Map <List <UserRoleListVM> >(Dtos); if (Request.IsAjaxRequest()) { return(PartialView("_List", Vms)); } return(View(Vms)); }
public List <UserRoleListDTO> GetListDto(SystemUserRoleSM sm) { var sql = "select * from EM_User_Role where 1=1 "; if (!string.IsNullOrEmpty(sm.UserName)) { sql += " and ( Name like '%'+@UserName+'%' or Description like '%'+@UserName+'%' )"; } var query = DapperHelper.SqlQuery <UserRoleListDTO>(sql, sm).ToList(); return(query); }