From b445defcf7e9dad85032a8279cca29a2892d3089 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期四, 05 九月 2024 12:38:58 +0800
Subject: [PATCH] 修改生产报表查询方法,物料新增编辑增加事业部与项目保存字段
---
WebAPI/Controllers/PublicPageMethodController.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Controllers/PublicPageMethodController.cs b/WebAPI/Controllers/PublicPageMethodController.cs
index 8a9a2a5..45881d2 100644
--- a/WebAPI/Controllers/PublicPageMethodController.cs
+++ b/WebAPI/Controllers/PublicPageMethodController.cs
@@ -3473,7 +3473,7 @@
SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN();
string sql = string.Format(@"select '鏉冮檺绠＄悊-鐢ㄦ埛' id,'' HNumber,'鏉冮檺绠＄悊--鐢ㄦ埛' title,'' ParentID
union all
- select gnbm id,gnsy HNumber,gnmc as title, case when sjgnbm='' then '鏉冮檺绠＄悊--鐢ㄦ埛' else sjgnbm end ParentID from Xt_Xtgnb where sjgnbm=''
+ select gnbm id,gnsy HNumber,gnmc as title, case when sjgnbm='' then '鏉冮檺绠＄悊--鐢ㄦ埛' else sjgnbm end ParentID from Xt_Xtgnb where sjgnbm='' and useflag=1
union all
Select gnbm id,gnsy HNumber,gnmc as title,sjgnbm as ParentID
from Xt_Xtgnb where mjbz=0 and useflag=1 and rightflag=1 and sjgnbm in(
--
Gitblit v1.9.1