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