📄 rep.asp
字号:
<!--#include file="include/conn.asp"-->
<%
response.Clear()
auto=request("auto")
myActionStr="添加"
ifActiveStr="checked"
Num="9"
flyDate=date+1
endDatetime=date+2
if auto<>"" then
dim szSQL
set oRst=Server.CreateObject("AdoDb.recordset")
szSQL="select * from repbunk where auto="&auto
oRst.Open szSQL,conn,3,1
if not(oRst.eof or oRst.bof) then
if oRst("ifActive")<>"1" then
ifActiveStr=""
end if
FlightNo=oRst("FlightNo")
bunk=oRst("bunk")
flyDate=oRst("flyDate")
datetime=oRst("DateTime")
endDatetime=oRst("endDatetime")
'Auto=oRst("Auto")
end if
myActionStr="更新"
oRst.close
set oRst=nothing
end if
if flyDate="" then flyDate="1"
if endDatetime="" then endDatetime="1"
%>
<%
if Request.ServerVariables("REQUEST_METHOD")="POST" then
flightno=Ucase(trim(request.form("flightno")))
bunk=request.form("bunk")
flyDate=request.form("flyDate")
endDatetime=request.form("endDatetime")
set rs=server.CreateObject("adodb.recordset")
if request.form("MyAction")<>"AddNew" then
qsql=" select * from repbunk where auto="&auto&" "
rs.open qsql,conn,1,3
else
qsql=" select * from repbunk "
rs.open qsql,conn,1,3
rs.addnew
end if
rs("datetime")=now()
rs("flightno")=flightno
rs("bunk")=bunk
rs("flyDate")=flyDate
rs("endDatetime")=endDatetime
rs.update
rs.close:set rs=nothing
response.write "<script language=javascript>alert('记录"&myActionStr&"成功!');window.location.href='manage2.asp';</script>"
end if
%>
<HTML>
<HEAD>
<TITLE>添加座舱位</TITLE>
<link href="include/css.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" type="text/css" href="style/comm.css" />
<link rel="stylesheet" type="text/css" href="style/skin0.css" />
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<SCRIPT language=javascript>
<!--
function isFlightNo(s)
{
var patrn=/^[a-zA-Z0-9]{2}([0-9]){3,4}$/;
if (!patrn.exec(s))
return false;
else
return true;
}
function checkinput()
{
if (!isFlightNo(Seatform.FlightNo.value)){
alert("航班号不规范！前两位必须为数字或字母，不区分大小写；后几位必须为数字\n");
Seatform.FlightNo.focus();
return false;
}
if (Seatform.FlightNo.value.length>6 || Seatform.FlightNo.value.length<5)
{
alert("航班号不规范！航班号长度不对!");
Seatform.FlightNo.focus();
return false;
}
if (Seatform.flyDate.value=="")
{
alert("起飞日期不能为空!");
Seatform.flyDate.focus();
return false;
}
if (isNaN(Seatform.num.value))
{
alert("座位数必须是数字!");
Seatform.num.focus();
return false;
}
if (isNaN(Seatform.price.value))
{
alert("价格必须是数字!");
Seatform.price.focus();
return false;
}
if (isNaN(Seatform.fullprice.value))
{
alert("全价必须是数字!");
Seatform.fullprice.focus();
return false;
}
//-->
}
</SCRIPT>
<script language=javascript src="include/newjs/calendar.js" ></script>
</head>
<body>
<div class="txt_title">添加假位（用途：隐藏某航班，不能扣位出票的舱位信息）</div>
<table width="100%" cellpadding="0" cellspacing="1" >
<form action="rep.asp" method="post" name="Seatform" onSubmit="return checkinput();">
<%if auto="" then%>
<input type="hidden" name="MyAction" value="AddNew">
<%end if%>
<input type="hidden" name="Auto" value="<%=auto%>">
<tr>
<td height="30" align="right" bgcolor="#FFFFFF">航班号:</td>
<td bgcolor="#FFFFFF"><input name="FlightNo" type="text" style="width:100px" value="<%=FlightNo%>" maxlength="6"></td>
<td bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="30" align="right" bgcolor="#FFFFFF">航班日期:</td>
<td bgcolor="#FFFFFF"><input name="flyDate" type="text" value="<%=flyDate%>" size="10" maxlength="15" onClick=javascript:calendar(); >
-->
<input name="endDatetime" type="text" value="<%=enddatetime%>" size="10" maxlength="15" onClick=javascript:calendar(); ></td>
<td bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="30" align="right" bgcolor="#FFFFFF">舱位(可多个舱位):</td>
<td bgcolor="#FFFFFF"><input name="bunk" type="text" id="bunk" style="width:150px" value="<%=bunk%>"></td>
<td bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td width="147" height="30" align="right" bgcolor="#FFFFFF">有效:</td>
<td width="321" bgcolor="#FFFFFF"><input name="ifActiveStr" type="checkbox" value="ON" <%=ifActiveStr%>></td>
<td bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="30" colspan="3" align="center" bgcolor="#FFFFFF"><input type="submit" value=" 确 认 " >
<input type="button" value=" 返 回 " onClick="javascript:window.history.back();"></td>
</tr>
</form>
</table>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -