package huayi.xxzx.personalmessage;
import java.sql.*;
import java.util.*;
public class personalmessage{
	public personalmessage(){
	}
	public String getname(String id)
	{
		String name="";
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		String sqlname="select * from T_YGDLXXB where YGBH='"+id+"'";
		ResultSet rsname=myConn.executeQuery(sqlname);
		try{
			while(rsname.next())
			{
				name=rsname.getString("YGXM");
			}
			return name;
		}catch(Exception e){System.out.print(e.toString());}
		return name;
	}
	public String getdepartment(String id)
	{
		String department="";
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		String sqldep="select * from V_PERSONAL where YGBH='"+id+"'";
		ResultSet rsdep=myConn.executeQuery(sqldep);
		try
		{
			while(rsdep.next())
			{
				department=rsdep.getString("BMMC");
			}
			return department;
		}catch(Exception e){System.out.print(e.toString());}
		return department;
	}
	public String getduty(String id)
	{
		String duty="";
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		String sqlduty="select * from V_PERSONAL where YGBH='"+id+"'";
		ResultSet rsduty=myConn.executeQuery(sqlduty);
		try
		{
			while(rsduty.next())
			{
				duty=rsduty.getString("ZWJC");
			}
			return duty;
		}catch(Exception e){System.out.print(e.toString());}
		return duty;
	}
	public int getrollcount(String id)
	{
		int rollcount=0;//投票的數(shù)目；
		huayi.xxzx.nowtime.nowtime day=new huayi.xxzx.nowtime.nowtime();
		String today=day.getdate();
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		huayi.xxzx.contraststr.contraststr cst=new huayi.xxzx.contraststr.contraststr();
		String sqlroll="select * from V_TP where TPZBH='"+id+"'";
		ResultSet rsroll=myConn.executeQuery(sqlroll);
		String deadline="";
		try
		{
			while(rsroll.next())
			{
				deadline=rsroll.getString("TPJZSJ");
				if(cst.contraststr(today,deadline))
					rollcount++;
			}
			return rollcount;
		}catch(Exception e){System.out.print(e.toString());}
		return rollcount;
	}
	public int gettaskcount(String id)
	{
		huayi.xxzx.nowtime.nowtime day=new huayi.xxzx.nowtime.nowtime();
		String today=day.getdate();
		int taskcount=0;
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		huayi.xxzx.contraststr.contraststr cst=new huayi.xxzx.contraststr.contraststr();
		String sqltask="select * from T_DBSY where YGBH='"+id+"'";
		ResultSet rstask=myConn.executeQuery(sqltask);
		String deadline="";
		try{
			while(rstask.next())
			{
				deadline=rstask.getString("JSSJ");
				if(cst.contraststr(today,deadline))
					taskcount++;
			}
			return taskcount;
		}catch(Exception e){System.out.print(e.toString());}
		return taskcount;
	}
}