<%@ page contentType="text/html;charset=gbk" %>
<%@ page import="java.util.*" %>
<%@ page import="net.sz600.tool.SzDateHelp"%>
<%@ page import="net.sz600.basicdata.*" %>
<%@ page import="net.sz600.tool.SzConvert" %>
<%@ page import="net.sz600.database.SzPageInfo" %>
<%@ page import="net.sz600.system.*" %>
<%@ page import="net.sz600.drivingSchool.*" %>
<%@ include file="/sessionInfo.jsp"%>

<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<link href="<%=strSkin_SESSION%>/css2007.css" rel="stylesheet" type="text/css">
<script language="javascript" src="../../share/js/commonTool.js"></script>
<%@ include file="/drivingSchool/tool/ReadIDCard.jsp"%>

</head>
<%
	
	//学号
	String XM = SzConvert.strWriteData(request.getParameter("XM"));
	//学号
	String SFZ = SzConvert.strWriteData(request.getParameter("SFZ"));
	//流水号
	String LSH = SzConvert.strWriteData(request.getParameter("LSH"));
	//条件sCond
	StringBuffer sCond = new StringBuffer("");

	
	//out.println(sCond.toString());
	//
	StatHelp statHelp = new StatHelp();
	//学员信息字段
	String[] fileds = new String[]{"XXMC1","XXMC2","XXMC3","XXMC6","XXMC7",
			"XXMC8","XXMC24","XXMC32","XXMC58","XXMC63",
			"XXMC36","XXMC67"};
	//查询学员信息
	String[] studentInfo = statHelp.getStudentInfo(fileds,LSH,XM,SFZ);
	if (studentInfo != null && studentInfo[0] != null && !"".equals(studentInfo[0])){
		sCond.append(" AND XXMC14=" + studentInfo[0]);
	} else {
		sCond.append(" AND 1<>1");
	}
	

	//获取考试信息Map
	Map studentKaoShiMap = statHelp.getKMKaoInfoMap(sCond.toString());
	
	//考试信息
	String[] ksInfo = null;

	
%>
<%@ include file="/share/title.jsp"%>
<div style="width: 100%;" align="center">
<table width="600">
  <form name="formBar" method="post">
  <tr>
    <td>  
      流水号<input type="text" name="LSH" class="txtClassSearch" value="<%=LSH %>">
      姓名<input type="text" name="XM" class="txtClassSearch" value="<%=XM %>"  OnDblClick="javascript:ReadIDCard();">
      身份证<input type="text" name="SFZ" class="txtClass1" value="<%=SFZ %>" OnDblClick="javascript:ReadIDCard();">
     <%=SzPageHelp.button("btnClass", "查询", "javascript:FormSubmit(formBar,'statStudentJinDu.jsp');", "btnSearch")%>
	</td>
  </tr>
  </form>
</table>
<table width="600" border="1" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" class="tableClass" cellpadding="1" cellspacing="0">
  <tr class="trClassTitle">
    <td>学号</td>
    <td>流水号</td>
    <td>姓名</td>
    <td>报名时间</td>
    <td>准驾车型</td>
  </tr>
  <tr align="center">
    <td><%=studentInfo==null || studentInfo[2]==null? "&nbsp;":studentInfo[2] %></td>
    <td><%=studentInfo==null || studentInfo[7]==null? "&nbsp;":studentInfo[7] %></td>
    <td><%=studentInfo==null || studentInfo[1]==null? "&nbsp;":studentInfo[1] %></td>
    <td><%=studentInfo==null || studentInfo[6]==null? "&nbsp;":studentInfo[6] %></td>
    <td>C1</td>
  </tr>
