tongji_updata_syainservlet.java

jsp考勤

package test;

import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;
import util.*;
import def.*;
import exce.*;
import entity.*;


/**
 *	偙偺僒乕僽儗僢僩偼丄儘僌僀儞僠僃僢僋偺偨傔偺Servlet偱偡丅<br>
 *	@version	2.00
 *	@author		TOA
 *
 *	峏怴棜楌
 *	<ul>
 *		<li>
 *	</ul>
 */


public class Tongji_Updata_SyainServlet extends HttpServlet
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	public void service(HttpServletRequest req,HttpServletResponse res)
	throws ServletException,IOException
	{
		int errf = 0;
		Connection con = null;
		Status st = new Status();
		res.setContentType("text/html;charset=Shift_JIS");
		req.setCharacterEncoding("Shift_JIS");
		HttpSession session = req.getSession(true);
		ChangeField cf = new ChangeField();

		//僄儔乕儊僢僙乕僕惗惉梡儊僜僢僪傪掕媊
		ErrorMessage em = new ErrorMessage();
		//僄儔乕僼僅儚乕僪梡儊僜僢僪傪掕媊
		ErrorForward efw = new ErrorForward();
	

		String starttime = req.getParameter("starttime").replace(":","");
		String endtime = req.getParameter("endtime").replace(":","");
		String tikoku = req.getParameter("tikoku");
		String soutai = req.getParameter("soutai");
		String zangyou = req.getParameter("zangyou");
		String xiujia = req.getParameter("xiujia");
		String syutyou = req.getParameter("syutyou");
		String ketukin = req.getParameter("ketukin");
		String i = req.getParameter("i");

		String userid =(String) session.getAttribute(SISnet.SESSION_ID_STR+".LOGINID");
		int count = cf.strToInt(i);
		Syutuketu_Jouhou_003Entity[] ees =(Syutuketu_Jouhou_003Entity[]) session.getAttribute(SISnet.SESSION_ID_STR+".DATA");
		
		try
		{			
			//僙僢僔儑儞傛傝儘僌僀儞ID偲僷僗儚乕僪傪庢摼偟傑偡丅

			//DB僆乕僾儞
			con = DatabaseConn.getConnection();
			Syain_Kyutuketu sk = new Syain_Kyutuketu();

			// set new data for update row;
			Syutuketu_Jouhou_003Entity ee = ees[count];
			ee._start_time = cf.strToInt(starttime); // 弌嬑帪揰
			ee._end_time = cf.strToInt(endtime);// 戅嬑帪揰
			ee._tikoku = cf.strToDouble(tikoku); // 抶崗
			ee._soutai = cf.strToDouble(soutai);
			ee._zangyou = cf.strToDouble(zangyou);
			ee._xiujia = cf.strToDouble(xiujia);
			ee._syutyou =cf.strToDouble(syutyou);
			ee._ketukin =cf.strToDouble(ketukin);
			ee._update_user = userid;
			ee._olupdate_user = userid;

			// Syain_Kyutuketu僆僽僕僃僋僩偺 updata()儊僜僢僪傪幚峴偟傑偡丅
			sk.updata(con,ee);
			
			int year = cf.strToInt(cf.dateToStr(ee._date_time).split("/")[0]);
			int month = cf.strToInt(cf.dateToStr(ee._date_time).split("/")[1]);
			String datefrom = year+"-"+month+"-"+"01";
			String dateto = "";
			if (month<9){
				dateto=year+"-"+"0"+(month+1)+"-"+"01";
			}
			else if(month==12){
				dateto=(year+1)+"-01-01";
			}
			else{
				dateto=year+"-"+(month+1)+"-"+"01";
			}			
				// Syain_Kyutuketu僆僽僕僃僋僩偺 search()儊僜僢僪傪幚峴偟傑偡丅
			Syutuketu_Jouhou_003Entity[] eees = sk.tongjisearch(con,ee._bumon_cd,ee._user_cd,ee._user_cd,datefrom,dateto);
			HejiEntity hj = new HejiEntity();
			for(int j=0;j<eees.length;j++){
				hj._tikoku = hj._tikoku + ees[j]._tikoku;
                hj._soutai =  hj._soutai + ees[j]._soutai;
                hj._zangyou = hj._zangyou + ees[j]._zangyou;
                hj._xiujia = hj._xiujia + ees[j]._xiujia;
                hj._syutyou = hj._syutyou + ees[j]._syutyou;
                hj._ketukin = hj._ketukin + ees[j]._ketukin;
			}
			//僙僢僔儑儞奿擺
			session.setAttribute(SISnet.SESSION_ID_STR+".XIANGXI_DATA",eees);
			session.setAttribute(SISnet.SESSION_ID_STR+".XIANGXI_HEJI",hj);			
			session.setAttribute(SISnet.SESSION_ID_STR+".len_tongji",eees.length+"");
				
				String parm="type=0";
				WinParam win[] = new WinParam[1];
				win[0]=new WinParam();
				win[0].param=parm;
				win[0].url="/kaoqin/kqglstm103.jsp";
				win[0].tar="_self";
				//師偵屇傇URL
					
				//僐儈僢僩張棟傪峴偆
				con.commit();

				//捈愙JSP傪屇傃弌偡丅乮偨偩屇傇偩偗乯
				req.setAttribute("JspParam",win);
				RequestDispatcher requestDispatcher=req.getRequestDispatcher("hb/util/Success.jsp");
				requestDispatcher.forward(req,res);
		}
		catch(OriginalException e) {
			
			errf = 1;
			st = e.getStatus();
			st.status	= -5;								// Application僄儔乕偵偡傞
			if ( st.errno != 71 ) {
				st.errno	= 110;								// Login,Password偑晄惓偱偡
			}
			String msg = em.getErrorMsg(st,"<BR>");
			efw.errForward(1,
							msg,
							req,
							res,
							this.getServletContext());
		} catch(Exception ee) {
			
			errf = 1;
			st.status	= -99;
			st.errno	= 999;
			String msg = em.getErrorMsg(st,"<BR>");
			efw.errForward(1,
							msg,
							req,
							res,
							this.getServletContext());
		} finally {
			try	{
				if ( errf == 1 ) {
					con.rollback();
				}
				if ( con != null ) {
					con.close();
				}
			} catch(Exception ee) {
				
				st.status	= -99;
				st.errno	= 999;
				String msg = em.getErrorMsg(st,"<BR>");
				efw.errForward(1,
								msg,
								req,
								res,
								this.getServletContext());
			}
		} 
	}
}