/// <summary> /// 获取员工列表 /// </summary> /// <returns></returns> public PagedResult <Users> GetUserList(UsersParameter parameter) { string sqlstr = $"select * from (select ROW_NUMBER() OVER(ORDER BY s.UserID )AS Row,s.* from Users s) ss WHERE ss.Row BETWEEN @StartIndex AND @EndIndex"; List <Users> modelList = DbHelper.Query <Users>(sqlstr, new { StartIndex = parameter.SkipCount, EndIndex = parameter.TakeCount }); int totalCount = DbHelper.QuerySingle <int>("select * from Users"); return(new PagedResult <Users> { PageIndex = parameter.PageIndex, PageSize = parameter.PageSize, TotalItemCount = totalCount, Items = modelList }); }
public async Task <IEnumerable <Users> > GetUsers([FromQuery] UsersParameter usersParameter) { var result = await _users.GetUsersasync(usersParameter); return(result); }
/// <summary> /// 获取员工列表 /// </summary> /// <returns></returns> public ActionResult GetUserList(UsersParameter parameter) { PagedResult <Users> userList = _userService.GetUserList(parameter); return(View(userList)); }