//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.text.SimpleDateFormat;

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.ActionMapping;

import com.dut.dao.BatchDBConnectionUtil;
import com.dut.logic.logic.InputCheckUtil;
import com.dut.logic.logic.KensyouLogic;
import com.dut.logic.logic.TousenLogic;
import com.dut.logic.util.NumberUtil;
import com.dut.logic.util.StringUtil;

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

	private String yeshu;

	private String dengji;

	// --------------------------------------------------------- Instance
	// Variables
	static BatchDBConnectionUtil BU1 = new BatchDBConnectionUtil();// Date

	// Lianjie

	static SimpleDateFormat date = new SimpleDateFormat("yyyy-MM-dd");

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

	public String getDengji() {
		return dengji;
	}

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

	public String getYeshu() {
		return yeshu;
	}

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

	/**
	 * Method validate
	 * 
	 * @param mapping
	 * @param request
	 * @return ActionErrors
	 */
	public ActionErrors validate(ActionMapping mapping,
			HttpServletRequest request) {
		ActionErrors errors = new ActionErrors();

		StringUtil U1 = new StringUtil();
		String year = "";
		String number = "";
		// TODO Auto-generated method stub

		if (request.getParameter("name").equals("Login")) {
			if (request.getParameter("nen") == null
					|| request.getParameter("nen").equals("")) {
				errors.add("message", new ActionError("year_empty"));
				return errors;
			}
			if (request.getParameter("nen") != null
					|| request.getParameter("nen").equals("") == false) {

				year = request.getParameter("nen");
				request.setAttribute("nowyear", year);
				boolean b_year = NumberUtil.isnotNum(year);
				if (year.length() != 4 || b_year == true) {
					errors.add("message", new ActionError("year_format1"));
					return errors;
				}
				boolean b_year1 = InputCheckUtil.nen_fanwei(year);
				if (b_year1 == false) {
					errors.add("message", new ActionError("year_format2"));
					return errors;
				}

			}
			String yeshu_id = U1.trans(yeshu);
			request.setAttribute("t_yeshu", yeshu_id);
			if (dengji == null || dengji.equals("")) {
				errors.add("message", new ActionError("dengji_empty"));
				return errors;
			}
			String dengji_id = U1.trans(dengji);
			request.setAttribute("t_dengji", dengji_id);

			if (request.getParameter("number") == null
					|| request.getParameter("number").equals("")) {
				errors.add("message", new ActionError("d_number_empty"));
				return errors;
			}
			if (request.getParameter("number") != null
					|| request.getParameter("number").equals("") == false) {
				number = request.getParameter("number");
				request.setAttribute("number", number);
				boolean b_dnumber = NumberUtil.isnotNum(number);

				if ((number.length() > 8) || b_dnumber == true) {

					errors.add("message", new ActionError("d_number_format"));
					return errors;
				}

			}
			int leng = number.length();
			int h1 = Integer.parseInt(year);
			int h2 = Integer.parseInt(yeshu_id);
			int h3 = Integer.parseInt(dengji_id);
			int h4 = Integer.parseInt(number.substring(leng - 1));
			// System.out.println("h1=======>"+h1);
			// System.out.println("h2=======>"+h2);
			// System.out.println("h3=======>"+h3);
			// System.out.println("h4=======>"+h4);

			String sq = "select * from kensyou where nen=" + h1
					+ " and hagaki_id=" + h2 + " and toukyu_id=" + h3
					+ " and sketa=" + h4;
			System.out.println(sq);
			ResultSet rs = KensyouLogic.Select(sq);
			try {
				if (rs.next() == false) {
					errors.add("message", new ActionError("Data"));
					return errors;
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
			String sq_1 = "select * from tousen where nen=" + h1
					+ " and hagaki_id=" + h2 + " and toukyu_id=" + h3
					+ " and tousen_no='" + number + "'";
			System.out.println(sq_1);
			ResultSet rs1 = TousenLogic.T_select(sq_1);
			try {
				if (rs1.next() == true) {
					errors.add("message", new ActionError("data_exist"));
					return errors;
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}

		}// Login if
		if (request.getParameter("name").equals("Search")) {
			if (request.getParameter("nen") == null
					|| request.getParameter("nen").equals("")) {
				errors.add("message", new ActionError("year_empty"));
				return errors;
			}
			if (request.getParameter("nen") != null
					|| request.getParameter("nen").equals("") == false) {

				year = request.getParameter("nen");
				request.setAttribute("nowyear", year);
				boolean b_year = NumberUtil.isnotNum(year);

				if (year.length() != 4 || b_year == true) {
					errors.add("message", new ActionError("year_format1"));
					return errors;
				}
				boolean b_year1 = InputCheckUtil.nen_fanwei(year);
				if (b_year1 == false) {
					errors.add("message", new ActionError("year_format2"));
					return errors;
				}

			}
			String yeshu_id = U1.trans(yeshu);
			request.setAttribute("t_yeshu", yeshu_id);
			if (dengji != null) {
				String dengji_id = U1.trans(dengji);
				request.setAttribute("t_dengji", dengji_id);
			}
			if (request.getParameter("number") != null
					|| request.getParameter("number").equals("") == false) {
				number = request.getParameter("number");
				request.setAttribute("number", number);
			}

		}// Search kuo hao

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

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

		// TODO Auto-generated method stub
	}

}