📄 usual_line_mod.asp
字号:
<!--#include file="include/conn.asp"-->
<!--#include file="include/function.asp"-->
<!--#include file="CheckSystem.asp"-->
<%
call checklimit(session("Limit"),"3")'调用验证管理员权限的函数
response.Clear()
%>
<%
if Request.ServerVariables("REQUEST_METHOD")="POST" then
set rs=server.createobject("adodb.recordset")
MyAction=testdb(request.form("MyAction"))'标志变量，判断是更新还是添加
myActionStr=testdb(request.form("myActionStr"))
LineCode=testdb(request.form("LineCode"))
ConstracteTax=testdb(request.form("ConstracteTax"))
distance=testdb(request.form("distance"))
AirWays=testdb(request.form("AirWays"))
FF=testdb(request.form("FF"))
FC=testdb(request.form("FC"))
FY=testdb(request.form("FY"))
Y95=testdb(request.form("Y95"))
Y90=testdb(request.form("Y90"))
Y85=testdb(request.form("Y85"))
Y80=testdb(request.form("Y80"))
Y75=testdb(request.form("Y75"))
Y70=testdb(request.form("Y70"))
Y65=testdb(request.form("Y65"))
Y60=testdb(request.form("Y60"))
Y55=testdb(request.form("Y55"))
Y50=testdb(request.form("Y50"))
Y45=testdb(request.form("Y45"))
Y40=testdb(request.form("Y40"))
Y35=testdb(request.form("Y35"))
Y30=testdb(request.form("Y30"))
Y25=testdb(request.form("Y25"))
Y20=testdb(request.form("Y20"))
Y15=testdb(request.form("Y15"))
Y10=testdb(request.form("Y10"))
Y05=testdb(request.form("Y05"))
Endtime=testdb(request.form("Endtime"))
updatetime=testdb(request.form("updatetime"))
'----------------执行更行
if MyAction<>"AddNew" then
sql="select * from TAprice where [航段]='"&LineCode&"'"
rs.open sql,conn,1,3
else
sql="select * from TAprice"
rs.open sql,conn,1,3
rs.addnew
end if
rs("航段")=LineCode
rs("Airways")=Airways
if isnumeric(ConstracteTax) then
rs("ConstracteTax")=ConstracteTax
end if
if isnumeric(distance) then
rs("distance")=distance
end if
if isnumeric(FF) then
rs("F")=FF
end if
if isnumeric(FC) then
rs("C")=FC
end if
if isnumeric(FY) then
rs("Y")=FY
end if
rs("Y95")=Y95
rs("Y90")=Y90
rs("Y85")=Y85
rs("Y80")=Y80
rs("Y75")=Y75
rs("Y70")=Y70
rs("Y65")=Y65
rs("Y60")=Y60
rs("Y55")=Y55
rs("Y50")=Y50
rs("Y45")=Y45
rs("Y40")=Y40
rs("Y35")=Y35
rs("Y30")=Y30
rs("Y25")=Y25
rs("Y20")=Y20
rs("Y15")=Y15
rs("Y10")=Y10
rs("Y05")=Y05
if isdate(Endtime) then
rs("Endtime")=Endtime
end if
rs("updatetime")=updatetime
rs.update
rs.close:set rs=nothing
response.write"<script language=javascript>alert('记录已经"&myActionStr&"成功!\n');window.location.href='usual_line.asp';</script>"
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>后台管理机票系统</title>
<link href="include/css.css" rel="stylesheet" type="text/css">
</head>
<script language="javascript" src="include/newjs/calendar.js"></script>
<SCRIPT language=javascript>
<!--
function isLineCode(s)
{
var patrn=/^[a-zA-Z]{6}$/;
if (!patrn.exec(s))
return false;
else
return true;
}
function isEngName(s)
{
var patrn=/^[0-9a-zA-Z]{0,2}$/;
if (!patrn.exec(s))
return false;
else
return true;
}
function checkinput()
{
if (!isLineCode(ZXLform.LineCode.value)){
alert("航段不规范！必须为6个字母，不区分大小写；\n");
ZXLform.LineCode.focus();
return false;
}
if (!isEngName(ZXLform.AirWays.value))
{
alert("航空公司代号不规范！必须为2个字母或数字，不区分大小写；\n");
ZXLform.CompanyName.focus();
return false;
}
if (isNaN(ZXLform.ConstracteTax.value))
{
alert("建设税必须是数字!");
ZXLform.ConstracteTax.focus();
return false;
}
if (isNaN(ZXLform.distance.value))
{
alert("里程必须是数字!");
ZXLform.distance.focus();
return false;
}
if (isNaN(ZXLform.FF.value))
{
alert("头等航价格必须是数字!");
ZXLform.FF.focus();
return false;
}
if (isNaN(ZXLform.FC.value))
{
alert("公务航价格必须是数字!");
ZXLform.FC.focus();
return false;
}
if (isNaN(ZXLform.FY.value))
{
alert("经济航价格必须是数字!");
ZXLform.FY.focus();
return false;
}
if (isNaN(ZXLform.F95.value))
{
alert("F95必须是数字!");
ZXLform.F95.focus();
return false;
}
if (isNaN(ZXLform.F90.value))
{
alert("F90必须是数字!");
ZXLform.F90.focus();
return false;
}
if (isNaN(ZXLform.F85.value))
{
alert("F85必须是数字!");
ZXLform.F85.focus();
return false;
}
if (isNaN(ZXLform.F80.value))
{
alert("F80必须是数字!");
ZXLform.F80.focus();
return false;
}
if (isNaN(ZXLform.F75.value))
{
alert("F75必须是数字!");
ZXLform.F75.focus();
return false;
}
if (isNaN(ZXLform.F70.value))
{
alert("F70必须是数字!");
ZXLform.F70.focus();
return false;
}
if (isNaN(ZXLform.F65.value))
{
alert("F65必须是数字!");
ZXLform.F65.focus();
return false;
}
if (isNaN(ZXLform.F60.value))
{
alert("F60必须是数字!");
ZXLform.F60.focus();
return false;
}
if (isNaN(ZXLform.F55.value))
{
alert("F55必须是数字!");
ZXLform.F55.focus();
return false;
}
if (isNaN(ZXLform.F50.value))
{
alert("F50必须是数字!");
ZXLform.F50.focus();
return false;
}
if (isNaN(ZXLform.F45.value))
{
alert("F45必须是数字!");
ZXLform.F45.focus();
return false;
}
if (isNaN(ZXLform.F40.value))
{
alert("F40必须是数字!");
ZXLform.F40.focus();
return false;
}
if (isNaN(ZXLform.F35.value))
{
alert("F35必须是数字!");
ZXLform.F35.focus();
return false;
}
if(!isDateString(ZXLform.Endtime.value)||ZXLform.Endtime.value=="yyyy-mm-dd")
{
alert("请输入正确的日期格式!");
ZXLform.Endtime.focus();
return false;
}
return true;
//-->
}
function isDateString(sDate)//日期格式检查
{
var iaMonthDays = [31,28,31,30,31,30,31,31,30,31,30,31]
var iaDate = new Array(3)
var year, month, day
if (arguments.length != 1) return false
iaDate = sDate.toString().split("-")
if (iaDate.length != 3) return false
if (iaDate[1].length > 2 || iaDate[2].length > 2) return false
year = parseFloat(iaDate[0])
month = parseFloat(iaDate[1])
day=parseFloat(iaDate[2])
if (year < 1900 || year > 2100) return false
if (((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0)) iaMonthDays[1]=29;
if (month < 1 || month > 12) return false
if (day < 1 || day > iaMonthDays[month - 1]) return false
return true
}
</SCRIPT>
<body>
<%
LineCode=request.QueryString("LineCode")
myActionStr="添加"
if LineCode<>"" then
usql="select * from Taprice where [航段]='"&LineCode&"'"
set urs=server.CreateObject("adodb.recordset")
urs.open usql,conn,1,1
if not urs.eof then
LineCode=urs("航段")
distance=urs("distance")'里程
ConstracteTax=urs("ConstracteTax")'建设税
AirWays=urs("AirWays")
FF=urs("F")
FC=urs("C")
FY=urs("Y")
Y95=urs("Y95")
Y90=urs("Y90")
Y85=urs("Y85")
Y80=urs("Y80")
Y75=urs("Y75")
Y70=urs("Y70")
Y65=urs("Y65")
Y60=urs("Y60")
Y55=urs("Y55")
Y50=urs("Y50")
Y45=urs("Y45")
Y40=urs("Y40")
Y35=urs("Y35")
Y30=urs("Y30")
Y25=urs("Y25")
Y20=urs("Y20")
Y15=urs("Y15")
Y10=urs("Y10")
Y05=urs("Y05")
EndTime=urs("EndTime")
updatetime=date()
end if
urs.close
set urs=nothing
myActionStr="更新"
end if
%>
<TABLE cellPadding=0 cellSpacing=1 id=TABLE1 >
<form name="ZXLform" action="usual_line_mod.asp" method="post" onSubmit="return checkinput();">
<TR bgColor=#C3E7F9>
<TH height="30">航段</TH>
<TH height="30" style="padding-left:5px"> 里程 </TH>
<TH> 建设税 </TH>
<TH>航空代号</TH>
<TH style="padding-left:5px">F</TH>
<TH>C</TH>
<TH height="30">Y</TH>
<TH>Y95</TH>
<TH>Y90</TH>
<TH>Y85</TH>
</TR>
<%if LineCode="" then%>
<input type="hidden" name="MyAction" value="AddNew">
<%end if%>
<input type="hidden" name="myActionStr" value="<%=myActionStr%>">
<TR bgcolor="#FFFFFF" >
<TD height="25" align=center>
<input name="LineCode" type="text" id="LineCode" value="<%=LineCode%>" size="8" maxlength="6">
</TD>
<TD height="25" align="center" nowrap style="padding-left:3px">
<input name="distance" type="text" value="<%=distance%>" size="6" maxlength="6">
</TD>
<TD height="25" align="center">
<input name="ConstracteTax" type="text" id="ConstracteTax" value="<%=ConstracteTax%>" size="6" maxlength="6"> </TD>
<TD height="25" align="center"><input name="AirWays" type="text" value="<%=AirWays%>" size="6" maxlength="2"></TD>
<TD height="25" align="center" style="padding-left:3px">
<input name="FF" type="text" value="<%=FF%>" size="6" maxlength="6">
</TD>
<TD height="25" align="center" nowrap>
<input name="FC" type="text" value="<%=FC%>" size="6" maxlength="6"> </TD>
<TD align="center"><input name="FY" type="text" value="<%=FY%>" size="6" maxlength="6"></TD>
<TD align="center"><input name="Y95" type="text" value="<%=Y95%>" size="6" maxlength="6"></TD>
<TD align="center"><input name="Y90" type="text" value="<%=Y90%>" size="6" maxlength="6"></TD>
<TD align="center"><input name="Y85" type="text" value="<%=Y85%>" size="6" maxlength="6"></TD>
</TR>
<TR bgColor=#C3E7F9>
<TH height="30">Y80</TH>
<TH height="30" style="padding-left:5px">Y75 </TH>
<TH>Y70 </TH>
<TH>Y65</TH>
<TH style="padding-left:5px">Y60</TH>
<TH>Y55</TH>
<TH height="30">Y50</TH>
<TH height="30">Y45</TH>
<TH height="30">Y40</TH>
<TH height="30">Y35</TH>
</TR>
<TR bgcolor="#FFFFFF" >
<TD height="25" align=center>
<input name="Y80" type="text" value="<%=Y80%>" size="8" maxlength="6">
</TD>
<TD height="25" align="center" nowrap >
<input name="Y75" type="text" value="<%=Y75%>" size="6" maxlength="6"></TD>
<TD height="25" align="center">
<input name="Y70" type="text" value="<%=Y70%>" size="6" maxlength="6"> </TD>
<TD height="25" align="center">
<input name="Y65" type="text" value="<%=Y65%>" size="6" maxlength="6"></TD>
<TD height="25" align="center">
<input name="Y60" type="text" value="<%=Y60%>" size="6" maxlength="6"></TD>
<TD height="25" align="center" nowrap>
<input name="Y55" type="text" value="<%=Y55%>" size="6" maxlength="6"> </TD>
<TD align="center">
<input name="Y50" type="text" value="<%=Y50%>" size="6" maxlength="6"></TD>
<TD align="center">
<input name="Y45" type="text" value="<%=Y45%>" size="6" maxlength="6"></TD>
<TD align="center">
<input name="Y40" type="text" value="<%=Y40%>" size="6" maxlength="6">
</TD>
<TD align="center">
<input name="Y35" type="text" value="<%=Y35%>" size="6" maxlength="6"></TD>
</TR>
<TR bgColor=#C3E7F9>
<TH height="30">Y30</TH>
<TH height="30">Y25</TH>
<TH height="30">Y20</TH>
<TH>Y15</TH>
<TH>Y10</TH>
<TH>Y05</TH>
<TH height="30" colspan="2">结束日期</TH>
<TH height="30" colspan="2">更新时间</TH>
</TR>
<TR bgcolor="#FFFFFF" >
<TD height="25" align=center>
<input name="Y30" type="text" value="<%=Y30%>" size="8" maxlength="6">
</TD>
<TD height="25" align=center><input name="Y25" type="text" value="<%=Y25%>" size="6" maxlength="6"></TD>
<TD height="25" align=center><input name="Y20" type="text" value="<%=Y20%>" size="6" maxlength="6"></TD>
<TD height="25" align="center">
<input name="Y15" type="text" value="<%=Y15%>" size="6" maxlength="6"> </TD>
<TD height="25" align="center"><input name="Y10" type="text" value="<%=Y10%>" size="6" maxlength="6"></TD>
<TD height="25" align="center"><input name="Y05" type="text" value="<%=Y05%>" size="6" maxlength="6"></TD>
<TD colspan="2" align="center"><input name="Endtime" type="text" value="<%=Endtime%>" size="16" maxlength="12" onClick=javascript:calendar(); >
</TD>
<TD colspan="2" align="center"><%if LineCode<>"" then
Updatetime=Updatetime
else
Updatetime=date()
end if
response.write Updatetime
%>
<input name="Updatetime" type="hidden" value="<%=Updatetime%>" size="10"></TD>
</TR>
<TR bgColor=#EEEEEE>
<td height="30" colspan="11" align="right" style="padding-right:20px;">
<input type="submit" name="AddNow" value="确认">
<input type="button" value="返回" name="CancelRow" onClick="javascript:window.location.href='usual_line.asp';"></td>
</TR>
</form>
</TABLE>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -