From 710311abde05a1e08a90d8b6154d7d6b78e7a84e Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期一, 24 三月 2025 17:31:24 +0800
Subject: [PATCH] 设备启动点检单、防错验证检查单、首件单、巡检单、工序转移检验单、库存检验单、车间自检单、环境检测单、不良品评审处理单、异常反馈单、异常反馈接收单、异常反馈签到单、异常反馈处理单、异常反馈验收单、检验取样单、检验还样单 数据库分页； 保存前控制，保存后控制； 审核前控制，反审核前控制， 审核后控制，反审核后控制，删除前控制，删除后控制； 关闭前控制，反关闭前控制；；关闭后控制，反关闭后控制；
---
WebAPI/Controllers/BLL/Xt_UserGroupController.cs | 77 +++++++++++++++++++++++++++++++++++++-
1 files changed, 75 insertions(+), 2 deletions(-)
diff --git a/WebAPI/Controllers/BLL/Xt_UserGroupController.cs b/WebAPI/Controllers/BLL/Xt_UserGroupController.cs
index 64d2d52..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}')");
@@ -150,6 +161,66 @@
}
}
+ }
+ 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;
+
+ //涓昏〃
+ oCN.RunProc("insert into System_UserGroup (GroupName,HLev,Explain)values" +
+ $"('{omdelMian.GroupName}','{omdelMian.HLev}','{omdelMian.Explain}')");
+
+ //鏂板鍚庢煡璇� 纭繚鏁版嵁娣诲姞鎴愬姛
+ ds = oCN.RunProcReturn("Select * from System_UserGroup where GroupName='" + omdelMian.GroupName + "'", "System_UserGroup");
+ if (ds == null || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鐢ㄦ埛鏂板澶辫触锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ var HGroupID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["GroupID"]);
+
+
+ //鏍规嵁澶嶅埗鐨勬簮鍗曟嵁鐨処D锛岃幏鍙栨簮鍗曟嵁鐨処D瀵瑰簲瑙掕壊鐨勬潈闄�
+ ds = oCN.RunProcReturn("Select * from System_UserGroup where GroupID='" + sourceBill_GroupID + "'", "System_UserGroup");
+ if (ds == null || ds.Tables[0].Rows.Count == 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "琚鍒剁殑瑙掕壊涓嶅瓨鍦紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ string AuthorityID = ds.Tables[0].Rows[0]["AuthorityID"].ToString();
+ oCN.RunProc("update System_UserGroup set AuthorityID = '" + AuthorityID + "' where GroupID = " + HGroupID);
+
+
+ //璁剧疆瑙掕壊缁戝畾鐨勭敤鎴�
+ oCN.RunProc("delete from System_UserGroupInfo where GroupId=" + HGroupID.ToString());
+
+ if (num[0] != "-1")
+ {
+ for (int i = 0; i < num.Length; i++)
+ {
+ oCN.RunProc("insert into System_UserGroupInfo (GroupId,UserId) values (" + HGroupID.ToString() + ",'" + num[i] + "')");
+ }
+ }
+
}
else if (OperationType == 3)
{
@@ -192,8 +263,10 @@
if (ds.Tables[0].Rows.Count > 0)
{
oCN.BeginTran();//寮�鍚簨鍔�
-
- oCN.RunProc($"delete from h_v_System_UserGroup where HGroupID={HInterID}");
+ //鍒犻櫎瑙掕壊琛�
+ oCN.RunProc($"delete from System_UserGroup where GroupID={HInterID}");
+ //鍒犻櫎鍏宠仈鐨勭敤鎴峰叧绯�
+ oCN.RunProc($"delete from System_UserGroupInfo where GroupId={HInterID}");
oCN.Commit();//缁撴潫浜嬪姟
--
Gitblit v1.9.1