专家管理 前台申请专家 ，后台审批专家 ，评审品目为下拉多选框 项目录入 专家替换字符：'（组长）','(组长)',',','（评审组长）...

username@email.com

2021-06-07 2b2ef5f1a07b3632546aef59046e7a048b3b3d8e

 zhengcaioa/Services/ExpertService.cs

@@ -72,6 +72,7 @@
                    updateplExpert.TitileCerti8 = expert.TitileCerti8;
                    updateplExpert.TitileCerti9 = expert.TitileCerti9;
                    updateplExpert.TitileCerti10 = expert.TitileCerti10;
                    updateplExpert.ShenheStatus = expert.ShenheStatus;
                }

                _context.SaveChanges();
@@ -100,6 +101,26 @@

        public ResultDataEntity<ExpertDTO> SearchByPaging(ExpertDTOSearch searchEntity) 
        {


            var listCode = (from a in _context.SysCodeDtls
                            join b in _context.SysCodes
                            on a.CodeId equals b.Id
                            where a.RecStatus == "A"
                                          && b.RecStatus == "A"
                            select new CodeDataEntity()
                            {
                                CodeId = b.Id,
                                CodeTable = b.CodeTable,
                                CodeField = b.CodeField,
                                CodeSn = a.CodeSn,
                                Comments = a.Comments,
                                Contents = a.Contents,
                                RecStatus = a.RecStatus,
                                Sort = a.Sort
                            }
                      );

            ResultDataEntity<ExpertDTO> data = new ResultDataEntity<ExpertDTO>();
            List<ExpertDTO> list = new List<ExpertDTO>();
            //筛选
@@ -108,18 +129,72 @@
                         {
                             ExpertId = q.Key.ExpertId,
                             JoinCount = q.Count(),
                         }
                          )
                         })
                           

                       on a.Id equals h.ExpertId
                      into hsss
                         from hhh in hsss.DefaultIfEmpty()


                         join c in listCode.Where(x => x.CodeTable == "experts" && x.CodeField == "level")
                        on a.Level equals c.CodeSn
                        into csss
                         from ccc in csss.DefaultIfEmpty()


                         where a.RecStatus == "A"
                          && (searchEntity.JoinCount<=0 || hhh.JoinCount >= searchEntity.JoinCount)
                         select a).ToList(); 
                         select new ExpertDTO
                         {
                             Id = a.Id,
                             Name = a.Name,
                             Sex = a.Sex,
                             InfoSource = a.InfoSource,
                             IdCard = a.IdCard,
                             Province = a.Province,
                             AreaId = a.AreaId,
                             City = a.City,

                             Address = a.Address,
                             Postal = a.Postal,
                             ExpertType = a.ExpertType,

                             Level = a.Level,
                             LevelName = ccc.Comments,
                             Phone1 = a.Phone1,
                             Phone2 = a.Phone2,
                             Qq = a.Qq,

                             Remark = a.Remark,

                             Creater = a.Creater,
                             Createtime = a.Createtime,

                             RecStatus = a.RecStatus,
                             Modifier = a.Modifier,
                             Modifytime = a.Modifytime,

                             Wechat = a.Wechat,
                             ReviewItem = a.ReviewItem,
                             CertiNumber = a.CertiNumber,
                             CertiFont = a.CertiFont,
                             CertiBack = a.CertiBack,
                             TitileCerti = a.TitileCerti,
                             
                             Sort = a.Sort,
                             ShenheStatus = a.ShenheStatus,
                             
                             
                         }).ToList(); 

            if (!string.IsNullOrEmpty(searchEntity.Name))
            {
                query = query.Where(m => m.Name.Contains(searchEntity.Name)).ToList();
            }
            if (!string.IsNullOrEmpty(searchEntity.ShenheStatus))
            {
                query = query.Where(m => m.ShenheStatus == searchEntity.ShenheStatus).ToList();
            }
            if (!string.IsNullOrEmpty(searchEntity.ExpertType))
            {
@@ -167,9 +242,9 @@
            if (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
            var expertlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            list = _mapper.Map<List<ExpertDTO>>(expertlist);
            //list = _mapper.Map<List<ExpertDTO>>(expertlist);

            data.LoadData(searchEntity, list);
            data.LoadData(searchEntity, expertlist);
            return data;
        
        }