?? ddlmx.asp
字號:
<!-- #include file="include/adovbs.inc" -->
<!-- #include file="include/dataconn.asp" -->
<!-- #include file="common.asp" -->
<%
Response.Buffer =false
Response.Expires=-1
userid=session("user_id")
if userid<>"" then
thistoday =year(now)&"-"&month(now)&"-"&day(now)
dtfrom=trim(request("dtfrom"))
dtto=trim(request("dtto"))
if len(dtfrom)=0 then
dtfrom=year(now)&"-"& month(now)&"-1"
dtfrom=cstr(dtfrom)
dtfrom=datevalue(dtfrom)
end if
if len(dtto)=0 then
dtto=cstr(thistoday)
dtto=datevalue(dtto)
end if
set ao=conn.execute("select count(*) as allorder from orders where dlid="&userid&"")
allorder=ao("allorder")
ao.close
set ao=nothing
set HyRs=server.CreateObject("adodb.recordset")
sql = "SELECT * FROM orders"
sql =sql & " where dlid="&userid&" and ispassed=true and ordertime between #"&dtfrom&"# and #"&dtto&"#"
sql =sql & " order by id desc"
HyRs.Open sql,conn
j=HyRs.RecordCount
if not hyrs.eof then money=j*hyrs("price")
if money="" then money=0
set oo=conn.execute("select * from dlclub where hid="&userid&"")
orders=oo("orders")
price=oo("oprice")
allmoney=orders*price
ye=oo("allmoney")
jj=orders*10
%>
<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<link rel="stylesheet" href="include/e1.css" type="text/css">
<script>
function fPopUpCalendarDlg(ctrlobj)
{
showx = event.screenX - event.offsetX - 4 - 210 ; // + deltaX;
showy = event.screenY - event.offsetY + 18; // + deltaY;
newWINwidth = 210 + 4 + 18;
retval = window.showModalDialog("Include/CalendarDlg.htm", "", "dialogWidth:197px; dialogHeight:210px; dialogLeft:"+showx+"px; dialogTop:"+showy+"px; status:no; directories:yes;scrollbars:no;Resizable=no; " );
if( retval != null ){
ctrlobj.value = retval;
}else{
//alert("canceled");
}
}
</script>
</head>
<body leftmargin="10" topmargin="10" marginwidth="0" marginheight="0">
<form method="post" action="ddlmx.asp" id="form1" name="form1">
<table width="100%" border="0" height="21" cellpadding="0" cellspacing="0">
<tr>
<td width="76%"> <div align="center"><font color="#FFFFFF"><font color="#000000">從</font></font>
<input id="dtfrom" name="dtfrom" readonly value="<% =dtfrom %>" size="12">
<img src="image/datetime.gif" style="cursor:hand;" align="absmiddle" alt="彈出日歷下拉菜單" onClick="fPopUpCalendarDlg(document.form1.dtfrom);return false" width="16">
到
<input id="dtto" name="dtto" readonly value="<% =dtto %>" size="12">
<img src="image/datetime.gif" style="cursor:hand;" align="absmiddle" alt="彈出日歷下拉菜單" onClick="fPopUpCalendarDlg(document.form1.dtto);return false" width="16">
<input type="image" value="submit" src="Image/027.gif" id="image1" name="image1">
</div></td>
<td width="24%"> </td>
</tr>
</table>
</form>
<table border="1" cellpadding="0" cellspacing="0" width="98%" bordercolordark="#e0f4ff" bordercolorlight="#162d6b">
<tr class="td3">
<td width="150" height="26">
<DIV align=center><FONT color=#ffffff>報單數</FONT></DIV></td>
<td width="150" height="26" align="center"> <FONT color=#ffffff>報單費用</FONT></td>
<td width="150" height="26" align="center"> <FONT color=#ffffff>累計報單數</FONT></td>
<td width="150" height="26" align="center"> <FONT color=#ffffff>累計報單費用</FONT></td>
<td width="150" height="26" align="center"> 報單獎金</td>
<td width="150" height="26" align="center"> 當前余額</td>
</tr>
<tr height="25">
<td height="24" align="center" width="150"> <%=j%>
</td>
<td height="24" align="center" width="150"><%=money%> </td>
<td height="24" align="center" width="150"> <%=orders%> </td>
<td height="24" align="center" width="150"> <%=allmoney%> </td>
<td height="24" align="center" width="150"> <%=jj%></td>
<td height="24" align="center" width="150"> <%=ye%></td>
</tr>
</table>
<p></p>
<%
end if%>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -