personbean.java

企业员工信息管理系统

		}
		else if(strBMNO.equals(ds.toString(strOrgNO)))//部门未改变,更新级别序号
		{
			if(jbxh==0||jbxh>=maxjbNo)
				{ jbxh=maxjbNo-1;strJBXH=""+jbxh;}
			if(jbxh < yjbxh){
				String sql1="update ZZ_ZGB set JBXH=JBXH+1 where BMBH='"
							+ strOrgNO	
							+ "' and ZZZT=0 and JBXH >=" 
							+ jbxh
							+ "  and  JBXH<"
							+ yjbxh;
				deleteRecord(sql1);
			}
			else if(jbxh > yjbxh && yjbxh!=0){
				String sql2="update ZZ_ZGB set JBXH=JBXH-1 where BMBH='"
							+ strOrgNO	
							+ "' and ZZZT=0 and JBXH <=" 
							+ jbxh
							+ "  and  JBXH>"
							+ yjbxh;
				deleteRecord(sql2);
			}
		}
		else//部门发生改变,更新级别序号
		{///修改原部门内人员级别序号
			String sql3="update ZZ_ZGB set JBXH=JBXH-1 where BMBH='"
						+ strBMNO	
						+ "' and ZZZT=0 and JBXH >" 
						+ yjbxh;
			deleteRecord(sql3);
			////修改新部门内人员级别序号
			maxjbNo=makeID("ZZ_ZGB","BMBH","ZZZT","JBXH",strOrgNO,"0",false,true);
			if(!strJBXH.equals(""))
				jbxh=Integer.parseInt(strJBXH);
			if(jbxh==0||jbxh>maxjbNo)
				{ jbxh=maxjbNo;strJBXH=""+jbxh;}
			String sql4="update ZZ_ZGB set JBXH=JBXH+1 where BMBH='"+ strOrgNO + "' and ZZZT=0 and JBXH >=" + jbxh ;
			deleteRecord(sql4);
		}
/////////////////////////////////////////////
		Vector vect = new Vector();
		vect.add("ZZ_ZGB");
		vect.add(addVector("BMBH",strOrgNO,"CHAR"));
		vect.add(addVector("XM",strXM,"CHAR"));
		vect.add(addVector("GH",strGH,"CHAR"));
//		vect.add(addVector("CZQX",strCZQX,"CHAR"));
//		vect.add(addVector("LCQX",strLCQX,"CHAR"));
		vect.add(addVector("PZCS",strPZCS,"CHAR"));
		vect.add(addVector("MMWT",strMMWT,"CHAR"));
		vect.add(addVector("MMDA",strMMDA,"CHAR"));
		if(strMM!=null && !strMM.equals(""))
		{
			strMM = (new MD5()).toMD5(strMM);
			vect.add(addVector("MM",strMM,"CHAR"));
		}
		vect.add(addVector("XB",strXB,"CHAR"));
		vect.add(addVector("CSNY",strCSNY,"CHAR"));
		vect.add(addVector("MZ",strMZ,"CHAR"));
		vect.add(addVector("ZZMM",strZZMM,"CHAR"));
		vect.add(addVector("XL",strXL,"CHAR"));
		vect.add(addVector("ZC",strZC,"CHAR"));
		vect.add(addVector("QQ",strQQ,"CHAR"));
		vect.add(addVector("BGDH",strBGDH,"CHAR"));
		vect.add(addVector("FJDH",strFJDH,"CHAR"));
		vect.add(addVector("YZBM",strYZBM,"CHAR"));
		vect.add(addVector("JTDZ",strJTDZ,"CHAR"));
		vect.add(addVector("JTDH",strJTDH,"CHAR"));
		vect.add(addVector("YDDH",strYDDH,"CHAR"));
		vect.add(addVector("EMAIL",stremail,"CHAR"));
		vect.add(addVector("ZZZT",strZZZT,"NUM"));
//
		vect.add(addVector("YHM",strYHM,"CHAR"));
		vect.add(addVector("ZCRQ",strZCRQ,"CHAR"));
