package com.dut.logic.db;

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

import com.dut.dao.BatchDBConnectionUtil;
import com.dut.logic.util.DataTypeCheck;
import com.dut.logic.util.NumberUtil;
import com.dut.logic.util.StringUtil;

public class Seikyu {


	
	private String helinen; //char
	
	private String h_jiysku_mei; //char
	
	private int nen; // smallint

	private int hagaki_id; // smallint

	private int id;

	private int toukyu_id; // smallint

	private String bangou; // char

	private int kumi_kubun; // smallint

	private String kumi; // char

	private int ken_id; // smallint

	private String kyoku_id; // char

	private int syouhin_id;

	private Date seikyu_date;

	private int report_flg; // tinyint

	private int taisyo_flg; // tinyint

	private Date taisyo_date;

	private int kettei_flg; // tinyint

	private Date kettei_date;

	private int siji_flg; // tinyint

	private Date siji_date;

	private int hassou_flg; // tinyint

	private Date hassou_date;

	private int h_jitaku; // tinyint

	private int h_zipcd_mae; // smallint

	private int h_zipcd_ato; // smallint

	private String h_atena; // varchar

	private String h_jusyo; // varchar

	private String h_tel; // char

	private Date h_sitei_date;

	private int del_flg; // tinyint

	private Date del_date;

	private Date insert_date;

	private Date update_date; // Datetime

	private String kyokusyo_mei; // char

	private String toukyu_mie; // char

	private String syouhin_ryaku; // char

	private String hagaki_mie; // char

	private String syouhin_mei;

	

	public String getH_jiysku_mei() {
		return h_jiysku_mei;
	}

	public void setH_jiysku_mei(String h_jiysku_mei) {
		this.h_jiysku_mei = h_jiysku_mei;
	}

	
	
	public String getHelinen() {
		return helinen;
	}

	public void setHelinen(int nen) {
		this.helinen = DataTypeCheck.xiliToHeli(String.valueOf(nen));
	}

	public String getBangou() {
		return bangou;
	}

	public void setBangou(String bangou) {
		this.bangou = bangou;
	}

	public Date getDel_date() {
		return del_date;
	}

	public void setDel_date(Date del_date) {
		this.del_date = del_date;
	}

	public int getDel_flg() {
		return del_flg;
	}

	public void setDel_flg(int del_flg) {
		this.del_flg = del_flg;
	}

	public String getH_atena() {
		return h_atena;
	}

	public void setH_atena(String h_atena) {
		this.h_atena = h_atena;
	}

	public int getH_jitaku() {
		return h_jitaku;
	}

	public void setH_jitaku(int h_jitaku) {
		this.h_jitaku = h_jitaku;
	}

	public String getH_jusyo() {
		return h_jusyo;
	}

	public void setH_jusyo(String h_jusyo) {
		this.h_jusyo = h_jusyo;
	}

	public Date getH_sitei_date() {
		return h_sitei_date;
	}

	public void setH_sitei_date(Date h_sitei_date) {
		this.h_sitei_date = h_sitei_date;
	}

	public String getH_tel() {
		return h_tel;
	}

	public void setH_tel(String h_tel) {
		this.h_tel = h_tel;
	}

	public int getH_zipcd_ato() {
		return h_zipcd_ato;
	}

	public void setH_zipcd_ato(int h_zipcd_ato) {
		this.h_zipcd_ato = h_zipcd_ato;
	}

	public int getH_zipcd_mae() {
		return h_zipcd_mae;
	}

	public void setH_zipcd_mae(int h_zipcd_mae) {
		this.h_zipcd_mae = h_zipcd_mae;
	}

	public int getHagaki_id() {
		return hagaki_id;
	}

	public void setHagaki_id(int hagaki_id) {
		this.hagaki_id = hagaki_id;
	}

	public Date getHassou_date() {
		return hassou_date;
	}

	public void setHassou_date(Date hassou_date) {
		this.hassou_date = hassou_date;
	}

	public int getHassou_flg() {
		return hassou_flg;
	}

