From 1aa53fde5eb18a39c53daf910d69cb857913b08d Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 06 七月 2022 15:23:02 +0800
Subject: [PATCH] 提交

---
 zhengcaioa/Services/CooperOrderService.cs |   63 +++++++++++++++++++++++++++++++
 1 files changed, 63 insertions(+), 0 deletions(-)

diff --git a/zhengcaioa/Services/CooperOrderService.cs b/zhengcaioa/Services/CooperOrderService.cs
index 834cf60..0de12ce 100644
--- a/zhengcaioa/Services/CooperOrderService.cs
+++ b/zhengcaioa/Services/CooperOrderService.cs
@@ -90,6 +90,9 @@
                     updateproject.SonghuoTime1 = entity.SonghuoTime1;
                     updateproject.HuifangJdr = entity.HuifangJdr;
                     updateproject.HuifangKehuyijian = entity.HuifangKehuyijian;
+                    updateproject.Xmname = entity.Xmname;
+                    updateproject.Xmcode = entity.Xmcode;
+                    updateproject.Jichumoney = entity.Jichumoney;
 
                 }
 
@@ -957,6 +960,53 @@
                     challengeletterDTO.RequestInfoName = codeDataEntity.Comments;
                 }
                
+            }
+
+
+            return result;
+        }
+
+
+        public List<TChallengeletterDTO> GetListChallengelettertousu(string customid, string XmCode)
+        {
+
+            var entity = (from a in _context.CooperOrders.Where(x=>x.OrderType1== "浠f嫙璐ㄧ枒鍑�" && 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;
+                }
+
             }
 
 
@@ -1972,5 +2022,18 @@
 
             return query;
         }
+
+
+        public FrameworkUser GetFrameworkUsers(string ID)
+        {
+             
+
+
+            var entity = _zcUserInfoN_dbContext.FrameworkUsers.Find(new Guid(ID));
+
+           
+
+            return entity;
+        }
     }
 }

--
Gitblit v1.9.1