package swdyx.bhdt;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import swdyx.common.*;
import java.util.*;
import javax.sql.*;
public class DsjAction
    extends Action {
  private static final int PAGE_LENGTH = 10;
  public ActionForward execute(ActionMapping actionMapping,
                               ActionForm actionForm, HttpServletRequest
                               httpServletRequest,
                               HttpServletResponse httpServletResponse) {
    ActionForward myforward = null;
    String myaction = actionMapping.getParameter();

    if ("DsjList".equals(myaction)) {
      myforward = performDsjList(actionMapping, actionForm,
                                    httpServletRequest,
                                    httpServletResponse);
    }
    else if ("DsjCk".equals(myaction)) {
      myforward = performDsjCk(actionMapping, actionForm,
                                  httpServletRequest,
                                  httpServletResponse);
    }

    return myforward;
  }

  //進入大事記信息頁面
  public ActionForward performDsjList(ActionMapping actionMapping,
                                         ActionForm actionForm,
                                         HttpServletRequest httpServletRequest,
                                         HttpServletResponse
                                         httpServletResponse) {
    //定義session
    HttpSession mySession = httpServletRequest.getSession();
    //設置初始查詢條件
    mySession.setAttribute("DSJ", "1=1");
    //清空頁碼session
    mySession.setAttribute("PAGE", "");
    try {

      // 連接數據源
      DataSource ds = Datasource.getDataSource();
      List dsj = null;
      dsj = SperatePage(actionMapping, actionForm, httpServletRequest,
                           httpServletResponse);
      httpServletRequest.setAttribute("TYPE", dsj);

    }
    catch (Exception e) {
      return actionMapping.findForward("error");
    }
      return actionMapping.findForward("success");

 } //進入大事記信息頁面  方法執行完畢

//打開列表時所用的分頁方法     此方法為通用方法
  public List SperatePage(ActionMapping actionMapping,
                          ActionForm actionForm,
                          HttpServletRequest httpServletRequest,
                          HttpServletResponse httpServletResponse) {
    List dsj = null;
    try {
      //連接數據源
      DataSource ds = Datasource.getDataSource();
      //建立BhdtDao的對象bhdtDao
      DsjDao dsjDao = new DsjDao(ds);

      int offset; //申明頁碼變量

      //獲取頁面參數pager.offset 如：10 表示第二頁
      String pageOffset = httpServletRequest.getParameter("pager.offset");

      //定位分頁符
      //定義頁碼session
      HttpSession pagesession = httpServletRequest.getSession();

      //判斷頁碼是否存在
      if (pageOffset == null || pageOffset.equals("")) { //如果不能從頁面上取到頁碼或者取到的頁碼為空 則從第一次進來時設置的頁碼session中取
        pageOffset = pagesession.getAttribute("PAGE").toString();
      }
      //把取得的頁碼放入session
      pagesession.setAttribute("PAGE", pageOffset);

      if (pageOffset == null || pageOffset.equals("")) { //如果此時獲得的頁碼還為空  則設置offset為0  否則offest=Integer.parseInt(pageOffset
        offset = 0;
      }
      else {
        offset = Integer.parseInt(pageOffset);
      }

      int size = 0;
      //當前url路徑
      String url = httpServletRequest.getContextPath() + actionMapping.getPath() +
          ".do";

      //獲取當前的查詢條件  //從第一次進入該模塊設置的session 中取   或者  從檢索條件中設置的session 中取
      HttpSession mySession = httpServletRequest.getSession();
      String sFilter;
      sFilter = (String) mySession.getAttribute("DSJXX");
      //所有記錄數
      size = dsjDao.countlist(sFilter);
      //分頁顯示連接   調用分頁方法
      String pagerHeader = Separatepage.geneHtml(offset, size, PAGE_LENGTH, url);
      httpServletRequest.setAttribute("pagerHeader", pagerHeader);
      dsj = dsjDao.list(offset, PAGE_LENGTH, sFilter);

    }
    catch (Exception e) {
    }
    return dsj;
  } //打開列表時所用的分頁方法    方法執行完畢

//打開各大事記信息頁面
  public ActionForward performDsjCk(ActionMapping actionMapping,
                                       ActionForm actionForm,
                                       HttpServletRequest httpServletRequest,
                                       HttpServletResponse
                                       httpServletResponse) {

    //獲取頁面傳來參數
    String xh = httpServletRequest.getParameter("xh");
    try {
      // 連接數據源
      DataSource ds = Datasource.getDataSource();

      //查看各大事記的具體信息
      DsjDao dsjDao = new DsjDao(ds);
      BhdtBo bhdtBo = dsjDao.retrieve(xh);
      httpServletRequest.setAttribute("DSJ", bhdtBo);

    }
    catch (Exception e) {
      return actionMapping.findForward("error");
    }
    return actionMapping.findForward("success");

  } //end

}