WEBS引用更新

yxj

2025-10-24 ae36a4639fff74935c27c8e7bb0ce6b39ad039a5

 WebAPI/Controllers/BLL/Xt_UserGroupController.cs

@@ -82,6 +82,8 @@
            public string GroupName { get; set; }
            public string HLev { get; set; }
            public string Explain { get; set; }
            public int HUSEORGID { get; set; }
            public int HCREATEORGID { get; set; }
        }
        [Route("Xt_UserGroup/UserGroupInfoEdit")]
        [HttpPost]
@@ -124,9 +126,20 @@

                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}')");
                    oCN.RunProc("insert into  System_UserGroup (GroupName,HLev,Explain,HUSEORGID,HCREATEORGID)values" +
                        $"('{omdelMian.GroupName}','{omdelMian.HLev}','{omdelMian.Explain}','{omdelMian.HUSEORGID}','{omdelMian.HCREATEORGID}')");

                    //新增后查询  确保数据添加成功
                    ds = oCN.RunProcReturn("Select * from  System_UserGroup where GroupName='" + omdelMian.GroupName + "'", "System_UserGroup");
@@ -151,9 +164,70 @@
                    }
                  
                }
                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,HUSEORGID,HCREATEORGID)values" +
                        $"('{omdelMian.GroupName}','{omdelMian.HLev}','{omdelMian.Explain}','{omdelMian.HUSEORGID}','{omdelMian.HCREATEORGID}')");


                    //新增后查询  确保数据添加成功
                    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)
                {
                    oCN.RunProc("update  System_UserGroup set GroupName='" + omdelMian.GroupName + "',HLev='" + omdelMian.HLev + "',Explain='" + omdelMian.Explain + "'"
                    oCN.RunProc("update  System_UserGroup set GroupName='" + omdelMian.GroupName + "',HLev='" + omdelMian.HLev + "',Explain='" + omdelMian.Explain + "',HUSEORGID='" + omdelMian.HUSEORGID + "',HCREATEORGID='" + omdelMian.HCREATEORGID + "'"
                    + " where GroupId=" + omdelMian.HGroupID);

                    oCN.RunProc("delete from  System_UserGroupInfo where GroupId=" + omdelMian.HGroupID);