testdetaillist.jsp

来自「培训考试系统代码」· JSP 代码 · 共 613 行

JSP
613
字号
<%@ page contentType="text/html;charset=gb2312"%>

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



<%    Object sessionRs         =  session.getAttribute("TRNMNG-TESTLIST");

      SysResultSet turnOrderRs =  sessionRs == null ?null:(SysResultSet)sessionRs;

%>

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

<title>个人培训档案列表</title>

 <script src="/agt/public/js/scriptfuns.js" type="text/javascript"></script>

<%

    String vstaffno = "";

    String vstaffname = "";

    String vgroup = "";

    String vdepartment = "";

    String vskill = "";



    if (request.getAttribute("staffno") !=null)

    {

        vstaffno = (String)request.getAttribute("staffno");

    }

    else

    {

        vstaffno = (String)request.getParameter("staffno");

    }



    if (request.getAttribute("staffname") !=null)

    {

        vstaffname = (String)request.getAttribute("staffname");

    }

    else

    {

        vstaffname = (String)request.getParameter("staffname");

    }



    if (request.getAttribute("group") !=null)

    {

        vgroup = (String)request.getAttribute("group");

    }

    else

    {

        vgroup = (String)request.getParameter("group");

    }



    if (request.getAttribute("department") !=null)

    {

        vdepartment = (String)request.getAttribute("department");

    }

    else

    {

        vdepartment = (String)request.getParameter("department");

    }



    if (request.getAttribute("skill") !=null)

    {

        vskill = (String)request.getAttribute("skill");

    }

    else

    {

        vskill = (String)request.getParameter("skill");

    }

    %>



<form method="post" name="TrnmngForm" action="/TrnmngAction.do">

<table width="539" border="0" cellpadding="3" cellspacing="1" class="table-cs1">
                    <tr>

                      <td width="15%" align="center" class="td-cs1">工号</td>

                      <td width="25%" class="td-cs2"><%=vstaffno%></td>

                      <td width="15%" align="center" class="td-cs1">姓名</td>

                      <td width="45%" class="td-cs2"><%=vstaffname%></td>

  </tr>

  <tr>

                      <td  align="center" class="td-cs1">业务组</td>

                      <td class="td-cs2"><%=vgroup%></td>

                      <td  align="center" class="td-cs1">部门</td>

    <td class="td-cs2"><%=vdepartment%></td>

  </tr>

  <tr>

                      <td align="center" class="td-cs1">技能</td>

    <td colspan = "3" class="td-cs2"><%=vskill%></td>

  </tr>

</table>




<input type="hidden" name="operatorflag">

<input type="hidden" name="testid" >

