lessonoperatoraction.java

培训考试系统代码

        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return servlet.findForward("error");
        }
        finally
        {
            con.close();
        }
        req.setAttribute("successId",SuccessCode.LESSON_MOD);
        return servlet.findForward("success");
    }

    /**
     * 审批通过或者驳回功能
     * @param mapping
     * @param form
     * @param req
     * @return
     */
    private ActionForward checkOperator(ActionMapping mapping,
                                        LessonMngOperatorForm    form,
                                        HttpServletRequest req)
    {
        SysConnPool cspool = null;
        SysDbConn con = null;
        try
        {
            log(form.getLessonid()[0]);
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedQuery("");
            con.setInt(1,form.getState());
            con.setString(2,form.getCheckNotion());
            con.setString(3,form.getHandleid());
            con.setString(4,form.getLessonid()[0]);

            con.csCommonQuery("SQL_AGT_LESSONCHECK","1","-1");
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return servlet.findForward("error");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return servlet.findForward("error");
        }
        finally
        {
            con.close();
        }
        form.setState(1);
        return checkList(mapping,form,req);
    }


 /**
   * 提交审查操作
   * @param mapping
   * @param form
   * @param req
   * @return
   */
  private ActionForward draftSub(ActionMapping mapping,
                             LessonMngOperatorForm    form,
                             HttpServletRequest req)
  {
      log("draft now ....");
      SysConnPool cspool = null;
      SysDbConn con = null;
      String lesson[] = form.getLessonid();
      String lessonids ="";
      if( lesson != null)
      {
          for( int i=0;i < lesson.length-1; i++)
          {
              lessonids += lesson[i]+"~";
          }
          lessonids = lessonids +lesson[lesson.length -1];
      }
      try
      {
          cspool = SysConnPool.getInstance();
          con = cspool.getAplComs();
          con.preparedSP();
          con.setString(1,lessonids);
          SysRecord  res = con.csCommonSP("p_agt_lessondraftsub").getParamSet();
          if( res.getInt(0) != 0)
          {
              req.setAttribute("errorId",ErrorCode.LESSON_DRAFT);
              return servlet.findForward("error");
          }
      }
      catch(SysDbException e)
      {
          e.printStackTrace();
          req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
          return servlet.findForward("error");
      }
      catch(java.sql.SQLException e)
      {
          e.printStackTrace();
          req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
          return servlet.findForward("error");
      }
      finally
      {
          con.close();
      }
      form.setState(0);
      return draftList(mapping ,form,req);
  }


  /**
   * 取消课程操作
   * @param mapping
   * @param form
   * @param req
   * @return
   */
  private ActionForward cancel(ActionMapping mapping,
                               LessonMngOperatorForm    form,
                               HttpServletRequest req)
    {
        log("cancel now ....");
        SysConnPool cspool = null;
        SysDbConn con = null;
        String lesson[] = form.getLessonid();
        String lessonids ="";
        if( lesson != null)
        {
            for( int i=0;i < lesson.length-1; i++)
            {
                lessonids += lesson[i]+"~";
            }
            lessonids = lessonids +lesson[lesson.length -1];
        }
        try
        {
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedSP();
            con.setString(1,lessonids);
              //System.out.println("oklist");
            SysRecord  res = con.csCommonSP("p_agt_lessondcancel").getParamSet();
            if( res.getInt(0) != 0)
            {
                req.setAttribute("errorId",ErrorCode.LESSON_DRAFT);
                return servlet.findForward("error");
            }
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return servlet.findForward("error");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return servlet.findForward("error");
        }
        finally
        {
            con.close();
        }

       return manList(mapping,form,req);

  }

    /**
     * 进入审批页面
     * @param mapping
     * @param form
     * @param req
     * @return
     */
    private ActionForward pass(ActionMapping mapping,
                               LessonMngOperatorForm    form,
                               HttpServletRequest req)
    {
        SysConnPool cspool = null;
        SysDbConn con = null;
        try
        {
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            getDetail(con,form,req);
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return servlet.findForward("error");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return servlet.findForward("error");
        }
        catch(Exception e)
        {
           e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
            return servlet.findForward("error");
        }
        finally
        {
            con.close();
        }
        return mapping.findForward("pass");
    }

    /**
     * 审批操作
     * @param mapping
     * @param form
     * @param req
     * @return
     */
    private ActionForward passOperator(ActionMapping mapping,
                                       LessonMngOperatorForm    form,
                                       HttpServletRequest req)
    {
        SysConnPool cspool = null;
        SysDbConn con = null;
        try
        {
            log(form.getLessonid()[0]);
            log(form.getState()+"state");
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedQuery("");
            con.setInt(1,form.getState());
            con.setString(2,form.getConfirmNotion());
            con.setString(3,form.getLessonid()[0]);
            con.csCommonQuery("SQL_AGT_LESSONPASS","1","-1");

           //发布操作成功
           if(form.getState() == 5)
           { //发邮件通知
              con.preparedSP();
              con.setString(1 ,form.getLessonid()[0]);
              con.setInt(2,Initor.systemConfig.getInt("agt/lessonNotify",4));
              SysDataSet ds2 = con.csCommonSP("P_Agt_LessonSendEmail");
              SysRecord rc2 = ds2.getParamSet() ;
           }

        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return servlet.findForward("error");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return servlet.findForward("error");
        }
        finally
        {
            con.close();
        }
        form.setState(3);
        return passList(mapping,form,req);
    }
    /**
     * 删除功能
     * @param mapping
     * @param form
     * @param req
     * @return
     */
    private ActionForward delete(ActionMapping mapping,
                                 LessonMngOperatorForm    form,
                                 HttpServletRequest req)
    {
        log("delete now ....");
        SysConnPool cspool = null;
        SysDbConn con = null;
        String lesson[] = form.getLessonid();
        String lessonids ="";
        if( lesson != null)
        {
            for( int i=0;i < lesson.length-1; i++)
            {
                lessonids += lesson[i]+"~";
            }
            lessonids = lessonids +lesson[lesson.length -1];
        }
        try
        {
            cspool = SysConnPool.getInstance();
            con = cspool.getAplComs();
            con.preparedSP();
            con.setString(1,lessonids);
            SysRecord  res = con.csCommonSP("p_agt_lessondel").getParamSet();
            if( res.getInt(0) != 0)
            {
                req.setAttribute("errorId",ErrorCode.LESSON_DEL);
                return servlet.findForward("error");
            }
        }
        catch(SysDbException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
            return servlet.findForward("error");
        }
        catch(java.sql.SQLException e)
        {
            e.printStackTrace();
            req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
            return servlet.findForward("error");
        }
        finally
        {
            con.close();
        }

         if("1".equalsIgnoreCase(req.getParameter("cdel")))
         {
           return manList(mapping, form, req);
         }
         else
         {
          return draftList(mapping,form,req);
         }
    }

    /**
     * 用来得到草稿箱,审查列表,审阅列表
     * @param mapping
     * @param form
     * @param req
     */
    private void list(SysDbConn con,
                      LessonMngOperatorForm    form,
                      HttpServletRequest req) throws SysDbException ,
    SQLException
    {
        con.preparedSP();
        con.setString(1,req.getSession().getAttribute("staffno").toString());
        con.setString(2,form.getState()+"");
        log("state"+ form.getState());
        //省，市中心编码开始默认是相同的
        con.setString(3,"00");
        con.setString(4,"00");

        SysResultSet res = con.csCommonSP("p_agt_lessonlist").getResultSet();
        //System.out.println("res"+ res.getMetaData().getRecordCount());
        req.getSession().setAttribute("LESSON_LIST_RES",res);