根据用户关联客户获取过滤条件

duhe

2023-12-26 17daeed07e6518d3eb3821a4e58946a5a4b13414

 WebAPI/Controllers/BLL/Xt_UserGroupController.cs

@@ -192,8 +192,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();//结束事务