/// <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 roleName = Request["RoleName"]; string roleType = Request["RoleType"]; //定义对象,得到所有的参数 GetModelQuery roleInfo = new GetModelQuery(); roleInfo.pageIndex = pageIndex; roleInfo.pageSize = pageSize; roleInfo.total = 0; roleInfo.RoleName = roleName; roleInfo.RoleType = roleType; //获取所有的总数输入 var data = from n in _roleService.LoadRoleInfo(roleInfo) select new { n.ID, n.DelFlag, n.RoleName, n.RoleType, n.SubTime }; //var data = _roleService.List(pageSize, pageIndex, out total, c => true, true, d => d.id); var value = data.ToList(); var jsonResult = new { total = roleInfo.total, rows = value }; return(Json(jsonResult, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 得到用户的所有信息 /// </summary> /// <returns></returns> 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,SearchMail string searchName = Request["SearchName"]; string searchMail = Request["SearchMail"]; //封装一个业务逻辑层,来处理分页过滤的事件 GetModelQuery userInfoQuery = new GetModelQuery(); userInfoQuery.pageIndex = pageIndex; userInfoQuery.pageSize = pageSize; userInfoQuery.Name = searchName; userInfoQuery.Mail = searchMail; userInfoQuery.total = 0; //放置依赖刷新 var data = from u in _userInfoService.LoadSearchData(userInfoQuery) select new { u.ID, u.UName, u.Phone, u.Pwd, u.Mail, u.LastModifiedOn, u.SubTime }; //var data = _userInfoService.LoadPagerEntities(pageSize, pageIndex, out total, u => true, true, u => u.ID); var result = new { total = userInfoQuery.total, rows = data }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public IActionResult Model(Guid id) { var query = new GetModelQuery(id); var model = _queryProcessor.Process(query); return(View(model)); }
/// <summary>Enumerates execute in this collection.</summary> /// <param name="query">The query.</param> /// <returns>An enumerator that allows foreach to be used to process execute in this collection.</returns> public IQueryable <ModelPerformanceModel> Execute(GetModelQuery query) { return(this.PerformanceDbContext .ModelPerformanceEntitySet .Join(this.PerformanceDbContext.ModelPerformanceReturnEntitySet .Where( a => a.PerformanceImportID.Equals( this.PerformanceDbContext.ModelPerformanceReturnEntitySet .Where(j => j.ModelPerformanceID == a.ModelPerformanceID) .OrderByDescending(c => c.PerformanceImportID) .Select(x => x.PerformanceImportID).FirstOrDefault() ) ), a => a.ModelPerformanceID, b => b.ModelPerformanceID, (a, b) => new { a, b }) .Join(this.PerformanceDbContext.PerformanceImportEntitySet.Where(pi => pi.StatusTypeEv.Equals(2)), pr => pr.b.PerformanceImportID, i => i.PerformanceImportID, (pr, i) => new ModelPerformanceModel { ModelPerformanceID = pr.a.ModelPerformanceID, Code = pr.a.Code, Name = pr.a.Name, HistoricalInceptionDate = pr.a.HistoricalInceptionDate, AssetMarkInceptionDate = pr.a.AssetMarkInceptionDate, InitialCompositeDate = pr.a.InitialCompositeDate, ModifiedBy = pr.a.ModifiedBy, ModifiedDate = pr.a.ModifiedDate, CreatedBy = pr.a.CreatedBy, CreatedDate = pr.a.CreatedDate, } ).Distinct().AsQueryable()); }
/// <summary> /// 获取权限的所有的信息 /// </summary> /// <returns></returns> public ActionResult GetActionUserInfoShow() { //首先获取前台传递过来的参数 int pageIndex = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]); int pageSize = Request["rows"] == null ? 10 : Convert.ToInt32(Request["rows"]); //获取前台传递过来的数据实现进行模糊查询 string SearchActionName = Request["SearchActionName"]; string SearchRequestHttpType = Request["SearchRequestHttpType"]; //定义对象,得到所有的参数值 GetModelQuery actionInfo = new GetModelQuery(); actionInfo.ActionName = SearchActionName; actionInfo.pageIndex = pageIndex; actionInfo.pageSize = pageSize; actionInfo.RequestHttpType = SearchRequestHttpType; actionInfo.total = 0; //调用方法,实现绑定所有的数据 var data = from c in _actioninfoService.LoadDataActionInfo(actionInfo) select new { c.ID, c.ActionName, c.ActionType, c.RequestUrl, c.RequestHttpType, c.SubTime }; //var data = _actioninfoService.LoadPagerEntities(pageSize, pageIndex, out total, c => true, true, e => e.ID); //获取前台需要的数据 var jsonResult = new { total = actionInfo.total, rows = data }; return(Json(jsonResult, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult <GetModelDto> > GetMake([FromRoute] GetModelQuery query) { var model = await this.Mediator.Send(query); this.logger.LogInformation("Getting item {ID}", query.Id); if (model == null) { this.logger.LogWarning("Cannot find Make object with corresponding id: {0}", query.Id); return(NotFound(query)); } return(Ok(model)); }
/// <summary> /// 加载用户模糊查询的数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public IQueryable <AdminInfo> LoadSearchData(GetModelQuery query) { //拿到所有的数据 var temp = DbSession.AdminInfoRepository.Get(u => true); //进行过滤姓名 if (!string.IsNullOrEmpty(query.Name)) { temp = temp.Where <AdminInfo>(u => u.UName.Contains(query.Name)); } //进行邮箱的过滤 if (!string.IsNullOrEmpty(query.Mail)) { temp = temp.Where <AdminInfo>(u => u.Mail.Contains(query.Mail)); } //返回总数 query.total = temp.Count(); //做分页查询 return(temp.Skip(query.pageSize * (query.pageIndex - 1)).Take(query.pageSize).AsQueryable()); }
public IQueryable <ActionGroup> LoadEntityActionGroup(GetModelQuery actionGroup) { //首先读取到所有的数据 var temp = DbSession.ActionGroupRepository.Get(c => true); //根据菜单组名称进行过滤 if (!string.IsNullOrEmpty(actionGroup.GroupName)) { temp = temp.Where <ActionGroup>(c => c.GroupName.Contains(actionGroup.GroupName)); } //根据菜单组类型进行过滤 if (actionGroup.GroupType != "-1" && !string.IsNullOrEmpty(actionGroup.GroupType)) { temp = temp.Where <ActionGroup>(c => c.GroupType.Equals(Convert.ToInt16(actionGroup.GroupType))); } //得到菜单组的总数 actionGroup.total = temp.Count(); //进行分页查询信息 return(temp.Skip <ActionGroup>(actionGroup.pageSize * (actionGroup.pageIndex - 1)).Take(actionGroup.pageSize)); }
/// <summary> /// 读取用户所有的权限组的信息显示在前台 /// </summary> /// <returns></returns> public ActionResult GetAllActionGroupInfo() { int pageIndex = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]); int pageSize = Request["rows"] == null ? 10 : Convert.ToInt32(Request["rows"]); string GroupName = Request["SearchActionName"]; string GroupType = Request["SearchActionType"]; GetModelQuery actionGroupInfo = new GetModelQuery(); actionGroupInfo.pageIndex = pageIndex; actionGroupInfo.pageSize = pageSize; actionGroupInfo.total = 0; actionGroupInfo.GroupName = GroupName; actionGroupInfo.GroupType = GroupType; // var data = _actiongroupService.LoadPagerEntities(pageSize, pageIndex, out total, c => true, true, c => c.ID); var data = from x in _actiongroupService.LoadEntityActionGroup(actionGroupInfo) select new { x.ID, x.DelFlag, x.GroupName, x.GroupType }; var postJson = new { total = actionGroupInfo.total, rows = data }; return(Json(postJson, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 实现对数据的模糊查询 /// </summary> /// <param name="actionInfo"></param> /// <returns></returns> public IQueryable <ActionInfo> LoadDataActionInfo(GetModelQuery actionInfo) { //首先拿到所有的数据 var temp = _dbSession.ActionInfoRepository.LoadEntities(u => true); //然后进行权限名称过滤 if (!string.IsNullOrEmpty(actionInfo.ActionName)) { temp = temp.Where <ActionInfo>(c => c.ActionName.Contains(actionInfo.ActionName)); } //然后进行请求方式的过滤 if (!string.IsNullOrEmpty(actionInfo.RequestHttpType)) { temp = temp.Where <ActionInfo>(c => c.RequestHttpType.Contains(actionInfo.RequestHttpType)); } //返回总数 actionInfo.total = temp.Count(); //最后实现分页 return(temp.Skip <ActionInfo>(actionInfo.pageSize * (actionInfo.pageIndex - 1)).Take <ActionInfo>(actionInfo.pageSize).AsQueryable()); }
/// <summary> /// 实现对查询的数据进行分组 /// </summary> /// <param name="roleInfo"></param> /// <returns></returns> public IQueryable <Role> LoadRoleInfo(GetModelQuery roleInfo) { //首先查询出所有的数据 var temp = _dbSession.RoleRepository.LoadEntities(c => true); //判断角色名称 if (!string.IsNullOrEmpty(roleInfo.RoleName)) { temp = temp.Where <Role>(c => c.RoleName.Contains(roleInfo.RoleName)); } //判断角色名称是否赋值 if (roleInfo.RoleType != "-1" && !string.IsNullOrEmpty(roleInfo.RoleType)) { temp = temp.Where <Role>(c => c.RoleType.Equals(Convert.ToInt16(roleInfo.RoleType))); } //获取总数total roleInfo.total = temp.Count(); //获取总数返回 return(temp.Skip <Role>(roleInfo.pageSize * (roleInfo.pageIndex - 1)).Take(roleInfo.pageSize)); }
public Model Handle(GetModelQuery query) { return(_modelRepository.GetById(query.ModelId)); }