//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.action;

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

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
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.dao.BatchDBConnectionUtil;
import com.dut.logic.db.Tousen;
import com.dut.logic.logic.InputCheckUtil;
import com.dut.logic.logic.KensyouLogic;
import com.dut.logic.logic.TousenLogic;
import com.dut.logic.util.StringUtil;
import com.dut.struts.form.TousenUpdateActionForm;

/** 
 * MyEclipse Struts
 * Creation date: 04-16-2006
 * 
 * XDoclet definition:
 * @struts.action path="/tousenSearch" name="tousenUpdateActionForm" scope="request" validate="true"
 */
public class TousenSearchAction extends Action {

	// --------------------------------------------------------- Instance Variables

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

	/** 
	 * Method execute
	 * 根據不同的檢索條件,去查詢數據庫
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * 劉濤 2006-04-24
	 */
	public ActionForward execute(
		ActionMapping mapping,
		ActionForm form,
		HttpServletRequest request,
		HttpServletResponse response) {
		TousenUpdateActionForm tousenUpdateActionForm = (TousenUpdateActionForm) form;
		// TODO Auto-generated method stub
		ActionForward forward=new ActionForward ();
		ActionErrors errors=new ActionErrors();
			
		StringUtil U1=new StringUtil();
		String year="";
			
		String login_time=(String) request.getSession().getAttribute("nowdate");
		String sq="";
		ResultSet rs=null;
		String yeshu_id=tousenUpdateActionForm.getYeshu();
		String dengji_id="";
		year=request.getParameter("nen");
		int nen=Integer.parseInt(year);
		int hagaki_id=Integer.parseInt(yeshu_id);
		String yeshu_values="";
		String dengji_values="";
		String number="";
		String Tou_no="";
		ArrayList A1=new ArrayList();
		System.out.println("00000==="+tousenUpdateActionForm.getDengji());
		System.out.println("11111==="+request.getParameter("number"));
		int flag=0;
		if((tousenUpdateActionForm.getDengji()==null||tousenUpdateActionForm.getDengji().equals(""))&&(request.getParameter("number")==null||request.getParameter("number").equals("")))
		{
			System.out.println("111111111111");
			sq="select * from tousen where nen="+nen+" and hagaki_id="+hagaki_id;
			System.out.println("sq==>"+sq);
			flag=2;
		}

		if((tousenUpdateActionForm.getDengji()!=null)&&(request.getParameter("number").equals("")))
		{
			System.out.println("222222222222");
			dengji_id=U1.trans(tousenUpdateActionForm.getDengji());
			sq="select * from tousen where nen="+nen+" and hagaki_id="+hagaki_id+" and toukyu_id="+dengji_id;	
			flag=1;
		}
		
		if((tousenUpdateActionForm.getDengji()==null)&&(request.getParameter("number").equals("")==false))
		{
			number=request.getParameter("number");
			System.out.println("number==="+number);
			sq="select * from tousen where nen="+nen+" and hagaki_id="+hagaki_id+" and tousen_no='"+number+"'";
			flag=2;
		}
		
		if((tousenUpdateActionForm.getDengji()!=null)&&(request.getParameter("number").equals("")==false))
		{
			dengji_id=U1.trans(tousenUpdateActionForm.getDengji());
			number=request.getParameter("number");
			System.out.println("number==="+number);
			sq="select * from tousen where nen="+nen+" and hagaki_id="+hagaki_id+" and toukyu_id="+dengji_id+" and tousen_no='"+number+"'";
		}
		A1=TousenLogic.A_Search(sq);
		System.out.println("year44444===>"+year);
	
		String sq1="select hagaki_mei from hagakicd where Hagaki_id="+yeshu_id;
		yeshu_values=StringUtil.trans_date(KensyouLogic.getDataNameThrough(sq1));
		if(dengji_id.equals("")==false)
		{
			String sq2="select toukyu_mei from toukyucd where Toukyu_id="+dengji_id;	
			dengji_values=StringUtil.trans_date(KensyouLogic.getDataNameThrough(sq2));
		}

		if(flag==1)
		{
			number="";
		}
		if(flag==2)
		{
			dengji_values="";
		}
		
		request.getSession().setAttribute("year",year);
		request.getSession().setAttribute("yeshu_values",yeshu_values);
		request.getSession().setAttribute("dengji_values",dengji_values);
		request.getSession().setAttribute("number",number);
		int s=A1.size();
		String size=Integer.toString(A1.size());
		System.out.println("size==="+size);
		if(s==0)
		{		
			errors.add("message",new ActionError("Data"));
			saveErrors(request,errors);
			return (new ActionForward(mapping.getInput()));
		}
		request.getSession().setAttribute("size",size);
		request.getSession().setAttribute("A1",A1);
		/*****************頁面轉向 TousenSearch.jsp****************/
		forward=mapping.findForward("t_search");
		return forward;
	}

}