/*
 * @(#)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;

/**
 * 進(jìn)行業(yè)務(wù)邏輯處理的例子<br>
 * @author wang yong
 * @version 1.0
 */
public class UserEditBean extends BusinessLogic{
  /**
   * 構(gòu)造函數(shù)
   */
  public UserEditBean(){
    System.out.println("FrameWork：業(yè)務(wù)處理類(lèi)實(shí)例化完成【" + this.getClass().getName() + "】");
  }

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

      UserSession USession = (UserSession)request.getSession().getAttribute("UserSession");

      SqlUtil sqlutil = new SqlUtil();
      String strSql = "";

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

      if(command.equals("update"))
      {
        // 用戶帳號(hào)
        String username = request.getParameter("username")==null?"":request.getParameter("username");
        USession.setUserName(StringUtil.ISO2GB2312(username));

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

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

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

        // 來(lái)自哪里
        String comefrom = request.getParameter("comefrom")==null?"":request.getParameter("comefrom");
        USession.setComeFrom(StringUtil.ISO2GB2312(comefrom));

        // 用戶姓別
        String sex = request.getParameter("sex")==null?"":request.getParameter("sex");
        USession.setSex(StringUtil.ISO2GB2312(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");
        USession.setOicq(StringUtil.ISO2GB2312(oicq));

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

        // 個(gè)人主頁(yè)
        String homepage = request.getParameter("homepage")==null?"":request.getParameter("homepage");
        USession.setHomePage(StringUtil.ISO2GB2312(homepage));

        // 個(gè)人介紹
        String introduction = request.getParameter("introduction")==null?"":request.getParameter("introduction");
        USession.setIntroduction(StringUtil.ISO2GB2312(introduction));

        // 修改個(gè)人檔案
        strSql = "UPDATE USER_TBL SET USERNAME='" + StringUtil.escape(username) + "',NICENAME='" + StringUtil.escape(nicename) + "',SEX='" + sex + "',BIRTHDAY='" + b_year + "-" + b_month + "-" + b_day + "',OICQ='" + oicq + "',MAIL='" + mail + "',ORGNAME='" + StringUtil.escape(orgname) + "',UNITNAME='" + StringUtil.escape(unitname) + "',HOMEPAGE='" + StringUtil.escape(homepage) + "',COMEFROM='" + StringUtil.escape(comefrom) + "',INTRODUCTION='" + StringUtil.escape(introduction) + "' WHERE USERID='" + USession.getUserID() + "'";

        // 修改登錄session信息
        sqlutil.executeUpdate(strSql);
        request.getSession().setAttribute("UserSession", USession);
      }
      else if(command.equals("chgpwd"))
      {
        // 用戶密碼
        String password = request.getParameter("password")==null?"":request.getParameter("password");
        String oldpassword = request.getParameter("oldpassword")==null?"":request.getParameter("oldpassword");

        // 修改個(gè)人密碼
        strSql = "UPDATE USER_TBL SET PASSWORD='" + password + "' WHERE USERID='" + USession.getUserID() + "' AND PASSWORD='" + oldpassword + "'";
        sqlutil.executeUpdate(strSql);
      }

      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 = '" + USession.getUserID() + "' AND A.ROLEID = B.ROLEID";

      ResultSet resultset = sqlutil.executeQuery(strSql);

      parameters.setParameters("results","UserInfo", 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/useredit.jsp");
    }
    catch(Exception ex){
      ;
    }
  }


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


  }

}