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