| | |
| | | } |
| | | |
| | | |
| | | public List<TChallengeletterDTO> GetListChallengeletterChosen() |
| | | { |
| | | var query = (from a in _context.TChallengeletters |
| | | join b in _context.CooperOrders.Where(x => x.RecStatus == "A") |
| | | on a.OrderId equals b.Id |
| | | |
| | | select new TChallengeletterDTO |
| | | { |
| | | Id = b.Id, |
| | | OrderId = b.OrderNo |
| | | } |
| | | ).ToList(); |
| | | |
| | | |
| | | |
| | | |
| | | return query; |
| | | } |
| | | |
| | | |
| | | public ResultEntity saveChallengeletter(TChallengeletterDTO dto) |
| | | { |
| | | ResultEntity resultEntity = new ResultEntity(); |
| | |
| | | WeishouMoney = (a.Money ?? 0) /*- (a.Youhui ?? 0)*/ - (lll.YishouMoney ?? 0), |
| | | OrderType1 = a.OrderType1, |
| | | Status = b.Status.ToString(), |
| | | Modifytime = b.Modifytime.Value, |
| | | //StatusName = ddd.Comments |
| | | } |
| | | ).ToList(); |
| | |
| | | WeishouMoney = (a.Money ?? 0) /*- (a.Youhui ?? 0)*/ - (lll.YishouMoney ?? 0), |
| | | OrderType1 = a.OrderType1, |
| | | Status = b.Status.ToString(), |
| | | Modifytime = b.Modifytime.Value, |
| | | } |
| | | ).ToList(); |
| | | |
| | | query2.AddRange(query1); |
| | | var query = query2.Where(x => x.WeishouMoney <= 0).OrderByDescending(x => x.Createtime).ToList(); |
| | | var query = query2.Where(x => x.WeishouMoney <= 0).OrderByDescending(x => x.Modifytime).ToList(); |
| | | |
| | | |
| | | |