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]
@@ -136,8 +138,8 @@
                    }

                    //主表
                    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");
@@ -180,8 +182,9 @@
                    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");
@@ -224,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);