hrmresourceoperation.jsp

BBS功能模块

      SysMaintenanceLog.setSysLogInfo();






      response.sendRedirect("/hrm/resource/HrmResourceSystemView.jsp?id="+id+"&isView="+isView);
      return;
    }

    if(operation.equalsIgnoreCase("editbasicinfo")){

        String id = Util.null2String(fu.getParameter("id"));
        String workcode = Util.fromScreen(fu.getParameter("workcode"),user.getLanguage());
        String lastname = Util.fromScreen(fu.getParameter("lastname"),user.getLanguage());
        String sex = Util.fromScreen(fu.getParameter("sex"),user.getLanguage());

        String resourceimageid= Util.null2String(fu.uploadFiles("photoid"));
        String oldresourceimageid= Util.null2String(fu.getParameter("oldresourceimage"));
        if(resourceimageid.equals("")) resourceimageid=oldresourceimageid ;

        String departmentid = Util.fromScreen(fu.getParameter("departmentid"),user.getLanguage());
        String costcenterid = Util.fromScreen(fu.getParameter("costcenterid"),user.getLanguage());
        String jobtitle = Util.fromScreen(fu.getParameter("jobtitle"),user.getLanguage());
        String joblevel = Util.fromScreen(fu.getParameter("joblevel"),user.getLanguage());
        String jobactivitydesc = Util.fromScreen(fu.getParameter("jobactivitydesc"),user.getLanguage());
        String managerid = Util.fromScreen(fu.getParameter("managerid"),user.getLanguage());
        String assistantid = Util.fromScreen(fu.getParameter("assistantid"),user.getLanguage());
        String status = Util.fromScreen(fu.getParameter("status"),user.getLanguage());
        String locationid = Util.fromScreen(fu.getParameter("locationid"),user.getLanguage());
        String workroom = Util.fromScreen(fu.getParameter("workroom"),user.getLanguage());
        String telephone = Util.fromScreen(fu.getParameter("telephone"),user.getLanguage());
        String mobile = Util.fromScreen(fu.getParameter("mobile"),user.getLanguage());
        String mobilecall = Util.fromScreen(fu.getParameter("mobilecall"),user.getLanguage());
        String fax = Util.fromScreen(fu.getParameter("fax"),user.getLanguage());
        String jobcall = Util.fromScreen(fu.getParameter("jobcall"),user.getLanguage());
        String systemlanguage = Util.fromScreen(fu.getParameter("systemlanguage"),user.getLanguage());
        if(systemlanguage.equals("")||systemlanguage.equals("0")){
         systemlanguage = "7";
        }

        para =""+id+separator+workcode+separator+lastname+separator+sex+separator+resourceimageid
          +separator+ departmentid+separator+ costcenterid+separator+jobtitle+separator+joblevel+separator+jobactivitydesc+separator+         managerid+separator+assistantid+separator+status+separator+locationid+separator+workroom+separator+telephone+separator+mobile+separator+mobilecall+separator+fax+separator+jobcall+separator+systemlanguage;

        rs.executeProc("HrmResourceBasicInfo_Update",para);
        rs.executeProc("HrmResource_ModInfo",""+id+separator+userpara);

        String oldmanagerstr = "";
        String sql = "select managerstr from HrmResource where id = "+id;
        rs.executeSql(sql);
        while(rs.next()){
        oldmanagerstr = rs.getString("managerstr");
        }
        sql = "select managerstr from HrmResource where id = "+Util.getIntValue(managerid);
        rs.executeSql(sql);
        String managerstr = "";
        while(rs.next()){
          managerstr += rs.getString("managerstr");
          managerstr +=managerid +",";
        }
        para = ""+id+separator+ managerstr;
        rs.executeProc("HrmResource_UpdateManagerStr",para);
        sql = "select id,managerstr from HrmResource where managerstr like '"+oldmanagerstr + id + ",%'";
        rs.executeSql(sql);
        while(rs.next()){
          String nowmanagerstr = Util.null2String(rs.getString("managerstr"));
          String resourceid = rs.getString("id");
          nowmanagerstr = Util.StringReplaceOnce(nowmanagerstr,oldmanagerstr ,managerstr);
          para = resourceid + separator + nowmanagerstr ;
          rs.executeProc("HrmResource_UpdateManagerStr",para);
        }

        String subcmpanyid1 = DepartmentComInfo.getSubcompanyid1(departmentid);
        para = ""+id+separator+subcmpanyid1;
        rs.executeProc("HrmResource_UpdateSubCom",para);

        para = ""+id;
        for(int i = 0;i<5;i++){
        String datefield = Util.null2String(fu.getParameter("datefield"+i));
        String numberfield = ""+Util.getDoubleValue(fu.getParameter("numberfield"+i),0);
        String textfield = Util.null2String(fu.getParameter("textfield"+i));
        String tinyintfield = ""+Util.getIntValue(fu.getParameter("tinyintfield"+i),0);
        para += separator+datefield + separator+numberfield+separator+textfield+separator+tinyintfield;
        }
        rs.executeProc("HrmResourceDefine_Update",para);




    if (RecordSetDB.getDBType().equals("db2")){
        //db2 trigger
        int seclevel = Util.getIntValue(fu.getParameter("seclevel"),0);
        String nowmanagerstr = Util.null2String(rs.getString("managerstr"));
        //rs.executeProc("Tri_U_HrmresourceShare",""+id+separator+departmentid+separator+subcmpanyid1+separator+seclevel+separator+nowmanagerstr);
    }

        /*
        CREATE procedure Tri_U_HrmresourceShare
        (
        in id integer ,
        in departmentid integer,
        in subcompanyid1 integer,
        in seclevel integer,
        in managerstr varchar(200)
        )
        */

        //add by wjy
        //同步RTX端的用户信息.
        OrganisationCom.editUser(Integer.parseInt(id));

        // 改为自进行修正
        ResourceComInfo.updateResourceInfoCache(id);

        SysMaintenanceLog.resetParameter();
    	SysMaintenanceLog.setRelatedId(Util.getIntValue(id));
    	SysMaintenanceLog.setRelatedName(ResourceComInfo.getResourcename(id));
        SysMaintenanceLog.setOperateItem("29");
        SysMaintenanceLog.setOperateUserid(user.getUID());
        SysMaintenanceLog.setClientAddress(request.getRemoteAddr());
    	SysMaintenanceLog.setOperateType("2");
    	SysMaintenanceLog.setOperateDesc("HrmResourceBasicInfo_Update");
    	SysMaintenanceLog.setSysLogInfo();

        if(isView == 0){
            response.sendRedirect("HrmResourceBasicInfo.jsp?id="+id);
        }else{
            response.sendRedirect("HrmResource.jsp?id="+id);
        }
        return;
    }

    if(operation.equalsIgnoreCase("editcontactinfo")){

        String id = Util.null2String(fu.getParameter("id"));
        String locationid = Util.fromScreen(fu.getParameter("locationid"),user.getLanguage());
        String workroom = Util.fromScreen(fu.getParameter("workroom"),user.getLanguage());
        String telephone = Util.fromScreen(fu.getParameter("telephone"),user.getLanguage());
        String mobile = Util.fromScreen(fu.getParameter("mobile"),user.getLanguage());
        String mobilecall = Util.fromScreen(fu.getParameter("mobilecall"),user.getLanguage());
        String fax = Util.fromScreen(fu.getParameter("fax"),user.getLanguage());
        String systemlanguage = Util.fromScreen(fu.getParameter("systemlanguage"),user.getLanguage());
        if(systemlanguage.equals("")||systemlanguage.equals("0")){
         systemlanguage = "7";
        }
        String email = Util.fromScreen(fu.getParameter("email"),user.getLanguage());

        para =""+id    +separator+locationid+separator+workroom  +separator+
            telephone+separator+ mobile   +separator+mobilecall+separator+
            fax+separator+systemlanguage+separator+email;
        rs.executeProc("HrmResourceContactInfo_Update",para);


        //add by wjy
        //同步RTX端的用户信息.
        OrganisationCom.editUser(Integer.parseInt(id));
        // 改为自进行修正
        ResourceComInfo.updateResourceInfoCache(id);

      	SysMaintenanceLog.resetParameter();
    	SysMaintenanceLog.setRelatedId(Util.getIntValue(id));
    	SysMaintenanceLog.setRelatedName(ResourceComInfo.getResourcename(id));
        SysMaintenanceLog.setOperateItem("29");
        SysMaintenanceLog.setOperateUserid(user.getUID());
        SysMaintenanceLog.setClientAddress(request.getRemoteAddr());
    	SysMaintenanceLog.setOperateType("2");
    	SysMaintenanceLog.setOperateDesc("HrmResourceContactInfo_Update");
    	SysMaintenanceLog.setSysLogInfo();

      if(isView == 0){
        response.sendRedirect("HrmResourceBasicInfo.jsp?id="+id);
      }else{
        response.sendRedirect("HrmResource.jsp?id="+id);
      }
      return;
    }

    if(operation.equalsIgnoreCase("editpersonalinfo")){
        String id = Util.null2String(fu.getParameter("id"));
        String birthday = Util.fromScreen(fu.getParameter("birthday"),user.getLanguage());
        String folk = Util.fromScreen(fu.getParameter("folk"),user.getLanguage()) ;	 /*民族*/
        String nativeplace = Util.fromScreen(fu.getParameter("nativeplace"),user.getLanguage()) ;	/*籍贯*/
        String regresidentplace = Util.fromScreen(fu.getParameter("regresidentplace"),user.getLanguage()) ;	/*户口所在地*/
        String maritalstatus = Util.fromScreen(fu.getParameter("maritalstatus"),user.getLanguage());
        String policy = Util.fromScreen(fu.getParameter("policy"),user.getLanguage()) ; /*政治面貌*/
        String bememberdate = Util.fromScreen(fu.getParameter("bememberdate"),user.getLanguage()) ;	/*入团日期*/
        String bepartydate = Util.fromScreen(fu.getParameter("bepartydate"),user.getLanguage()) ;	/*入党日期*/
        String islabourunion = Util.fromScreen(fu.getParameter("islabouunion"),user.getLanguage()) ;
        String educationlevel = Util.fromScreen(fu.getParameter("educationlevel"),user.getLanguage()) ;/*学历*/
        String degree = Util.fromScreen(fu.getParameter("degree"),user.getLanguage()) ; /*学位*/
        String healthinfo = Util.fromScreen(fu.getParameter("healthinfo"),user.getLanguage()) ;/*健康状况*/
        String height = Util.fromScreen(fu.getParameter("height"),user.getLanguage()) ;/*身高*/
        String weight = Util.fromScreen(fu.getParameter("weight"),user.getLanguage()) ;
        String residentplace = Util.fromScreen(fu.getParameter("residentplace"),user.getLanguage()) ;	/*现居住地*/
        String homeaddress = Util.fromScreen(fu.getParameter("homeaddress"),user.getLanguage()) ;
        String tempresidentnumber = Util.fromScreen(fu.getParameter("tempresidentnumber"),user.getLanguage()) ;
        String certificatenum = Util.fromScreen(fu.getParameter("certificatenum"),user.getLanguage()) ;/*证件号码*/
        int iscreate = Util.getIntValue(fu.getParameter("iscreate"),0);
        certificatenum=certificatenum.trim();
        String tempcertificatenum=certificatenum;
        int msg=0;
        if(!certificatenum.equals("")){
            rs.executeSql("select id from HrmResource where id<>"+id+" and certificatenum='"+certificatenum+"'");
            if(rs.next()){
                msg=1;
				rs.executeSql("select certificatenum from HrmResource where id="+id);
				if(rs.next()){
					tempcertificatenum=Util.null2String(rs.getString("certificatenum"));
				}
            }            
        }
        para = ""+id+	separator+birthday+separator+folk+separator+nativeplace+separator+regresidentplace+separator+
             maritalstatus+	separator+policy+separator+bememberdate+separator+bepartydate+separator+islabourunion+
             separator+educationlevel+separator+degree+separator+healthinfo+separator+height+separator+weight+
             separator+residentplace+separator+homeaddress+separator+tempresidentnumber+separator+tempcertificatenum;

        rs.executeProc("HrmResourcePersonalInfo_Insert",para);
        rs.executeProc("HrmResource_ModInfo",""+id+separator+userpara);

        int rownum = Util.getIntValue(fu.getParameter("rownum"),user.getLanguage()) ;
        rs.executeProc("HrmFamilyInfo_Delete",""+id);
        for(int i = 0;i<rownum;i++){
            String member = Util.fromScreen(fu.getParameter("member_"+i),user.getLanguage());
            String title = Util.fromScreen(fu.getParameter("title_"+i),user.getLanguage());
            String company = Util.fromScreen(fu.getParameter("company_"+i),user.getLanguage());
            String jobtitle = Util.fromScreen(fu.getParameter("jobtitle_"+i),user.getLanguage());
            String address = Util.fromScreen(fu.getParameter("address_"+i),user.getLanguage());
            String info = member+title+company+jobtitle+address;
            if(!info.trim().equals("")){
                para = ""+id+separator+member+separator+title+separator+company+separator+jobtitle+separator+address;

                rs.executeProc("HrmFamilyInfo_Insert",para);
            }
        }

        //处理自定义字段 add by wjy
        CustomFieldTreeManager.editCustomData("HrmCustomFieldByInfoType", Util.getIntValue(fu.getParameter("scopeid"),0), fu, Util.getIntValue(id,0));
        CustomFieldTreeManager.editMutiCustomData("HrmCustomFieldByInfoType", Util.getIntValue(fu.getParameter("scopeid"),0), fu, Util.getIntValue(id,0));

        // 个人信息不需要清理人力资源缓存 ResourceComInfo.removeResourceCache();

      	SysMaintenanceLog.resetParameter();
    	SysMaintenanceLog.setRelatedId(Util.getIntValue(id));
    	SysMaintenanceLog.setRelatedName(ResourceComInfo.getResourcename(id));
        SysMaintenanceLog.setOperateItem("29");
        SysMaintenanceLog.setOperateUserid(user.getUID());
        SysMaintenanceLog.setClientAddress(request.getRemoteAddr());
    	SysMaintenanceLog.setOperateType("2");