/*
 * @(#)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 EditLibraryBean extends BusinessLogic{
  /**
   * 構造函數(shù)
   */
  public EditLibraryBean(){
    System.out.println("FrameWork：業(yè)務處理類實例化完成【" + this.getClass().getName() + "】");
  }

  /**
   * 業(yè)務邏輯處理機能
   */
  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 = request.getParameter("command")==null?"":request.getParameter("command");
      String libid = request.getParameter("libid")==null?"":request.getParameter("libid");
      String libraryid = request.getParameter("libraryid")==null?"":request.getParameter("libraryid");
      String categoryid = request.getParameter("category")==null?"":request.getParameter("category");
      String levelid = request.getParameter("level")==null?"":request.getParameter("level");
      String title = request.getParameter("title")==null?"":request.getParameter("title");
      String[] answers = request.getParameterValues("answers");
      String answer = "";
      if(answers!=null)
      {
        for(int i=0; i<answers.length; i++)
        {
          if(i<answers.length-1)
          {
            answer = answer + answers[i] + ",";
          }
          else
          {
            answer = answer + answers[i];
          }
        }
      }

      String answerA = request.getParameter("answerA")==null?"":request.getParameter("answerA");
      String answerB = request.getParameter("answerB")==null?"":request.getParameter("answerB");
      String answerC = request.getParameter("answerC")==null?"":request.getParameter("answerC");
      String answerD = request.getParameter("answerD")==null?"":request.getParameter("answerD");
      String answerE = request.getParameter("answerE")==null?"":request.getParameter("answerE");
      String answerF = request.getParameter("answerF")==null?"":request.getParameter("answerF");
      String answerG = request.getParameter("answerG")==null?"":request.getParameter("answerG");

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

      if(command.equals("add"))
      {
        // 添加試題
        strSql = "INSERT INTO LIBRARY_TBL(LIBID,CATEGORYID,LEVELID,TITLE,ANSWER,A,B,C,D,E,F,G,ONOFF,CREATETIME) VALUES('"+libid+"','"+categoryid+"','"+levelid+"','"+StringUtil.escape(title)+"','"+answer+"','"+StringUtil.escape(answerA)+"','"+StringUtil.escape(answerB)+"','"+StringUtil.escape(answerC)+"','"+StringUtil.escape(answerD)+"','"+StringUtil.escape(answerE)+"','"+StringUtil.escape(answerF)+"','"+StringUtil.escape(answerG)+"','"+onoff+"',SYSDATE())";
        sqlutil.executeUpdate(strSql);
      }
      else if(command.equals("update"))
      {
        // 編輯試題
        strSql = "UPDATE LIBRARY_TBL SET CATEGORYID='"+categoryid+"',LEVELID='"+levelid+"',TITLE='"+StringUtil.escape(title)+"',ANSWER='"+answer+"',A='"+StringUtil.escape(answerA)+"',B='"+StringUtil.escape(answerB)+"',C='"+StringUtil.escape(answerC)+"',D='"+StringUtil.escape(answerD)+"',E='"+StringUtil.escape(answerE)+"',F='"+StringUtil.escape(answerF)+"',G='"+StringUtil.escape(answerG)+"',ONOFF='"+onoff+"' WHERE LIBRARYID = '" + libraryid + "'";
        sqlutil.executeUpdate(strSql);
      }

      if(!command.equals("add"))
      {
        strSql = "SELECT A.LIBRARYID,A.CATEGORYID,B.CATEGORYNAME,A.LEVELID,C.LEVELNAME,A.TITLE,A.ANSWER,A.A,A.B,A.C,A.D,A.E,A.F,A.G,A.ONOFF FROM LIBRARY_TBL A,CATEGORY_TBL B,LEVEL_TBL C WHERE A.CATEGORYID=B.CATEGORYID AND A.LEVELID=C.LEVELID AND A.LIBRARYID='" + libraryid + "'";
        resultset = sqlutil.executeQuery(strSql);
        parameters.setParameters("results","LibraryEdit", resultset);
      }

      strSql = "SELECT CATEGORYID,CATEGORYNAME FROM CATEGORY_TBL";
      resultset = sqlutil.executeQuery(strSql);
      parameters.setParameters("results","CategoryList", resultset);

      strSql = "SELECT LEVELID,LEVELNAME FROM LEVEL_TBL";
      resultset = sqlutil.executeQuery(strSql);
      parameters.setParameters("results","LevelList", resultset);
      sqlutil.close();

      parameters.setParameters("results", "ForwardPage", "/framework/exam/libraryedit.jsp");
    }
    catch(Exception ex){
      System.out.println("error:"+ex.getMessage());;
    }
  }


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


  }

}