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 | 42 +++++++++++++++++++++++++++++++++++++++--- 1 files changed, 39 insertions(+), 3 deletions(-) diff --git a/zhengcaioa/Services/CooperOrderService.cs b/zhengcaioa/Services/CooperOrderService.cs index d8facb5..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; } @@ -971,9 +973,11 @@ select new TChallengeletterDTO { Id = b.Id, - OrderId = b.OrderNo + OrderId = b.OrderNo, + khid = b.Khdw, + Createtime = b.Createtime, } - ).ToList(); + ).OrderByDescending(x=>x.Createtime).ToList(); @@ -1936,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