From 5a50381b4d3b30a8de467d01d657a3a842ee0298 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期一, 06 十二月 2021 16:28:42 +0800 Subject: [PATCH] 提交 --- zhengcaioa/Services/CooperOrderService.cs | 21 ++++++++++++++++++++- 1 files changed, 20 insertions(+), 1 deletions(-) diff --git a/zhengcaioa/Services/CooperOrderService.cs b/zhengcaioa/Services/CooperOrderService.cs index fa1b109..fca347f 100644 --- a/zhengcaioa/Services/CooperOrderService.cs +++ b/zhengcaioa/Services/CooperOrderService.cs @@ -978,7 +978,7 @@ updateproject.RequestInfo = entity.RequestInfo; updateproject.IsReply = entity.IsReply; - + updateproject.Status = entity.Status; updateproject.Respondent = entity.Respondent; updateproject.RespondDate = entity.RespondDate; @@ -1568,6 +1568,13 @@ into lsss from lll in lsss.DefaultIfEmpty() + + // join d in listCode.Where(x => x.CodeTable == "t_challengeletter" && x.CodeField == "status") + //on b.Status equals int.Parse(d.CodeSn) + //into dsss + // from ddd in dsss.DefaultIfEmpty() + + where a.RecStatus == "A" && a.OrderType1 == "浠f嫙璐ㄧ枒鍑�" && (string.IsNullOrWhiteSpace(searchEntity.XdTime) || (b.Createtime >= XdTimestart && b.Createtime <= XdTimeend)) && (string.IsNullOrWhiteSpace(searchEntity.Wenshuleixing) || a.OrderType1 == searchEntity.Wenshuleixing.Trim()) @@ -1596,6 +1603,8 @@ YishouMoney = lll.YishouMoney ?? 0, WeishouMoney = (a.Money ?? 0) /*- (a.Youhui ?? 0)*/ - (lll.YishouMoney ?? 0), OrderType1 = a.OrderType1, + Status = b.Status.ToString(), + //StatusName = ddd.Comments } ).ToList(); @@ -1648,6 +1657,7 @@ YishouMoney = lll.YishouMoney ?? 0, WeishouMoney = (a.Money ?? 0) /*- (a.Youhui ?? 0)*/ - (lll.YishouMoney ?? 0), OrderType1 = a.OrderType1, + Status = b.Status.ToString(), } ).ToList(); @@ -1670,6 +1680,15 @@ //if (searchEntity.totalrows == 0) searchEntity.totalrows = query.Count(); var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList(); + foreach (var cooperOrderDTO in lianlist) + { + var codeDataEntity = listCode.Where(x => x.CodeTable == "t_challengeletter" && x.CodeField == "status" && x.CodeSn == cooperOrderDTO.Status.ToString()).FirstOrDefault(); + if (codeDataEntity != null) { + cooperOrderDTO.StatusName = codeDataEntity.Comments; + } + } + + data.LoadData(searchEntity, lianlist); return data; } -- Gitblit v1.9.1