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

/**
 * 題庫(kù)管理<br>
 * @author wang yong
 * @version 1.0
 */
public class LibManagerBean extends BusinessLogic{
  /**
   * 構(gòu)造函數(shù)
   */
  public LibManagerBean(){
    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{
      String strSql = "";
      ResultSet resultset = null;
      SqlUtil sqlutil = new SqlUtil();

      UserSession USession = (UserSession)request.getSession().getAttribute("UserSession");
      
      String command = "";
      if(parameters.getParameters("request", "command")!=null)
      {
        command = (String)parameters.getParameters("request", "command");
      }
   
      if(command.equals("add"))
      {
        // 添加題庫(kù)
        String libname = (String)parameters.getParameters("request", "libname");
        if(!libname.trim().equals(""))
        {
          strSql = "INSERT INTO LIB_TBL(LIBNAME,CREATEUSERID,CREATETIME,ONOFF) VALUES('" + StringUtil.escape(libname) + "', '" + USession.getUserID() + "', SYSDATE(), '0')";
          sqlutil.executeUpdate(strSql);
        }
      }
      else if(command.equals("del"))
      {
        String libid[] = null;
        if(request.getParameterValues("libid")!=null)
        {
          libid = (String[])request.getParameterValues("libid");
          for(int i=0; i<libid.length; i++)
          {
            // 刪除題庫(kù)
            strSql = "DELETE FROM LIB_TBL WHERE LIBID = '" + libid[i] + "'";
            sqlutil.executeUpdate(strSql);

            // 刪除該題庫(kù)下的所有考題
            strSql = "DELETE FROM LIBRARY_TBL WHERE LIBID = '" + libid[i] + "'";
            sqlutil.executeUpdate(strSql);
          }
        }
      }
      else if(command.equals("onoff"))
      {
        String libid = "";
        if(request.getParameter("libid")!=null)
        {
          libid = (String)request.getParameter("libid");

        }

        String onoff = "0";
        if(request.getParameter("onoffvalue")!=null)
        {
          onoff = (String)request.getParameter("onoffvalue");
        }

          // 改變題庫(kù)可用狀態(tài)
          strSql = "UPDATE LIB_TBL SET ONOFF='" + onoff + "' WHERE LIBID = '" + libid + "'";
          sqlutil.executeUpdate(strSql);
      }
      else
      {
      }

      strSql = "SELECT A.LIBID,A.LIBNAME,B.USERNAME AS CREATEUSERNAME,A.CREATETIME,A.ONOFF FROM LIB_TBL A,USER_TBL B WHERE A.CREATEUSERID=B.USERID ORDER BY A.CREATETIME";
      resultset = sqlutil.executeQuery(strSql);

      sqlutil.close();

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

      parameters.setParameters("results", "ForwardPage", "/framework/exam/liblist.jsp");

    }
    catch(Exception ex){
      System.out.println("error:"+ex.getMessage());;
    }
  }


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


  }

}