baifenbaishop.git

			@@ -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)