From d96f23ba5f38ba07bf4b20d50e329ef71f30b2fe Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期三, 15 三月 2023 13:51:08 +0800
Subject: [PATCH] 仓库库位更改联表字段， 组织过滤
---
zymes/OperationService/zymes_RealessStock.cs | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/zymes/OperationService/zymes_RealessStock.cs b/zymes/OperationService/zymes_RealessStock.cs
index 258e5d1..2afab17 100644
--- a/zymes/OperationService/zymes_RealessStock.cs
+++ b/zymes/OperationService/zymes_RealessStock.cs
@@ -46,8 +46,8 @@
foreach (var billObj in e.DataEntitys)
{
var forgName = Context.CurrentOrganizationInfo.Name;
- //if (!forgName.Contains("鏉窞鏂帿灏旂鎬ф潗鏂欐湁闄愬叕鍙�"))
- // continue;
+ if (!forgName.Contains("鏉窞鏂帿灏旂鎬ф潗鏂欐湁闄愬叕鍙�"))
+ continue;
//var sql = $"exec zymes_RealessStock {billObj["Id"]} ";
var id = billObj["Id"].ToString();
string sql = string.Empty;
@@ -69,7 +69,7 @@
join T_BAS_FLEXVALUESDETAIL t2 on t1.FSTOCKLOCID = t2.FID
--SELECT * FROM T_BAS_FLEXVALUESENTRY t1--浠撲綅鍊奸泦鍒楄〃鏄庣粏
--join T_BAS_FLEXVALUESENTRY_L t2 on t1.FENTRYID=t2.FENTRYID--浠撲綅鍊奸泦鍒楄〃
-join T_BAS_FLEXVALUESENTRY t3 on t2.FF100003 = t3.FENTRYID--浠撲綅鍊奸泦鍒楄〃鏄庣粏
+join T_BAS_FLEXVALUESENTRY t3 on t2.FF100006 = t3.FENTRYID--浠撲綅鍊奸泦鍒楄〃鏄庣粏
join T_BAS_FLEXVALUESENTRY_L t4 on t3.FENTRYID=t4.FENTRYID
where t1.fstockid= {0} --閲囪喘鍏ュ簱鍗曢�夋嫨浠撳簱鍚� 閫夋嫨浠撲綅
", id);
--
Gitblit v1.9.1