//		vect.add(addVector("DJGL",strDJGL,"CHAR"));
//		vect.add(addVector("FBWZ",strFBWZ,"NUM"));
//		vect.add(addVector("GLYH",strGLYH,"NUM"));
		vect.add(addVector("GRJJ",strGRJJ,"CHAR"));
		vect.add(addVector("JBXH",strJBXH,"NUM"));
		vect.add(addVector("ZNYH",strZNYH,"NUM"));
		vect.add("ZGBH = "+strPersonNO+"");

		//检验工号是否已经存在
		String sql = "select GH from ZZ_ZGB where GH='"+ strGH + "' and ZZZT=0 and ZGBH<>'"+ strPersonNO +"'";
		ResultSet rs =selectRecord(sql);
		try{
			if (rs.next())
				return 5;
			else  //检验用户名是否已经存在
			{
				stmt = rs.getStatement();rs.close();stmt.close();
				sql = "select YHM from ZZ_ZGB where YHM='"+ strYHM + "' and ZZZT=0 and ZGBH<>'"+ strPersonNO +"'";
				rs = selectRecord(sql);
				if(rs.next())
					return 6;
			}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		updateRecord(vect);
		return 0;
	}

	//删除当前人员数据记录
	public int delPerson()
	{
		String sql=""; 
		ResultSet rst = selectRecord("select JBXH from ZZ_ZGB where ZGBH='"	
			+ strPersonNO + "' and ZZZT=0");
		Statement stmt = null;
		int yjbxh=999;
		try{
			if(rst.next())
				yjbxh=Integer.parseInt(rst.getString("JBXH"));
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rst!=null)try{ stmt = rst.getStatement(); rst.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		sql="update ZZ_ZGB set JBXH=JBXH-1 where BMBH='"
					+ getBMBH()
					+ "' and ZZZT=0 and JBXH >" 
					+ yjbxh;
		//System.out.println(sql);
		deleteRecord(sql);
		sql = "update ZZ_ZGB set ZZZT = 3 where ZGBH = '"+strPersonNO+"'";
		deleteRecord(sql);

		sql = "delete from ZZ_ZGZWB where ZGBH = '"+strPersonNO+"'";
		return deleteRecord(sql);

	}
	public void delDBPs()//从数据库中永久删除离退休等人员信息
	{
		String sql=""; 
		sql = "delete from ZZ_ZGB where ZGBH = '"+strPersonNO+"'";

		deleteRecord(sql);
	}

	public void resumePs() //恢复挂起人员
	{
		String sql=""; 
		sql = "update ZZ_ZGB set ZZZT=0 where ZGBH = '"+strPersonNO+"'";
		executeUpdate(sql);
	}

	//取得当前职工在当前部门的操作权限
	public String getOper()
	{
		String strOper = "";
		String sql = "";
		String strMRCZ = "1";
		String strSYZT = "0";
		String str1 = ",";
		String str2 = "@";
		String strBMBH = "";
		String strZWBH = "";
		String strMax = "";
		int i,j;
		
		sql = " select CZQX from ZZ_ZGZWB where ZGBH = '"+strPersonNO+"' ";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		while(rs.next())//在ZZ_ZGZWB表找此职工所有职务的权限
		{   		
			String strX = ds.toString(rs.getString(1));//取得某一职务的权限
			if (!strX.equals(""))
			{						
				strMax+=strX+str2;
			}
		}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		if(strMax.equals(""))//如果ZZ_ZGZWB中的操作权限为空,在ZZ_ZWB表找此职工所有职务的权限
		{
			sql = "select a.CZQX from ZZ_ZWB a,ZZ_ZGZWB b where ZGBH = '"+strPersonNO+"' and a.zwzt<>1 and a.BMBH = b.BMBH and a.ZWBH = b.ZWBH  ";
			rs = selectRecord(sql);
			try{
				while(rs.next())//把此职工的所有职务的权限用（@）分割存储
				{
					String strX = ds.toString(rs.getString(1));//取得某一职务的权限
					if (!strX.equals(""))
					{						
						strMax+=strX+str2;
					}
				}
			}catch(Exception e){System.out.println("运行时出错："+e);}
			finally{
				if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
				if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
			}
			if(strMax.equals(""))//判断是否启用默认权限，空则用默认权限
			{
				sql = "select ID from CODE_ANCZQXB where MRCZ = "+strMRCZ+" and SYZT = "+strSYZT+"";
				ResultSet r = selectRecord(sql);
				try{
				while(r.next())
				{
					strOper+=ds.toString(r.getString("ID"))+str1;
				}
				}catch(Exception e){System.out.println("运行时出错："+e);}
				finally{
					if(r!=null)try{ stmt = r.getStatement(); r.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
					if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
				}
				if(strOper.length()!=0)
					strOper = strOper.substring(0,strOper.length()-1);
				if(strOper.length()==0)
					strOper = "";
				return strOper;				
			}
		}

		strMax = strMax.substring(0,strMax.length()-1);
		String strMaxOper[] = strMax.split("@");
		strMax = ",";
		for(i=0;i<strMaxOper.length;i++)//取得此职工最大权限集合strMax
		{
			String strEp[] = strMaxOper[i].split(",");
			for(j=0;j<strEp.length;j++)
			{
				strEp[j] = strEp[j];
				/*String[] s = strMax.split(",");
				boolean f = true;
				for(int k=0;k<s.length;k++){
					if(strEp[j].equals(s[k])){
						f = false;
						break;
					}
				}*/
				if(strMax.indexOf("," + strEp[j] + ",")==-1)
				{
					strMax+=strEp[j]+str1;
				}
			}
		}
		strOper = strMax;
		strOper = strOper.substring(1,strOper.length()-1);
		/*	String strOpers[] = strOper.split(",");
			for(i=0;i<strOpers.length;i++)//根据分割后的编号取得模块名称
			{
				strOper+=db.toName("CODE_ANCZQXB","MKBH","MKMC",strOpers[i])+str1;
			}
			strOper = strOper.substring(0,strOper.length()-1);*/
		return strOper;
	}

	//取得当前操作者能够分配的操作权限(即 在某部门能够'分配职务'才能够分配在此部门的操作权限)
	public String getOper_lm()
	{
		String strOper = "";
		String sql = "";
		String strMRCZ = "1";
		String strSYZT = "0";
		String str1 = ",";
		String str2 = "@";
		String strBMBH = "";
		String strZWBH = "";
		String strMax = "";
		int i,j;
		
		sql = " select x.CZQX from ZZ_ZGZWB x,zz_zwb y where x.ZGBH = '"+strPersonNO+"' and y.zwzt<>1 and x.bmbh=y.bmbh and x.zwbh=y.zwbh and x.BMBH in ( select distinct a.BMBH from ZZ_ZGZWB a,ZZ_ZWB b where a.ZGBH='"+strPersonNO+"' and (a.CZQX like '%,73%' or a.CZQX like '%,73%,' or a.CZQX like '%73%,' or b.CZQX like '%,73%' or b.CZQX like '%,73%,' or b.CZQX like '%73%,') and b.zwzt<>1 and a.BMBH=b.BMBH and a.ZWBH=b.ZWBH  ) ";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		while(rs.next())//在ZZ_ZGZWB表找此职工所有职务的权限
		{   		
			String strX = ds.toString(rs.getString(1));//取得某一职务的权限
			if (!strX.equals(""))
			{						
				strMax+=strX+str2;
			}
		}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}

		if(strMax.equals(""))//如果ZZ_ZGZWB中的操作权限为空,在ZZ_ZWB表找此职工所有职务的权限
		{
			sql = "select a.CZQX from ZZ_ZWB a,ZZ_ZGZWB b where ZGBH = '"+strPersonNO+"' and a.zwzt<>1 and a.BMBH = b.BMBH and a.ZWBH = b.ZWBH and  b.BMBH in ( select distinct a.BMBH from ZZ_ZGZWB a,ZZ_ZWB b where a.ZGBH='"+strPersonNO+"' and b.zwzt<>1 and (a.CZQX like '%,73%' or a.CZQX like '%,73%,' or a.CZQX like '%73%,' or b.CZQX like '%,73%' or b.CZQX like '%,73%,' or b.CZQX like '%73%,') and a.BMBH=b.BMBH and a.ZWBH=b.ZWBH   ) ";
			rs = selectRecord(sql);
			try{
			while(rs.next())//把此职工的所有职务的权限用（@）分割存储
			{
				String strX = ds.toString(rs.getString(1));//取得某一职务的权限
				if (!strX.equals(""))
				{						
					strMax+=strX+str2;
				}
			}
			}catch(Exception e){System.out.println("运行时出错："+e);}
			finally{
				if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
				if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
			}

			if(strMax.equals(""))//判断是否启用默认权限，空则用默认权限
			{
				sql = "select ID from CODE_ANCZQXB where MRCZ = "+strMRCZ+" and SYZT = "+strSYZT+"";
				ResultSet r = selectRecord(sql);
				try{
				while(r.next())
				{
					strOper+=ds.toString(r.getString("ID"))+str1;
				}
				}catch(Exception e){System.out.println("运行时出错："+e);}
				finally{
					if(r!=null)try{ stmt = r.getStatement(); r.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
					if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
				}
				if(strOper.length()!=0)
					strOper = strOper.substring(0,strOper.length()-1);
				if(strOper.length()==0)
					strOper = "";
				return strOper;				
			}
		}
		strMax = strMax.substring(0,strMax.length()-1);
		String strMaxOper[] = strMax.split("@");
		strMax = ",";
		for(i=0;i<strMaxOper.length;i++)//取得此职工最大权限集合strMax
		{
			String strEp[] = strMaxOper[i].split(",");
			for(j=0;j<strEp.length;j++)
			{
				strEp[j] = strEp[j];
				/*String[] s = strMax.split(",");
				boolean f = true;
				for(int k=0;k<s.length;k++){
					if(strEp[j].equals(s[k])){
						f = false;
						break;
					}
				}*/
				if(strMax.indexOf("," + strEp[j] + ",")==-1)
				{
					strMax+=strEp[j]+str1;
				}
			}
		}
		strOper = strMax;
		strOper = strOper.substring(1,strOper.length()-1);
		/*	String strOpers[] = strOper.split(",");
			for(i=0;i<strOpers.length;i++)//根据分割后的编号取得模块名称
			{
				strOper+=db.toName("CODE_ANCZQXB","MKBH","MKMC",strOpers[i])+str1;
			}
			strOper = strOper.substring(0,strOper.length()-1);*/
		return strOper;
	}
	//将getOper返回的操作权限编号转为汉字      new  李伯华
	public String toOperName(String strOperNo)
	{
		String strOper="";
		String strOpers[] = strOperNo.split(",");
		for(int i=0;i<strOpers.length;i++)//根据分割后的编号取得模块名称
		{
			strOper+=db.toName("CODE_ANCZQXB","ID","MKMC",strOpers[i])+":"+db.toName("CODE_ANCZQXB","ID","ANMC",strOpers[i])+",";
		}
		strOper = strOper.substring(0,strOper.length()-1);
		return strOper;
	}
	//将getFlow返回的流程权限编号转为汉字    new  李伯华
	public String toFlowName(String strFlowNo)
	{
		String strFlow="";
		String strFlows[] = strFlowNo.split(",");
		for(int i=0;i<strFlows.length;i++)//根据分割后的编号取得模块名称
		{
			strFlow+=db.toName("CODE_LCQXB","MKBH","MKMC",strFlows[i])+",";
		}
		strFlow = strFlow.substring(0,strFlow.length()-1);
		return strFlow;
	}
	//通过职工编号得到当前职务的流程权限，没转化为汉字
	public String getFlow()
	{
		String strFlow = "";
		String sql = "";