📄 detail.asp
字号:
<script>
//
// 力天2002网络办公系统
// Copyright (c) 深圳市力天软件开发有限公司
// http://www.ebexpert.net
//
// 文件名 : modify.asp
// 描述 : 列车时刻数据修改
// 版本 :
// 作者 : zyh
// 备注 :
</script>
<!--#include file="const.inc"-->
<%
traincode=trim(request("traincode"))
if traincode<>"" then
traintype=trim(request("traintype"))
leavestation=trim(request("leavestation"))
returnstation=trim(request("returnstation"))
passstation=trim(request("passstation"))
leavetime=trim(request("leavetime"))
returntime=trim(request("returntime"))
price=trim(request("price"))
remark=trim(request("remark"))
id=request("id")
Set conn=Server.CreateObject("ADODB.Connection")
DBPath1=server.mappath("../access.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
conn.Execute "update pubtrain set traincode='" & traincode & "',traintype='" & traintype & "',leavestation='" & leavestation & "',returnstation='" & returnstation & "',passstation='" & passstation & "',leavetime='" & leavetime & "',returntime='" & returntime & "',price='" & price & "',remark='" & remark & "' where id=" & id
set conn=nothing
%>
<script language="javascript">
window.close();
window.opener.parent.frames("main").document.location ="index.asp?channelid=<%=request("channelid")%>";
</script>
<% else %>
<html>
<head>
<title>修改列车时刻表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/eintrdemo.css">
</head>
<%
Set conn=Server.CreateObject("ADODB.Connection")
DBPath1=server.mappath("../access.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from pubtrain where id=" & request("id"),conn,3,1
%>
<form method="post" action="" name="form">
<table width="100%" border="0" cellspacing="1" cellpadding="2">
<tr bgcolor="#4E5960">
<td class="heading"> <font color="#FFFFFF"><b>显示列车时刻表</b></font></td>
</tr>
</table>
<table width="100%" border="1" cellspacing="0" cellpadding="1" bordercolordark="#FFFFFF" bordercolor="#000000">
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">车次</td>
<input type=hidden value="<%=rs("id")%>" name="id">
<td width="88%">
<input size=30 maxlength=50 name="traincode" value="<%=trim(rs("traincode"))%>">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">车种</td>
<td width="88%">
<input size=30 maxlength=50 value="<%=trim(rs("traintype"))%>" name="traintype">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">起点</td>
<td width="88%">
<input size=20 maxlength=20 value="<%=trim(rs("leavestation"))%>" name="leavestation">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">途经站</td>
<td width="88%">
<input size=40 maxlength=200 value="<%=trim(rs("passstation"))%>" name="passstation">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">终点</td>
<td width="88%">
<input size=20 maxlength=20 value="<%=trim(rs("returnstation"))%>" name="returnstation">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">发车时间</td>
<td width="88%">
<input size=20 maxlength=20 value="<%=trim(rs("leavetime"))%>" name="leavetime">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">到站时间</td>
<td width="88%">
<input size=20 maxlength=20 value="<%=trim(rs("returntime"))%>" name="returntime">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">价格</td>
<td width="88%">
<input size=20 maxlength=50 value="<%=trim(rs("price"))%>" name="price">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">备注</td>
<td width="88%">
<textarea name="remark" cols="40" rows="4"><%=trim(rs("remark"))%></textarea>
</td>
</tr>
</table>
<div align="center"><br>
<a href="javascript:document.form.reset();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','images/reset_on.gif',1)"><img name="Image2" border="0" src="images/reset_off.gif" width="60" height="19" hspace="5"></a><a href="Javascript:window.close();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','images/closelittle_2.gif',1)"><img name="Image3" border="0" src="images/closelittle_1.gif" width="60" height="19" hspace="5"></a><br>
</div></form>
</body>
</html>
<% end if %>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -