kaigi_jouhou.java

jsp考勤

/*
 *	Copyright (C) 2000, TOA-System Co.  All rights reserved.
 */
package test;

import java.sql.*;
import java.text.*;
import exce.*;
import def.*;
import util.*;
import entity.*;
import dbcommon.*;

/**
 *	偙偺僋儔僗偼丄儘僌僀儞娭楢偺僋儔僗偱偡丅<br>
 *	@version	2.00
 *	@author		TOA
 *
 *	峏怴棜楌
 *	<ul>
 *		<li>僐儊儞僩傪捛壛
 *	</ul>
 */
public class Kaigi_Jouhou {
	public Kaigi_Jouhou() {}
	CommonUtil cu = new CommonUtil();
	ChangeField cf = new ChangeField();
	Status st = new Status();
	SimpleDateFormat sdf = new SimpleDateFormat(SISnet.DATE_FMT);

     /**
	 *	夛媍忣曬偺庢摼傪峴偆
	 *	@param	conn		DB僪儔僀僶偺URL側偳
	 *			
	 *			
	 *	@return	status		Status僆僽僕僃僋僩
	 */
	public Kaigi_Jouhou_004Entity[] search(Connection conn,String starttime,String endtime,String datefrom,String dateto) {							    
		String		where	= "";
		
		try {
			// Kaigi_Jouhou_004DataAccess僆僽僕僃僋僩偺findKaigi_Jouhou_004()儊僜僢僪傪幚峴偟傑偡丅
			Kaigi_Jouhou_004DataAccess kjda = new Kaigi_Jouhou_004DataAccess();

			where =" WHERE STRAT_DATE_TIME =to_date('" + sdf.format(cf.strToDate(datefrom))+"','yyyy/mm/dd')" +" AND ((STRAT_JITEN BETWEEN '" +starttime+"'"+
				" AND '" +endtime+"'"+" )OR (END_JITEN BETWEEN '" +starttime+"'"+
				" AND '" +endtime+"'"+" ))AND END_DATE_TIME=to_date('" +sdf.format(cf.strToDate(dateto))+"','yyyy/mm/dd')";

			Kaigi_Jouhou_004Entity[] kjte = kjda.findKaigi_Jouhou_004(conn, where);


		       return kjte;
			

		} catch (ApplicationException ae) {
			st = ae.getStatus();
			ae.printStackTrace();
			throw new ApplicationException(st.usermsg, st.errno);
		} catch (OracleException orae) {
			st = orae.getStatus();
			orae.printStackTrace();
			throw new OracleException(st);
		} catch (Exception e) {
			e.printStackTrace();
			throw new OriginalException(e);
		}
	}

	 /**
	 *	夛媍忣曬嵏鎚偺庢摼傪峴偆
	 *	@param	conn		DB僪儔僀僶偺URL側偳
	 *			
	 *			
	 *	@return	status		Status僆僽僕僃僋僩
	 */
	public Kaigi_Jouhou_004Entity[] find(Connection con,String todaydate,String qufen)
	{
		String whe= "";
		if (!todaydate.equals(""))
		{
			whe=" WHERE STRAT_DATE_TIME>=to_date('" + todaydate + "','yyyy-mm-dd') and KUBUN='"+qufen+"'";
		}
		try
		{			
			// Kaigi_Jouhou_004DataAccess僆僽僕僃僋僩偺findKaigi_Jouhou_004()儊僜僢僪傪幚峴偟傑偡丅
			Kaigi_Jouhou_004DataAccess kjd = new Kaigi_Jouhou_004DataAccess();
			
			Kaigi_Jouhou_004Entity[] kje = kjd.findKaigi_Jouhou_004(con,whe);
			
			return (kje);
		}
		catch (ApplicationException ae) {
		st = ae.getStatus();
		ae.printStackTrace();
		throw new ApplicationException(st.usermsg, st.errno);
		} catch (OracleException orae) {
		st = orae.getStatus();
		orae.printStackTrace();
		throw new OracleException(st);
		} catch (Exception e) {
		e.printStackTrace();
		throw new OriginalException(e);
		}	
		
		
	}

	 /**
	 *	夛媍幒梊栺忣曬嵏鎚偺庢摼傪峴偆
	 *	@param	conn		DB僪儔僀僶偺URL側偳
	 *			
	 *			
	 *	@return	status		Status僆僽僕僃僋僩
	 */
	public Kaigi_Jouhou_004Entity[] yuyue_find(Connection conn,String date) {							    
		String		where	= "";
		
		try {
			// Kaigi_Jouhou_004DataAccess僆僽僕僃僋僩偺findKaigi_Jouhou_004()儊僜僢僪傪幚峴偟傑偡丅
			Kaigi_Jouhou_004DataAccess kjda = new Kaigi_Jouhou_004DataAccess();

			where =" WHERE STRAT_DATE_TIME =to_date('" + sdf.format(cf.strToDate(date))+"','yyyy/mm/dd')" +" AND KUBUN ='9' ORDER BY STRAT_JITEN";
			
			Kaigi_Jouhou_004Entity[] kjte = kjda.findKaigi_Jouhou_004(conn, where);


		       return kjte;
			

		} catch (ApplicationException ae) {
			st = ae.getStatus();
			ae.printStackTrace();
			throw new ApplicationException(st.usermsg, st.errno);
		} catch (OracleException orae) {
			st = orae.getStatus();
			orae.printStackTrace();
			throw new OracleException(st);
		} catch (Exception e) {
			e.printStackTrace();
			throw new OriginalException(e);
		}
	}



	/**
	 *	夛媍忣曬偺捛壛傪峴偆
	 *	@param	conn		DB僪儔僀僶偺URL側偳
	 *			
	 *			
	 */
	public void insert(Connection conn,String starttime,String endtime,String datefrom,String dateto,String message,String[] syain_jouhou) {							    
		
		try {
			// Kaigi_Jouhou_004DataAccess僆僽僕僃僋僩偺createKaigi_Jouhou_004()儊僜僢僪傪幚峴偟傑偡丅
			Kaigi_Jouhou_004DataAccess kjda = new Kaigi_Jouhou_004DataAccess();
			Kaigi_Jouhou_004Entity kjee 	= new Kaigi_Jouhou_004Entity();

			kjee._user_cd  = syain_jouhou[0];
			kjee._user_nm  = syain_jouhou[1];
			kjee._bumon_cd  =syain_jouhou[2];
			kjee._bumon_nm  =syain_jouhou[3];
			kjee._strat_date_time =cf.strToDate(datefrom);
			kjee._strat_jiten =cf.strToInt(starttime);          
			kjee._end_date_time =cf.strToDate(dateto);
			kjee._end_jiten =cf.strToInt(endtime);
			kjee._beko =message;
			if (syain_jouhou[4].equals("9"))
			{
				kjee._kubun ="1";
			}
			else
			{
				kjee._kubun="0";
			}
			kjee._update_user=syain_jouhou[0];
			kjee._olupdate_user=syain_jouhou[0];


	        kjda.createKaigi_Jouhou_004(conn, kjee);

		} catch (ApplicationException ae) {
			st = ae.getStatus();
			ae.printStackTrace();
			throw new ApplicationException(st.usermsg, st.errno);
		} catch (OracleException orae) {
			st = orae.getStatus();
			orae.printStackTrace();
			throw new OracleException(st);
		} catch (Exception e) {
			e.printStackTrace();
			throw new OriginalException(e);
		}
	}

	/**夛媍忣曬偺曄峏
	 *	
	 *	@param	conn		DB僪儔僀僶偺URL側偳
	 *			pr		
	 */
	public void updata(Connection conn,Kaigi_Jouhou_004Entity updata_kjee,String userid) {							
		
		try {

			// Kaigi_Jouhou_004DataAccess僆僽僕僃僋僩偺updateKaigi_Jouhou_004()儊僜僢僪傪幚峴偟傑偡丅
			Kaigi_Jouhou_004DataAccess kjda = new Kaigi_Jouhou_004DataAccess();
			Kaigi_Jouhou_004Entity kjee 	= new Kaigi_Jouhou_004Entity();

			kjee._user_cd  = updata_kjee._user_cd;
			kjee._user_nm  = updata_kjee._user_nm;
			kjee._bumon_cd  = updata_kjee._bumon_cd;
			kjee._bumon_nm  = updata_kjee._bumon_nm;
			kjee._strat_date_time  = updata_kjee._strat_date_time;
			kjee._strat_jiten  = updata_kjee._strat_jiten;
			kjee._end_date_time  = updata_kjee._end_date_time;
			kjee._end_jiten  = updata_kjee._end_jiten;
			kjee._beko  = updata_kjee._beko;
			kjee._kubun  = "0";			
			kjee._update_user= userid;
			kjee._olupdate_user= userid;


	        kjda.updateKaigi_Jouhou_004(conn, kjee);


		} catch (ApplicationException ae) {
			st = ae.getStatus();
			ae.printStackTrace();
			throw new ApplicationException(st.usermsg, st.errno);
		} catch (OracleException orae) {
			st = orae.getStatus();
			orae.printStackTrace();
			throw new OracleException(st);
		} catch (Exception e) {
			e.printStackTrace();
			throw new OriginalException(e);
		}
	}


	/**
	 *	幮堳忣曬偺嶍彍傪峴偆
	 *	@param	conn		DB僪儔僀僶偺URL側偳
	 *			
	 *			
	 */
	public void delet(Connection conn,Kaigi_Jouhou_004Entity kjee) {	
		String		where	= "";
		
		try {
			// Kaigi_Jouhou_004DataAccess僆僽僕僃僋僩偺deleteKaigi_Jouhou_004()儊僜僢僪傪幚峴偟傑偡丅
			Kaigi_Jouhou_004DataAccess kjda = new Kaigi_Jouhou_004DataAccess();
			where	= "WHERE STRAT_DATE_TIME =to_date('" + sdf.format(kjee._strat_date_time)+"','yyyy/mm/dd')" + " AND STRAT_JITEN = '" +
			kjee._strat_jiten+"'"+"AND END_DATE_TIME =to_date('" + sdf.format(kjee._end_date_time)+"','yyyy/mm/dd')" + " AND END_JITEN = '" +
			kjee._end_jiten+"'"	;
			
	        kjda.deleteKaigi_Jouhou_004(conn, where);

		} catch (ApplicationException ae) {
			st = ae.getStatus();
			ae.printStackTrace();
			throw new ApplicationException(st.usermsg, st.errno);
		} catch (OracleException orae) {
			st = orae.getStatus();
			orae.printStackTrace();
			throw new OracleException(st);
		} catch (Exception e) {
			e.printStackTrace();
			throw new OriginalException(e);
		}
	}

}