?? modify.asp
字號:
<script>
//
// 力天2002網絡辦公系統
// Copyright (c) 深圳市力天軟件開發有限公司
// http://www.ebexpert.net
//
// 文件名 : modify.asp
// 描述 : 航班時刻數據修改
// 版本 :
// 作者 : zyh
// 備注 :
</script>
<!--#include file="const.inc"-->
<%
planecode=trim(request("planecode"))
if planecode<>"" then
planetype=trim(request("planetype"))
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 pubplane set planecode='" & planecode & "',planetype='" & planetype & "',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 pubplane where id=" & request("id"),conn,3,1
%>
<body bgcolor="#efefef" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/modify_on.gif')">
<form method="post" action="" name="form">
<table width="100%" border="0" cellspacing="1" cellpadding="2">
<tr bgcolor="#4E5960">
<td class="heading"> <b><font color="#FFFFFF">航班修改</font></b></td>
</tr>
</table>
<table width="100%" border="1" cellspacing="0" cellpadding="1" bordercolordark="#FFFFFF" bordercolor="#000000" height="222">
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top" height="23">航班：</td>
<td width="88%" height="23">
<input size=30 maxlength=50 name="planecode" value="<%=trim(rs("planecode"))%>">
<input type=hidden value="<%=rs("id")%>" name="id">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top" height="23">機型：</td>
<td width="88%" height="23">
<input size=30 maxlength=50 value="<%=trim(rs("planetype"))%>" name="planetype">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top" height="23">起點：</td>
<td width="88%" height="23">
<input size=20 maxlength=20 value="<%=trim(rs("leavestation"))%>" name="leavestation">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top" height="23">終點：</td>
<td width="88%" height="23">
<input size=20 maxlength=20 value="<%=trim(rs("returnstation"))%>" name="returnstation">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top" height="23">中途停降：</td>
<td width="88%" height="23">
<input size=40 maxlength=200 value="<%=trim(rs("passstation"))%>" name="passstation">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top" height="23">起飛時間：</td>
<td width="88%" height="23">
<input size=20 maxlength=20 value="<%=trim(rs("leavetime"))%>" name="leavetime">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top" height="16">降落時間：</td>
<td width="88%" height="16">
<input size=20 maxlength=20 value="<%=trim(rs("returntime"))%>" name="returntime">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top" height="16">票價：</td>
<td width="88%" height="16">
<input size=20 maxlength=50 value="<%=trim(rs("price"))%>" name="price">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top" height="16">備注：</td>
<td width="88%" height="16">
<textarea name="remark" cols="40" rows="4"><%=trim(rs("remark"))%></textarea>
</td>
</tr>
</table>
<div align="center"><br>
<a href="javascript:document.form.submit();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1','','images/modify_on.gif',1)"><img name="Image1" border="0" src="images/modify_off.gif" width="60" height="19" hspace="5"></a><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 + -