From dbfebaff9e8f5b10f8037c87971fb9d3edf025d3 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期三, 02 四月 2025 17:27:29 +0800
Subject: [PATCH] 工程项目 增加 部门 字段， 工程项目 （任务类）任务大类和任务项目分类和日期， 任何一项 变化时，都要 刷新下 项目代码；通过存储过程 来 获取 项目代码
---
WebAPI/Controllers/BLL/Xt_UserGroupController.cs | 22 ++++++++++++++++++++++
1 files changed, 22 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/BLL/Xt_UserGroupController.cs b/WebAPI/Controllers/BLL/Xt_UserGroupController.cs
index 2a9191c..7a6438c 100644
--- a/WebAPI/Controllers/BLL/Xt_UserGroupController.cs
+++ b/WebAPI/Controllers/BLL/Xt_UserGroupController.cs
@@ -124,6 +124,17 @@
if (OperationType == 1)//鏂板
{
+ //鏂板鍓嶆煡璇� 纭繚瑙掕壊鍚嶆湭閲嶅鏂板
+ ds = oCN.RunProcReturn("Select * from System_UserGroup where GroupName='" + omdelMian.GroupName + "'", "System_UserGroup");
+ if (ds.Tables[0].Rows.Count > 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "瑙掕壊鏂板澶辫触锛佸綋鍓嶈鑹插悕宸茬粡瀛樺湪锛屼笉鍙噸澶�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
//涓昏〃
oCN.RunProc("insert into System_UserGroup (GroupName,HLev,Explain)values" +
$"('{omdelMian.GroupName}','{omdelMian.HLev}','{omdelMian.Explain}')");
@@ -153,6 +164,17 @@
}
else if (OperationType == 2)//澶嶅埗
{
+ //鏂板鍓嶆煡璇� 纭繚瑙掕壊鍚嶆湭閲嶅鏂板
+ ds = oCN.RunProcReturn("Select * from System_UserGroup where GroupName='" + omdelMian.GroupName + "'", "System_UserGroup");
+ if (ds.Tables[0].Rows.Count > 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "瑙掕壊鏂板澶辫触锛佸綋鍓嶈鑹插悕宸茬粡瀛樺湪锛屼笉鍙噸澶�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
string realExplain = omdelMian.Explain.Substring(0, omdelMian.Explain.IndexOf("#澶嶅埗鍘熻鑹睮D锛�")); //鑾峰彇鐣岄潰璁剧疆鐨凟xplain鍊�
string sourceBill_GroupID = omdelMian.Explain.Replace(realExplain + "#澶嶅埗鍘熻鑹睮D锛�", ""); //鑾峰彇澶嶅埗鐨勬簮鍗曟嵁鐨処D
omdelMian.Explain = realExplain;
--
Gitblit v1.9.1