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/BaseSet/Gy_UnitController.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Gy_UnitController.cs b/WebAPI/Controllers/BaseSet/Gy_UnitController.cs
index d80b8e9..5d74ac6 100644
--- a/WebAPI/Controllers/BaseSet/Gy_UnitController.cs
+++ b/WebAPI/Controllers/BaseSet/Gy_UnitController.cs
@@ -48,7 +48,7 @@
return objJsonResult;
}
- string sql1 = string.Format(@"select * from h_v_Gy_UnitList where 绂佺敤鏍囪='' and 缁勭粐鍚嶇О='" + Organization + "'");
+ string sql1 = string.Format(@"select * from h_v_Gy_UnitList where 缁勭粐鍚嶇О='" + Organization + "'");
if (sWhere == null || sWhere.Equals(""))
{
ds = oCN.RunProcReturn(sql1 + sWhere + "order by 璁￠噺鍗曚綅浠ｇ爜 ", "h_v_Gy_UnitList");
--
Gitblit v1.9.1