package org.pan.web;

import java.sql.*;
import java.util.Vector;
import java.util.Calendar;
import org.pan.util.*;
import javax.servlet.http.HttpServletRequest;
import org.pan.web.employee;

/**
 * Title:       員工信息管理類
 * Description:
 * Copyright:    Copyright (c) 2008
 * @author:		 雙魚林
 * @version 1.0
 */

public class employeeManage extends DataBase {
	private employee oneEmployee = new employee();	//新的一個員工
	private javax.servlet.http.HttpServletRequest request; //建立頁面請求
	private boolean sqlflag = true ;		//對接收到的數(shù)據(jù)是否正確
	private Vector employeelist;				//顯示員工列表向量數(shù)組
	private int page = 1;					//顯示的頁碼
	private int pageSize=5;				//每頁顯示的圖書數(shù)
	private int pageCount =0;				//頁面總數(shù)
	private long recordCount =0;			//查詢的記錄總數(shù)
  public String errorMessage = "";           //保存出錯信息
  public String sqlStr = "";

	
	public employeeManage() throws Exception{
		super();
	}

	public Vector getEmployeelist() {
		return employeelist;
	}

	public boolean getSqlflag() {
		return sqlflag;
	}

	public String getGbk( String str) {
		try
		{
			return new String(str.getBytes("ISO8859-1"));
		}
		catch (Exception e)
		{
			return str;
		}
	}
	
	//將頁面表單傳來的資料分解并保存到員工類的各個字段中
	public boolean getRequest(javax.servlet.http.HttpServletRequest newrequest) {
		boolean flag = false;
		try
		{	
			request = newrequest;
			String employeeId = request.getParameter("employeeId");
			if(null == employeeId || employeeId.equals("")) {
				employeeId = "";
				sqlflag = false;
			}
			oneEmployee.setEmployeeId(getGbk(employeeId));
			
			String name = request.getParameter("name");
			if (name==null || name.equals("")) {
				name = "";
				sqlflag = false;
			}
			oneEmployee.setName(getGbk(name));
			
			String cardNumber = request.getParameter("cardNumber");
			if(null == cardNumber || cardNumber.equals("")) {
				cardNumber = "";
			}
			oneEmployee.setCardNumber(getGbk(cardNumber));
			
			String nation = request.getParameter("nation");
			if(null == nation || nation.equals("")) {
				nation = "";
			}
			oneEmployee.setNation(getGbk(nation));
			
			String sex = request.getParameter("sex");
			if(null == sex || sex.equals("")) {
				sex = "";
			}
			oneEmployee.setSex(getGbk(sex));
			
			String birthday = request.getParameter("birthday");
			if(null == birthday || birthday.equals("")) {
				birthday = ""; 
			}
			oneEmployee.setBirthday(getGbk(birthday));
			
		  String graduateSchool = request.getParameter("graduateSchool");
			if(null == graduateSchool || graduateSchool.equals("")) {
				graduateSchool = "";
			}
			oneEmployee.setGraduateSchool(getGbk(graduateSchool));
			
			String schoolRecord = request.getParameter("schoolRecord");
			if(null == schoolRecord || schoolRecord.equals("")) {
				schoolRecord = "";
			}
			oneEmployee.setSchoolRecord(getGbk(schoolRecord));
			
		  String department = request.getParameter("department");
		  if (department == null || department.equals("")) {
		  	department = "";sqlflag=false;
		  }
		  oneEmployee.setDepartment(getGbk(department));
		 
		  String positionName = request.getParameter("positionName");
		  if (positionName == null || positionName.equals("")) {
		  	positionName = "";
		  }
		  oneEmployee.setPositionName(getGbk(positionName));
		  
		  String telephone = request.getParameter("telephone");
		  if (telephone == null || telephone.equals("")) {
		  	telephone = "";
		  }
		  oneEmployee.setTelephone(getGbk(telephone));
		  
		  String email = request.getParameter("email");
		  if(null == email || email.equals("")) {
		  	email = "";
		  }
		  oneEmployee.setEmail(getGbk(email));
		  
		  String memo = request.getParameter("memo");
		  if(null == memo || memo.equals("")) {
		  	memo = "";
		  }
		  oneEmployee.setMemo(getGbk(memo));
		  
			if (sqlflag){
				flag = true;
			}
			return flag;					
		}
		catch (Exception e)
		{
			return flag;
		}
	}


