From c54d598cc71ca26f262d498e034b64627d7b6616 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 07 七月 2022 15:25:19 +0800
Subject: [PATCH] 提交
---
zhengcaioa/Services/CooperOrderService.cs | 69 +++++++++++++++++++++++++++++++++-
1 files changed, 67 insertions(+), 2 deletions(-)
diff --git a/zhengcaioa/Services/CooperOrderService.cs b/zhengcaioa/Services/CooperOrderService.cs
index 83b46c6..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;
}
@@ -964,6 +967,53 @@
}
+ 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;
+ }
+
+ }
+
+
+ return result;
+ }
+
+
public List<TChallengeletterDTO> GetListChallengeletterChosen()
{
var query = (from a in _context.TChallengeletters
@@ -973,9 +1023,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();
@@ -1970,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