</table>
<table width="600" border="1" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" class="tableClass" cellpadding="1" cellspacing="0">
  <form name="formUpdate" method="post">
  <input type="hidden" name="OPERATOR" value="add"> 
  <input type="hidden" name="SzDLXM" value="<%=sDLXM_SESSION %>">
  <input type="hidden" name="SzDLID" value="<%=iDLID_SESSION %>">
  <input type="hidden" name="SzBMMC" value="<%=sBMMC_SESSION %>">
  <input type="hidden" name="SzBMID" value="<%=iBMID_SESSION %>">
  <input type="hidden" name="XM" value="<%=XM %>">
  <input type="hidden" name="SFZ" value="<%=SFZ %>">
  <input type="hidden" name="LSH" value="<%=LSH %>">
  
  <tr class="trClassTitle">
  	<td width="200">环节</td>
  	<td>详情</td>
  	<td>备注</td>
  </tr>
  <tr>
  	<td>档案递交时间</td>
  	<td><%=studentInfo==null || studentInfo[8]==null? "":studentInfo[8] %>&nbsp;</td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>流水号</td>
  	<td><%=studentInfo==null || studentInfo[7]==null? "&nbsp;":studentInfo[7] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>上课时间</td>
  	<td><%=studentInfo==null || studentInfo[9]==null? "&nbsp;":studentInfo[9] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>模拟考成绩</td>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  </tr>
  <%
  String sKey = studentInfo==null || studentInfo[0]==null? "0":studentInfo[0];
  ksInfo = (String[])studentKaoShiMap.get(sKey+":文考");
  
  %>
  <tr>
  	<td>文考考试时间</td>
  	<td><%=ksInfo==null || ksInfo[2]==null? "&nbsp;":ksInfo[2] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>文考成绩</td>
  	<td><%=ksInfo==null || ksInfo[3]==null? "&nbsp;":ksInfo[3] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  </tr>
  <%
  ksInfo = (String[])studentKaoShiMap.get(sKey+":场考");
  %>
  <tr>
  	<td>场考考试时间</td>
  	<td><%=ksInfo==null || ksInfo[2]==null? "&nbsp;":ksInfo[2] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>场考成绩</td>
  	<td><%=ksInfo==null || ksInfo[3]==null? "&nbsp;":ksInfo[3] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  </tr>
  <%
  ksInfo = (String[])studentKaoShiMap.get(sKey+":长训");
  %>
  <tr>
  	<td>长训考试时间</td>
  	<td><%=ksInfo==null || ksInfo[2]==null? "&nbsp;":ksInfo[2] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>长训成绩</td>
  	<td><%=ksInfo==null || ksInfo[3]==null? "&nbsp;":ksInfo[3] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  </tr>
  <%
  ksInfo = (String[])studentKaoShiMap.get(sKey+":路考");
  %>
  <tr>
  	<td>路考考试时间</td>
  	<td><%=ksInfo==null || ksInfo[2]==null? "&nbsp;":ksInfo[2] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>路考成绩</td>
  	<td><%=ksInfo==null || ksInfo[3]==null? "&nbsp;":ksInfo[3] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  </tr>
  <%
  ksInfo = (String[])studentKaoShiMap.get(sKey+":安全教育");
  %>
  <tr>
  	<td>安全教育考试时间</td>
  	<td><%=ksInfo==null || ksInfo[2]==null? "&nbsp;":ksInfo[2] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>安全教育成绩</td>
  	<td><%=ksInfo==null || ksInfo[3]==null? "&nbsp;":ksInfo[3] %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  	<td>&nbsp;</td>
  </tr>
  <%
  String zt = studentInfo==null || studentInfo[10]==null? "&nbsp;":studentInfo[10];
  String ztsj = studentInfo==null || studentInfo[11]==null? "&nbsp;":studentInfo[11];
  %>
  <tr>
  	<td>在学</td>
  	<td><%=zt.equals("在学")? ztsj:"&nbsp;" %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>暂停</td>
  	<td><%=zt.equals("暂停")? ztsj:"&nbsp;" %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>休学(长时间不来)</td>
  	<td><%=zt.equals("休学(长时间不来)")? ztsj:"&nbsp;" %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>失踪</td>
  	<td><%=zt.equals("失踪")? ztsj:"&nbsp;" %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>领证</td>
  	<td><%=zt.equals("领证")? ztsj:"&nbsp;" %></td>
  	<td>&nbsp;</td>
  </tr>
  <tr>
  	<td>退学</td>
  	<td><%=zt.equals("退学")? ztsj:"&nbsp;" %></td>
  	<td>&nbsp;</td>
  </tr>
  </form>
</table>
</div>
<%
    ////如果要使用日历控件，必须输出这个calendarFrame
    out.println(SzPageHelp.calendar2Frame("../../"));
%>


