From 95da5302750b690c5e52953b1d74aff4576cc5be Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期五, 05 一月 2024 14:58:06 +0800
Subject: [PATCH] 生产汇报单子表源单信息存入数据；日计划工单列表查询视图改为调用左连接的；排产保存方法中的生产资源重复校验的查询取消内连接子表
---
WebAPI/Controllers/SCGL/Sc_ComplementGoodBillController.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Controllers/SCGL/Sc_ComplementGoodBillController.cs b/WebAPI/Controllers/SCGL/Sc_ComplementGoodBillController.cs
index 3f53aa9..ee29387 100644
--- a/WebAPI/Controllers/SCGL/Sc_ComplementGoodBillController.cs
+++ b/WebAPI/Controllers/SCGL/Sc_ComplementGoodBillController.cs
@@ -777,7 +777,7 @@
else if (com.Type == 3772)
{
//鐢熶骇璁㈠崟 涓嬫煡 宸ュ簭娴佽浆鍗�
- ds = oCN.RunProcReturn($"select * from h_v_Sc_ProcessExchangeBillQuery where HICMOInterID='{com.HSouceInterID}' and HICMOEntryID={com.HSourceEntryID}", "h_v_Sc_ProcessExchangeBillQuery");
+ ds = oCN.RunProcReturn($"select * from h_v_Sc_ProcessExchangeBillQuery where HICMOInterID='{com.HSouceInterID}' and HICMOEntryID={com.HSourceEntryID} and HBillSubType<>'SUB'", "h_v_Sc_ProcessExchangeBillQuery");
}
//娣诲姞鍒楀悕
--
Gitblit v1.9.1