package com.dut.logic.util;

import java.sql.Date;
import java.text.SimpleDateFormat;
import java.util.StringTokenizer;

import com.dut.logic.logic.InputCheckUtil;

public class DataTypeCheck {

	
	
	/**
	 * 該函數(shù)用于將日期格式字符串轉(zhuǎn)換成?java.sql.Date類型
	 * @param str
	 * @return Date
	 * @author ?楊麗娟 2006-04-11
	 */
	public static Date StringtoDate(String str){
		Date date = null;
		if(str==null || str.equals("")){
			return null;
		}
		else if(InputCheckUtil.isnotDateformat(str)){
			return null;
		}
		else{
			int year = Integer.parseInt(str.substring(0,4));
			int Month = Integer.parseInt(str.substring(5,7));
			int Day = Integer.parseInt(str.substring(8,10));
			/**
			 * 添加如果數(shù)據(jù)庫中存入的是0000-00-00
			 * 則將當前系統(tǒng)時間轉(zhuǎn)換成String
			 * @author 楊麗娟 2006-04-21
			 */
			if(year == 0 || Month == 0 || Day == 0){
				SimpleDateFormat ff = new SimpleDateFormat("yyyy-MM-dd");			
				String nowdate = ff.format(new java.util.Date());
				year = Integer.parseInt(nowdate.substring(0,4));
				Month = Integer.parseInt(nowdate.substring(5,7));
				Day = Integer.parseInt(nowdate.substring(8,10));
			}
			date = new Date(year-1900,Month-1,Day);
		}
		return date;
	}

	
	/**
	 * 該函數(shù)用于將java.sql.Date??類型轉(zhuǎn)換成?String??類型
	 * @param Date
	 * @return sql
	 * @author 楊麗娟 2006-04-11
	 */
	public static String DatetoString(Date date){
		String str = null;
		if(date != null){
			str = date.toString();
		}
		return str;
	}
	
	/**
	 * 該函數(shù)用于將西歷年轉(zhuǎn)換成和歷平成年?
	 * @param String
	 * @return String
	 * @author ?楊麗娟 ?@2006-04-11
	 */
	public static String xiliToHeli(String str) {

		int xyear = Integer.parseInt(str);
		int hyear = xyear - 1988;
		return String.valueOf(hyear);
	}

	/**
	 * ?該函數(shù)用于將和歷平成年轉(zhuǎn)換成西歷年?
	 * @param String
	 * @return String
	 * @author ?楊麗娟 2006-04-11
	 */
	public static String HeliToXili(String str) {

		int hyear = Integer.parseInt(str);
		int xyear = hyear + 1988;
		return String.valueOf(xyear);
	}
	
	/**
	 * 該函數(shù)用于將java.util.Date型轉(zhuǎn)換成java.sql.Date類型
	 * @param date
	 * @return java.sql.Date
	 * @author ?楊麗娟 2006-04-11
	 */
	public static java.sql.Date changeSqlDate(java.util.Date date) {

		SimpleDateFormat si = new SimpleDateFormat("yyyy/MM/dd");
		String dateTime = si.format(date);
		StringTokenizer st = new StringTokenizer(dateTime, "/");
		int timeY = Integer.parseInt(st.nextToken()) - 1900;
		int timeM = Integer.parseInt(st.nextToken()) - 1;
		int timeD = Integer.parseInt(st.nextToken());
		java.sql.Date dateSQL = new java.sql.Date(timeY, timeM, timeD);
		return dateSQL;
	}
}