📄 jporder.asp
字号:
dim pagesize
if IsEmpty(request("pagesize")) then
pagesize = ListRowsMax
else
pagesize = cint(request("pagesize"))
end if
'打开数据库
oConn_Start
dim body,loopT,loopH,arrClassId
thisurl = "jpOrder.asp?"
dim page,sql,oRs,pagecount,recordcount,rows
dim dict
set dict = server.CreateObject("scripting.dictionary")
'获取快速通道的下拉列表
dict("#key#") = key
page = cint(Request("page"))
body = oTemplate.GetPart(oDict("template"),"<!--newslist-->","<!--//newslist-->")
loopT = oTemplate.GetPart(body,"<!--loop-->","<!--//loop-->")
set oRs = server.CreateObject("adodb.recordset")
'获取该分类下的所有子分类
sql = "Select O.*,c.FromClassId,c.FlyPrice,S.ClassName From Sm_Order O Inner Join sm_InterFly c on o.InterId=c.InterId inner join Sm_Class S on c.ToClassId=S.ClassId Where 1=1"
sql = sql + " Order by O.OrderId Desc"
'response.Write(sql)
oRs.Open sql,oConn,1,1
' 以下为翻页需要的代码+++++++++++++++++++++++猀?吢日??++++++++++
dim buttonstr '按钮字符串
buttonstr = "<td class=BT_TurnPageOper nowrap><input class=input type=""button"" value=""添加记录"" onclick=""window.location='jpOrder.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("#OrderId#") = Null2Space(N2BS(oRs("OrderId")))
If oRs("validFlag")=1 then
dict("#check1#") = " selected"
Else
dict("#check2#") = " selected"
End If
dict("#ContactName#") = oRs("ContactName")
dict("#BackTime#") = oRs("BackTime")
dict("#PersonNum#") = oRs("PersonNum")
dict("#FromClassIdOptions#") = GetOptions("Select ClassId as id,ClassName as name from sm_Class Where ClassType=3 And FatherId=0",oRs("FromClassId"))
' dict("#FlyIdOptions#") = GetOptions("Select BasicId as id,BasicName as name from sm_BasicParam Where BasicType=1",oRs("FlyId"))
dict("#Mobile#") = oRs("Mobile")
dict("#FromTime#") = oRs("FromTime")
dict("#ClassName#") = oRs("ClassName")
dict("#FlyPrice#") = oRs("FlyPrice")
dict("#Addtime#") = oRs("DateCreated")
dict("#Email#") = oRs("Email")
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" OrderMemo="Microsoft FrontPage 5.0">
<meta name="ProgId" OrderMemo="FrontPage.Editor.Document">
<meta http-equiv="OrderMemo-Type" OrderMemo="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="jpOrder.asp">订票列表</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="jpOrder.asp?FlyFlag=#FatherFlyTrueNameId#">
<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="OrderId" value="#OrderId#">
<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 align="center" class="T01"> 订票联系人姓名</td>
<td width="84%" align="left"><span class="T05"><span class="T03">
#ContactName# </span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 旅客人数</td>
<td align="left"><span class="T05"><span class="T03">
#PersonNum#</span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 出发日期</td>
<td align="left"><span class="T05"><span class="T03">
#FromTime# </span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 返回日期</td>
<td align="left"><span class="T05"><span class="T03">
#BackTime#</span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 手机号码</td>
<td align="left"><span class="T05"><span class="T03">
#Mobile#
</span></span></td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01">固定电话</td>
<td align="left">#Phone#</td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01">送票地址</td>
<td align="left">#Address#</td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01">Email</td>
<td align="left">#Email#</td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01">QQ</td>
<td align="left">#QQ#</td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> 备注</td>
<td align="left">#OrderMemo# </td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> </td>
<td align="left"><span class="T05"><span class="T03"> </span></span> #ckxx# </td>
</tr>
<tr align="center" bgcolor="#FFFFFF">
<td align="center" class="T01"> </td>
<td align="left"><span class="T05"><span class="T03"> </span></span></td>
</tr>
<tr align="center">
<td colspan="2" class="T01"><span class="tablebutbk">
</span> </td>
</tr>
</table>
</form>
<!--//edit-->
<!--编辑结束-->
<!--列表开始-->
<!--newslist-->
<!--搜索开始-->
<!--search-->
<form name="form2" method="post" action="?FlyFlag=#FatherFlyTrueNameId#" 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="jpOrder.asp?FlyFlag=#FatherFlyTrueNameId#">
<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 width="29" valign="middle">操作</td>
<td width="55">是否显示</td>
<td width="105">订票人姓名</td>
<td width="111">旅客人数</td>
<td width="42">出发地</td>
<td width="93">目的地</td>
<td width="85">手机号码</td>
<td width="71">单程</td>
<td width="75">订票时间</td>
<td width="90">出发时间</td>
<td width="69">Email</td>
<td width="46">查看</td>
</tr>
<!--loop-->
<tr align="center" bgcolor="#FFFFFF">
<td class="T01"><input name="selAnnounce" type="checkbox" value="#OrderId#"></td>
<td class="T02"><select name="ValidFlag#OrderId#" id="select" class="input">
<option value="1"#check1#>是</option>
<option value="0"#check2#>否</option>
</select></td>
<td class="T02">#ContactName#</td>
<td class="T04">#PersonNum#</td>
<td class="T04"><select name="FromClassId#OrderId#" class="input" id="FromClassId#OrderId#">
#FromClassIdOptions#
</select></td>
<td class="T04">#ClassName#</td>
<td class="T04">#Mobile#</td>
<td class="T05"><span class="T03">
#FlyPrice# </span></td><td class="T05"><span class="T03">#Addtime#
</span></td>
<td class="T05"><span class="T03">#FromTime#
</span></td>
<td class="T05">#Email#</td>
<td class="T07"><span class="T06"><a href="?OrderId=#OrderId#&cmd=edit">[查看]</a></span></td>
</tr>
<!--//loop-->
<tr align="center">
<td colspan="11" 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="jpOrder.asp?key=#key#&ClassId=#ClassId#">
<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 + -