	public void setHassou_flg(int hassou_flg) {
		this.hassou_flg = hassou_flg;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public Date getInsert_date() {
		return insert_date;
	}

	public void setInsert_date(Date insert_date) {
		this.insert_date = insert_date;
	}

	public int getKen_id() {
		return ken_id;
	}

	public void setKen_id(int ken_id) {
		this.ken_id = ken_id;
	}

	public Date getKettei_date() {
		return kettei_date;
	}

	public void setKettei_date(Date kettei_date) {
		this.kettei_date = kettei_date;
	}

	public int getKettei_flg() {
		return kettei_flg;
	}

	public void setKettei_flg(int kettei_flg) {
		this.kettei_flg = kettei_flg;
	}

	public String getKumi() {
		return kumi;
	}

	public void setKumi(String kumi) {
		this.kumi = kumi;
	}

	public int getKumi_kubun() {
		return kumi_kubun;
	}

	public void setKumi_kubun(int kumi_kubun) {
		this.kumi_kubun = kumi_kubun;
	}

	public String getKyoku_id() {
		return kyoku_id;
	}

	public void setKyoku_id(String kyoku_id) {
		this.kyoku_id = kyoku_id;
	}

	public int getNen() {
		return nen;
	}

	public void setNen(int nen) {
		this.nen = nen;
	}

	public int getReport_flg() {
		return report_flg;
	}

	public void setReport_flg(int report_flg) {
		this.report_flg = report_flg;
	}

	public Date getSeikyu_date() {
		return seikyu_date;
	}

	public void setSeikyu_date(Date seikyu_date) {
		this.seikyu_date = seikyu_date;
	}

	public Date getSiji_date() {
		return siji_date;
	}

	public void setSiji_date(Date siji_date) {
		this.siji_date = siji_date;
	}

	public int getSiji_flg() {
		return siji_flg;
	}

	public void setSiji_flg(int siji_flg) {
		this.siji_flg = siji_flg;
	}

	public int getSyouhin_id() {
		return syouhin_id;
	}

	public void setSyouhin_id(int syouhin_id) {
		this.syouhin_id = syouhin_id;
	}

	public Date getTaisyo_date() {
		return taisyo_date;
	}

	public void setTaisyo_date(Date taisyo_date) {
		this.taisyo_date = taisyo_date;
	}

	public int getTaisyo_flg() {
		return taisyo_flg;
	}

	public void setTaisyo_flg(int taisyo_flg) {
		this.taisyo_flg = taisyo_flg;
	}

	public int getToukyu_id() {
		return toukyu_id;
	}

	public void setToukyu_id(int toukyu_id) {
		this.toukyu_id = toukyu_id;
	}

	public Date getUpdate_date() {
		return update_date;
	}

	public void setUpdate_date(Date update_date) {
		this.update_date = update_date;
	}

	public String getKyokusyo_mei() {
		return kyokusyo_mei;
	}

	public void setKyokusyo_mei(String kyokusyo_mei) {
		this.kyokusyo_mei = kyokusyo_mei;
	}

	public String getSyouhin_ryaku() {
		return syouhin_ryaku;
	}

	public void setSyouhin_ryaku(String syouhin_ryaku) {
		this.syouhin_ryaku = syouhin_ryaku;
	}

	public String getToukyu_mie() {
		return toukyu_mie;
	}

	public void setToukyu_mie(String toukyu_mie) {
		this.toukyu_mie = toukyu_mie;
	}

	public String getHagaki_mie() {
		return hagaki_mie;
	}

	public void setHagaki_mie(String hagaki_mie) {
		this.hagaki_mie = hagaki_mie;
	}

	public String getSyouhin_mei() {
		return syouhin_mei;
	}

	public void setSyouhin_mei(String syouhin_mei) {
		this.syouhin_mei = syouhin_mei;
	}

	/**
	 * 判斷輸入的時間是否是前者小于后者,是返回false,不是返回true
	 * 
	 * @param before
	 * @param after
	 * @return boolean
	 * @author 王楠楠?? 2006-04-11
	 */
	public static boolean isnotTime_before(String before, String after) {
		if (before == null || before.equals("") || after == null
				|| after.equals("")) {
			return false;
		} 
		/**輸入的時間不為空是將字符串轉換成Date類型*/
		else {
			int before_Year = Integer.parseInt(before.substring(0, 4)) - 1900;
			int before_Month = Integer.parseInt(before.substring(5, 7)) - 1;
			int before_Hour = Integer.parseInt(before.substring(8, 10));
			java.util.Date before_date = new java.util.Date(before_Year,
					before_Month, before_Hour);

			int after_Year = Integer.parseInt(after.substring(0, 4)) - 1900;
			int after_Month = Integer.parseInt(after.substring(5, 7)) - 1;
			int after_Hour = Integer.parseInt(after.substring(8, 10));
			java.util.Date after_date = new java.util.Date(after_Year,
					after_Month, after_Hour);
			
			/**調用比較方法,返回false則輸入正確*/
			boolean flag = before_date.before(after_date);
			if (flag == false) {
				return true;
			}
		}
		return false;
	}


	/**
	 * 計算兩個數的商的百分比,并且保留兩位小數
	 * 
	 * @param hiki
	 * @param tyou
	 * @return String 
	 * @author 王楠楠 2006-04-12
	 */
	public static String hikikae_lv(int hiki, int tyou) {
		String las_num = null;
		String hiki_las_lv = null;
		String hiki_lv = null;
		double hi = (double) hiki;
		double ty = (double) tyou;
		if (hi == 0.0 && ty == 0.0) {