checkdatas2.jsp 2.15 KB
<%@ page language="java" contentType="application/json;charset=UTF-8" %>
<%@page import="weaver.general.Util"%>
<%@page import="weaver.hrm.company.SubCompanyComInfo"%>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<%
//校验名称是否存在
 String para ="";
 String  subcom = "5";
                    int supsubcomid =0 ;
                    char separator = Util.getSeparator() ;
                    //更新机构权限数据:新增加的分部默认继承上级分部的所有机构权限。
                    para = String.valueOf(subcom) + separator + String.valueOf(supsubcomid);
                    rs.executeProc("HrmRoleSRT_AddByNewSc",para);

                    //更新左侧菜单,新增的分部继承上级分部的左侧菜单
                    String strWhere=" where resourcetype=2 and resourceid="+supsubcomid; 
                    if(supsubcomid==0) strWhere=" where resourcetype=1  and resourceid=1 "; 
                    String strSql="insert into leftmenuconfig (userid,infoid,visible,viewindex,resourceid,resourcetype,locked,lockedbyid,usecustomname,customname,customname_e)  select  distinct  userid,infoid,visible,viewindex,"+subcom+",2,locked,lockedbyid,usecustomname,customname,customname_e from leftmenuconfig "+strWhere;
                    //System.out.println(strSql);
                    rs.executeSql(strSql);



                    //更新顶部菜单,新增的分部继承上级分部的顶部菜单
                    strWhere=" where resourcetype=2 and resourceid="+supsubcomid; 
                    if(supsubcomid==0) strWhere=" where resourcetype=1  and resourceid=1 "; 
                    strSql="insert into mainmenuconfig (userid,infoid,visible,viewindex,resourceid,resourcetype,locked,lockedbyid,usecustomname,customname,customname_e)  select  distinct  userid,infoid,visible,viewindex,"+subcom+",2,locked,lockedbyid,usecustomname,customname,customname_e from mainmenuconfig "+strWhere;
                    //System.out.println(strSql);
                    rs.executeSql(strSql);
                    
                    SubCompanyComInfo sub = new SubCompanyComInfo();
                    sub.removeCompanyCache();
%>