//得到用户的所有信息 public ActionResult GetAllUserInfos() { //json数据:{total:"",row:""} //分页的数据 int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]); int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]); ////SearchName string txtSearchUserName = Request["txtSerachUserName"]; //处理分页过滤事件 ModelDataQuery pm = new ModelDataQuery(); pm.pageIndex = pageIndex; pm.pageSize = pageSize; pm.UserName = txtSearchUserName; pm.total = 0; //放置依赖刷新 var data = from u in _iUserInfoService.LoadSearchData(pm) select new { u.UserID, u.UserName, u.Password, u.CreateOperatorID, u.CreateOperatorName, u.CreateTime, u.ModiOperatorID, u.ModiOperatorName, u.ModiTime, u.Notes }; var result = new { total = pm.total, rows = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
//得到所有的用户权限信息 public ActionResult GetActionUserInfoShow() { //json数据:{total:"",row:""} // //分页的数据 // int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]); int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]); ////SearchName string txtResourceName = Request["txtResourceName"]; //处理分页过滤事件 ModelDataQuery pm = new ModelDataQuery(); pm.pageIndex = pageIndex; pm.pageSize = pageSize; pm.ResourceName = txtResourceName; pm.total = 0; ////放置依赖刷新 var data = from u in t_resourceservice.LoadDataActionInfo(pm) select new { u.ResourceID, u.ResourceName, u.ResDescription, u.CreateOperatorID, u.CreateOperatorName, u.CreateTime, u.ModiOperatorID, u.ModiOperatorName, u.ModiTime, u.Notes }; ////var data = _userInfoService.LoadPagerEntities(pageSize, pageIndex, out total, u => true, true, u => u.ID); var result = new { total = pm.total, rows = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 实现对用户角色的绑定 /// </summary> /// <returns></returns> public ActionResult GetAllUserRoleInfo() { //首先获取从前台传递过来的参数 int pageIndex = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]); int pageSize = Request["rows"] == null ? 10 : Convert.ToInt32(Request["rows"]); //获取从前台传递过来的需要多条件模糊查询的数据 string txtSerachRoleName = Request["txtSerachRoleName"]; //定义对象,得到所有的参数 ModelDataQuery roleInfo = new ModelDataQuery(); roleInfo.pageIndex = pageIndex; roleInfo.pageSize = pageSize; roleInfo.RoleName = txtSerachRoleName; roleInfo.total = 0; //获取所有的总数输入 var data = from n in _roleService.LoadRoleInfo(roleInfo) select new { n.RoleID, n.RoleName, n.RoleDescription, n.Notes }; //var data = _roleService.LoadPagerEntities(pageSize, pageIndex, out total, c => true, true, d => d.ID); var jsonResult = new { total = roleInfo.total, rows = data }; return(Json(jsonResult, JsonRequestBehavior.AllowGet)); }
public IQueryable <T_Resource> LoadDataActionInfo(ModelDataQuery resourceInfo) { //首先拿到所有的数据 var temp = resource.LoadEntities(u => true); //然后进行权限名称过滤 if (!string.IsNullOrEmpty(resourceInfo.ResourceName)) { temp = temp.Where <T_Resource>(c => c.ResourceName.Contains(resourceInfo.ResourceName)); } //返回总数 resourceInfo.total = temp.Count(); //最后实现分页 return(temp.Skip <T_Resource>(resourceInfo.pageSize * (resourceInfo.pageIndex - 1)).Take <T_Resource>(resourceInfo.pageSize).AsQueryable()); }
public IQueryable <T_User> LoadSearchData(ModelDataQuery query) { //拿到所有的数据 var temp = user.LoadEntities(u => true); //进行的过滤 if (!string.IsNullOrEmpty(query.UserName)) { temp = temp.Where <T_User>(u => u.UserName.Contains(query.UserName)); } //返回总数 query.total = temp.Count(); //做分页查询 return(temp.Skip <T_User>(query.pageSize * (query.pageIndex - 1)).Take <T_User>(query.pageSize).AsQueryable()); //return temp.Skip(query.pageSize * (query.pageIndex - 1)).Take(query.pageSize).AsQueryable(); }
public IQueryable <T_Role> LoadRoleInfo(ModelDataQuery roleInfo) { //首先查询出所有的数据 var temp = role.LoadEntities(c => true); //判断角色名称 if (!string.IsNullOrEmpty(roleInfo.RoleName)) { temp = temp.Where <T_Role>(c => c.RoleName.Contains(roleInfo.RoleName)); } //获取总数total roleInfo.total = temp.Count(); //获取总数返回 return(temp.Skip <T_Role>(roleInfo.pageSize * (roleInfo.pageIndex - 1)).Take <T_Role>(roleInfo.pageSize).AsQueryable()); //return temp.Skip<T_Role>(roleInfo.pageSize * (roleInfo.pageIndex - 1)).Take(roleInfo.pageSize); }