| | |
| | | updateproject.Law = entity.Law; |
| | | updateproject.Sort = entity.Sort; |
| | | updateproject.Lawcoment = entity.Lawcoment; |
| | | updateproject.Questionname = entity.Questionname; |
| | | |
| | | } |
| | | |
| | |
| | | updateproject.Law = entity.Law; |
| | | updateproject.Sort = entity.Sort; |
| | | updateproject.Lawcoment = entity.Lawcoment; |
| | | |
| | | updateproject.Questionname = entity.Questionname; |
| | | |
| | | } |
| | | |
| | |
| | | |
| | | 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; |
| | | } |
| | | |
| | | } |
| | | } |