| | |
| | | updateproject.SonghuoTime1 = entity.SonghuoTime1; |
| | | updateproject.HuifangJdr = entity.HuifangJdr; |
| | | updateproject.HuifangKehuyijian = entity.HuifangKehuyijian; |
| | | updateproject.Xmname = entity.Xmname; |
| | | updateproject.Xmcode = entity.Xmcode; |
| | | updateproject.Jichumoney = entity.Jichumoney; |
| | | |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | |
| | | public List<TChallengeletterDTO> GetListChallengelettertousu(string customid, string XmCode) |
| | | { |
| | | |
| | | var entity = (from a in _context.CooperOrders.Where(x=>x.OrderType1== "代拟质疑函" && x.RecStatus == "A" && x.Khdw == customid) |
| | | join b in _context.TChallengeletters.Where(x=>x.XmCode == XmCode) on a.Id equals b.OrderId |
| | | select b ).ToList(); |
| | | |
| | | |
| | | //_context.TChallengeletters.Where(x =>/* x.Status == 1 && */x.OrderId == OrderId).ToList(); |
| | | |
| | | |
| | | |
| | | var result = _mapper.Map<List<TChallengeletterDTO>>(entity); |
| | | |
| | | |
| | | 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 |
| | | } |
| | | ).Where(x => x.CodeTable == "t_challengeletter" && x.CodeField == "request_info").ToList(); |
| | | foreach (var challengeletterDTO in result) |
| | | { |
| | | var codeDataEntity = listCode.Where(x => x.CodeSn == challengeletterDTO.RequestInfo).FirstOrDefault(); |
| | | if (codeDataEntity != null) |
| | | { |
| | | challengeletterDTO.RequestInfoName = codeDataEntity.Comments; |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | return result; |
| | | } |
| | | |
| | | |
| | | public List<TChallengeletterDTO> GetListChallengeletterChosen() |
| | | { |
| | | var query = (from a in _context.TChallengeletters |
| | |
| | | select new TChallengeletterDTO |
| | | { |
| | | Id = b.Id, |
| | | OrderId = b.OrderNo |
| | | OrderId = b.OrderNo, |
| | | khid = b.Khdw, |
| | | Createtime = b.Createtime, |
| | | } |
| | | ).ToList(); |
| | | ).OrderByDescending(x=>x.Createtime).ToList(); |
| | | |
| | | |
| | | |
| | |
| | | |
| | | return query; |
| | | } |
| | | |
| | | |
| | | public FrameworkUser GetFrameworkUsers(string ID) |
| | | { |
| | | |
| | | |
| | | |
| | | var entity = _zcUserInfoN_dbContext.FrameworkUsers.Find(new Guid(ID)); |
| | | |
| | | |
| | | |
| | | return entity; |
| | | } |
| | | } |
| | | } |