1

llj

23 小时以前 e3f218a023f0625f415a1526b278636c3e39aa4f

 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");
@@ -153,13 +166,25 @@
                }
                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}')");
                    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");
@@ -202,7 +227,7 @@
                }
                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);