📄 lastshopping.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="script/user_common.asp"-->
<!--#include file="script/convertDate.asp"-->
<!--#include file="script/fixNumber.asp"-->
<% if((Session("user")==false)||(Session("user")=='undefined')||(Session("user")==null)){Response.Redirect("Index.asp");}
var rs = Server.CreateObject("ADODB.Recordset");
var custID = parseInt(Session("cid"));
var strSQL;
strSQL = "SELECT Distinct OID, ODate, Ostatus, OTotal FROM vwOrder WHERE CID = " + custID;
strSQL+= " Order By ODate Desc, OID Desc";
rs.Open(strSQL,oConn,3,1);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>DTH Computer</title>
<script language="jscript">
function openPopup(url)
{
popupWin = window.open(url,"ProductDetail","width=620,height=550,scrollbars=yes");
var posx = (screen.availWidth-620)/2;
var posy = (screen.availHeight-550)/2;
popupWin.moveTo(posx,posy);
}
</script>
</head>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" bgcolor="#2D87CD">
<!--#include file="Include/top.asp"-->
<div align="center">
<table width="779" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td height="129" valign="top">
<!--#include file="Include/inc_top.asp"-->
</td>
</tr>
<tr>
<td valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<!--DWLayoutTable-->
<tr>
<td width="159" rowspan="3" valign="top" style="background-image: url('images/mnleft_bg.gif'); background-repeat: repeat-y; background-position-x: center;">
<!--#include file="Include/inc_menuleft.asp"-->
</td>
<td width="1" rowspan="2" valign="top" bgcolor="#CCCCCC"></td>
<td width="460" rowspan="2" align="center" valign="top" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="7" background="images/top_body_bg.gif"></td>
</tr>
<tr>
<td style="padding-left: 10px; padding-right:10; padding-top:3; padding-bottom:0" valign="top">
<marquee behavior="scroll" width="100%" style="color: #0066CC; font-family:Tahoma; font-size:8pt" scrollamount="4" onmouseover="this.stop();" onmouseout="this.start();" scrolldelay="85">
Công ty Máy tính DTH - Xin kính chào quý khách - Địa chỉ: 1A Yết Kiêu, Hoàn Kiếm, Hà Nội - Điện thoại: (04) 8224880 - Fax: (04) 8224881</marquee>
</td>
</tr>
<%
if((!rs.BOF)||(!rs.EOF)){
%>
<tr>
<td height="38" align="center" valign="middle"><strong><font color="#0000CC" size="2" face="arial, tahoma, verdana">Thông tin về các lần giao dịch truớc của bạn <br> ở công ty chúng tôi</font></strong></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td align="right" valign="top" style="padding-bottom:3px; padding-right:3px; ">
<font color="darkblue" face="arial, tahoma, verdana" size="2">Tổng số <strong><%=rs.RecordCount%></strong> hóa đơn</font></td>
</tr>
<tr>
<td style="padding-left:3px; padding-right:3px; "><table width="100%" border="1" cellpadding="2" cellspacing="0" bordercolor="#999966" style=" border:1px solid; border-collapse:collapse;">
<tr>
<td width="12%" align="center" valign="top" bgcolor="#E4E4D6"><strong><font size="2" face="arial, tahoma, verdana">STT</font></strong></td>
<td width="12%" align="center" valign="top" bgcolor="#E4E4D6"><strong><font size="2" face="arial, tahoma, verdana">Ngày</font></strong> </td>
<td width="39%" align="center" valign="top" bgcolor="#E4E4D6"><strong><font size="2" face="arial, tahoma, verdana">Tên hàng</font></strong> </td>
<td width="12%" align="center" valign="top" bgcolor="#E4E4D6"><strong><font size="2" face="arial, tahoma, verdana">Số lượng</font></strong> </td>
<td width="12%" align="center" valign="top" bgcolor="#E4E4D6"><strong><font size="2" face="arial, tahoma, verdana">Giá<span style="color:#FF0000 "> (USD)</span></font></strong> </td>
<td width="11%" align="center" valign="top" bgcolor="#E4E4D6"><strong><font size="2" face="arial, tahoma, verdana">Đã thanh toán</font></strong></td>
<td width="14%" align="center" valign="top" bgcolor="#E4E4D6"><strong><font size="2" face="arial, tahoma, verdana">Thành tiền<span style="color:#FF0000 "> (USD)</span></font></strong> </td>
</tr>
<%
rs.PageSize=5;
var totalPage=rs.PageCount;
var totalRecord = rs.RecordCount;
var intCurrentPage;
var i;
var dem = 1;
if(isNaN(Request.QueryString("page")))
{
intCurrentPage = 1;
}
else
{
intCurrentPage = parseInt(Request.QueryString("page"));
}
if (totalPage > 0)
{
rs.AbsolutePage = parseInt(intCurrentPage);
}
else
{
intCurrentPage = 0;
}
i=1;
while((!rs.BOF)&&(!rs.EOF)){
var strSQL2 = "SELECT PName, OQuantity, PPrice, OStatus, OID, PID FROM vwOrder WHERE OID = " + rs.Fields("OID");
rs2=Server.CreateObject("ADODB.Recordset");
rs2.Open(strSQL2,oConn,3,1);
var k = 1;
while (!rs2.EOF && !rs2.BOF){
%>
<tr valign="middle"><%if (k==1){%>
<td align="center" class="cart" rowspan="<%=rs2.RecordCount%>"><%=rs.PageSize * (intCurrentPage-1) + dem%></td>
<td align="center" class="cart" height="23" rowspan="<%=rs2.RecordCount%>">
<font color="#663300"><strong><font size="2"><%=convertDate(rs.Fields("ODate"))%></font></strong></font> <br>
<span style="font-family:Arial, Verdana, Tahoma; font-size:10px; color: #666666 ">
<a title="Hóa đơn chi tiết" href="#" onClick="Javascript:openPopup('popup_OrderDetail.asp?oid=<%=rs.Fields("OID")%>&txtDay=<%=convertDate(rs.Fields("ODate"))%>');">(Chi tiết)</a>
</span>
</td>
<%}%>
<td class="trOut" align="left" onMouseOver="this.className='trOver';" onMouseOut="this.className='trOut';">
<a title="Chi tiết sản phẩm" href="Product_detail.asp?pID='<%=rs2.Fields('PID')%>'"><%=rs2.Fields("PName")%></a>
</td>
<td align="center" class="tdShopping"><%=rs2.Fields("OQuantity")%></td>
<td align="center" class="tdShopping"><%=rs2.Fields("PPrice")%></td>
<%if (k==1){%>
<td align="center" class="cart" height="23" rowspan="<%=rs2.RecordCount%>"><input type="checkbox" <%if(rs.Fields('OStatus')==1){%> checked <%}else{%> disabled <%}%>>
</td>
<%}%>
<td align="right" class="tdShopping"><%=fixDecimalPlaces(eval(rs2.Fields("OQuantity")*rs2.Fields("PPrice")),2)%></td>
</tr>
<%
k++;
rs2.MoveNext();
}
%>
<tr>
<td align="right" valign="middle" colspan="6" class="tdShopping"><font color="darkblue" size="2" face="arial, tahoma, verdana"><strong>Tổng tiền</strong></font></td>
<td align="right" valign="middle" class="tdShopping"><font color="#FF0000"><%fixDecimalPlaces(rs.Fields("OTotal"),2)%></font>
</td>
</tr>
<%
if(i==rs.PageSize)
{
break;
}
i++;
dem++;
rs.MoveNext();
if((!rs.BOF)||(!rs.EOF))
{
%>
<tr bgcolor="#B6CEE7">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td colspan="2"> </td>
<td> </td>
</tr>
<%
}
}
%>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
<%if(rs.PageCount>1){%>
<tr>
<td align="center" valign="top">
<%
var intCount;
if(intCurrentPage>1)
Response.Write("<a href=?page=" + (intCurrentPage-1) + ">Trước</a>" + " |");
else
Response.Write("<font color='#999999' size='2'>Trước</font> |");
for(intCount = 1;intCount<=rs.PageCount;intCount++)
{
if (intCount == intCurrentPage)
Response.Write("<font color='#DD0000' size='2'>" + " " + intCount + "</font>" + " | ");
else{
Response.Write("<a href=?page=" + intCount + ">" + " " + intCount + "</a> " + " | ");
}
}
if(intCurrentPage!=rs.PageCount)
Response.Write("<a href=?page=" + (intCurrentPage+1) + ">Sau</a>");
else
Response.Write(" <font color='#999999' size='2'>Sau</font>");
%>
</td>
</tr>
<tr>
<td style=" padding-bottom:5px; padding-top:4px; " height="18" align="center" valign="top">
<font color="darkblue" face="arial, tahoma, verdana" size="2">Trang
<%=intCurrentPage%>
/
<%=rs.PageCount%>
</font> </td>
</tr>
<%}%>
<%
}else{
%>
<tr>
<td align="center" valign="middle" style="padding-left:3px; padding-right:3px; padding-top:3px; ">
<strong><font color="#0000CC" size="2" face="arial, tahoma, verdana">Khách hàng chưa thực hiện giao dịch nào ở công ty chúng tôi!
Tài khoản của quý khách đẫ được kích hoạt quý khách có thể sử dụng tất cả các chức năng của Website!</font></strong></td>
</tr>
<%}%>
</table>
<td width="1" rowspan="2" valign="top" bgcolor="#CCCCCC"></td>
<td width="158" valign="top" rowspan="2" style="background-image: url('images/mnleft_bg.gif'); background-repeat: repeat-y; background-position-x: center;">
<!--#include file="Include/inc_menuright.asp"-->
</td>
</tr>
</table></td>
</tr>
<tr>
<td>
<!--#include file="Include/inc_bottom.asp"-->
</td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -