📄 detailinfo.asp
字号:
<html>
<TITLE>查询设备资料</TITLE>
</HEAD>
<BODY bgcolor="#aabbaa">
<%
if session("hy_id")="" then
response.redirect "1.htm"
end if
%>
<font color="red" face="幼圆">
<p><a href="vod1.asp">返回首页</a>|
<% if session("level")>1 then%>
<a href="editinfo.asp">修改资料</a>|
<a href="addinfo.asp">添加资料</a>|
<a href="deleteinfo.asp">删除资料</a>|
<a href="browseinfo.asp">查询资料</a>|
<% end if %></p>
<hr width="100%" noshade size="1" color="red">
</font>
<table><tr><td> </td></tr></table>
<div align="center">
<%
dim cnn,rst,ssql,equ_id
equ_id=trim(request.form("equ_id"))
set cnn=server.createobject("adodb.connection")
set rst= server.createobject("adodb.recordset")
cnn.connectionstring="provider=sqloledb;data source=(local);"&_
"uid=sa;pwd=0335;database=vod"
cnn.open
equ_id=request.querystring("equ_id")
ssql=" select * from shebei where equ_id='"&equ_id&"'"
set rst=cnn.execute(ssql, , adcmdtext)
if not rst.eof then
%>
<font face="宋体" size="4">
<tr align="center">
<caption><b>编号为：<%=equ_id %> 的设备详细资料如下表
</tr></font>
<table><tr><td> </td></tr></table>
<table bgcolor="#bbdddd" border="1" cellspaceing="6" cellpadding="6">
<tr>
<td align="center" width="200">设备编号：</td>
<td align="left" width="200"> <% =rst("equ_id")%>
<input type="hidden" name="txtoldequ_id" size="20" value=<% =rst("equ_id")%>>
</td> </td>
<td align="center" width="200">设备名称：</td>
<td align="left" width="200"> <% =rst("equ_name")%></td>
</tr>
<tr>
<td align="center" width="200">购买日期：</td>
<td align="left" width="200"> <% =rst("equ_data")%></td>
<td align="center" width="200">生产厂家：</td>
<td align="left" width="200"> <% =rst("equ_factory")%></td>
</tr>
<tr>
<td align="center" width="200">设备价格：</td>
<td align="left" width="200"> <% =rst("equ_value")%></td>
<td align="center" width="200">所属部门：</td>
<td align="left" width="200"> <% =rst("equ_department")%></td>
</tr>
<tr>
<td align="center" width="200">磨损程度：</td>
<td align="left" width="200"> <% =rst("equ_old")%></td>
<td align="center" width="200">维修电话：</td>
<td align="left" width="200"> <% =rst("equ_tel")%></td>
</tr>
<tr>
<td align="center" width="200">备注说明：</td>
<td colspan="5" cols="74"><% =rst("equ_remark")%></td>
</tr>
</table>
<% end if %>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -