
<!--#include file="../checkLogin.asp"-->
<!--#include file="../SQLconn.asp"-->
<!doctype html>
<html>
<head><title></title><meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<link rel="stylesheet" type="text/css" href="../images/<%=request.cookies("imgdir")%>/css/style.css" media="all"/>
<script src="../laydate/laydate.js"></script>
<style type="text/css">
<!--
.STYLE3 {color: #990033}
-->
</style>
<body>
<table width="100%" height="495" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="27">
	<div class="header">
	<div class="nav">
        <ul>
           
            <li><a href="shenqing.asp" target="_self">维修申报</a></li> 
			
            <li><a href="main.asp" target="_self">已申报列表</a></li>
			
			<li><a href="Daishenpi.asp" target="_self">维修处理</a></li>
			
			<li><a href="Yishenpi.asp?qdtype=未处理" target="_self">已处理维修</a></li>
			<li class="on">维修统计</li>
        </ul>
    </div>	
	</td>
  </tr>

  <tr>
    <td height="470" valign="top"   class="NemuMainBox">
	<br>
	<%
		
		 leibie=request("leibie")
		 
		 shuoming=request("shuoming")
		 baoxiuren=request("baoxiuren")
		 shenpiren=request("shenpiren")
	    
		 strdate1=request("date1")
		 strdate2=request("date2")		
		 if strdate1="" then 
		   strdate1=now-30
		 end if
		 if strdate2="" then 
		   strdate2=now
		 end if
				 
		
	%>
	 <form name="form1" method="get" action="Findbaoxiu.asp"  onSubmit="return CheckForm();">
<div align="center">
<table width="95%" height="30" border="1" align="center" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8"  class="mtablehui">
  <tr style="background-color:#D6E4FF"  class="TableHeader">
    <td height="30" colspan="3" align="center" nowrap class="NemuNot">

  <table width="846" border="0" align="center" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8" >   
      <tr>
        <td width="30" nowrap class="STYLE1"><div align="center">类别</div></td>
        <td width="37" nowrap class="STYLE1"><div align="center">
            <select name="leibie" id="leibie"  >
              <option><%=leibie%></option>
              <option></option>
              <% Set RSsel = Conn.Execute("select vname from  varset where name='baoxiutype'")
								   While NOT RSsel.EOF %>
              <OPTION value=<%=RSsel( "vname" )%>><%=RSsel( "vname" )%></OPTION>
              <% RSsel.MoveNext
								  Wend
								  RSsel.Close%>
            </select>
        </div></td>
        <td width="30" height="38" nowrap class="STYLE1"><div align="center"><span class="STYLE1 STYLE2">开始</span></div></td>
        <td width="72" nowrap class="STYLE1"><b><b>
         <input name=date1  placeholder="请输入日期"  style="width:90px"  value=<%=strdate1%> class="laydate-icon" onClick="laydate()">
        </b></b></td>
        <td width="30" nowrap class="STYLE1"><div align="center"><span class="STYLE2">结束</span></div></td>
        <td width="79" nowrap class="STYLE1"><b><b>
          <input name=date2  placeholder="请输入日期"  style="width:90px"  value=<%=strdate2%> class="laydate-icon" onClick="laydate()">
        </b></b></td>
        <td width="32" nowrap class="STYLE1"><div align="center">内容</div></td>
        <td width="76" nowrap class="STYLE1"><div align="center">
          <input name="shuoming" class="text" id="shuoming"  size=10 maxlength="30" value=<%=shuoming%>>
        </div></td>
		<td width="40" nowrap class="STYLE1"><div align="center">报修人</div></td>
        <td width="76" nowrap class="STYLE1"><div align="center">
          <input name="baoxiuren" class="text" id="baoxiuren"  size=10 maxlength="30" value=<%=baoxiuren%>>
        </div></td>
		<td width="40" nowrap class="STYLE1"><div align="center">处理人</div></td>
        <td width="90" nowrap class="STYLE1"><div align="center">
          <input name="shenpiren" class="text" id="shenpiren"  size=10 maxlength="30" value=<%=shenpiren%>>
        </div></td>
        <td width="80" class="STYLE1"><div align="center">
          <input name="submit" type="submit" class="topanniu" value="查询">
        </div></td>
      </tr>
    </table>
	</td>
  </tr>
</table>
    </div>
  <br>
  
  
   <%
     tname=request.cookies("tname")


'检查权限
       Set MyOAASPObj = Server.CreateObject("YFSchoolOApro.YFSchoolDll")
           if MyOAASPObj.QuanXian(tname,"报修处理")=0 then 
		    response.redirect  "../NoPower.asp"
           end if 
		   set MyOAASPObj=nothing
'检查权限结束
 
   Set Rsyipi=Server.CreateObject("Adodb.Recordset")
   sqlsended="Select * from shiwu  where  (tname like  '%"&baoxiuren&"%') and  (chuliren like  '%"&shenpiren&"%') and  (shiwutype like  '%"&leibie&"%') and  (updatetime BETWEEN '"&strdate1&"'  AND   '"&strdate2&"')    AND (content like  '%"&shuoming&"%')  order by updatetime  desc"
   Rsyipi.open sqlsended,conn,1,1
%>
  <table width="95%" border="1" align="center" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8"  class="mtable">
    <tr style="background-color:#D6E4FF"  class="TableHeader">
	<td  align="center" nowrap class="STYLE1"><div align="center">序号</div></td>
	<td   align="center" nowrap class="STYLE1"><div align="center">类别</div></td>
      <td height="30" align="center" nowrap="nowrap" class="STYLE1">报修人</td>
      <td align="center" nowrap="nowrap" class="STYLE1">报修内容</td>
      <td align="center" nowrap="nowrap" class="STYLE1">报修时间</td>
      <td align="center" nowrap class="STYLE1">完成时间</td>
	  <td align="center" nowrap class="STYLE1">处理人</td>
      <td align="center" nowrap class="STYLE1">维修结果</td>
	  <td align="center" nowrap class="STYLE1">查看</td>
    </tr>
 
<% While NOT Rsyipi.EOF %>
 <%ixuhao=ixuhao+1%>
    <tr><td width="30" align="center" nowrap class="STYLE1"><%=ixuhao%></td>
	<td width="80" align="center" nowrap class="STYLE1"><%=Rsyipi("shiwutype")%></td>
     <td width="100" height="30" align="center" nowrap class="STYLE1">
	 <% if  Rsyipi("代报")<>""  then %>
	      <%=Rsyipi("代报")%>
	      (<%=Rsyipi("tname")%>代报)
	    <%else  %>
	   <%=Rsyipi("tname")%>
	  
	  <%end if  %>	  </td>
      <td width="508" align="left" class="STYLE1"><div align="left"> &nbsp;<%=Rsyipi("content")%> </div></td>
      <td width="80" align="center" nowrap class="STYLE1"><%=formatdatetime(Rsyipi("updatetime"),2)%></td>
      <td width="80" align="center" nowrap class="STYLE1"><%=formatdatetime(Rsyipi("chuliriqi"),2)%></td>
	  <td  width="80"  align="center" nowrap class="STYLE1"><%=Rsyipi("chuliren")%></td>
      <td width="115" align="center" nowrap class="STYLE1"><%=Rsyipi("jieguo")%></td>
     <td  width="96" align="center" nowrap class="STYLE1"><a href="view.asp?curpage=<%=curpage%>&ID=<%=Rsyipi("id")%>" target="_blank">&nbsp;详细</a>&nbsp;
	 <a   href= "# "   onclick= "javascript:if(confirm( '您真的要删除记录？ '))href= 'delTongJi.asp?ID=<%=Rsyipi("id")%>'; "> 删除 </a>	 </td>
    </tr>
   <%
			Rsyipi.MoveNext
			Wend
			Rsyipi.Close
			%>
  </table>
</FORM>	</td>
  </tr>
</table>
</body>
</html>
