examquerylist1.jsp

培训考试系统代码

<%@ page contentType="text/html;charset=gb2312"%>

<%@ include file="/agt/public/jsp/top.jsp" %>

<%    Object sessionRs         =  session.getAttribute("EXAM-QUERY-RESULTSET");
      SysResultSet turnOrderRs =  sessionRs == null ?null:(SysResultSet)sessionRs;
      String byClass  =  (String)session.getAttribute("BYCLASS");
%>
<%@ include file="/agt/public/jsp/Order.jsp"   %>
<!-- title>考试安排查询列表页面 </title -->
<%    SysResultSet turnOrderRs1 =  null;

      if(request.getAttribute("CLSMNG-GET-LIST") != null)
      {
         turnOrderRs1 = (SysResultSet)request.getAttribute("CLSMNG-GET-LIST");
      }


%>
   <form method="post" name="examForm" action="/ExamMan.do">
   <%
      //获取查询条件,并传送到下一页面
      String titleTerm = request.getParameter("titleTerm");
      String subjectTerm = request.getParameter("subjectTerm");
      String classIdTerm = request.getParameter("classIdTerm");
      String stateTerm = request.getParameter("stateTerm");
      String scopeTerm = request.getParameter("scopeTerm");
      String cityIdTerm = request.getParameter("cityIdTerm");
      String startTimeTerm = request.getParameter("startTimeTerm");
      String endTimeTerm = request.getParameter("endTimeTerm");
      String partStaffTerm = request.getParameter("partStaffTerm");

      String queryTerm = "&opeType=" + OperatorFlagCode.EXAM_QUERY;
      queryTerm += "&titleTerm=" + titleTerm;
      queryTerm += "&subjectTerm=" + subjectTerm;
      queryTerm += "&classIdTerm=" + classIdTerm;
      queryTerm += "&stateTerm=" + stateTerm;
      queryTerm += "&scopeTerm=" + scopeTerm;
      queryTerm += "&cityIdTerm=" + cityIdTerm;
      queryTerm += "&startTimeTerm=" + startTimeTerm;
      queryTerm += "&endTimeTerm=" + endTimeTerm;
      queryTerm += "&partStaffTerm=" + partStaffTerm;
      queryTerm += "&byClass=" + byClass;

   %>

   <input type="hidden" name="opeType" value="<%=OperatorFlagCode.EXAM_QUERY%>">

   <input type="hidden" name="titleTerm" value="<%=titleTerm%>">
   <input type="hidden" name="subjectTerm" value="<%=subjectTerm%>">
   <input type="hidden" name="classIdTerm" value="<%=classIdTerm%>">
   <input type="hidden" name="stateTerm" value="<%=stateTerm%>">
   <input type="hidden" name="scopeTerm" value="<%=scopeTerm%>">
   <input type="hidden" name="cityIdTerm" value="<%=cityIdTerm%>">
   <input type="hidden" name="startTimeTerm" value="<%=startTimeTerm%>">
   <input type="hidden" name="endTimeTerm" value="<%=endTimeTerm%>">
   <input type="hidden" name="partStaffTerm" value="<%=partStaffTerm%>">
   <input type="hidden" name="byClass" value="<%=byClass%>">


                    <table width="539" border="0" cellpadding="3" cellspacing="1" class="table-cs1">
                      <tr class="td-cs1">
      <td width="5%" height="25"  align="center"  nowrap>&nbsp;</td>

      <td width="50%" height="25" align="center" nowrap> <a href="/agt/exam/ExamQueryList.jsp?orderColum=1&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk-cs1">考试名称
        </a></td>

      <td width="8%" height="25" align="center"  nowrap> <a href="/agt/exam/ExamQueryList.jsp?orderColum=3&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk-cs1">状态
        </a></td>

      <td width="8%" height="25" align="center"  nowrap> <a href="/agt/exam/ExamQueryList.jsp?orderColum=6&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk-cs1">范围
        </a></td>

      <td width="15%" height="25" align="center"  nowrap> <a href="/agt/exam/ExamQueryList.jsp?orderColum=4&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk-cs1">开始时间</a>
      </td>

      <td width="15%" height="25" align="center"  nowrap> <a href="/agt/exam/ExamQueryList.jsp?orderColum=5&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk-cs1">结束时间</a>
      </td>
     </tr>

       <%
            if( turnOrderRs != null && turnOrderRs.getMetaData().getRecordCount() != 0 )
            {
                //此处是用来显示结果
                for(int i=(pageNum-1)*pageRecoder; turnOrderRs.setRecord(i)&&(i<pageNum*pageRecoder); i++)
                {
        %>

    <tr class="td-cs2">
<input type="hidden" name="state" value="<%=turnOrderRs.getInt(3) %>">

      <td height="25">
        <input type="checkbox" name="examIds" value="<%=turnOrderRs.getString(0) %>"></td>

                        <td height="25" align="center" style="word-break:break-all"><a class="lnk-cs2" href="/ExamMan.do?opeType=<%=OperatorFlagCode.EXAM_QUERY_DETAIL %>&examId=<%=turnOrderRs.getString(0) %>&directName=examdetail"><%=turnOrderRs.getString(1) %></a></td>
            <% int state = turnOrderRs.getInt(3);
               String stateStr = "";
               if(state == 0) { stateStr = "录入";}
               else if(state == 1) { stateStr = "审查";}
               else if(state == 2) { stateStr = "审查不通过";}
               else if(state == 3) { stateStr = "审批";}
               else if(state == 4) { stateStr = "审批不通过";}
               else if(state == 5) { stateStr = "发布";}
               else { stateStr = "取消";}

               int scope = turnOrderRs.getInt(6);
               String scopeStr = "";
               if(scope == 0) {scopeStr = "开放式";}
               else {scopeStr = "限制式";}

               String startTime = turnOrderRs.getString(4);
               if(startTime == null)
               {
                  startTime = "&nbsp;";
               }
               String endTime = turnOrderRs.getString(5);
               if(endTime == null)
               {
                  endTime =  "&nbsp;";
               }
            %>

                        <td height="25" align="center"><%=stateStr%></td>
                        <td height="25" align="center"><%=scopeStr%></td>
                        <td height="25" align="center"><%=startTime%></td>
                        <td height="25" align="center"><%=endTime%></td>
          </tr>
        <%
                 }
             }
        %>
   </table>


 <%if( turnOrderRs != null && turnOrderRs.getMetaData().getRecordCount() != 0 )
 {%>

  <table width="539" height="30" border="0" cellpadding="0" cellspacing="0">
    <tr>
         <td width="22%"><input type="checkbox" name="selectItem" onclick="selectDo();"> 全选 </td>
         <td width="22%">
                          <input name="search_exam" onClick="statSubmit();return false;" type="image"  src="/agt/public/images/search_exam.gif" width="100" height="22" border="0" onMouseOver="this.src='/agt/public/images/'+ this.name + '_2.gif';" onMouseOut="this.src='/agt/public/images/'+ this.name + '.gif'"></td>
         <td width="56%">
                          <input name="cancel_exam" type="image" onclick="cancleSubmit();return false;" src="/agt/public/images/cancel_exam.gif" width="82" height="22" border="0" onmouseover="this.src='/agt/public/images/'+ this.name + '_2.gif';" onmouseout="this.src='/agt/public/images/'+ this.name + '.gif'"></td>
      </tr>
   </table>
 <%}%>
   </form>
   <form method="post" name="changePageForm">
  <table width="539" border="0" cellpadding="0" cellspacing="0">
    <tr>

   <td>总共有<font color="#FF0000"><%=recordCount%></font>条记录</td>
   <td>当前第<font color="#FF0000"><%=pageNum%></font>页</td>
   <td><%if(pageNum != 1) {%><a href="/agt/exam/ExamQueryList.jsp?pageNum=1&orderFlag=<%=isOrderFlag%><%=queryTerm%>">首页 </a><%} else {%>首页 <%}%></td>
   <td><%if(pageNum != 1) {%><a href="/agt/exam/ExamQueryList.jsp?pageNum=<%=frontPageNum%>&orderFlag=<%=isOrderFlag%><%=queryTerm%>">上一页 </a><%} else {%>上一页  <%}%></td>
   <td ><%if(pageNum < maxPage) {%><a href="/agt/exam/ExamQueryList.jsp?pageNum=<%=backPageNum%>&orderFlag=<%=isOrderFlag%><%=queryTerm%>">下一页 </a><%} else {%> 下一页<%}%></td>
   <td><%if(pageNum < maxPage) {%><a href="/agt/exam/ExamQueryList.jsp?pageNum=<%=maxPage%>&orderFlag=<%=isOrderFlag%><%=queryTerm%>">末页 </a><%} else {%>末页  <%}%>&nbsp;跳转到</td>
      <td>
	  <table width="113" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td width="44"> 跳转到 </td>
                      <td width="37">
