From cf25900d05a788e9052132b55e471695319542e0 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 03 十二月 2021 15:40:49 +0800
Subject: [PATCH] t提交
---
zhengcaioa/Services/CooperOrderService.cs | 173 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 171 insertions(+), 2 deletions(-)
diff --git a/zhengcaioa/Services/CooperOrderService.cs b/zhengcaioa/Services/CooperOrderService.cs
index 7bf10c7..fa1b109 100644
--- a/zhengcaioa/Services/CooperOrderService.cs
+++ b/zhengcaioa/Services/CooperOrderService.cs
@@ -923,7 +923,7 @@
public List<TChallengeletterDTO> GetListChallengeletter(string OrderId)
{
- var entity = _context.TChallengeletters.Where(x => x.Status == 1 && x.OrderId == OrderId).ToList();
+ var entity = _context.TChallengeletters.Where(x =>/* x.Status == 1 && */x.OrderId == OrderId).ToList();
@@ -1065,7 +1065,7 @@
public List<TComplaintletterDTO> GetListComplaintletter(string OrderId)
{
- var entity = _context.TComplaintletters.Where(x => x.Status == 1 && x.OrderId == OrderId).ToList();
+ var entity = _context.TComplaintletters.Where(x => /*x.Status == 1 &&*/ x.OrderId == OrderId).ToList();
@@ -1504,5 +1504,174 @@
_context.SaveChanges();
return result;
}
+
+
+
+ public ResultDataEntity<CooperOrderDTO> SearchByPagingWenshu(CooperOrderDTOSearch searchEntity)
+ {
+
+
+
+ ResultDataEntity<CooperOrderDTO> data = new ResultDataEntity<CooperOrderDTO>();
+ List<CooperOrderDTO> list = new List<CooperOrderDTO>();
+
+
+
+
+ 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
+ }
+ );
+ DateTime XdTimestart = DateTime.Now;
+ DateTime XdTimeend = DateTime.Now;
+ if (!string.IsNullOrWhiteSpace(searchEntity.XdTime))
+ {
+ string[] XdTimes = searchEntity.XdTime.Split("|");
+ DateTime.TryParse(XdTimes[0], out XdTimestart);
+ DateTime.TryParse(XdTimes[1], out XdTimeend);
+ XdTimeend = XdTimeend.AddDays(1);
+ }
+
+
+ var query2 = (from a in _context.CooperOrders
+
+ join b in _context.TChallengeletters
+ on a.Id equals b.OrderId
+
+
+
+ join g in _context.CooperatecustomCustomers.Where(x => x.RecStatus == "A")
+ on a.Khdw equals g.Id
+ into gsss
+ from ggg in gsss.DefaultIfEmpty()
+
+ join l in _context.FiOrderrecievemoneys.Where(x => x.RecStatus == "A").GroupBy(q => new { q.OrderId }).Select(q => new
+ {
+ OrderId = q.Key.OrderId,
+ YishouMoney = q.Sum(x => x.Recievemoney),
+ }
+ )
+ on a.Id equals l.OrderId
+ into lsss
+ from lll in lsss.DefaultIfEmpty()
+
+ where a.RecStatus == "A" && a.OrderType1 == "浠ｆ嫙璐ㄧ枒鍑�"
+ && (string.IsNullOrWhiteSpace(searchEntity.XdTime) || (b.Createtime >= XdTimestart && b.Createtime <= XdTimeend))
+ && (string.IsNullOrWhiteSpace(searchEntity.Wenshuleixing) || a.OrderType1 == searchEntity.Wenshuleixing.Trim())
+ && (string.IsNullOrWhiteSpace(searchEntity.XmName) || b.XmName.Contains(searchEntity.XmName.Trim()))
+ && (string.IsNullOrWhiteSpace(searchEntity.XmCode) || b.XmCode.Contains(searchEntity.XmCode.Trim()))
+ && (string.IsNullOrWhiteSpace(searchEntity.PurchaserName) || b.PurchaserName.Contains(searchEntity.PurchaserName.Trim()))
+ //&& (string.IsNullOrWhiteSpace(searchEntity.Agency) || b.Agency.Contains(searchEntity.Agency.Trim()))
+ && (string.IsNullOrWhiteSpace(searchEntity.KhdwName) || ggg.Name.Contains(searchEntity.KhdwName.Trim()))
+ && (searchEntity.Status <= 0 || b.Status == searchEntity.Status)
+
+
+
+
+
+ select new CooperOrderDTO
+ {
+ Id = a.Id,
+
+ XmCode = b.XmCode,
+ XmName = b.XmName,
+ PurchaserName = b.PurchaserName,
+ Agency = "",
+ KhdwName = ggg.Name,
+ XdTime = a.Createtime,
+ XdTimeName = a.Createtime.ToString("yyyy-MM-dd"),
+ YishouMoney = lll.YishouMoney ?? 0,
+ WeishouMoney = (a.Money ?? 0) /*- (a.Youhui ?? 0)*/ - (lll.YishouMoney ?? 0),
+ OrderType1 = a.OrderType1,
+ }
+ ).ToList();
+
+
+ var query1 =(from a in _context.CooperOrders
+ join b in _context.TComplaintletters.Where(x => x.Status == 1)
+ on a.Id equals b.OrderId
+
+
+ join g in _context.CooperatecustomCustomers.Where(x => x.RecStatus == "A")
+ on a.Khdw equals g.Id
+ into gsss
+ from ggg in gsss.DefaultIfEmpty()
+
+ join l in _context.FiOrderrecievemoneys.Where(x => x.RecStatus == "A").GroupBy(q => new { q.OrderId }).Select(q => new
+ {
+ OrderId = q.Key.OrderId,
+ YishouMoney = q.Sum(x => x.Recievemoney),
+ }
+ )
+ on a.Id equals l.OrderId
+ into lsss
+ from lll in lsss.DefaultIfEmpty()
+
+ where a.RecStatus == "A" && a.OrderType1 == "浠ｆ嫙鎶曡瘔涔�"
+ && (string.IsNullOrWhiteSpace(searchEntity.XdTime) || (b.Createtime >= XdTimestart && b.Createtime <= XdTimeend))
+ && (string.IsNullOrWhiteSpace(searchEntity.Wenshuleixing) || a.OrderType1 == searchEntity.Wenshuleixing.Trim())
+ && (string.IsNullOrWhiteSpace(searchEntity.XmCode) || b.XmCode.Contains(searchEntity.XmCode.Trim()))
+ && (string.IsNullOrWhiteSpace(searchEntity.XmName) || b.XmName.Contains(searchEntity.XmName.Trim()))
+ && (string.IsNullOrWhiteSpace(searchEntity.PurchaserName) || b.PurchaserName.Contains(searchEntity.PurchaserName.Trim()))
+ && (string.IsNullOrWhiteSpace(searchEntity.Agency) || b.Agency.Contains(searchEntity.Agency.Trim()))
+ && (string.IsNullOrWhiteSpace(searchEntity.KhdwName) || ggg.Name.Contains(searchEntity.KhdwName.Trim()))
+ && (searchEntity.Status <= 0 || b.Status == searchEntity.Status)
+
+
+
+
+
+ select new CooperOrderDTO
+ {
+ Id = a.Id,
+
+ XmCode = b.XmCode,
+ XmName = b.XmName,
+ PurchaserName = b.PurchaserName,
+ Agency = b.Agency,
+ KhdwName = ggg.Name,
+ XdTime = b.Createtime.Value,
+ XdTimeName = b.Createtime.Value.ToString("yyyy-MM-dd"),
+ YishouMoney = lll.YishouMoney ?? 0,
+ WeishouMoney = (a.Money ?? 0) /*- (a.Youhui ?? 0)*/ - (lll.YishouMoney ?? 0),
+ OrderType1 = a.OrderType1,
+ }
+ ).ToList();
+
+ query2.AddRange(query1);
+ var query = query2.Where(x => x.WeishouMoney <= 0).OrderByDescending(x => x.Createtime).ToList();
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ //if (searchEntity.totalrows == 0)
+ searchEntity.totalrows = query.Count();
+ var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
+ data.LoadData(searchEntity, lianlist);
+ return data;
+ }
}
}
--
Gitblit v1.9.1