baoxiu_list.asp

ASP+Accesss数据库设备WEB报修

<!--#include file =conn.asp-->
<%
Dim baoxiu_id,rs
baoxiu_id=cint(request("baoxiu_id"))
if baoxiu_id<>"" and baoxiu_id="0" then
	Response.Write "<script>alert('未指定参数');window.location.href='index.asp';</script>"
	response.end
else
 set rs=server.createobject("adodb.recordset")
 sql="select *  from baoxiu where baoxiu_id=" & baoxiu_id
 rs.open sql,conn,3,2
 	if rs.eof and rs.bof then
		rs.close
		set rs=nothing
		Response.Write "<script>alert('指定的报修不存在！');window.location.href='index.asp';</script>"
		response.end
	end if
end if 
%>
<!--#include file =head.asp-->
<link href="admin/style.css" rel="stylesheet" type="text/css">
<table width="760" border="0" align="center" cellpadding="0" cellspacing="1" class="tableBorder5">
      <tr> 
        <td height="30" colspan="6" align="center" class="TableTitle1"><b><span class="style1"><%=rs("baoxiu_user")%></span> 报 修 的 详 细 资 料</b></td>
  </tr>
  <tr align="center" > 
    <td width="118" height="30" class="TableBody1">报修编号：</td>
    <td width="112" height="30" class="TableBody1" ><span class="style2"><%=rs("bx_id")%></span></td>
    <td width="120" class="TableBody1" >部门或班级：</td>
    <td width="136" class="TableBody1" ><span class="style2">
      <% baoxiu_id=cint(request("baoxiu_id"))
           set rs_s=server.CreateObject("adodb.recordset")
           sql="select * from b_smallclass where id="&rs("baoxiu_banji")&" order by nbigarea"
           rs_s.open sql,conn,1,1
           %>
      <%=rs_s("nsmallarea")%>
      <%
           rs_s.close
           set rs_s=nothing
           %>
    </span></td>
    <td width="134" height="30" class="TableBody1" >故障物品<span lang="en-us">/</span>部件：</td>
        <td width="131" class="TableBody1" ><span class="style2">
          <% baoxiu_id=cint(request("baoxiu_id"))
           set rs_s=server.CreateObject("adodb.recordset")
           sql="select * from w_sclass where id="&rs("baoxiu_wp")&" order by bclassid"
           rs_s.open sql,conn,1,1
           %>
          <%=rs_s("sclassname")%>
          <%
           rs_s.close
           set rs_s=nothing
           %>
        </span></td>
  </tr>
      <tr align="center">
        <td width="118" height="30" class="TableBody1" >联系电话：</td>
        <td width="112" height="30" class="TableBody1" ><span class="style2"><%=rs("contact")%></span></td>
        <td width="120" height="30" class="TableBody1" >预约维修日期：</td>
        <td width="136" height="30" class="TableBody1" ><span class="style2"><%=rs("baoxiu_date")%></span></td>
        <td height="30" class="TableBody1" >报修日期：</td>
        <td height="30" class="TableBody1" ><span class="style2"><%=rs("star_time")%></span></td>
      </tr>
  <tr > 
    <td width="118" height="30" align="center" class="TableBody1" >报修原因：</td>
    <td height="30" colspan="5" class="TableBody1" >&nbsp;<span class="style2"><%=rs("baoxiu_yuanyin")%></span></td>
      </tr>
  <tr >
    <td height="30" align="center" class="TableBody1" >具体故障现象 ：</td>
        <td colspan="5" class="TableBody1" >&nbsp;<span class="style2"><%=rs("guzhang")%></span></td>
  </tr>
  <tr >
    <td height="30" colspan="6" align="right" class="TableBody1" ><a href="fankui.asp?baoxiu_id=<%=baoxiu_id%>">回复</a>&nbsp;&nbsp;<a href="baoxiu_edit.asp?baoxiu_id=<%=baoxiu_id%>">修改</a></td>
      </tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td height="20"><%if rs("weixiu_main")<>"" then%></td>
      </tr>
    </table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" class="tableBorder5">
<tr>
        <td>
          <table width="100%"  border="0" cellspacing="0" cellpadding="4">
            <tr>
              <td height="30" align="center" class="TableTitle1"><b>维 修 人 员 反 馈</b></td>
            </tr>
          </table>          
          <table width="100%" border="0" cellpadding="5" cellspacing="1">
            <tr >
              <td height="30" align="center" class="TableBody1">维修人员：</td>
              <td width="15%" height="30" align="center" class="TableBody1"><span class="style1"><%=rs("user_name")%></span></td>
              <td width="16%" height="30" align="center" class="TableBody1">修复与否：</td>
              <td width="18%" align="center" class="TableBody1"><span class="style2"><%=rs("weixiu_zhuangtai")%></span></td>
              <td width="18%" height="30" align="center" class="TableBody1">维修时间：</td>
              <td width="17%" align="center" class="TableBody1"><span class="style2"><%=rs("weixiu_time")%></span></td>
            </tr>
            <tr >
              <td width="16%" height="30" align="center" class="TableBody1" >维修反馈：</td>
              <td height="30" colspan="5" class="TableBody1" ><span class="style2"><%=rs("weixiu_main")%></span></td>
            </tr>
            <tr >
              <td height="30" colspan="6" align="right" class="TableBody1"><a href="fankui_edit.asp?baoxiu_id=<%=baoxiu_id%>">修改</a></td>
            </tr>
          </table>
    <%end if%></td>
      </tr>
    </table>
<!--#include file =bottom.asp-->