Example #1
0
        public IActionResult List(RoleRequestPayload payload)
        {
            var response = ResponseModelFactory.CreateResultInstance;

            using (_dbContext)
            {
                var query = _dbContext.SystemRole.AsQueryable();
                if (!string.IsNullOrEmpty(payload.Kw))
                {
                    query = query.Where(x => x.RoleName.Contains(payload.Kw.Trim()));
                }
                if (payload.IsDeleted > CommonEnum.IsDeleted.All)
                {
                    query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted);
                }

                var list       = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
                var totalCount = query.Count();
                var data       = list.Select(_mapper.Map <SystemRole, RoleJsonModel>);

                response.SetData(list, totalCount);
                ToLog.AddLog("查询", "成功:查询:系统角色管理列表数据", _dbContext);
                return(Ok(response));
            }
        }
        List(RoleRequestPayload payload)
        {
            var response = ResponseModelFactory.CreateResultInstance;

            await using (_dbContext)
            {
                var query = _dbContext.DncRole.AsQueryable();
                if (!string.IsNullOrEmpty(payload.Kw))
                {
                    query = query.Where(x => x.Name.Contains(payload.Kw.Trim()) || x.Code.Contains(payload.Kw.Trim()));
                }
                if (payload.IsDeleted > CommonEnum.IsDeleted.All)
                {
                    query = query.Where(x => x.IsDeleted == payload.IsDeleted);
                }
                if (payload.Status > CommonEnum.Status.All)
                {
                    query = query.Where(x => x.Status == payload.Status);
                }
                var list = await query.Paged(payload.CurrentPage, payload.PageSize).ToListAsync();

                var totalCount = await query.CountAsync();

                var data = list.Select(_mapper.Map <DncRole, RoleJsonModel>);

                response.SetData(data, totalCount);
                return(Ok(response));
            }
        }
        public IActionResult List(RoleRequestPayload payload)
        {
            var response = ResponseModelFactory.CreateResultInstance;

            using (_dbContext)
            {
                var query = from a in _dbContext.PersonalDiary
                            where a.IsDeleted == 0
                            select new
                {
                    PersonalDiaryUuid = a.PersonalDiaryUuid,
                    Id            = a.Id,
                    Headline      = a.Headline,
                    Content       = a.Content,
                    WriteTime     = a.WriteTime,
                    Accessory     = a.Accessory,
                    EstablishName = a.EstablishName,
                    EstablishTime = a.EstablishTime,
                    IsDeleted     = a.IsDeleted,
                };
                if (!string.IsNullOrEmpty(payload.Kw))
                {
                    query = query.Where(x => x.Headline.Contains(payload.Kw.Trim()) || x.EstablishName.Contains(payload.Kw.Trim()));
                }

                //时间段查询
                if (!string.IsNullOrEmpty(payload.kwstartime))
                {
                    query = query.Where(x => x.WriteTime.Contains(payload.kwstartime));
                }

                //if (!string.IsNullOrEmpty(payload.kwendtime))
                //{
                //    query = query.Where(x => Convert.ToDateTime(x.EstablishTime) <= Convert.ToDateTime(payload.kwendtime));
                //}

                if (payload.FirstSort != null)
                {
                    query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
                }
                if (AuthContextService.CurrentUser.DisplayName != "超级管理员")
                {
                    query = query.Where(x => x.EstablishName == AuthContextService.CurrentUser.DisplayName);
                }
                var list       = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
                var totalCount = query.Count();
                response.SetData(list, totalCount);
                return(Ok(response));
            }
        }
Example #4
0
        public IActionResult List(RoleRequestPayload payload)
        {
            var response = ResponseModelFactory.CreateResultInstance;

            using (_dbContext)
            {
                var query = from a in _dbContext.DepartmentDeclare
                            where a.IsDeleted == 0
                            select new
                {
                    DepartmentDeclareUuid = a.DepartmentDeclareUuid,
                    Id                = a.Id,
                    DeclareName       = a.DeclareName,                                                                                                  //姓名
                    DeclareDepartment = _dbContext.Department.FirstOrDefault(x => x.DepartmentUuid == Guid.Parse(a.DeclareDepartment)).Name.ToString(), //部门
                    DeclareTime       = a.DeclareTime,                                                                                                  //时间
                    BonusPoint        = a.BonusPoint,                                                                                                   //加分项
                    PlusScore         = a.PlusScore,                                                                                                    //加分值
                    PlusContent       = a.PlusContent,                                                                                                  //加分内容
                    Deduction         = a.Deduction,                                                                                                    //减分项
                    DeductionScore    = a.DeductionScore,                                                                                               //减分值
                    DeductionContent  = a.DeductionContent,                                                                                             //加分内容
                    Remark            = a.Remark,                                                                                                       //备注
                    EstablishName     = a.EstablishName,                                                                                                //添加人
                    AuditOpinion      = a.AuditOpinion,                                                                                                 //审核意见
                    AuditStatus       = a.AuditStatus,                                                                                                  //审核状态
                    IsDeleted         = a.IsDeleted,                                                                                                    //是否删除
                };
                //姓名查询
                if (!string.IsNullOrEmpty(payload.Kw))
                {
                    query = query.Where(x => x.DeclareName.Contains(payload.Kw.Trim()));
                }
                //时间查询
                if (!string.IsNullOrEmpty(payload.kwendtime))
                {
                    query = query.Where(x => x.DeclareTime.Contains(payload.kwendtime.Trim()));
                }
                //排序
                if (payload.FirstSort != null)
                {
                    query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
                }
                var list       = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
                var totalCount = query.Count();
                response.SetData(list, totalCount);
                ToLog.AddLog("查询", "成功:查询:绩效申报信息数据", _dbContext);
                return(Ok(response));
            }
        }
Example #5
0
        public IActionResult List(RoleRequestPayload payload)
        {
            var response = ResponseModelFactory.CreateResultInstance;

            using (_dbContext)
            {
                var query = _dbContext.SystemRole.Select(x => new
                {
                    x.SystemRoleUuid,
                    x.RoleName,
                    x.AddTime,
                    x.AddPeople,
                    x.IsDeleted,
                    x.Id,
                    x.IsFixation,
                    x.SchoolUuid,
                    x.IsCreEdu,
                    _disabled = IsDisabled(x.IsCreEdu.Value, x.IsFixation.Value),
                });
                if (AuthContextService.CurrentUser.SchoolGuid != null)
                {
                    query = query.Where(x => x.SchoolUuid == AuthContextService.CurrentUser.SchoolGuid);
                }
                if (!string.IsNullOrEmpty(payload.Kw))
                {
                    query = query.Where(x => x.RoleName.Contains(payload.Kw.Trim()));
                }
                if (payload.IsDeleted > CommonEnum.IsDeleted.All)
                {
                    query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted);
                }

                var list       = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
                var totalCount = query.Count();
                //var data = list.Select(_mapper.Map<SystemRole, RoleJsonModel>);

                response.SetData(list, totalCount);
                return(Ok(response));
            }
        }