⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 admin_add1.asp

📁 机票预定系统 各个模块的设计-ticket reservation systems detailed design system modules of the design
💻 ASP
字号:
<!--#include file="include/conn.asp"-->
<!--#include file="CheckSystem.asp"-->
<%
call checklimit(session("Limit"),"6")'调用验证管理员权限的函数
response.Clear()
auto=request("auto")
ifDynamicBunk=1
myActionStr="添加"
ifActiveStr="checked"
ifDynamicBunkStr="checked"
'Num="9"
flyDate=date+1
endDatetime=date+2
if auto<>"" then
	 dim szSQL
     set oRst=Server.CreateObject("AdoDb.recordset")
	 szSQL="select * from myBunkmessage 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
				if oRst("ifDynamicBunk")<>"1" then
				ifDynamicBunkstr=1
				end if
			   ' fontColor=oRst("fontColor")
                ifActive=oRst("ifActive")
				ifDynamicBunk=1
				FlightNo=oRst("FlightNo")
                flyDate=oRst("flyDate")
				rebate=oRst("Rebate")
				price=oRst("Price")
	            bunk=oRst("bunk")
				datetime=oRst("DateTime")
				endDatetime=oRst("endDatetime")
				'Auto=oRst("Auto")
	end if
myActionStr="更新"
oRst.close
set oRst=nothing
end if
if flyDate="" then flyDate=date()+1
if endDatetime="" then endDatetime=date()+2
if rebate="" then rebate="特价舱"
%>

<%
if Request.ServerVariables("REQUEST_METHOD")="POST" then

     fontColor="#FF0000"
	 flightno=Ucase(trim(request.form("flightno")))
     price=trim(request.form("price"))
	 flyDate=request.form("flyDate")
	 endDatetime=request.form("endDatetime")
	 rebate=request.form("rebate")
	 bunk=request.form("bunk")
	 TempifActiveStr="0"
     if trim(request.form("ifActiveStr"))="ON" then
	 TempifActiveStr="1"
	 end if
	 ifActive=TempifActiveStr
	 ifDynamicBunk=1 
	set rs=server.CreateObject("adodb.recordset")
	if request.form("MyAction")<>"AddNew" then
		qsql=" select * from mybunkmessage where auto="&auto&" " 
		rs.open qsql,conn,1,3 
	else
		qsql=" select * from mybunkmessage "
		rs.open qsql,conn,1,3
		rs.addnew
	end if
		rs("datetime")=now()
		rs("flightno")=UCase(flightno)
		rs("price")=price
		rs("flyDate")=flyDate
		rs("rebate")=rebate
		rs("bunk")=UCase(bunk)
		rs("endDatetime")=endDatetime
		rs("ifActive")=ifActive
		rs("ifDynamicBunk")=1
		rs.update
		rs.close:set rs=nothing
	 response.write "<script language=javascript>alert('记录"&myActionStr&"成功!');window.location.href='manage1.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" />
<!-- powered By ZhouXiaolong -->
<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 isBunk(s)
	{
		var patrn=/^[a-zA-Z]{1}$/;
		if(!patrn.exec(s))
		return false;
		else
		return true;
	}
function checkinput()
{
	if (!isFlightNo(Seatform.FlightNo.value)){
		alert("航班号不规范!前两位必须为数字或字母,不区分大小写;后几位必须为数字\n");
		Seatform.FlightNo.focus();
	  return false; 
		}
	if(!isBunk(Seatform.Bunk.value)){
		alert("舱位等级不规范,必须为字母,不区分大小写!");
		Seatform.Bunk.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.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 cellpadding="0" cellspacing="1" >
<form action="admin_add1.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 bgcolor="#C3E7F9">
     <td width="14%" height="25" align="right" bgcolor="#FFFFFF">航班号:</td>
     <td width="36%" bgcolor="#FFFFFF"><input name="FlightNo" type="text" style="width:100px" value="<%=FlightNo%>" maxlength="6"></td>
     <td width="50%" bgcolor="#FFFFFF">输入相应航班号</td>
    </tr>
	<tr>
	  <td height="25" align="right" bgcolor="#FFFFFF">航班有效日期:</td>
	  <td valign="middle" bgcolor="#FFFFFF"><input name="flyDate" type="text"  value="<%=flyDate%>" size="10" maxlength="15"   onClick=javascript:calendar(); >
	    --&gt;
        <input name="endDatetime" type="text" value="<%=enddatetime%>"  size="10" maxlength="15"  onClick=javascript:calendar(); ></td>
	  <td bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
	<tr>
	  <td height="25" align="right" bgcolor="#FFFFFF">舱位名称:</td>
	  <td valign="middle" bgcolor="#FFFFFF"><input name="Rebate" type="text" id="Rebate" style="width:100px" value="<%=rebate%>" size="6" maxlength="6"></td>
	  <td bgcolor="#FFFFFF">舱位名称(如:特价舱,30折经济舱等)</td>
    </tr>
	<tr>
	  <td height="25" align="right" bgcolor="#FFFFFF">航位等级:</td>
	  <td valign="middle" bgcolor="#FFFFFF"><input name="Bunk" type="text" id="Bunk" value="<%=bunk%>" size="8" maxlength="1"></td>
	  <td bgcolor="#FFFFFF"> 航位等级:(如:A,Y,C等)</td>
    </tr>
	<tr>
	  <td height="25" align="right" bgcolor="#FFFFFF">折扣:</td>
	  <td valign="middle" bgcolor="#FFFFFF"><input name="price" type="text" id="price" value="<%if price<>"" then response.Write(price) else response.Write(0) end if%>" size="6" maxlength="4"></td>
	  <td bgcolor="#FFFFFF">折扣:(如:25,30,40,50等)</td>
    </tr>
	<tr>
	  <td height="25" align="right" bgcolor="#FFFFFF">有效:</td>
	  <td valign="middle" bgcolor="#FFFFFF"><input name="ifActiveStr" type="checkbox" value="ON" <%=ifActiveStr%>></td>
	  <td bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
	<tr>
      <td height="30" colspan="3" align="center" bgcolor="#FFFFFF">
	    <input type="submit" value=" 确 认 " name="addRow">&nbsp;&nbsp;
      <input type="button" value=" 返 回 " name="CancelRow"  onClick="javascript:window.history.back();"></td>
   </tr>
</form>
</table>

</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -