/*
 * @(#)BusinessBean.java 
 *
 * Copyright 2003 by SYNTC, All rights reserved.
 *
 * This software is the confidential and proprietary information of SYNTC.
 * ("Confidential Information").
 */
package cn.com.syntc.webapp.business;

import javax.servlet.*;
import javax.servlet.http.*;

import cn.com.syntc.common.action.*;
import cn.com.syntc.common.io.*;
import cn.com.syntc.common.util.*;
import cn.com.syntc.common.type.*;
import cn.com.syntc.webapp.taglib.CheckLogin;

import cn.com.syntc.webapp.session.UserSession;

/**
 * 進行業務邏輯處理的例子<br>
 * @author wang yong
 * @version 1.0
 */
public class EntryUserBean extends BusinessLogic{
  /**
   * 構造函數
   */
  public EntryUserBean(){
    System.out.println("FrameWork：業務處理類實例化完成【" + this.getClass().getName() + "】");
  }

  /**
   * 業務邏輯處理機能
   */
  public void execute(HttpServletRequest request, HttpServletResponse response, Parameters parameters) throws CommonException{
    try{

      SqlUtil sqlutil = new SqlUtil();
      ResultSet resultset = null;
      String strSql = "";

      String command = request.getParameter("command")==null?"":request.getParameter("command");

      // 用戶ID
      String userid = request.getParameter("userid")==null?"":request.getParameter("userid");
System.out.println("userid="+userid);
      // 用戶帳號
      String username = request.getParameter("username")==null?"":request.getParameter("username");

      // 用戶姓名
      String nicename = request.getParameter("nicename")==null?"":request.getParameter("nicename");

       // 用戶密碼
      String password = request.getParameter("password")==null?"":request.getParameter("password");

       // 用戶角色
      String roleid = request.getParameter("userrole")==null?"":request.getParameter("userrole");

      // 用戶單位
      String orgname = request.getParameter("orgname")==null?"":request.getParameter("orgname");

      // 用戶科室
      String unitname = request.getParameter("unitname")==null?"":request.getParameter("unitname");

      // 來自哪里
      String comefrom = request.getParameter("comefrom")==null?"":request.getParameter("comefrom");

      // 用戶姓別
      String sex = request.getParameter("sex")==null?"":request.getParameter("sex");

      // 出生年月
      String b_year = request.getParameter("b_year")==null?"":request.getParameter("b_year");
      String b_month = request.getParameter("b_month")==null?"":request.getParameter("b_month");
      String b_day = request.getParameter("b_day")==null?"":request.getParameter("b_day");

      // 用戶OICQ
      String oicq = request.getParameter("oicq")==null?"":request.getParameter("oicq");

      // 用戶郵箱
      String mail = request.getParameter("mail")==null?"":request.getParameter("mail");

      // 個人主頁
      String homepage = request.getParameter("homepage")==null?"":request.getParameter("homepage");

      // 個人介紹
      String introduction = request.getParameter("introduction")==null?"":request.getParameter("introduction");

      if(command.equals("add"))
      {
        // 添加用戶
        strSql = "INSERT INTO USER_TBL(USERNAME,NICENAME,`PASSWORD`,ROLEID,SEX,BIRTHDAY,OICQ,MAIL,ORGNAME,UNITNAME,HOMEPAGE,COMEFROM,INTRODUCTION,CREATETIME) VALUES('" + StringUtil.escape(username) + "','" + StringUtil.escape(nicename) + "','" + password + "','" + roleid + "','" + sex + "','" + b_year + "-" + b_month + "-" + b_day + "','" + oicq + "','" + mail + "','" + StringUtil.escape(orgname) + "','" + StringUtil.escape(unitname) + "','" + StringUtil.escape(homepage) + "','" + StringUtil.escape(comefrom) + "','" + StringUtil.escape(introduction) + "',SYSDATE())";

        sqlutil.executeUpdate(strSql);
      }
      else if(command.equals("update"))
      {
        strSql = "UPDATE USER_TBL SET USERNAME='" + StringUtil.escape(username) + "',NICENAME='" + StringUtil.escape(nicename) + "',PASSWORD='" + password + "',ROLEID='" + roleid + "',SEX='" + sex + "',BIRTHDAY='" + b_year + "-" + b_month + "-" + b_day + "',OICQ='" + StringUtil.escape(oicq) + "',MAIL='" + StringUtil.escape(mail) + "',ORGNAME='" + StringUtil.escape(orgname) + "',UNITNAME='" + StringUtil.escape(unitname) + "',HOMEPAGE='" + StringUtil.escape(homepage) + "',COMEFROM='" + StringUtil.escape(comefrom) + "',INTRODUCTION='" + StringUtil.escape(introduction) + "' WHERE USERID='" + userid + "'";

        sqlutil.executeUpdate(strSql);
      }

      if(!command.equals("add"))
      {
        strSql = "SELECT A.USERID,A.USERNAME,A.NICENAME,A.PASSWORD,A.SEX,A.BIRTHDAY,EXTRACT(YEAR FROM A.BIRTHDAY) AS YEAR,EXTRACT(MONTH FROM A.BIRTHDAY) AS MONTH,EXTRACT(DAY FROM A.BIRTHDAY) AS DAY,A.OICQ,A.MAIL,A.ORGNAME,A.UNITNAME,A.HOMEPAGE,A.COMEFROM,A.INTRODUCTION,A.LASTLOGINTIME,B.ROLEID,B.ROLENAME,SYSDATE() AS LOGINTIME FROM USER_TBL A,ROLE_TBL B WHERE A.USERID = '" + userid + "' AND A.ROLEID = B.ROLEID ORDER BY A.ROLEID,A.ORGNAME,A.UNITNAME";
        resultset = sqlutil.executeQuery(strSql);
        parameters.setParameters("results","UserEntry", resultset);
      }

      strSql = "SELECT ROLEID,ROLENAME FROM ROLE_TBL";
      resultset = sqlutil.executeQuery(strSql);

      parameters.setParameters("results","RoleList", resultset);

      sqlutil.close();

      parameters.setParameters("results", "ForwardPage", "/framework/exam/userentry.jsp");
    }
    catch(Exception ex){
      ;
    }
  }


  /**
   * 頁面表單檢測處理機能
   */
  public void validate(HttpServletRequest request, HttpServletResponse response, Parameters parameters) throws CommonException{


  }

}