设备启动点检单、防错验证检查单、首件单、巡检单、工序转移检验单、库存检验单、车间自检单、环境检测单、不良品评审处理单、异常反馈单、异常反馈接收单、异常...

zrg

2025-03-24 710311abde05a1e08a90d8b6154d7d6b78e7a84e

 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("#复制原角色ID："));        //获取界面设置的Explain值
                    string sourceBill_GroupID = omdelMian.Explain.Replace(realExplain + "#复制原角色ID：", "");                     //获取复制的源单据的ID
                    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"]);


                    //根据复制的源单据的ID，获取源单据的ID对应角色的权限
                    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();//结束事务