  //按條件執(zhí)行員工的查找并將結果保存到employeelist向量數(shù)組中
	public boolean execute(HttpServletRequest res) throws Exception {  //用于執(zhí)行按條件查詢
		request = res;
		String PAGE = request.getParameter("page");   //頁碼
		String searchZiduan = request.getParameter("searchZiduan");  //查詢的字段
		String keyword = request.getParameter("keyword");	//查詢關鍵詞	
		if (keyword==null) keyword = "";
		if (searchZiduan == null) searchZiduan = "";
		keyword = getGbk(keyword);
		searchZiduan = getGbk(searchZiduan);
		try
		{
			page = Integer.parseInt(PAGE);
		}
		catch (NumberFormatException e)
		{
			page = 1;
		}
		 
		//取出記錄數(shù)
		if (searchZiduan.equals("") && !keyword.equals("") ) {
			sqlStr = "select count(*) from employee where employeeId like '%" + keyword + "%' or name like '%" + keyword + "%' or department like '%" + keyword + "%'";
		} else if (!searchZiduan.equals("")) {
			if (searchZiduan.equals("employeeId")) {
				sqlStr = "select count(*) from employee where employeeId like '%" +keyword+ "%'";
			} else if(searchZiduan.equals("name")) {
				sqlStr = "select count(*) from employee where name like '%" + keyword + "%'";
			} else if(searchZiduan.equals("department")){
				sqlStr = "select count(*) from employee where department like '%" + keyword + "%'";
			}
		} else if(searchZiduan.equals("") && keyword.equals("")) {
			sqlStr = "select count(*) from employee";
		}

		int rscount = pageSize;
		try
		{
			ResultSet rs1 = stmt.executeQuery(sqlStr);
			if (rs1.next()) recordCount = rs1.getInt(1);				
			rs1.close();
		}
		catch (SQLException e)
		{
			errorMessage = "查詢記錄總數(shù)錯誤:" + searchZiduan + sqlStr + e.getMessage();
			return false;
		}
		//計算查詢結果總頁數(shù)
		if (recordCount < 1)
      pageCount = 0;
    else
      pageCount = (int)(recordCount - 1) / pageSize + 1;
		//檢查查看的頁面數(shù)是否在范圍內(nèi)
		if (page < 1)  
       page = 1;
    else if (page > pageCount)
       page = pageCount;
		rscount = (int) recordCount % pageSize;	 // 最后一頁記錄數(shù)
		
		sqlStr = "select * from employee ";  //根據(jù)不同條件構造不同的sql查詢字符串
		if (searchZiduan.equals("") && !keyword.equals("") ) {
			sqlStr = sqlStr + "where employeeId like '%" + keyword + "%' or name like '%" + keyword + "%' or department like '%" + keyword + "%' order by employeeId desc";
		} else if(!searchZiduan.equals("")) {
			sqlStr = sqlStr + "where " + searchZiduan + " like '%" + keyword + "%' order by employeeId desc";
		} else if(searchZiduan.equals("") && keyword.equals("")) {
				sqlStr = sqlStr + "order by employeeId desc";
		}
		
		try
		{
			rs = stmt.executeQuery(sqlStr);
			employeelist = new Vector(rscount);
			for(int i=0;i<pageSize*(page-1);i++)rs.next();//跳過前面頁的記錄
			while (rs.next())
			{
				employee anemployee = new employee();
				anemployee.setEmployeeId(rs.getString("employeeId"));
				anemployee.setName(rs.getString("name"));
				anemployee.setCardNumber(rs.getString("cardNumber"));
				anemployee.setNation(rs.getString("nation"));
				anemployee.setSex(rs.getString("sex"));
				anemployee.setBirthday(rs.getString("birthday"));
				anemployee.setGraduateSchool(rs.getString("graduateSchool"));
				anemployee.setSchoolRecord(rs.getString("schoolRecord"));
				anemployee.setDepartment(rs.getString("department"));