From 5d6cb15ac86d9174393cb9d1538d69b567e2c26c Mon Sep 17 00:00:00 2001
From: 移动系统liao <liaoxujun@qq.com>
Date: 星期四, 09 五月 2024 08:56:50 +0800
Subject: [PATCH] 修改货品编辑bug
---
CoreCms.Net.Services/baifenbingfa/CoreCmsProductsServices.cs | 38 ++++++++++++++++++++++++++++++++++++++
1 files changed, 38 insertions(+), 0 deletions(-)
diff --git a/CoreCms.Net.Services/baifenbingfa/CoreCmsProductsServices.cs b/CoreCms.Net.Services/baifenbingfa/CoreCmsProductsServices.cs
index fbcae89..5df0ea1 100644
--- a/CoreCms.Net.Services/baifenbingfa/CoreCmsProductsServices.cs
+++ b/CoreCms.Net.Services/baifenbingfa/CoreCmsProductsServices.cs
@@ -20,6 +20,7 @@
using CoreCms.Net.Model.ViewModels.Basics;
using CoreCms.Net.Model.ViewModels.UI;
using SqlSugar;
+using static CoreCms.Net.Configuration.GlobalEnumVars;
namespace CoreCms.Net.Services
@@ -151,6 +152,43 @@
{
return await _dal.QueryDetaiListAsync(predicate, orderByExpression, orderByType, blUseNoLock);
}
+
+ public async Task<CoreCmsProducts> QueryEditByID(int id)
+ {
+ return await _unitOfWork.GetDbClient().Queryable<CoreCmsGoods, CoreCmsProducts>((good, product) => new JoinQueryInfos(
+ JoinType.Inner, good.id == product.goodsId
+ )
+ ).Where((good, product) =>product.id==id)
+ .Select((good, product) => new CoreCmsProducts
+ {
+ id = product.id,
+ goodsId = product.goodsId,
+ barcode = product.barcode,
+ sn = product.sn,
+ price = product.price,
+ costprice = product.costprice,
+ mktprice = product.mktprice,
+ marketable = product.marketable,
+ weight = product.weight,
+ stock = product.stock,
+ freezeStock = product.freezeStock,
+ pointsDeduction = product.pointsDeduction,
+ points = product.points,
+ spesDesc = product.spesDesc,
+ isDefalut = product.isDefalut,
+ images = product.images,
+ isDel = good.isDel,
+ name = good.name,
+ bn = good.bn,
+ isMarketable = good.isMarketable,
+ unit = good.unit,
+ distributionPrice = product.distributionPrice,
+ cutMoney = product.cutMoney,
+ distributionCutMoney = product.distributionCutMoney,
+ }).With(SqlWith.NoLock)
+ .FirstAsync();
+
+ }
#endregion
--
Gitblit v1.9.1