package oa.bean;

import java.text.*;
import java.util.*;
import java.lang.*;
import java.io.*;
import java.sql.*;
import oa.main.*;
//import javax.swing.tree.DefaultMutableTreeNode;

public class PersonDutyBean extends ParentBean
{
	String PersonNo="";//職工編號(hào)
    String DutyOrgNo="";//職務(wù)部門(mén)編號(hào)
    String DutyNo="";//職務(wù)編號(hào)

	//構(gòu)造函數(shù)
	public PersonDutyBean() 
	{
	}
	//設(shè)置部門(mén)編號(hào)
	public void setDutyOrgNo(String DutyOrgNo)
	{
		this.DutyOrgNo = DutyOrgNo;
	}
	//設(shè)置職工編號(hào)
	public void setPersonNo(String PersonNo)
	{
		this.PersonNo = PersonNo;
	}

	//通過(guò)部門(mén)編號(hào)得到部門(mén)名稱(chēng)
	public String getOrgName(String strOrgNo)
	{
		return toName("ZZ_BMB","BMBH","BMMC",strOrgNo);
	}

	public Vector getBMMC(String strPersonNo)//通過(guò)職工編號(hào)得到ZZ_ZGZWB的所有BMMC記錄	
	{
		Vector vt = new Vector();
		String sql = "";
		String bmbh = "";
		String bmName = "";

		sql = "select BMBH from ZZ_ZGZWB where ZGBH='"+strPersonNo+"' order by BMBH";
		ResultSet rs = selectRecord(sql);
		ResultSet rst = null;
		Statement stmt = null;
		try{
		while(rs.next())
		{	
			String bmbh1 = ds.toString(rs.getString("BMBH"));
			if(bmbh1.equals(bmbh))
			{
				continue;
			}
			else
			{
				bmbh = bmbh1;
				sql = "select BMMC from ZZ_BMB where BMBH='"+bmbh+"'";
				rst = selectRecord(sql);
				try{
					if(rst.next()){
						bmName = ds.toString(rst.getString("BMMC"));
						Hashtable ht = new Hashtable();
						ht.put("BMBH",bmbh);
						ht.put("BMMC",bmName);
						vt.add(ht);	
					}
				}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
				finally{
					if(rst!=null)try{ stmt = rst.getStatement(); rst.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
					if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
				}
			}
		}
		}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
		}
		return vt;
	}

	//通過(guò)職工編號(hào)得到職工姓名
	public String getPersonName(String strPersonNo)
	{
		return toName("ZZ_ZGB","ZGBH","XM",strPersonNo);
	}

