examquerylist.jsp

培训考试系统代码

<%@ page contentType="text/html;charset=gb2312"%>
<%@page import = "java.text.SimpleDateFormat" %>
<%@page import = "java.util.Date" %>
<%@ include file="/agt/public/jsp/top.jsp" %>

<%    Object sessionRs         =  session.getAttribute("EXAM-QUERY-RESULTSET");
      SysResultSet turnOrderRs =  sessionRs == null ?null:(SysResultSet)sessionRs;

%>
<%@ include file="/agt/public/jsp/Order.jsp"   %>
<!-- title>考试安排查询列表页面 </title -->
   <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;
      
      int tableWidth = 539;
      if("1".equalsIgnoreCase(byClass))
      {
         tableWidth = 500;
      }
 LinkedList authList = (LinkedList)session.getAttribute("AUTHLIST");
   %>

   <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%>">
   <input type="hidden" name="byQListDel" value="1">


                    <table width="<%=tableWidth%>" border="0" cellpadding="3" cellspacing="1" class="table-cs1">
                      <tr>
       <% 
          if(authList.contains("070304"))
          {
       %>
      <td width="5%" height="25"  align="center"  nowrap class="td-cs1">&nbsp;</td>
       <%}%>
                        <td width="48%" height="25" align="center" nowrap class="td-cs1"> <a href="/agt/exam/ExamQueryList.jsp?orderColum=1&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk">考试名称
                          </a></td>

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

                     

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

                        <td width="15%" height="25" align="center"  nowrap class="td-cs1"> <a href="/agt/exam/ExamQueryList.jsp?orderColum=5&orderFlag=<%=isOrderFlag%><%=queryTerm%>" class="lnk">结束时间</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) %>">
       <% 
          if(authList.contains("070304"))
          {
       %>
      <td height="25">
        <input type="checkbox" name="examIds" value="<%=turnOrderRs.getString(0) %>"></td>
      <%}%>
      
      <td height="25" style="word-break:break-all"><a href="/ExamMan.do?opeType=<%=OperatorFlagCode.EXAM_QUERY_DETAIL %>&examId=<%=turnOrderRs.getString(0) %>&directName=examdetail&byClass=<%=byClass %>&scope=<%=turnOrderRs.getString(6) %>"><%=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 = "取消";}

           
               String startTime = turnOrderRs.getString(4);
               
               String endTime = turnOrderRs.getString(5);
               if(endTime != null && !"".equalsIgnoreCase(endTime))
               {
                   SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");
                   String thisDate = df.format(new Date());

                   if(thisDate.compareTo(endTime) > -1 && state == 5)
                   {
                        stateStr  = "过期";
                   }         
               }
               
            %>

      <td height="25"><%=stateStr%></td>

     
      <td height="25"><%=startTime%></td>

      <td height="25"><%=endTime%></td>

          </tr>
        <%
                 }
             }
        %>
   </table>


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

  <table width="<%=tableWidth%>" height="30" border="0" cellpadding="0" cellspacing="0">
    <tr>
     <% 
      if(authList.contains("070304"))
      {
       %>
         <td width="15%"><input type="checkbox" name="selectItem" onclick="selectDo();"> 全选 </td>
    <% }
       if(authList.contains("070304"))
       {   
      %>   
         <td width="20%"><input name="cancel" type="image" onclick="cancleSubmit();return false;" src="/agt/public/images/cancel.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>
	 <td width="40%">
         <input name="del" type="image" onclick="deleteSubmit();return false;" src="/agt/public/images/del.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="<%=tableWidth%>" border="0" cellpadding="0" cellspacing="0">
    <tr>

   <td>总共有<font color="#FF0000"><%=recordCount%></font>条记录,<font color="#FF0000"><%=maxPage%></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 {%>末页  <%}%></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" onKeyPress="GoPageKeyPress();" <%if(maxPage < 2) { %> readonly <%}%>>
                      </td>
                      <td width="32">
<input name="go" type="image" onClick="changePageSubmit();return false;" <%if(maxPage < 2) { %> disabled <%}%> 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.value = "";
        pageNum.focus();
        return;
     }

     var maxPage = <%=maxPage%>;  //Order.jsp文件中已计算出maxPage
     var goPageNum = parseInt(pageNum.value) ;
     var maxNum = parseInt(maxPage) ;

     if(goPageNum < 1 || goPageNum > maxNum)
     {

         alert("跳转到的页数参数输入范围不正确,请重新输入。");
         pageNum.value = "";
         pageNum.focus();
         return;
     }
     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 deleteSubmit()
 {
    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 != "6")
        {
            alert("只有为取消状态的考试才能被删除,请重新选择!");
            return false;
        }
    }

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

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

    document.examForm.opeType.value = "<%=OperatorFlagCode.EXAM_DELETE%>";
    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" %>