From 7592c71981d9bc2b45e7b748f653ce8bb4c389ac Mon Sep 17 00:00:00 2001
From: liaoxujun@qq.com <liaoxujun@qq.com>
Date: 星期三, 10 四月 2024 17:40:02 +0800
Subject: [PATCH] no message
---
CoreCms.Net.Repository/Distribution/CoreCmsDistributionRepository.cs | 32 +++++++++++++++++++++++---------
1 files changed, 23 insertions(+), 9 deletions(-)
diff --git a/CoreCms.Net.Repository/Distribution/CoreCmsDistributionRepository.cs b/CoreCms.Net.Repository/Distribution/CoreCmsDistributionRepository.cs
index ca59cf9..8ba09f7 100644
--- a/CoreCms.Net.Repository/Distribution/CoreCmsDistributionRepository.cs
+++ b/CoreCms.Net.Repository/Distribution/CoreCmsDistributionRepository.cs
@@ -1,10 +1,10 @@
/***********************************************************************
- * Project: CoreCms
- * ProjectName: 鏍稿績鍐呭绠＄悊绯荤粺
- * Web: https://www.corecms.net
- * Author: 澶х伆鐏�
- * Email: jianweie@163.com
- * CreateTime: 2021/1/31 21:45:10
+ * Project: baifenBinfa
+ * ProjectName: 鐧惧垎鍏垫硶绠＄悊绯荤粺
+ * Web: http://chuanyin.com
+ * Author:
+ * Email:
+ * CreateTime: 202403/02
* Description: 鏆傛棤
***********************************************************************/
@@ -19,11 +19,12 @@
using CoreCms.Net.Model.ViewModels.Basics;
using CoreCms.Net.Model.ViewModels.DTO.Distribution;
using SqlSugar;
+using CoreCms.Net.Model.Entities.Distribution;
namespace CoreCms.Net.Repository
{
/// <summary>
- /// 鍒嗛攢鍟嗚〃 鎺ュ彛瀹炵幇
+ /// 缁忛攢鍟嗚〃 鎺ュ彛瀹炵幇
/// </summary>
public class CoreCmsDistributionRepository : BaseRepository<CoreCmsDistribution>, ICoreCmsDistributionRepository
{
@@ -155,7 +156,11 @@
updateTime = p.updateTime,
verifyTime = p.verifyTime,
isDelete = p.isDelete,
- UserGradeId = SqlFunc.Subqueryable<CoreCmsUser>().Where(o => o.id == p.userId).Select(o => o.grade)
+ storeCoordinate = p.storeCoordinate,
+ UserGradeId = SqlFunc.Subqueryable<CoreCmsUser>().Where(o => o.id == p.userId).Select(o => o.grade),
+ DistributionAchievementTotals = SqlFunc.Subqueryable<DistributionAchievement>()
+ .Where(da => da.userID == p.userId && da.isdelete == false)
+ .Sum(da => da.achievementTotals),
})
.MergeTable()
@@ -184,7 +189,16 @@
updateTime = p.updateTime,
verifyTime = p.verifyTime,
isDelete = p.isDelete,
- UserGradeId = SqlFunc.Subqueryable<CoreCmsUser>().Where(o => o.id == p.userId).Select(o => o.grade)
+ address = p.address,
+ areaCode = p.areaCode,
+ profession = p.profession,
+ sales=p.sales,
+ storeCoordinate = p.storeCoordinate,
+ UserGradeId = SqlFunc.Subqueryable<CoreCmsUser>().Where(o => o.id == p.userId).Select(o => o.grade),
+ DistributionAchievementTotals= SqlFunc.Subqueryable<DistributionAchievement>()
+ .Where(da=>da.userID==p.userId&&da.isdelete==false)
+ .Sum(da=>da.achievementTotals),
+
})
.MergeTable()
.OrderByIF(orderByExpression != null, orderByExpression, orderByType)
--
Gitblit v1.9.1