<input name="pageNum" type="text" class="input1-2" size="3">
                      </td>
                      <td width="32">
<input name="go" type="image" onClick="changePageSubmit();return false;" src="/agt/public/images/go.jpg" width="21" height="21" border="0" onMouseOver="this.src='/agt/public/images/'+ this.name + '_2.jpg';" onMouseOut="this.src='/agt/public/images/'+ this.name + '.jpg'"></td>
                    </tr>
                  </table>
      </td>

  </tr>
  </table>		     <input type="hidden" name="orderFlag" value="<%=isOrderFlag%>">     </form>
 <script src="/agt/public/js/scriptfuns.js" type="text/javascript"></script>
 <script  language="JavaScript">

 //跳页的检查与提交
 function changePageSubmit()
 {

     var pageNum = document.changePageForm.pageNum;

     if(pageNum==null || trim(pageNum.value)=="" || !isNumber(pageNum.value) )
     {
        alert("跳转到的页数输入有误,请重新输入！");
        pageNum.focus();
       return false;
     }

     document.changePageForm.action="/agt/exam/ExamQueryList.jsp?orderFlag=<%=isOrderFlag%><%=queryTerm%>";
     document.changePageForm.submit();
 }

 //全选的处理
 function selectDo()
 {
     var selectItem = document.examForm.selectItem;
     var examIds = document.examForm.examIds;
     if(examIds == null)
     {
        return false;
     }
     if(selectItem.checked == true)
     {
         for(var i=0; i<examIds.length;i++)
         {
            examIds[i].checked = true;
         }
         examIds.checked = true;
     }
     else
     {
         for(var i=0; i<examIds.length;i++)
         {
            examIds[i].checked = false;
         }
         examIds.checked = false;
     }

 }


 //取消考试提交
 function cancleSubmit()
 {
    var selectedCount = getSelectedCount();
    var state = document.examForm.state;
    var examIds = document.examForm.examIds;

    if(selectedCount == 0)
    {
        alert("取消考试必须先选中一条考试！") ;
        return false ;
    }

    for(var i=0;i<examIds.length;i++)
    {
        if(examIds[i].checked == true && state[i].value != "5")
        {
            alert("只有为发布状态的考试才能被取消,请重新选择!");
            return false;
        }
    }

    if(examIds.checked == true && state.value != "5")
    {//只有一条考试
        alert("只有为发布状态的考试才能被取消,请重新选择!");
        return false;
    }

    if( !window.confirm("是否取消所选中的考试,请确认。"))
    {
        return false ;
    }

    document.examForm.opeType.value = "<%=OperatorFlagCode.EXAM_CANCEL%>";
    document.examForm.submit();
 }

 //查询考试结果的检查与提交
 function statSubmit()
 {
    var selectedCount = getSelectedCount();

    if(selectedCount == 0)
    {
        alert("查询考试结果必须先选中一条考试！") ;
        return false;
    }

    if(selectedCount > 1)
    {
        alert("一次只能查询一条考试结果,请重新选择！") ;
        return false ;
    }
    document.examForm.opeType.value = "<%=OperatorFlagCode.EXAM_GET_STATINFO%>";
    document.examForm.submit();
 }

 //计算选择的个数
 function getSelectedCount()
 {
    var selectedCount = 0;
    var examIds = document.examForm.examIds;

    if(examIds == null)
    {
       return false;
    }

    if(examIds.checked == true)
    {
       selectedCount = selectedCount + 1;
    }

    for(var i=0; i<examIds.length;i++)
    {
        if(examIds[i].checked == true)
        {
            selectedCount = selectedCount + 1;
        }
    }
    return selectedCount;
 }
</script>

<%@ include file="/agt/public/jsp/bot.jsp" %>