From e0919683625f6a48699ed2c223f22366cc5bc949 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 23 六月 2022 15:09:33 +0800
Subject: [PATCH] 积分
---
zhengcaioa/Services/OrderBanciService.cs | 100 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 100 insertions(+), 0 deletions(-)
diff --git a/zhengcaioa/Services/OrderBanciService.cs b/zhengcaioa/Services/OrderBanciService.cs
index 08cf13b..5125b06 100644
--- a/zhengcaioa/Services/OrderBanciService.cs
+++ b/zhengcaioa/Services/OrderBanciService.cs
@@ -230,5 +230,105 @@
var list = _mapper.Map<List<OrderBanciDTO>>(listRole);
return list;
}
+
+
+
+ public List<OrderBanciDTO> GetJifenBanciList()
+ {
+
+
+
+ ResultDataEntity<OrderBanciDTO> data = new ResultDataEntity<OrderBanciDTO>();
+ List<OrderBanciDTO> list = new List<OrderBanciDTO>();
+
+
+
+ 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
+ }
+ );
+
+ ///OrderBancis
+ ///
+
+
+ var query = (from a in _context.OrderBancis
+ join b in _context.OrderBanciDtls on a.Id equals b.OrderBanciId
+
+ join d in listCode.Where(x => x.CodeTable == "order_banci_order" && x.CodeField == "kechengleixing_id")
+ on b.Shangxiawu equals d.CodeSn
+ into dzsssss
+ from dzzzzz in dzsssss.DefaultIfEmpty()
+
+ where a.RecStatus == "A" && b.RecStatus == "A" && b.Jifen != null
+ && a.Shijianend >= DateTime.Now
+
+
+
+
+
+
+ select new OrderBanciDTO
+ {
+ img_url ="",
+ point = b.Jifen,
+ sell_price = b.Jiage,
+ type = "Train",
+ title = a.Mingcheng+"("+ dzzzzz.Comments+")",
+ Id = a.Id,
+ Banci = a.Banci,
+ Mingcheng = a.Mingcheng,
+ Shijian = a.Shijian,
+ ShijianName = a.Shijian.HasValue ? a.Shijian.Value.ToString("yyyy-MM-dd HH:mm") : "",
+
+ Shijianend = a.Shijianend,
+ ShijianendName = a.Shijianend.HasValue ? a.Shijianend.Value.ToString("yyyy-MM-dd HH:mm") : "",
+
+ Didian = a.Didian,
+
+ Renshu = a.Renshu ?? 0,
+
+
+ Creater = a.Creater,
+ Createtime = a.Createtime,
+
+ RecStatus = a.RecStatus,
+ Modifier = a.Modifier,
+ Modifytime = a.Modifytime,
+
+
+ Shangxiawu = b.Shangxiawu,
+ Shijiandtl = b.Shijian,
+ Shixiamg = b.Shixiamg,
+ Zhujiangren = b.Zhujiangren,
+ Sort = b.Sort,
+ ShangxiawuName = dzzzzz.Comments,
+ Jiage = b.Jiage,
+ Jifen = b.Jifen,
+ JiageName = b.Jiage.HasValue ? b.Jiage.Value.ToString() : "",
+ JifenName = b.Jifen.HasValue ? b.Jifen.Value.ToString() : "",
+ id = a.Id,
+
+ }
+ ).OrderByDescending(x => x.Shijian).ThenBy(x=>x.Sort).ToList();
+
+
+
+ return query;
+ }
+
}
}
--
Gitblit v1.9.1