<input type="hidden" name="staffno" value =<%=vstaffno%>>

                    <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="20%" align="center" nowrap> <a class="lnk-cs1" href="/agt/trnmng/testdetaillist.jsp?orderColum=1&orderFlag=<%=isOrderFlag%>&staffno=<%=vstaffno%>&staffname=<%=vstaffname%>&group=<%=vgroup%>&department=<%=vdepartment%>&skill=<%=vskill%>">考试名称
                          </a> </td>



                        <td width="15%" align="center"  nowrap> <a class="lnk-cs1" href="/agt/trnmng/testdetaillist.jsp?orderColum=2&orderFlag=<%=isOrderFlag%>&staffno=<%=vstaffno%>&staffname=<%=vstaffname%>&group=<%=vgroup%>&department=<%=vdepartment%>&skill=<%=vskill%>">考试时间
                          </a> </td>






                        <td width="20%" align="center"  nowrap> <a class="lnk-cs1" href="/agt/trnmng/testdetaillist.jsp?orderColum=3&orderFlag=<%=isOrderFlag%>&staffno=<%=vstaffno%>&staffname=<%=vstaffname%>&group=<%=vgroup%>&department=<%=vdepartment%>&skill=<%=vskill%>">考试类型
                          </a> </td>



                        <td width="7%" align="center"  nowrap> <a class="lnk-cs1" href="/agt/trnmng/testdetaillist.jsp?orderColum=4&orderFlag=<%=isOrderFlag%>&staffno=<%=vstaffno%>&staffname=<%=vstaffname%>&group=<%=vgroup%>&department=<%=vdepartment%>&skill=<%=vskill%>">成绩</a>
                        </td>

                        <td width="8%" align="center"  nowrap> <a class="lnk-cs1" href="/agt/trnmng/testdetaillist.jsp?orderColum=8&orderFlag=<%=isOrderFlag%>&staffno=<%=vstaffno%>&staffname=<%=vstaffname%>&group=<%=vgroup%>&department=<%=vdepartment%>&skill=<%=vskill%>">总分</a>
                        </td>


                        <td width="15%" align="center"  nowrap> <a class="lnk-cs1" href="/agt/trnmng/testdetaillist.jsp?orderColum=5&orderFlag=<%=isOrderFlag%>&staffno=<%=vstaffno%>&staffname=<%=vstaffname%>&group=<%=vgroup%>&department=<%=vdepartment%>&skill=<%=vskill%>">是否通过</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">
                        <td height="25">
                          <input type="checkbox" name="testidarray" value="<%=turnOrderRs.getString(0)%>"></td>

                        <td align="center" style="width:100;word-break:break-all"><a class="lnk-cs2" href ="/TrnmngAction.do?operatorflag=TRNMNG_QUERYATEST&testid=<%=turnOrderRs.getString(0)%>&staffno=<%=vstaffno%>">
                          <%=turnOrderRs.getString(1)%></a></td>
                        <td align="center">
                        <% if (!(turnOrderRs.getString(2).equals(""))){%> 
                        <%=turnOrderRs.getString(2).substring(0,4)+"-"+turnOrderRs.getString(2).substring(4,6)+"-"+turnOrderRs.getString(2).substring(6,8)%>
                        <%}%>
                        </td>
                        <td align="center">
                        <%if(turnOrderRs.getString(3).equals("0")) { %> 考试 <%}%>                        
                        <%if(turnOrderRs.getString(3).equals("1")) { %> 考核 <%}%>                        
                        </td>
                        <td align="center"><%=turnOrderRs.getString(4)%></td>
                        <td align="center"><%=turnOrderRs.getString(8)%></td>
                        <td align="center">
                        <%if(turnOrderRs.getString(5).equals("0")) { %> 未通过 <%}%>                        
                        <%if(turnOrderRs.getString(5).equals("1")) { %> 通过 <%}%>                        
                        </td>



          </tr>

        <%

                 }

            }

        %>

   </table>



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

 {%>
                    <table width="539" border="0" cellpadding="0" cellspacing="0" class="table-cs1">
                      <tr>
                        <td width="91" height="25"> <input type="checkbox" name="selectItem" onclick="selectDo();">
                          全选 </td>
                          <td width="101"> <input name="edit" type="image" onclick="modifySubmit();return false;" src="/agt/public/images/edit.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="347" height="35"> <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="539" height="25" border="0" cellpadding="0" cellspacing="1">
                    <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/trnmng/testdetaillist.jsp?pageNum=1&orderFlag=<%=isOrderFlag%>&staffno=<%=vstaffno%>&staffname=<%=vstaffname%>&group=<%=vgroup%>&department=<%=vdepartment%>&skill=<%=vskill%>">首页 </a><%} else {%>首页 <%}%></td>

   <td><%if(pageNum != 1) {%><a href="/agt/trnmng/testdetaillist.jsp?pageNum=<%=frontPageNum%>&orderFlag=<%=isOrderFlag%>&staffno=<%=vstaffno%>&staffname=<%=vstaffname%>&group=<%=vgroup%>&department=<%=vdepartment%>&skill=<%=vskill%>">上一页 </a><%} else {%>上一页  <%}%></td>

   <td ><%if(pageNum < maxPage) {%><a href="/agt/trnmng/testdetaillist.jsp?pageNum=<%=backPageNum%>&orderFlag=<%=isOrderFlag%>&staffno=<%=vstaffno%>&staffname=<%=vstaffname%>&group=<%=vgroup%>&department=<%=vdepartment%>&skill=<%=vskill%>">下一页 </a><%} else {%> 下一页<%}%></td>

   <td><%if(pageNum < maxPage) {%><a href="/agt/trnmng/testdetaillist.jsp?pageNum=<%=maxPage%>&orderFlag=<%=isOrderFlag%>&staffno=<%=vstaffno%>&staffname=<%=vstaffname%>&group=<%=vgroup%>&department=<%=vdepartment%>&skill=<%=vskill%>">末页 </a><%} else {%>末页  <%}%>&nbsp; 跳转到</td>

       <td>
                          <input name="pageNum" type="text" class="input1-2" size="3" onKeyPress="GoPageKeyPress();" <%if(maxPage < 2) { %> readonly <%}%>>
		<input type="hidden" name="orderFlag" value="<%=isOrderFlag%>">

      </td>
      <td><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>    </form>

                  <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/trnmng/testdetaillist.jsp?staffno=<%=vstaffno%>&staffname=<%=vstaffname%>&group=<%=vgroup%>&department=<%=vdepartment%>&skill=<%=vskill%>";

     document.changePageForm.submit();

  }



 function selectDo()

 {

     var selectItem = document.TrnmngForm.selectItem;

     var testidarray = document.TrnmngForm.testidarray;

     if (testidarray.value != null)

     {

        if (selectItem.checked == true)

        {

            testidarray.checked = true;

        }

        else

        {

            testidarray.checked = false;

        }

     }

     else

     {

        if(testidarray == null)

        {

            return false;

        }

        if(selectItem.checked == true)

        {

            for(var i=0; i<testidarray.length;i++)

            {

                testidarray[i].checked = true;

            }

        }

        else

        {

            for(var i=0; i<testidarray.length;i++)

            {

                testidarray[i].checked = false;

            }

        }

    }

 }



 function modifySubmit()

 {

    var selectedCount = 0;

    var testidarray = document.TrnmngForm.testidarray;



    if(testidarray == null)

    {

       return false;

    }



    if (testidarray.value != null)

    {

        if(testidarray.checked)

        {

            document.TrnmngForm.testid.value = testidarray.value;

        }

        else

        {

            alert("修改档案必须先选中一条档案") ;

            return false ;

        }

    }

    else

    {

        for(var i=0; i<testidarray.length;i++)

        {

            if(testidarray[i].checked == true)

            {

                selectedCount = selectedCount + 1;

                document.TrnmngForm.testid.value = testidarray[i].value;

            }

        }

        if(selectedCount == 0)

        {

            alert("修改档案必须先选中一条档案") ;

            return false ;

        }

        if(selectedCount != 1)

        {

            alert("每次只能对一条档案进行修改") ;

            return false ;

        }

    }

    document.TrnmngForm.operatorflag.value = "TRNMNG_QUERYATEST";

    document.TrnmngForm.submit();

 }



 function deleteSubmit()

 {

    var selectedCount = 0;

    var testidarray = document.TrnmngForm.testidarray;



    if(testidarray == null)

    {

       return false;

    }



    if (testidarray.value != null)

    {

        if(!(testidarray.checked))

        {

            alert("删除档案必须先选中一条档案") ;

            return false ;

        }

    }

    else

    {

        for(var i=0; i<testidarray.length;i++)

        {

            if(testidarray[i].checked == true)

            {

                selectedCount = selectedCount + 1;

            }

        }

        if(selectedCount == 0)

        {

            alert("删除档案必须先选中一条档案") ;

            return false ;

        }

    }

    if( !window.confirm("是否删除,请确认"))

    {

         return false ;

    }
    document.TrnmngForm.operatorflag.value = "TRN_TRNDELBYTESTID";

    document.TrnmngForm.submit();

 }

 </script>

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







⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?