	//通過(guò)職工編號(hào)得到ZZ_ZGZWB的BMMC_ZWMC記錄
	public String getBMMC_ZWMC(String strPersonNo)
	{
		String sql = " select a.BMBH,b.zwmc,b.zwzt from ZZ_ZGZWB a,zz_zwb b where a.ZGBH='"+strPersonNo+"' and a.bmbh=b.bmbh and a.zwbh=b.zwbh ";
		ResultSet rs = selectRecord(sql);
		String bmName="",zwName="",mixName="",dutyzt="";
		Statement stmt = null;
		DutyBean dutybn = null;
		PersonBean psbn = null;
		try{
		while(rs.next())
		{	
			String bmbh = ds.toString(rs.getString("BMBH"));						
			bmName = getName(bmbh);
			zwName = ds.toString(rs.getString("ZWMC"));		
			dutyzt = ds.toString(rs.getString("ZWZT"));	
			if (dutyzt.equals("1"))
			{
				dutyzt = "(掛起)";
			}
			else
				dutyzt = "";

			if(!mixName.equals(""))
				mixName += "\n"+bmName+":"+zwName+dutyzt;
			if(mixName.equals(""))
				mixName = bmName+":"+zwName+dutyzt;
		}
		if(mixName.equals("")){
			dutybn = new DutyBean();
			psbn = new PersonBean();
			psbn.setPersonNO(strPersonNo);	 
			String BMBH = psbn.getBMBH();	
			String zwNo = dutybn.getOrdinaryZWBH(BMBH,"一般員工");
			if(zwNo.equals("")){
				Hashtable dutyhash = new Hashtable();
				dutyhash.put("BMBH",BMBH);
				dutyhash.put("ZWMC","一般員工");
				dutyhash.put("CZQX","");
				dutyhash.put("LCQX","");
				dutyhash.put("PZCS","");
				dutyhash.put("JBXH","");
				dutyhash.put("ZWZT","0");
				dutybn.addDuty(dutyhash);
				zwNo = dutybn.getOrdinaryZWBH(BMBH,"一般員工");
			}
			addRec(strPersonNo,BMBH,zwNo,"","");
			mixName = getBMMC_ZWMC(strPersonNo);
		}
		}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
		finally{
			if(psbn!=null) psbn.closeConn();
			if(dutybn!=null)dutybn.closeConn();
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
		}
		return mixName;
		
	}
	public Vector getData(String strPersonNo)//通過(guò)職工編號(hào)得到ZZ_ZGZWB的所有記錄
	{
		Vector vt = new Vector();
		String sql ="select BMBH,ZWBH from ZZ_ZGZWB where ZGBH='"+strPersonNo+"'";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		DutyBean dutybn = null;
		PersonBean psbn = null;
		try{
		while(rs.next())
		{	
			String bmbh = ds.toString(rs.getString("BMBH"));
			String zwbh = ds.toString(rs.getString("ZWBH"));
			Hashtable ht = new Hashtable();
			ht.put("BMBH",bmbh);
			ht.put("ZWBH",zwbh);
			vt.add(ht);
		}
		if(vt.size()==0){
			dutybn = new DutyBean();
			psbn = new PersonBean();
			psbn.setPersonNO(strPersonNo);
			String BMBH = psbn.getBMBH();
			String zwNo = dutybn.getOrdinaryZWBH(BMBH,"一般員工");
			if(zwNo.equals("")){
				Hashtable dutyhash = new Hashtable();
				dutyhash.put("BMBH",BMBH);
				dutyhash.put("ZWMC","一般員工");
				dutyhash.put("CZQX","");
				dutyhash.put("LCQX","");
				dutyhash.put("PZCS","");
				dutyhash.put("JBXH","");
				dutyhash.put("ZWZT","0");
				dutybn.addDuty(dutyhash);
				zwNo = dutybn.getOrdinaryZWBH(BMBH,"一般員工");
			}
			addRec(strPersonNo,BMBH,zwNo,"","");
			vt = getData(strPersonNo);
		}
		}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
			if(psbn!=null) psbn.closeConn();
			if(dutybn!=null)dutybn.closeConn();
		}
		return vt;
	}

	//通過(guò)職務(wù)名稱(chēng)得到職務(wù)編號(hào)
	public String getDutyNo(String strDutyName)
	{
		String dutyno = "";
		String sql = "select ZWBH from ZZ_ZWB where trim(ZWMC)='"+strDutyName+"' and BMBH='"+DutyOrgNo+"'";

		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		while(rs.next())
			dutyno = ds.toString(rs.getString("ZWBH"));
		}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
		}
		return dutyno;
	}

	//通過(guò)職務(wù)編號(hào)得到職務(wù)名稱(chēng)
	public String getDutyName(String strDutyNo)
	{
		String dutyname = "";
		String sql = "select ZWMC from ZZ_ZWB where ZWBH='"+strDutyNo+"' and BMBH='"+DutyOrgNo+"'";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		while(rs.next())
			dutyname = ds.toString(rs.getString("ZWMC"));
		}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
		}
		return dutyname;
	}

	
	//檢查ZZ_ZGZWB中是否已經(jīng)由此條記錄
	public boolean hasRect(String personno,String dutyOrgno,String dutyno)
	{
		boolean b = false;
		String sql="select * from ZZ_ZGZWB where ZGBH='"+personno+"' and BMBH='"+dutyOrgno+"' and ZWBH='"+dutyno+"'";
		ResultSet rs=db.QuerySQL(sql);
		Statement stmt = null;
		try{
			if(rs.next()){
				b = true;
			}
		}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
		}
		return b;
	}
	
	//判斷ZZ_ZGB中是否有輸入的部門(mén)名稱(chēng)、職工編號(hào)、職工姓名的對(duì)應(yīng)紀(jì)錄
	public int hasPerson(String orgName,String personno,String personname)
	{
		String sql="select * from ZZ_ZGB where BMBH='"+orgName+"' and ZGBH='"+personno+"' and XM='"+personname+"'";
		ResultSet rs=db.QuerySQL(sql);
		Statement stmt = null;
		try{
			if(rs.next())
				return 0;		    
		}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
		}
		return 1;
	}

	//判斷ZZ_ZWB是否有輸入的部門(mén)名稱(chēng)、職務(wù)名稱(chēng)的對(duì)應(yīng)紀(jì)錄
	public int hasOrgDuty(String orgName,String dutyName)
	{
		String sql="select * from ZZ_ZWB where BMMC='"+orgName+"' and ZWMC='"+dutyName+"'";
		ResultSet rs=selectRecord(sql);
		Statement stmt = null;
		try{
			if(rs.next())
				return 0;		 
		}catch(Exception e){System.out.println("運(yùn)行時(shí)出錯(cuò)："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
		}
		return 1;
	}

	public void addRec(String personno,String dutyOrgno,String dutyno,String czqx,String lcqx,boolean rebuild)
	{
		ResultSet rs = selectRecord(" select * from zz_zgzwb where zgbh='"+personno+"' and bmbh='"+dutyOrgno+"' and zwbh="+dutyno+" ");
		//System.out.println("Enter Bean!!!!!!!			"+rs);
		Statement stmt = null;
		RightBean rb = null;
		MakeNews news = null;
		try{
			if(!rs.next())
			{
				Vector vect=new Vector();
				vect.add("ZZ_ZGZWB");
				vect.add(addVector("ZGBH",personno,"CHAR"));
				vect.add(addVector("BMBH",dutyOrgno,"CHAR"));
				vect.add(addVector("ZWBH",dutyno,"CHAR"));
				vect.add(addVector("CZQX",czqx,"CHAR"));
				vect.add(addVector("LCQX",lcqx,"CHAR"));
			
				insertRecord(vect);

				if(!rebuild)
					return;

				PublicData.rebuildFlowVector();
				PublicData.rebuildRightVector();