public ActionResult GetUserInfoList() { int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5; //接收搜索条件 string userName = Request["name"]; string userRemark = Request["remark"]; int totalCount = 0; //构建搜索条件 UserInfoSearch userInfoSearch = new UserInfoSearch { UserName = userName, UserRemark = userRemark, PageIndex = pageIndex, PageSize = pageSize, TotalCount = totalCount }; short delFlag = (short)DeleteEnumType.Normarl; var userInfoList = UserInfoService.LoadSeachEntities(userInfoSearch, delFlag); var temp = from u in userInfoList select new { u.ID, u.UName, u.UPwd, u.Remark, u.SubTime }; return(Json(new { rows = temp, total = userInfoSearch.TotalCount }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 加载用户收据 /// </summary> /// <returns></returns> public ActionResult GetUserInfo() { int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5; //接受的搜索条件 string uName = Request["name"]; string uRemark = Request["remark"]; int totalCount = 0; //构建搜索的条件 UserInfoSearch userInfoSearch = new UserInfoSearch() { UName = uName, URemark = uRemark, PageIndex = pageIndex, PageSize = pageSize, TotalCount = totalCount }; short delFlag = (short)DelFlagEnum.Normal; var userInfoList = UserInfoService.LoadSearchEntities(userInfoSearch); //搜索 //var userList = UserInfoService.LoadPageEntities<int>(pageIndex, pageSize, out totalCount, u => u.DelFlag == delFlag, u => u.ID, true); var temp = from u in userInfoList select new { u.ID, UserName = u.UName, UserPwd = u.UPwd, u.SubTime, u.Remark }; return(Json(new { rows = temp, total = userInfoSearch.TotalCount }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 展示数据 /// </summary> /// <returns></returns> public ActionResult GetUserInfoList() { //请求报文里有两个参数:page和rows int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]); int pageSize = Request["rows"] == null ? 5 : int.Parse(Request["rows"]); //var temp = Bll.LoadPageEntities<int>(pageIndex, pageSize, out int pageCount, true, u => u.DelFlag == (short)DeleteEnumType.Normal, u => u.ID); UserInfoSearch userInfoSearch = new UserInfoSearch() { PageIndex = pageIndex, PageSize = pageSize, UserName = Request["name"], UserRemark = Request["remark"] }; //执行完下面这个方法后userInfoSearch.PageCount才有值 var temp = UserInfoBll.LoadSearchEntities(userInfoSearch, DeleteEnumType.Normal); var userInfoList = from u in temp select new { //下面可以注释的原因:自己看吧 /*ID = */ u.ID, /*UName = */ u.UName, /*UPwd = */ u.UPwd, /*Remark = */ u.Remark, SubTime = u.SubTime }; return(Json(new { total = userInfoSearch.PageCount, rows = userInfoList })); }
public ActionResult GetAllUserItem(UserInfoSearch search, int currRoleId, string currUserIds) { ViewBag.RoleId = currRoleId; ViewBag.CurrUserIds = currUserIds; BL.UserInfo userBL = new BL.UserInfo(); UserInfoModel usermodel = new Model.SystemMaint.UserInfo.UserInfoModel(); usermodel.List = userBL.GetAllItemById(search); usermodel.Search = search; return(PartialView("_UserSelectDialog", usermodel)); }
// GET: UserInfo public ActionResult Index(UserInfoSearch userInfoSearch, int?page) { int pageIndex = page ?? 1; int totalCount = 0; var dd = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"]; IEnumerable <UserInfo> list = _UserInfoService.GetPagedList(userInfoSearch, out totalCount); ViewBag.List = list.ToPagedList(1, 10); //var usersAsIPagedList = new StaticPagedList<UserInfo>(list, pageIndex, 10, totalCount); return(View(userInfoSearch)); }
public PagedResponse <UserInfoDto> Execute(UserInfoSearch search) { var query = _context.Users.AsQueryable(); if (!string.IsNullOrEmpty(search.Username) || !string.IsNullOrWhiteSpace(search.Username)) { query = query.Where(u => u.Username.ToLower().Contains(search.Username.ToLower())); } if (!string.IsNullOrEmpty(search.Name) || !string.IsNullOrWhiteSpace(search.Name)) { query = query.Where(u => u.Name.ToLower().Contains(search.Name.ToLower())); } if (!string.IsNullOrEmpty(search.Surname) || !string.IsNullOrWhiteSpace(search.Surname)) { query = query.Where(u => u.Surname.ToLower().Contains(search.Surname.ToLower())); } if (search.Birthdate != null) { query = query.Where(u => u.Birthdate < search.Birthdate); } if (search.RoleId != null) { query = query.Where(u => u.RoleId == search.RoleId); } var currentPage = search.Page; var perPage = search.PerPage; var skip = perPage * (currentPage - 1); return(new PagedResponse <UserInfoDto> { CurrentPage = currentPage, ItemsPerPage = perPage, TotalCount = query.Count(), Items = query.Skip(skip).Take(perPage).Select(x => new UserInfoDto { Id = x.Id, Username = x.Username, Name = x.Name, Surname = x.Surname, Email = x.Email, Phone = (int)x.Phone, Birthdate = x.Birthdate, CvPath = x.CvPath, AvatarPath = x.AvatarPath, AvatarAlt = x.AvatarAlt }) }); }
public IQueryable <UserInfo> LoadSearchPageEntities(UserInfoSearch us) { var temp = LoadEntities(c => true); if (!string.IsNullOrEmpty(us.Name)) { temp = temp.Where(w => w.Name.Contains(us.Name)); } if (!string.IsNullOrEmpty(us.Remark)) { temp = temp.Where(w => w.Remark.Contains(us.Name)); } us.TotalCount = temp.Count(); return(temp.OrderBy <UserInfo, string>(o => o.Name).Skip <UserInfo>((us.PageIndex - 1) * us.PageSize).Take <UserInfo>(us.PageSize).OrderBy(s => s.ID)); }
//public override void GetCurrentDAL() //{ // this.CurrentDAL = this.DbSession.UserInfoDAL; //} public IQueryable <UserInfo> LoadSearchPage(UserInfoSearch userInfoSearch) { IQueryable <UserInfo> list = CurrentDAL.LoadEntity(u => u.DelFlag == 0); if (!string.IsNullOrEmpty(userInfoSearch.UserName)) { list = list.Where(u => u.UName.Contains(userInfoSearch.UserName)); } if (!string.IsNullOrEmpty(userInfoSearch.Remark)) { list = list.Where(u => u.Remark.Contains(userInfoSearch.Remark)); } userInfoSearch.TotalCount = list.Count(); return(list.OrderBy <UserInfo, int>(u => u.ID).Skip <UserInfo>((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take <UserInfo>(userInfoSearch.PageSize)); }
public IQueryable <UserInfo> LoadSerachEntities(UserInfoSearch userInfoSearch, short delFlag) { var temp = CurrentDal.LoadEntities(u => u.DelFlag == delFlag); if (!string.IsNullOrEmpty(userInfoSearch.UName)) { temp = temp.Where(u => u.UName.Contains(userInfoSearch.UName)); } if (!string.IsNullOrEmpty(userInfoSearch.Remark)) { temp = temp.Where(u => u.Remark.Contains(userInfoSearch.Remark)); } userInfoSearch.TotalCount = temp.Count(); return(temp.OrderBy(u => u.ID).Skip((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take(userInfoSearch.PageSize)); }
/// <summary> /// 完成用户信息搜索 /// </summary> /// <param name="userInfoSearch"></param> /// <returns></returns> public IQueryable <UserInfo> LoadSearchEntities(UserInfoSearch userInfoSearch) { var temp = this.DbSession.UserInfoDal.LoadEntities(u => u.DelFlag == 0); if (!string.IsNullOrEmpty(userInfoSearch.UName)) { temp = temp.Where <UserInfo>(u => u.UName.Contains(userInfoSearch.UName)); } if (!string.IsNullOrEmpty(userInfoSearch.URemark)) { temp = temp.Where <UserInfo>(u => u.Remark.Contains(userInfoSearch.URemark)); } userInfoSearch.TotalCount = temp.Count(); return(temp.OrderBy <UserInfo, int>(u => u.ID).Skip <UserInfo>((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take <UserInfo>(userInfoSearch.PageSize)); }
/// <summary> /// 完成用户信息的搜索 /// </summary> /// <param name="userInfoSearch">封装的搜索条件数据</param> /// <returns></returns> public IQueryable <UserInfo> LoadSearchEntities(UserInfoSearch userInfoSearch, byte state) { var temp = CurrentDbSession.UserInfoDal.LoadEntities(o => o.StateFlag == state); //根据用户名来搜索 if (!string.IsNullOrEmpty(userInfoSearch.UserName)) { temp = temp.Where(o => o.UserName.Contains(userInfoSearch.UserName)); } else if (!string.IsNullOrEmpty(userInfoSearch.Remark)) { temp = temp.Where(o => o.Remark.Contains(userInfoSearch.Remark)); } return(temp.OrderBy(o => o.Id).Skip((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take(userInfoSearch.PageSize)); }
//获取用户信息 public ActionResult GetUserInfoList() { int pageIndex = int.Parse(Request["page"]); int pageSize = int.Parse(Request["rows"]); int totalCount = 0; string name = Request["name"]; string remark = Request["remark"]; UserInfoSearch userInfoSearch = new UserInfoSearch() { PageIndex = pageIndex, PageSize = pageSize, Name = name, Remark = remark, TotalCount = totalCount }; var userInfoList = userInfoService.LoadSearchPageEntities(userInfoSearch); var temp = from a in userInfoList select new { ID = a.ID, UName = a.Name, UPwd = a.Pwd, Remark = a.Remark, SubTime = a.SubTime }; return(Json(new { rows = temp, total = userInfoSearch.TotalCount }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 完成用户信息的搜索 /// </summary> /// <param name="userInfoSearch"></param> /// <param name="delFlag"></param> /// <returns></returns> public IQueryable <UserInfo> LoadSearchEntities(UserInfoSearch userInfoSearch, short delFlag) { var temp = this.CurrentDBSession.UserInfoDal.LoadEntities(c => c.DelFlag == delFlag); //根据用户名来搜索 if (!string.IsNullOrEmpty(userInfoSearch.UserName)) { temp = temp.Where <UserInfo>(u => u.UName.Contains(userInfoSearch.UserName)); } if (!string.IsNullOrEmpty(userInfoSearch.UserRemark)) { temp = temp.Where <UserInfo>(u => u.Remark.Contains(userInfoSearch.UserRemark)); } userInfoSearch.TotalCount = temp.Count(); return(temp.OrderBy <UserInfo, int>(u => u.ID).Skip <UserInfo>((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take <UserInfo>(userInfoSearch.PageSize)); }
public ActionResult GetUserInfoList(int page, int rows, string UName, string Remark) { //int totalCount = 0; UserInfoSearch userInfoSearch = new UserInfoSearch() { PageIndex = page, PageSize = rows, UName = UName, Remark = Remark, //TotalCount = totalCount }; var userInfoList = userInfoService.LoadSerachEntities(userInfoSearch, delFlag).Select(u => new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, SubTime = u.SubTime, Remark = u.Remark }); //var userInfoList = userInfoService.LoadPageEntities(page, rows, out totalCount, u => u.DelFlag == delFlag, u => u.ID).Select(u => new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, SubTime = u.SubTime, Remark = u.Remark }); string data = WebCommon.GetJsonList(userInfoSearch.TotalCount, userInfoList); return(Content(data)); }
/// <summary> /// 搜索数据 /// </summary> /// <param name="userInfoSearch">封装的搜索条件数据</param> /// <param name="delFlag">删除标记</param> /// <returns></returns> public IQueryable <UserInfo> LoadSearchEntities(UserInfoSearch userInfoSearch, DeleteEnumType delFlag) { //拿到所有标记为delFlag的数据(z-index:1) var temp = this.LoadEntities(u => u.DelFlag == (short)delFlag); //拿到所有名称为UserName的数据(z:2) if (!string.IsNullOrEmpty(userInfoSearch.UserName)) { temp = this.LoadEntities(u => u.UName == userInfoSearch.UserName); } //拿到所有备注为UserRemark的数据(z:3) if (!string.IsNullOrEmpty(userInfoSearch.UserRemark)) { temp = this.LoadEntities(u => u.Remark == userInfoSearch.UserRemark); } userInfoSearch.PageCount = temp.Count(); return(temp.OrderBy(u => u.ID).Skip((userInfoSearch.PageIndex - 1) * userInfoSearch.PageSize).Take(userInfoSearch.PageSize)); }
public IEnumerable <UserInfo> GetPagedList(UserInfoSearch userInfoSearch, out int totalCount) { Expression <Func <UserInfo, bool> > search = Predicates.Begin <UserInfo>(true); if (!string.IsNullOrEmpty(userInfoSearch.Name)) { search.And(m => m.Name.Contains(userInfoSearch.Name)); } if (userInfoSearch.CreateTimeStart != null) { search.And(m => m.CreateTime > userInfoSearch.CreateTimeStart); } if (userInfoSearch.CreateTimeEnd != null) { search.And(m => m.CreateTime < userInfoSearch.CreateTimeEnd); } return(_UserInfoRepository.GetPagedList(search, m => m.CreateTime, true, 1, 10, out totalCount).ToList()); }
/// <summary> /// 加载用户数据 /// </summary> /// <returns></returns> public ActionResult GetUserInfo() { int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; //当前页码。 int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5; //每页显示记录数。 UserInfoSearch userInfoSearch = new UserInfoSearch() { PageSize = pageSize, PageIndex = pageIndex, Remark = Request["remark"], UserName = Request["name"] }; IQueryable <UserInfo> list = UserInfoBLL.LoadSearchPage(userInfoSearch); var temp = from u in list select new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, Remark = u.Remark }; return(Json(new { rows = temp, total = userInfoSearch.TotalCount }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 加载用户管理页面 /// </summary> /// <returns></returns> public ActionResult GetUserInfoList() { int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5; string userName = Request["name"]; string userRemark = Request["remark"]; int totalCount = 0; var userInfoSearch = new UserInfoSearch() { UserName = userName, UserRemark = userRemark, PageIndex = pageIndex, PageSize = pageSize, TotalCount = totalCount }; var delFlag = (short)DeleteEnumType.Normal; //var userInfoList = bll.LoadPageEntities(pageIndex, pageSize, out totalCount, c => c.DelFlag == delFlag, c => c.Id,true).ToList(); var userInfoList = UserInfoService.LoadSearchEntities(userInfoSearch, delFlag).ToList(); var temp = userInfoList.Select(x => new { ID = x.Id, UName = x.Name, UPwd = x.Pwd, Remark = x.Remark, SunTime = x.SubTime }); return(Json(new { rows = temp.ToList(), total = userInfoSearch.TotalCount })); }
public ActionResult GetUserInfoList() { //获取页码 int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5; //接受搜索条件 string userName = Request["name"]; string userRemark = Request["remark"]; int totalCount = 0; //构建搜索条件 UserInfoSearch userInfoSearch = new UserInfoSearch() { UserName = userName, UserRemark = userRemark, PageIndex = pageIndex, PageSize = pageSize, TotalCount = totalCount }; short delFlag = (short)DeleteEnumType.Normal; var userinfoList = UserInfoService.LoadSearchEntities(userInfoSearch, delFlag); // var UserInfoList = UserInfoService.LoadPageEntities<int>(pageIndex, pageSize, out totalCount, c => c.DelFlag == delFlag, c => c.ID, true); var temp = from u in userinfoList select new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, Remark = u.Remark, SubTime = u.SubTime }; //JSon 固定要求 return(Json(new { rows = temp, total = userInfoSearch.TotalCount }, JsonRequestBehavior.AllowGet));//属性名师固定的 }
public JsonResult ListDlzh(FormCollection form) { UserInfoSearch search = new UserInfoSearch(); search.ORG_ID = base.CurrentUserOrgId; search.USER_NO = form["USER_NO1"].ToString(); search.USER_TYPE = form["USER_TYPES"].ToString();//当前用户的用户类型 STORE_ID search.STORE_ID = form["STORE_IDS"] == null ? 0 : int.Parse(form["STORE_IDS"].ToString()); search.CUUSER_ID = base.CurrentLoginUserId; PageView view = new PageView(form); search.ORG_ID = base.CurrentUserOrgId; string colkey = form["colkey"]; string colsinfo = form["colsinfo"]; //账户列表 PagedList <USER_INFO_EX> pList = _eservice.QueryUSER_INFO_EXList(search, view); JsonQTable fdata = JsonQTable.ConvertFromPagedList <USER_INFO_EX>(pList, colkey, colsinfo.Split(',')); return(Json(fdata)); }
/// <summary> /// 获取用户列表数据 /// </summary> /// <returns></returns> public ActionResult GetUserInfoList() { string value = Request["page"]; int pageIndex = value != null?int.Parse(value) : 1; value = Request["rows"]; int pageSize = value != null?int.Parse(value) : 5; string userName = Request["name"]; string remark = Request["remark"]; int totalCount = 0; //构建搜索条件. UserInfoSearch userInfoSearch = new UserInfoSearch() { UserName = userName, Remark = remark, PageIndex = pageIndex, PageSize = pageSize, TotalCount = totalCount }; byte delFlag = (byte)DeleteTypeEnum.Normarl; //根据构建好的搜索条件完成搜索 var userInfoList = UserInfoService.LoadSearchEntities(userInfoSearch, delFlag); ////获取分页数据。 //var userInfoList = UserInfoService.LoadPageEntities(pageIndex, pageSize, out totalCount, o => o.State == (int)DeleteEnumType.Normarl, o => o.Sort, true); var temp = from u in userInfoList select new { u.Id, u.UserName, u.UserPassword, u.Remark, u.CreateTime, }; return(Json(new { rows = temp, total = totalCount })); }
public IActionResult Get([FromServices] IGetAllUsers query, [FromQuery] UserInfoSearch search) { return(Ok(_executor.ExecuteQuery(query, search))); }
public IQueryable <UserInfo> LoadSearchPageEntities(UserInfoSearch us) { return(this.DbSession.UserInfoDal.LoadSearchPageEntities(us)); }