From 6fe3d6fc4e93f4cf31dc02d4f0cbc48d56c249b7 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 30 六月 2023 13:35:23 +0800
Subject: [PATCH] 多车间模式接口过滤
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 59 ++++++++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 46 insertions(+), 13 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index 8eb9053..092ece5 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -242,7 +242,7 @@
#endregion
#region [缁勭粐鏋舵瀯鍒犻櫎]
- public static ToMessage DeleteOrganization(int orgid)
+ public static ToMessage DeleteOrganization(int orgid,string orgcode)
{
var sql = "";
var cont = 0;
@@ -251,15 +251,25 @@
{
sql = @"select * from TOrganization where parent_id=@orgid and is_delete<>'1'";
dynamicParams.Add(@"orgid", orgid);
- cont = DapperHelper.selectcount(sql, dynamicParams);
- if (cont > 0)
+ var data0 = DapperHelper.selectdata(sql, dynamicParams);
+ if (data0.Rows.Count > 0)
{
mes.code = "300";
mes.Message = "褰撳墠缁勭粐鏈変笅绾у叧鑱�,璇峰厛鍒犻櫎涓嬬骇缁勭粐!";
+ return mes;
}
- else
+ sql = @"select * from TUser where is_delete<>'1' and stu_torgcode=@stu_torgcode";
+ dynamicParams.Add("@stu_torgcode", orgcode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
{
- sql = @"delete TOrganization where id=@orgid";
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "璇ョ粍缁囦笅鏈夊叧鑱旂殑鐢ㄦ埛,涓嶅厑璁稿垹闄�!";
+ mes.data = null;
+ return mes;
+ }
+ sql = @"delete TOrganization where id=@orgid";
dynamicParams.Add(@"orgid", orgid);
cont = DapperHelper.SQL(sql, dynamicParams);
if (cont > 0)
@@ -276,7 +286,7 @@
mes.Message = "鍒犻櫎鎿嶄綔澶辫触!";
mes.data = null;
}
- }
+
}
catch (Exception e)
{
@@ -633,7 +643,7 @@
sql = @"delete TUserRoleRelation where user_code=@usercode";
list.Add(new { str = sql, parm = new { usercode = data.Rows[0]["USERCODE"].ToString() } });
- sql = @"update TUser set is_delete='1' where id=@userid";
+ sql = @"delete TUser where id=@userid";
list.Add(new { str = sql, parm = new { userid = userid } });
bool aa = DapperHelper.DoTransaction(list);
if (aa)
@@ -1097,7 +1107,7 @@
from TRoleType R
left join TOrganization parent on R.torg_code=parent.org_code
left join TOrganization as child on parent.parent_id=child.id
- where R.is_delete<>'1' " + search;
+ where R.is_delete<>'1' and roletype_code<>'001' " + search;
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
@@ -1183,12 +1193,22 @@
{
var sql = "";
List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
try
{
list.Clear();
+ sql = @"select * from TRole where is_delete<>'1' and roletype_code=@roleTypeCode";
+ dynamicParams.Add("@roleTypeCode", roleTypeCode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "璇ヨ鑹茬被鍨嬩笅鏈夊叧鑱旂殑瑙掕壊鏄庣粏,涓嶅厑璁稿垹闄�!";
+ mes.data = null;
+ return mes;
+ }
sql = @"delete TRoleType where roletype_code=@roletypecode";
- list.Add(new { str = sql, parm = new { roletypecode = roleTypeCode } });
- sql = @"delete TRole where roletype_code=@roletypecode";
list.Add(new { str = sql, parm = new { roletypecode = roleTypeCode } });
bool aa = DapperHelper.DoTransaction(list);
if (aa)
@@ -1421,16 +1441,29 @@
{
var sql = "";
List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
try
{
- //鏇存柊瑙掕壊琛ㄣ�佽鑹插叧鑱旂敤鎴锋爣璇嗗強鍒犻櫎鐘舵��
- sql = @"update TRole set is_user='N',is_right='N',is_delete='1' where role_code=@RoleCode";
+ //鏌ユ壘鐢ㄦ埛瑙掕壊鍏宠仈鍏崇郴琛�
+ sql = @"select * from TUserRoleRelation where is_delete<>'1' and role_code=@RoleCode";
+ dynamicParams.Add("@RoleCode", RoleCode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "璇ヨ鑹蹭笅鏈夊叧鑱旂殑鐢ㄦ埛淇℃伅,涓嶅厑璁稿垹闄�!";
+ mes.data = null;
+ return mes;
+ }
+ //鏇存柊瑙掕壊琛ㄣ�佽鑹插叧鑱旂敤鎴锋爣璇嗗強鍒犻櫎鐘舵�乻et is_user='N',is_right='N',is_delete='1'
+ sql = @"delete TRole where role_code=@RoleCode";
list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
//鏇存柊瑙掕壊鍏宠仈鐢ㄦ埛琛ㄣ�佽鑹插叧鑱旂敤鎴锋爣璇嗗強鍒犻櫎鐘舵��
sql = @"delete TUserRoleRelation where role_code=@RoleCode";
list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
//鍒犻櫎(鏇存柊鐘舵��)瑙掕壊鍔熻兘琛�
- sql = @"update TRoleRightRelation set is_delete='1' where role_code=@RoleCode";
+ sql = @"delete TRoleRightRelation where role_code=@RoleCode";
list.Add(new { str = sql, parm = new { RoleCode = RoleCode } });
bool aa = DapperHelper.DoTransaction(list);
if (aa)
--
Gitblit v1.9.3