📄 product.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<!--#include file="script/user_common.asp"-->
<%
var intCat=Request.QueryString('catID');
var intSub=Request.QueryString('subID');
var strFac=String(Request.QueryString("facName"));
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>:: Công ty máy tính DTH ::</title>
</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 rowspan="2" 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>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3"> </td>
<td width="21"><img src="images/i_2.gif" width="21" height="21"></td>
<td width="99" style="padding-left:8px; ">
<font color="#3466DE">
<span style="font-family: Tahoma,verdana,Arial; font-weight: 700; font-size: 13pt">
Sản phẩm</span></font>
</td>
<td>
<hr noshade size="1" color="#979797">
</td>
<td width="3"> </td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td style=" padding-top:10px; ">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
var rsTop=Server.CreateObject("ADODB.Recordset");
var topSQL;
if((isNaN(intSub))||(intSub==""))
{
topSQL="Select Distinct CatName, CatID From vwSubCat Where CatID=" + parseInt(intCat);
}
else
{
topSQL="Select SubName, SubID From vwSubCat Where SubID=" + parseInt(intSub);
}
rsTop.Open(topSQL,oConn,3,1);
//if((rsTop.BOF)||(rsTop.EOF)){Response.Redirect('Index.asp');}
%>
<tr>
<td width="20" background="images/otrai.gif"></td>
<td bgcolor="#006699" align="left"><span style="font-size: 14px"><FONT
style="COLOR: #ffffff"><STRONG>
<%
if((isNaN(intSub))||(intSub==""))
{
var top=rsTop('CatName');
Response.Write(top);
}
else
{
var top=rsTop('SubName');
Response.Write(top);
}
rsTop.Close();
%>
</STRONG></FONT></span></td>
<td width="20" background="images/ophai.gif"></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20" height="45"> </td>
<%
var rsFac=Server.CreateObject("ADODB.Recordset");
var facSQL="Select Distinct PCompany From vwProduct";
if((isNaN(intSub))||(intSub==""))
{
facSQL+=" Where CatID=" + parseInt(intCat) + " AND PID <> 'null'";
}
else
{
facSQL+=" Where SubID=" + parseInt(intSub) + " AND PID <> 'null'";
}
rsFac.Open(facSQL,oConn,3,1);
//if((rsFac.BOF)||(rsFac.EOF)){Response.Redirect('Index.asp');}
%>
<td align="left" style=" padding-top:5px;" bgcolor="#FFFFFF">
<%
while((!rsFac.BOF)&&(!rsFac.EOF))
{
%>
<a href="Product.asp?catID=<%=intCat%>&subID=<%=intSub%>&facName=<%=rsFac.Fields('PCompany')%>" class="pCom"><%=rsFac.Fields('PCompany')%></a>
<%
rsFac.MoveNext();
if((!rsFac.BOF)&&(!rsFac.EOF))
{
Response.Write(" - ");
}
}rsFac.Close();
%>
</td>
<td width="20"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="5"> </td>
</tr>
<tr>
<td style="padding-left:8px; padding-right:8px; "><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
var rs=Server.CreateObject("ADODB.Recordset");
var strSQL="Select PID, PName, PImage, PPrice, PWarranty, PDescription, PStatus, PBest, PNew, PCompany From vwProduct"
if((isNaN(intSub))||(intSub==""))
{
strSQL+=" Where SCatID=" + parseInt(intCat) + " AND PID <> 'null'";
}
else
{
strSQL+= " Where PSubCatID=" + parseInt(intSub) + " AND PID <> 'null'";
}
if(strFac!="undefined")
{
strSQL+= " AND PCompany=" + "'" + strFac + "'";
}
strSQL+= " Order By SOrder"
rs.Open(strSQL,oConn,3,1);
//if((rs.BOF)||(rs.EOF)){Response.Redirect('Index.asp');}
rs.PageSize=10;
var totalPage=rs.PageCount;
var intCurrentPage;
var i;
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;
if((rs.BOF)&&(rs.EOF))
{
%>
<tr>
<td height="30" align="center" valign="top"><font color="#FF0000" size="3"><strong>Sản phẩm đang cập nhật!!!</strong></font><br>
</tr>
<%
}else{
while((!rs.BOF)&&(!rs.EOF))
{
%>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="80" align="left" valign="top"><img src="<%=rs.Fields('PImage')%>" width="80"></td>
<td rowspan="2" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td align="left" style="padding-left:5px; "><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="282" align="left" valign="middle">
<p>
<font size="2"><a title="Chi tiết" href="Product_detail.asp?pID='<%=rs.Fields("PID")%>'" class="pName"><%=rs.Fields('PName')%></a></font><%if(rs.Fields('PNew')==1){Response.Write(' <img src="images/new.gif" border=0>');}%></p>
</td>
<td width="77"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="99" align="right" valign="top">
<font color="#0000FF"
face="Arial, Helvetica, sans-serif"><%=rs.Fields('PCompany')%></font>
</td>
</tr>
<tr>
<td width="99" align="right" valign="bottom" style="padding-bottom:5px; padding-top:5px; padding-left:0px; padding-right:0px; ">
Kho hàng: <strong>
<%if(rs.Fields('PStatus')==1){Response.Write('Có');}else{Response.Write('Hết');}%>
</strong></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</tr>
<tr valign="bottom">
<td align="left" style="padding-top:5px; "><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="middle" style=" padding-left:5px; ">Giá: <font color="#FF0000"><%=rs.Fields('PPrice')%></font></td>
<td width="120" align="left" valign="middle"><font class="warranty">Bảo hành:</font> <%=rs.Fields('PWarranty')%> Tháng</td>
<td width="99" align="right" valign="bottom"><a href="Shopping_Cart.asp?act=add&pid=<%=rs.Fields('PID')%>" style="border-style:none ">
<img src="images/btn_muahang.gif" width="87" height="29" border="0"></a></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<%
if(i==rs.PageSize)
{
break;
}
i++;
rs.MoveNext();
if((!rs.BOF)&&(!rs.EOF))
%>
<tr>
<td valign="middle"><font color="#CCCCCC" style="padding-bottom:3px; padding-top:2px; ">------------------------------------------------------------------------------------------------------------</font></td>
</tr>
<%
}
}
%>
<tr>
<td align="center" valign="middle"> </td>
</tr>
<%
if (rs.PageCount > 1)
{
%>
<tr>
<td align="center" valign="middle">
<%
var intCount;
if(intCurrentPage>1)
Response.Write("<a href=?page=" + (intCurrentPage-1) + "&catID=" + intCat + "&subID=" + intSub + "&facName=" + String(strFac) + ">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 + "&catID=" + intCat + "&subID=" + intSub + "&facName=" + String(strFac) + ">" + " " + intCount + "</a> " + " | ");
}
}
if(intCurrentPage!=rs.PageCount)
Response.Write("<a href=?page=" + (intCurrentPage+1) + "&catID=" + intCat + "&subID=" + intSub + "&facName=" + String(strFac) + ">Sau</a>");
else
Response.Write(" <font color='#999999' size='2'>Sau</font>");
%>
</td>
</tr>
<tr>
<td align="center" valign="top" style="padding-top:8px; padding-bottom:5px; ">
<font color="darkblue" face="arial, tahoma, verdana" size="2">Trang <strong><%=intCurrentPage%> / <%=rs.PageCount%></strong></font>
</td>
</tr>
<%
}rs.Close();
%>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
<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>
<%oConn.Close();%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -