From 0c7b13e91cd472e21e4a620355e6fcabc11f695a Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 04 一月 2022 13:56:24 +0800 Subject: [PATCH] 计件登记,汇总,打印 --- zhengcaioa/Services/CooperOrderService.cs | 62 ++++++++++++++++++++++++++++++- 1 files changed, 60 insertions(+), 2 deletions(-) diff --git a/zhengcaioa/Services/CooperOrderService.cs b/zhengcaioa/Services/CooperOrderService.cs index d04c90f..834cf60 100644 --- a/zhengcaioa/Services/CooperOrderService.cs +++ b/zhengcaioa/Services/CooperOrderService.cs @@ -14,11 +14,13 @@ public class CooperOrderService: ICooperOrderService { private readonly zhengcaioaContext _context; + private readonly zcUserInfoN_dbContext _zcUserInfoN_dbContext; private readonly IMapper _mapper; - public CooperOrderService(zhengcaioaContext context, IMapper mapper) + public CooperOrderService(zhengcaioaContext context, IMapper mapper, zcUserInfoN_dbContext zcUserInfoN_dbContext) { _context = context; _mapper = mapper; + _zcUserInfoN_dbContext = zcUserInfoN_dbContext; } @@ -962,6 +964,28 @@ } + 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, + khid = b.Khdw, + Createtime = b.Createtime, + } + ).OrderByDescending(x=>x.Createtime).ToList(); + + + + + return query; + } + + public ResultEntity saveChallengeletter(TChallengeletterDTO dto) { ResultEntity resultEntity = new ResultEntity(); @@ -1826,6 +1850,7 @@ 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(); @@ -1880,11 +1905,12 @@ 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(); @@ -1914,5 +1940,37 @@ data.LoadData(searchEntity, lianlist); return data; } + + + + + public List<CooperOrderDTO> GetListComplaintsDisputeCount(string huiyuanid) + { + var query = (from a in _zcUserInfoN_dbContext.UsergGadeRoles + join b in _zcUserInfoN_dbContext.GadeRoles + on a.UserGadeRolesId equals b.Id + where a.UserId == Guid.Parse(huiyuanid) + select new CooperOrderDTO + { + Id = a.UserId.ToString(), + AnswerRoles = b.AnswerRoles, + XiaocaiKeTang = b.XiaocaiKeTang, + XiaoCaiQandA = b.XiaoCaiQandA, + Discount = b.Discount, + BiddingDocumentsCount = b.BiddingDocumentsCount, + ComplaintsDisputeCount = b.ComplaintsDisputeCount, + PerformanceDisputeCount = b.PerformanceDisputeCount, + BiddingDocumentsCountused = a.BiddingDocumentsCount, + ComplaintsDisputeCountused = a.ComplaintsDisputeCount, + PerformanceDisputeCountused = a.PerformanceDisputeCount, + + } + ).ToList(); + + + + + return query; + } } } -- Gitblit v1.9.1