📄 jpmanage2.asp
字号:
If ClassId="" Then
arrClassId = FlyFlag&""&getSort(0,FlyFlag)
Else
arrClassId = ClassId&""&getSort(ClassId,FlyFlag)
End If
sql = "Select s.*,c.ClassName From Sm_InterFly s Inner Join sm_Class c on s.ToClassId=c.ClassId Where s.FlyFlag="&FlyFlag
If Key<>"" Then sql = sql + " And n.FlyNo Like '%"&Key&"%'"
sql = sql + " Order by c.ClassName"
'response.Write(sql)
oRs.Open sql,oConn,1,3
' 以下为翻页需要的代码+++++++++++++++++++++++猀?吢日??++++++++++
dim buttonstr '按钮字符串
buttonstr = "<td class=BT_TurnPageOper nowrap><input class=input type=""button"" value=""添加记录"" onclick=""window.location='jpManage2.asp?cmd=new'""></td>"
dict("#page#") = 0
recordcount = oRs.RecordCount
if(page>Fix((recordcount-1)/pagesize)) then page = Fix((recordcount-1)/pagesize)
if(page<=0) then
page = 0
else
oRs.Move pagesize * page
end if
' 调用翻页函数生成翻页HTML字符串 参数（总记录数，每页显示数，当前页数，按钮以及其他元素的字符串）替换HTML中的#PageStr#
dict("#PageStr#") = ShowTurnPage(recordcount,pagesize,page,buttonstr)
' 翻页代码结束+++++++++++++++++++++++++++++++++++++++
body = oTemplate.ReplaceMacros(body,dict)
dict.RemoveAll
rows = 0
do while not oRs.EOF
rows = rows + 1
dict("#rows#") = rows
dict("#InterId#") = Null2Space(N2BS(oRs("InterId")))
If oRs("validFlag")=1 then
dict("#check1#") = " selected"
Else
dict("#check2#") = " selected"
End If
If oRs("RecommendFlag")=1 then
dict("#check3#") = " selected"
dict("#check4#") = ""
Else
dict("#check4#") = " selected"
dict("#check3#")=""
End If
dict("#FlyPrice#") = oRs("FlyPrice")
dict("#ClassName#") = oRs("ClassName")
dict("#FromClassIdOptions#") = GetOptions("Select ClassId as id,ClassName as name from sm_Class Where ClassType=1 And FatherId=0",oRs("FromClassId"))
dict("#FlyIdOptions#") = GetOptions("Select BasicId as id,BasicName as name from sm_BasicParam Where BasicType=1",oRs("FlyId"))
dict("#FromTime#") = oRs("FromTime")
loopH = loopH & oTemplate.ReplaceMacros(loopT,dict)
dict.RemoveAll()
if(rows >= pagesize) then exit do
oRs.MoveNext
loop
body = oTemplate.ReplacePart(body,"<!--loop-->","<!--//loop-->",loopH)
oDict("template") = oTemplate.ReplacePart(oDict("template"),"<!--list-->","<!--//list-->",body)
oConn_Close
end function
%>
<!--body-->
<html>
<head>
<meta name="GENERATOR" FlyMemo="Microsoft FrontPage 5.0">
<meta name="ProgId" FlyMemo="FrontPage.Editor.Document">
<meta http-equiv="FlyMemo-Type" FlyMemo="text/html; charset=gb2312">
<Title>神马管理后台</Title>
<link href="style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
background-color: #FC7E02;
}
.style1 {
color: #FF00FF;
font-style: italic;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<script language="javascript" src="../global/Script/changeDlList.js"></script>
<script language="javascript" src="../global/Script/YiFangCheckForm.js"></script>
<Script Language="JavaScript" src="../global/script/AdminFunc.js"></script>
<SCRIPT LANGUAGE="JavaScript">
<!--
//弹出式报警
g_check.alert = true;
//-->
</SCRIPT>
</head>
<body>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="98%" id="AutoNumber1" height="100%" bgcolor="#FFFFFF">
<tr>
<td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left"><img src="../images/15.gif" width="1" height="15"></td>
</tr>
<tr>
<td height="20" class="bborder1"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><a href="jpManage2.asp?cmd=new&FlyFlag=#FatherFlyNoId#">[#FatherFlyNo#添加]</a>
<a href="jpManage2.asp?FlyFlag=#FatherFlyNoId#"> [#FatherFlyNo#列表]</a></td>
<td align="right"> <span class="T01"> </span></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left"><img src="../images/15.gif" width="1" height="15"></td>
</tr>
<tr>
<td align="left"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="35">
<!--list-->
<!--编辑开始-->
<!--edit-->
<form name="form1" method="post" action="jpManage2.asp?FlyFlag=#FatherFlyNoId#">
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="e0e0e0">
<tr>
<td width="16%" align="center" valign="middle" class="T01"><span class="T02">
<input type="hidden" name="InterId" value="#InterId#">
<input name="cmd" type="hidden" id="cmd3" value="#cmd#">
是否显示</span></td>
<td width="84%" bgcolor="#FFFFFF"><span class="T03">
<input name="ValidFlag" type="radio" value="1"#check1#>
是
<input type="radio" name="ValidFlag" value="0"#check2#>
否</span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td width="16%" align="center" class="T01">是否推荐</td>
<td width="84%" align="left"><span class="T03">
<input name="RecommendFlag" type="radio" value="1"#check3#>
是
<input type="radio" name="RecommendFlag" value="0"#check4#>
否</span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01">出发地</td>
<td width="84%" align="left"><select name="FromClassId" class="input" id="FromClassId" usage="notempty" Tip="*还没选择一个出发地">
#FromClassIdOptions#
</select></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01">目的地</td>
<td width="84%" align="left"> <select name="ToClassId" size="1" id="ToClassId" style="BACKGROUND-COLOR: #fbfaf2" usage="notempty" Tip="*还没选择一个目的地">
#ToClassIdOptions#
</select></td></tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01">机场</td>
<td width="84%" align="left"><span class="T03">
<select name="FlyId" class="input" id="FlyId" usage="notempty" Tip="*还没选择一个机场">
#FlyIdOptions#
</select>
</span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 航空公司</td>
<td width="84%" align="left"><select name="CompanyId" class="input" id="CompanyId" usage="notempty" Tip="*还没选择一个航空公司">
#CompanyIdOptions#
</select></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 出发时间</td>
<td width="84%" align="left"><span class="T05"><span class="T03">
<input name="FromTime" type="text" class="input" id="FromTime" value="#FromTime#" size="20" usage="notempty" Tip="*出发时间不能为空">
*格式0815代表8:15</span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 到达时间 </td>
<td align="left"><span class="T05"><span class="T03">
<input name="ToTime" type="text" class="input" id="ToTime" value="#ToTime#" size="20" usage="notempty" Tip="*到达时间不能为空">
*格式0815代表8:15 </span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 航班号</td>
<td align="left"><span class="T05"><span class="T03">
<input name="FlyNo" type="text" class="input" id="FlyNo2" value="#FlyNo#" size="20">
</span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 机型</td>
<td width="84%" align="left"><span class="T05"><span class="T03">
<input name="FlyType" type="text" class="input" id="FlyType" value="#FlyType#" size="20">
</span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 每周航班</td>
<td align="left"><span class="T05"><span class="T03">
<input name="FlyWeekNo" type="text" class="input" id="FlyWeekNo" value="#FlyWeekNo#" size="20">
</span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 全价</td>
<td align="left"><span class="T05"><span class="T03">
<input name="FlyPrice" type="text" class="input" id="FlyPrice" value="#FlyPrice#" size="20" usage="num" Tip="*单程票价为数字格式">
*数字格式,填写零代表电话查询</span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 特价</td>
<td align="left"><span class="T05"><span class="T03">
<input name="FlyDoublePrice" type="text" class="input" id="FlyDoublePrice" value="#FlyDoublePrice#" size="20" usage="num" Tip="*往返票价为数字格式">
*数字格式,填写零代表电话查询 </span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 备注</td>
<td width="84%" align="left"><input type="hidden" name="FlyMemo" value="#FlyMemo#">
<iframe ID="eWebEditor1" src="../global/editpage/ewebeditor.asp?id=FlyMemo&style=xueren" frameborder="0" scrolling="no" width="550" HEIGHT="250"></iframe></td>
</tr>
<tr align="center">
<td colspan="2" class="T01"><span class="tablebutbk">
<input name="Submit22" type="submit" class="button" value="#input#">
<input name="Submit22" type="reset" class="button" value="清 空 信 息">
</span> </td>
</tr>
</table>
</form>
<!--//edit-->
<!--编辑结束-->
<!--列表开始-->
<!--newslist-->
<!--搜索开始-->
<!--search-->
<form name="form2" method="post" action="?FlyFlag=#FatherFlyNoId#" onSubmit="javascript:return reg_submit()">
<table width="70%" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td>快速通道：</td>
<td><select name="select2" onChange="MM_jumpMenu('self',this,0)">
<option selected value="">全部</option>
#rapidoption#
</select></td>
<td>搜索</td>
<td><input name="key" type="text" id="key" class="input"> </td>
<td><input type="submit" name="Submit2" value="搜索"></td>
</tr>
</table>
</form>
<!--//search-->
<!--搜索结束-->
<br> <br>
<form name="form1" method="post" action="jpManage2.asp?FlyFlag=#FatherFlyNoId#">
<input name="cmd" type="hidden" id="cmd" Value="News_EditDel">
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="e0e0e0">
<tr align="center" class="tabletopbk">
<td valign="middle">操作</td>
<td width="55">是否显示</td>
<td width="55">是否推荐</td>
<td>出发地</td>
<td>目的地</td>
<td>机场</td>
<td>全程</td>
<td>出发时间</td>
<td>编辑</td>
</tr>
<!--loop-->
<tr align="center" bgcolor="#FFFFFF">
<td class="T01"><input name="selAnnounce" type="checkbox" id="selAnnounce" value="#InterId#"></td>
<td class="T02"><select name="ValidFlag#InterId#" id="select" class="input">
<option value="1"#check1#>是</option>
<option value="0"#check2#>否</option>
</select></td>
<td class="T02"><select name="RecommendFlag#InterId#" class="input" id="RecommendFlag#InterId#">
<option value="1"#check3#>是</option>
<option value="0"#check4#>否</option>
</select></td>
<td class="T04"><select name="FromClassId#InterId#" class="input" id="FromClassId#InterId#">
#FromClassIdOptions#
</select></td>
<td class="T04">#ClassName#</td>
<td class="T04"><select name="FlyId#InterId#" class="input" id="FlyId#InterId#">
#FlyIdOptions#
</select></td>
<td class="T05"><span class="T03">
<input name="FlyPrice#InterId#" type="text" class="input" id="FlyPrice#InterId#" value="#FlyPrice#" size="6">
</span></td>
<td class="T05"><span class="T03">
<input name="FromTime#InterId#" type="text" class="input" id="FromTime#InterId#" value="#FromTime#" size="15">
</span></td>
<td class="T07"><span class="T06"><a href="?InterId=#InterId#&cmd=edit&FlyFlag=#FatherFlyNoId#">[编辑]</a></span></td>
</tr>
<!--//loop-->
<tr align="center">
<td colspan="9" class="T01"><table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td width="38%">
<p>
<input name=chkall type=checkbox value=on onclick=CheckAll(this.form)>
全选
<input name="act" type="submit" class="button" value="删 除" onClick="{if(confirm('您确定执行的操作吗?')){this.document.form1.submit();return true;}return false;}">
<input name="act" type="submit" class="button" value="修 改" onClick="{if(confirm('您确定执行的操作吗?')){this.document.form1.submit();return true;}return false;}">
</p></td>
<td align="right" width="62%"> </td>
</tr>
</table></td>
</tr>
</table>
</form>
<form method=post name=frmSearch id=frmSearch action="jpManage2.asp?key=#key#&ClassId=#ClassId#&FlyFlag=#FatherFlyNoId#">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right">
<input type=hidden name=page value="#page#">
#PageStr# </td>
</tr>
</table>
</form>
<!--//newslist-->
<!--列表结束-->
<!--//list-->
</td>
</tr>
</table></td>
</tr>
<tr>
<td align="left"> </td>
</tr>
</table></td>
</tr>
<tr>
<td align="right" valign="bottom"><!-- #BeginLibraryItem "/Library/copyright.lbi" -->
<a href="http://www.fashionsh.com.cn" target="_blank">时尚上海</a> 版权所有©2004<!-- #EndLibraryItem --></td>
</tr>
</table>
</body>
</html>
<!--//body-->
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -