//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.0.1/xslt/JavaClass.xsl

package com.dut.struts.form;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.dut.logic.db.Kensyou;
import com.dut.logic.logic.InputCheckUtil;
import com.dut.logic.logic.KensyouLogic;
import com.dut.logic.util.StringUtil;

/** 
 * MyEclipse Struts
 * Creation date: 04-05-2006
 * 
 * XDoclet definition:
 * @struts.form name="kensyoInputActionForm"
 */
public class KensyoInputActionForm extends ActionForm {

	private String t_year;
	private String yeshu;
	private String dengji;
	private String t_lastnumber;
	private String sk_year;
	private String sz_year;
	// --------------------------------------------------------- Instance Variables

	// --------------------------------------------------------- Methods

	/** 
	 * Method validate
	 * @param mapping
	 * @param request
	 * @return ActionErrors
	 */
	public ActionErrors validate(
		ActionMapping mapping,
		HttpServletRequest request) {
		ActionErrors errors=new ActionErrors();
		StringUtil U1=new StringUtil();
		String t_year1="";
		String t_lastnumber1="";
		String sk_year1="";
		String sz_year1="";
		
		String yeshu1=U1.trans(yeshu);
		String dengji1=U1.trans(dengji);	
		request.setAttribute("t_yeshu",yeshu1);
		request.setAttribute("t_dengji",dengji1);
		
		/************判斷當不為空的時候取值***************/
		if(t_year!=null||t_year.equals("")==false)
		{
			t_year1=U1.trans_date(t_year);
			request.setAttribute("t_year", t_year1);
		}
		if(t_lastnumber!=null&&t_lastnumber.equals("")==false)
		{
			t_lastnumber1=U1.trans(t_lastnumber);
			request.setAttribute("t_lastnumber",t_lastnumber1);
		}
		if(sk_year!=null||sk_year.equals("")==false)
		{
			sk_year1=U1.trans(sk_year);
			request.setAttribute("sk_year",sk_year1);
		}
		
		if(sz_year!=null||sz_year.equals("")==false)
		{
			sz_year1=U1.trans(sz_year);
			request.setAttribute("sz_year",sz_year1);
		}
		
		/********************錯誤判斷*********************/
		if(t_year==null||t_year.equals(""))//如果年為空
		{
			errors.add("message",new ActionError("year_empty"));
			return errors;
		}
		boolean b_year1=InputCheckUtil.BanJiao_Shuzi(t_year1);	//半角數字的判斷

		if(t_year1.length()!=4||b_year1==false)//如果年的長度不為4，或者不是半角數字
		{
			errors.add("message",new ActionError("year_format1"));
			return errors;	
		}
		boolean b_year2=InputCheckUtil.nen_fanwei(t_year1);//年的范圍的判斷
		if(b_year2==false)//如果年不在1930-2010之間
		{
			errors.add("message",new ActionError("year_format2"));
			return errors;	
		}
		request.getSession().setAttribute("nian", t_year1);

		
		if(t_lastnumber==null||t_lastnumber.equals(""))//如果下桁數為空
		{
			errors.add("message",new ActionError("lastnumber_empty"));
			return errors;	
		}

		boolean b2=InputCheckUtil.BanJiao_Shuzi(t_lastnumber1);//半角數字的判斷
		if(t_lastnumber1.length()!=1||b2==false)
		{
			errors.add("message",new ActionError("e_tlastnumber"));
			return errors;			
		}
		
		if(sk_year==null||sk_year.equals(""))//如果開始日付為空
		{
			errors.add("message",new ActionError("sk_year_empty"));
			return errors;	
		}

		boolean b3=InputCheckUtil.isnotDateformat(sk_year1);	//判斷日期格式
		if(b3==true)
		{
			errors.add("message",new ActionError("e_sk_year"));
			return errors;	
		}
		
		if(sz_year==null||sz_year.equals(""))//如果結束日付為空
		{
			errors.add("message",new ActionError("sz_year_empty"));
			return errors;	
		}

		boolean b4=InputCheckUtil.isnotDateformat(sz_year1);	//判斷日期格式
		if(b4==true)//如果不符合日期格式
		{
			errors.add("message",new ActionError("e_sz_year"));
			return errors;
			
		}
		/****************把字符串轉換為data型*************/
		Date Sk_date=InputCheckUtil.Turn_Date(sk_year1);
		System.out.println("Sk_date="+Sk_date);
		Date Sz_date=InputCheckUtil.Turn_Date(sz_year1);
		System.out.println("Sz_date="+Sz_date);
		
		boolean when=Sk_date.before(Sz_date);//比較日期先后
		if(when==false)//如果開始日付比結束日付晚
		{
			errors.add("message",new ActionError("when"));
			return errors;
			
		}
		/*************字符串轉換為整型************/
		int h1=Integer.parseInt(t_year1);
		int h2=Integer.parseInt(yeshu1);
		int h3=Integer.parseInt(dengji1);
		int h4=Integer.parseInt(t_lastnumber1);
		
		/********************按條件查詢數據庫************************/
		String sq="select * from kensyou where nen="+h1+" and hagaki_id="+h2+" and toukyu_id="+h3+" and sketa="+h4;
		ResultSet rs=KensyouLogic.Select(sq);
		try {
			if(rs.next()==true)//如果結果集不為空
			{
				errors.add("message",new ActionError("data_exist"));
				return errors;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		

		// TODO Auto-generated method stub
		return errors;
	}//public kuohao

	/** 
	 * Method reset
	 * @param mapping
	 * @param request
	 */
	public void reset(ActionMapping mapping, HttpServletRequest request) {

		// TODO Auto-generated method stub
	}

	public String getT_year() {
		return t_year;
	}

	public void setT_year(String t_year) {
		this.t_year = t_year;
	}

	public String getSk_year() {
		return sk_year;
	}

	public void setSk_year(String sk_year) {
		this.sk_year = sk_year;
	}

	public String getSz_year() {
		return sz_year;
	}

	public void setSz_year(String sz_year) {
		this.sz_year = sz_year;
	}

	public String getT_lastnumber() {
		return t_lastnumber;
	}

	public void setT_lastnumber(String t_lastnumber) {
		this.t_lastnumber = t_lastnumber;
	}

	public String getYeshu() {
		return yeshu;
	}

	public void setYeshu(String yeshu) {
		this.yeshu = yeshu;
	}

	public String getDengji() {
		return dengji;
	}

	public void setDengji(String dengji) {
		this.dengji = dengji;
	}

}