From c06eb4d284a80dbee4a2d040046c37bf73dcfcd5 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 29 八月 2022 09:50:58 +0800
Subject: [PATCH] 风险代理确认订单后计算业绩
---
zhengcaioa/Services/OrderBanciService.cs | 117 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 115 insertions(+), 2 deletions(-)
diff --git a/zhengcaioa/Services/OrderBanciService.cs b/zhengcaioa/Services/OrderBanciService.cs
index ce15e69..5125b06 100644
--- a/zhengcaioa/Services/OrderBanciService.cs
+++ b/zhengcaioa/Services/OrderBanciService.cs
@@ -84,6 +84,19 @@
return result;
}
+ public OrderBanciDTO GetAll(string id)
+ {
+
+ var entity = _context.OrderBancis.Find(id);
+
+
+
+ var result = _mapper.Map<OrderBanciDTO>(entity);
+
+
+ return result;
+ }
+
public ResultDataEntity<OrderBanciDTO> SearchByPaging(OrderBanciDTOSearch searchEntity)
{
@@ -121,7 +134,7 @@
string[] Shijians = searchEntity.Shijian.Split("|");
DateTime.TryParse(Shijians[0], out Shijianstart);
DateTime.TryParse(Shijians[1], out Shijianend);
- //Shijianend = Shijianend.AddDays(1);
+ Shijianend = Shijianend.AddDays(1);
}
var query = (from a in _context.OrderBancis
@@ -167,7 +180,7 @@
- if (searchEntity.totalrows == 0)
+ //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);
@@ -217,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