username@email.com
2022-07-28 976aa1a04fff81af4939affa80d3357013157353
zhengcaioa/Services/CooperOrderService.cs
@@ -1225,6 +1225,7 @@
                    updateproject.Law = entity.Law;
                    updateproject.Sort = entity.Sort;
                    updateproject.Lawcoment = entity.Lawcoment;
                    updateproject.Questionname = entity.Questionname;
                }
@@ -1507,7 +1508,7 @@
                    updateproject.Law = entity.Law;
                    updateproject.Sort = entity.Sort;
                    updateproject.Lawcoment = entity.Lawcoment;
                    updateproject.Questionname = entity.Questionname;
                }
@@ -2035,5 +2036,115 @@
            return entity;
        }
        public List<TChallengeRequestInfoDTO> GetListChallengeRequestInfo(string ChallengeId)
        {
            var entity = _context.TChallengeRequestInfos.Where(x => x.ChallengeId == ChallengeId).OrderBy(x => x.Id).ToList();
            var result = _mapper.Map<List<TChallengeRequestInfoDTO>>(entity);
            var request_info = (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
                            }
                   ).Where(x => x.CodeTable == "t_challengeletter" && x.CodeField == "request_info").ToList();
            foreach (var challengeItemDTO in result)
            {
                var codeDataEntity = request_info.Where(x => x.CodeSn == challengeItemDTO.RequestInfo).FirstOrDefault();
                if (codeDataEntity != null)
                {
                    challengeItemDTO.RequestInfoNameName = codeDataEntity.Comments;
                }
            }
            return result;
        }
        public ResultEntity saveChallengeRequestInfo(TChallengeRequestInfoDTO dto)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                var entity = _mapper.Map<TChallengeRequestInfo>(dto);
                if (entity.Id <= 0)
                {
                    _context.TChallengeRequestInfos.Add(entity);
                }
                else
                {
                    var updateproject = _context.TChallengeRequestInfos.Find(entity.Id);
                    updateproject.ChallengeId = entity.ChallengeId;
                    updateproject.RequestInfo = entity.RequestInfo;
                    updateproject.RequestInfoname = entity.RequestInfoname;
                }
                _context.SaveChanges();
                resultEntity.ReturnID = entity.Id.ToString();
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败,请联系管理员";
            }
            return resultEntity;
        }
        /// <summary>
        /// 删除质疑函子表
        /// </summary>
        /// <returns></returns>
        public ResultEntity deleteChallengeRequestInfo(string ChallengeId)
        {
            ResultEntity result = new ResultEntity();
            result.Result = true;
            var models = _context.TChallengeRequestInfos.Where(x => x.ChallengeId == ChallengeId).ToList(); ;
            foreach (var challengeItem in models)
            {
                _context.TChallengeRequestInfos.Remove(challengeItem);
            }
            _context.SaveChanges();
            return result;
        }
    }
}