📄 fly_company_mod_ba.asp
字号:
<!--#include file="include/conn.asp"-->
<!--#include file="CheckSystem.asp"-->
<%
SetLimit=session("Limit")
call checklimit(SetLimit,"1")'调用验证管理员权限的函数
response.Clear()
%>
<%
if Request.ServerVariables("REQUEST_METHOD")="POST" then
MyAction=request.form("MyAction")'标志变量,判断是更新还是添加
myActionStr=request.form("myActionStr")
settlecode=request.form("settlecode")
AirwaysID=request.form("AirwaysID")
CompanyNo=request.form("CompanyNo")
CompanyName=request.form("CompanyName")
ShortName=request.form("ShortName")
EnglishName=request.form("EnglishName")
Country=request.form("Country")
WaitingFlyBuilding=request.form("WaitingFlyBuilding")
DescQian=request.form("DescQian")
DescGai=request.form("DescGai")
DescTui=request.form("DescTui")
DescEntroic=request.form("DescEntroic")
updatetime=request.form("updatetime")
Address=request.form("Address")
Telphone=request.form("Telphone")
Fax=request.form("Fax")
file1=request.form("file1")
set rs=server.createobject("adodb.recordset")
if MyAction<>"AddNew" then '执行修改
sql="select * from airways where AirwaysID="&AirwaysID
rs.open sql,conn,1,3
else
sql="select * from Airways"
rs.open sql,conn,1,3
rs.addnew
end if
rs("CarrierCode")=CompanyNo
rs("AirWayName")=CompanyName
rs("ShortName")=ShortName
rs("EnglishName")=EnglishName
rs("Country")=Country
rs("settlecode")=settlecode
rs("DescEntroic")=DescEntroic
rs("WaitingFlyBuilding")=WaitingFlyBuilding
rs("DescQian")=DescQian
rs("DescGai")=DescGai
rs("DescTui")=DescTui
rs("Address")=Address
rs("Telphone")=Telphone
if Fax<>"" then
rs("Fax")=Fax
end if
if file1<>"" then
rs("PictureLogoPath")=file1
end if
rs("updatetime")=updatetime
rs.update
rs.close:set rs=nothing
response.write"<script language=javascript>alert('记录已经"&myActionStr&"成功!');window.location.href='Fly_company.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>
<!--
function isCompanyNo(s)
{
var patrn=/^[0-9a-zA-Z]{2}$/;
if (!patrn.exec(s))
return false;
else
return true;
}
function isEnglishName(s)
{
var patrn=/^[0-9a-zA-Z]{2,50}$/;
if (!patrn.exec(s))
return false;
else
return true;
}
function checkinput()
{
if (!isCompanyNo(ZXLform.CompanyNo.value)){
alert("公司代号不规范!必须为字母或数字,不区分大小写;\n");
ZXLform.CompanyNo.focus();
return false;
}
if (ZXLform.CompanyName.value=="")
{
alert("公司名称不能为空!");
ZXLform.CompanyName.focus();
return false;
}
if (!isEnglishName(ZXLform.settlecode.value)){
alert("结算代码不规范!必须为三个字母或数字,不区分大小写;\n");
ZXLform.settlecode.focus();
return false;
}
return true;
//-->
}
</SCRIPT>
<%
AirwaysID=request.QueryString("AirwaysID")
myActionStr="添加"
if AirwaysID<>"" then
usql="select * from Airways where AirwaysID="&AirwaysID
set urs=server.CreateObject("adodb.recordset")
urs.open usql,conn,1,1
if not urs.eof then
settlecode=urs("settlecode")
AirwaysID=urs("AirwaysID")
CompanyNo=urs("CarrierCode")
session("CompanyNo")=CompanyNo
CompanyName=urs("AirWayName")
ShortName=urs("ShortName")
EnglishName=urs("EnglishName")
Country=urs("Country")
WaitingFlyBuilding=urs("WaitingFlyBuilding")
DescQian=urs("DescQian")
DescGai=urs("DescGai")
DescTui=urs("DescTui")
DescEntroic=urs("DescEntroic")
Address=urs("Address")
Telphone=urs("Telphone")
Fax=urs("Fax")
file1=urs("PictureLogoPath")
updatetime=now()
end if
urs.close
set urs=nothing
myActionStr="修改"
end if
%>
<body>
<TABLE cellPadding=0 cellSpacing=1 >
<form name="ZXLform" action="Fly_company_mod_ba.asp" method="post" onSubmit="return checkinput();" >
<TR bgColor="#C3E7F9">
<td width="84" height="25" align="center" bgcolor="#C3E7F9">公司代号</td>
<td width="239" bgcolor="#FFFFFF"><input name="CompanyNo" type="text" value="<%=CompanyNo%>" size="6" maxlength="2"></td>
<td width="80" align="center" bgcolor="#C3E7F9">国家</td>
<td bgcolor="#FFFFFF"><input name="Country" type="text" value="<%=Country%>" size="20" maxlength="18"> </td>
</TR>
<%if AirwaysID="" then%>
<input type="hidden" name="MyAction" value="AddNew">
<%end if%>
<input type="hidden" name="AirwaysID" value="<%=AirwaysID%>">
<input type="hidden" name="myActionStr" value="<%=myActionStr%>">
<TR bgcolor="#FFFFFF" >
<TD height="25" align=center bgcolor="#C3E7F9">公司名称 </TD>
<TD><input name="CompanyName" type="text" value="<%=CompanyName%>" size="25" maxlength="50"></TD>
<TD align="center" bgcolor="#C3E7F9" >候机楼</TD>
<TD><input name="WaitingFlyBuilding" type="text" value="<%=WaitingFlyBuilding%>" size="20" maxlength="20"></TD>
</TR>
<TR bgcolor="#FFFFFF" >
<TD height="25" align=center bgcolor="#C3E7F9">英 文 名</TD>
<TD><input name="EnglishName" type="text" value="<%=EnglishName%>" size="25" maxlength="100"></TD>
<TD align="center" bgcolor="#C3E7F9">电话</TD>
<TD><input name="Telphoen" type="text" value="<%=Telphone%>" size="25" maxlength="50"></TD>
</TR>
<TR bgcolor="#FFFFFF" >
<TD height="25" align=center bgcolor="#C3E7F9">公司简称 </TD>
<TD ><input name="ShortName" type="text" value="<%=ShortName%>" size="25" maxlength="50"></TD>
<TD align="center" bgcolor="#C3E7F9" >传真</TD>
<TD><input name="Fax" type="text" value="<%=Fax%>" size="25" maxlength="50"></TD>
</TR>
<TR bgcolor="#FFFFFF" >
<TD height="25" align=center bgcolor="#C3E7F9">结算代码</TD>
<TD><input name="settlecode" type="text" value="<%=settlecode%>" size="8" maxlength="3"></TD>
<TD align="center" bgcolor="#C3E7F9" >地址</TD>
<TD><input name="Address" type="text" value="<%=Address%>" size="25" maxlength="50"></TD>
</TR>
<TR bgcolor="#FFFFFF" >
<TD height="60" align=center bgcolor="#C3E7F9">退 </TD>
<TD colspan="3"> <textarea name="DescTui" cols="70" rows="4"><%=DescTui%></textarea> </TD>
</TR>
<TR bgcolor="#FFFFFF" >
<TD height="60" align=center bgcolor="#C3E7F9">改 </TD>
<TD colspan="3"> <textarea name="DescGai" cols="70" rows="4"><%=DescGai%></textarea> </TD>
</TR>
<TR bgcolor="#FFFFFF" >
<TD height="60" align=center bgcolor="#C3E7F9">签 </TD>
<TD colspan="3"><textarea name="DescQian" cols="70" rows="4"><%=DescQian%></textarea></TD>
</TR>
<TR bgcolor="#FFFFFF" >
<TD height="50" align=center bgcolor="#C3E7F9">电子<br>
客票 </TD>
<TD colspan="3"><textarea name="DescEntroic" cols="70" rows="3"><%=DescEntroic%></textarea></TD>
</TR>
<TR bgcolor="#FFFFFF" >
<TD height="50" align=center bgcolor="#C3E7F9">图标</TD>
<TD colspan="3"><input name="file1" type="text" value="<%=file1%>" size="30" maxlength="100">
<input type="button" name="btn" value=" 浏 览 " onClick="window.open('upload_flash.asp?formname=ZXLform&editname=file1&uppath=../aircompanyimg&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')">
<%if trim(file1)<>"" and not isnull(file1) then%>
<img src="../aircompanyimg/<%=file1%>">
<%end if%>
</TD>
</TR>
<TR bgColor=#EEEEEE>
<td height="30" colspan="4" align="right">
<%if AirwaysID<>"" then
Updatetime=Updatetime
else
Updatetime=date()
end if
response.write Updatetime&" "
%>
<input name="Updatetime" type="hidden" value="<%=Updatetime%>" >
<input type="submit" name="AddNow" value="确认">
<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 + -