📄 products.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using BLL;
using Socut.Data;
namespace Websystem
{
/// <summary>
/// products 的摘要说明。
/// </summary>
public class products : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected CData myData=new CData();
protected DataSet ds=new DataSet();
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label3;
protected other ot=new other();
private void Page_Load(object sender, System.EventArgs e)
{
string user_IP="";
if(Request.ServerVariables["HTTP_VIA"]!=null)
{
user_IP=Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString();
}
else
{
user_IP=Request.ServerVariables["REMOTE_ADDR"].ToString();
}
string [] u_ip=user_IP.Split(new char[]{'.'});
bool look=false;
int i=1;
string sql = "select * from IpLock order by id desc";
ds = myData.GetDataSet(sql, 0, 0, "ip");
if(ds.Tables[0].Rows.Count>0)
foreach(DataRow dr in ds.Tables[0].Rows)
{
for(int j=1;j<=Convert.ToInt32(dr["ipsame"]);j++)
{
if(Convert.ToInt32(u_ip[j])==Convert.ToInt32(dr["ip"+i.ToString()]))
i++;
}
if(Convert.ToInt32(dr["ipsame"])==i)
{
look=true;//当条件成立表示IP类似，跳出循环，锁定IP，表示国内不可见
break;
}
}
if(look)
load_pro2();//国内不可见
else
load_pro();//国内可见
// Response.Write(user_IP);
load_new(look);
load_hot(look);
}
//加载产品列表(国内可见)
private void load_pro()
{
int pageid = 1;string str="";
if(ot.isDefined("pageid"))
pageid=Convert.ToInt32(Request["pageid"].ToString().Trim());
int pagesize = 6;//每页显示数
int endpage = pagesize;
if(ot.isDefined("endpage"))
endpage=Convert.ToInt32(Request["endpage"].ToString().Trim());
int pagesum=0;//总共有多少页
int pagenum = 0;//当然第几页
string flog="",sql ="";
if(ot.isDefined("flog"))
flog=Request.QueryString["flog"].ToString().Trim();
if(flog=="hot")
sql = "SELECT id,MERCHANDISE FROM (SELECT TOP " + endpage + " * FROM (SELECT TOP " + pagesize * pageid + " * FROM BU_MERCHANDISE where ISAVAILABILITY=1 ORDER BY BROWSEDEGREE desc) AS mytbl ORDER BY BROWSEDEGREE asc) AS tblme ORDER BY BROWSEDEGREE desc";
else
sql = "SELECT id,MERCHANDISE FROM (SELECT TOP " + endpage + " * FROM (SELECT TOP " + pagesize * pageid + " * FROM BU_MERCHANDISE where ISAVAILABILITY=1 ORDER BY ID desc) AS mytbl ORDER BY ID asc) AS tblme ORDER BY ID desc";
ds=myData.GetDataSet(sql,0,pagesize,"ds");
str+="<table width=94% border=0 cellspacing=0 cellpadding=0><tr><td> </td></tr><tr><td height=469 align=center valign=top class=wenzi1>";
str+="<table width=98% border=0 cellspacing=0 cellpadding=0 id=table2><tr>";
int i=0;
if( ds.Tables[0].Rows.Count>0)
foreach(DataRow dr in ds.Tables[0].Rows)
{++i;
str+="<td width=50% height=32 align=center><table border=0 width=100% id=table3 cellspacing=0 cellpadding=0><tr><td width=215 height=134 align=center valign=middle><a href=productmore.aspx?id="+dr[0].ToString()+"><img src="+imgs(dr[0].ToString())+" width=210 height=130 border=0></a></td></tr><tr><td height=28 width=50% align=center class=wenzi1> <p align=center><span class=linkc><a href=productmore.aspx?id="+dr[0].ToString()+"><strong>"+dr[1].ToString()+"</strong></a></span></td></tr></table></td>";
if(i%2==0 )
{
str+="</tr></table>";
str+="<table width=98% border=0 cellspacing=0 cellpadding=0 id=table2><tr>";
}
}
str+=" </tr></table> </td></tr></table>";
sql = "SELECT COUNT(ID) as counts FROM BU_MERCHANDISE where ISAVAILABILITY=1 ";
ds = myData.GetDataSet(sql,0,0,"aa");
pagenum = Convert.ToInt32( ds.Tables[0].Rows[0]["counts"]);
if((pagenum%pagesize)==0)
{
pagesum = pagenum / pagesize;
}
else
{
pagesum = pagenum / pagesize + 1;
}
if (pageid == pagesum - 1) endpage = pagenum % pagesize;
str += "<table border=0 width=100% id=table1><tr><td height='34' colspan='5' align='center'>共有" + pagenum + "个，" + pageid + "/" + pagesum + "页 ";
if (pageid >1)
{
str += "<a href=\"?flog="+flog+"&pageid=1&endpage="+pagesize+"\">[第一页]</a><a href=\"?flog="+flog+"&pageid="+(pageid-1)+"&endpage="+pagesize+"\">[上一页]</a>";
}
if (pageid < pagesum)
{
str += "<a href=\"?flog="+flog+"&pageid="+(pageid+1)+"&endpage="+endpage+"\">[下一页]</a><a href=\"?flog="+flog+"&pageid="+pagesum+"&endpage="+(pagenum % pagesize)+"\">[第末页]</a>";
}
str += "</td></tr></table>";
this.Label1.Text=str;
}
//显示展示图
private string imgs(string id)
{
string sql="select picpath from MERCHANDISEPIC where MERCHANDISEID="+Convert.ToInt32(id)+" order by id desc";
ds=myData.GetDataSet(sql,0,0,"img");
string a="";
if(ds.Tables["img"].Rows.Count>0)
a=ds.Tables["img"].Rows[0][0].ToString();
return a;
}
//加载产品列表(国内不可见)
private void load_pro2()
{
int pageid = 1;string str="";
if(ot.isDefined("pageid"))
pageid=Convert.ToInt32(Request["pageid"].ToString().Trim());
int pagesize = 6;//每页显示数
int endpage = pagesize;
if(ot.isDefined("endpage"))
endpage=Convert.ToInt32(Request["endpage"].ToString().Trim());
int pagesum=0;//总共有多少页
int pagenum = 0;//当然第几页
string flog="",sql ="";
if(ot.isDefined("flog"))
flog=Request.QueryString["flog"].ToString().Trim();
if(flog=="hot")
sql = "SELECT id,MERCHANDISE FROM (SELECT TOP " + endpage + " * FROM (SELECT TOP " + pagesize * pageid + " * FROM BU_MERCHANDISE where ISAVAILABILITY=1 and ISOPEN=0 ORDER BY BROWSEDEGREE desc) AS mytbl ORDER BY BROWSEDEGREE asc) AS tblme ORDER BY BROWSEDEGREE desc";
else
sql = "SELECT id,MERCHANDISE FROM (SELECT TOP " + endpage + " * FROM (SELECT TOP " + pagesize * pageid + " * FROM BU_MERCHANDISE where ISAVAILABILITY=1 and ISOPEN=0 ORDER BY ID desc) AS mytbl ORDER BY ID asc) AS tblme ORDER BY ID desc";
ds=myData.GetDataSet(sql,0,pagesize,"ds");
str+="<table width=94% border=0 cellspacing=0 cellpadding=0><tr><td> </td></tr><tr><td height=469 align=center valign=top class=wenzi1>";
str+="<table width=98% border=0 cellspacing=0 cellpadding=0 id=table2><tr>";
int i=0;
if( ds.Tables[0].Rows.Count>0)
foreach(DataRow dr in ds.Tables[0].Rows)
{
++i;
str+="<td width=50% height=32 align=center><table border=0 width=100% id=table3 cellspacing=0 cellpadding=0><tr><td width=215 height=134 align=center valign=middle><a href=productmore.aspx?id="+dr[0].ToString()+"><img src="+imgs(dr[0].ToString())+" width=210 height=130 border=0></a></td></tr><tr><td height=28 width=50% align=center class=wenzi1> <p align=center><span class=linkc><a href=productmore.aspx?id="+dr[0].ToString()+"><strong>"+dr[1].ToString()+"</strong></a></span></td></tr></table></td>";
if(i%2==0 )
{
str+="</tr></table>";
str+="<table width=98% border=0 cellspacing=0 cellpadding=0 id=table2><tr>";
}
}
str+=" </tr></table> </td></tr></table>";
sql = "SELECT COUNT(ID) as counts FROM BU_MERCHANDISE where ISAVAILABILITY=1 and ISOPEN=0 ";
ds = myData.GetDataSet(sql,0,0,"aa");
pagenum = Convert.ToInt32( ds.Tables[0].Rows[0]["counts"]);
if((pagenum%pagesize)==0)
{
pagesum = pagenum / pagesize;
}
else
{
pagesum = pagenum / pagesize + 1;
}
if (pageid == pagesum - 1) endpage = pagenum % pagesize;
str += "<table border=0 width=100% id=table1><tr><td height='34' colspan='5' align='center'>共有" + pagenum + "个，" + pageid + "/" + pagesum + "页 ";
if (pageid >1)
{
str += "<a href=\"?flog="+flog+"&pageid=1&endpage="+pagesize+"\">[第一页]</a><a href=\"?flog="+flog+"&pageid="+(pageid-1)+"&endpage="+pagesize+"\">[上一页]</a>";
}
if (pageid < pagesum)
{
str += "<a href=\"?flog="+flog+"&pageid="+(pageid+1)+"&endpage="+endpage+"\">[下一页]</a><a href=\"?flog="+flog+"&pageid="+pagesum+"&endpage="+(pagenum % pagesize)+"\">[第末页]</a>";
}
str += "</td></tr></table>";
this.Label1.Text=str;
}
//加载最新产品
private void load_new(bool look)
{string str="<table width=100% border=0 cellspacing=0 cellpadding=0>";
string sql="";
if(look)
sql = "SELECT id,MERCHANDISE FROM BU_MERCHANDISE where ISOPEN=0 ORDER BY ID desc";
else
sql = "SELECT id,MERCHANDISE FROM BU_MERCHANDISE ORDER BY ID desc";
ds=myData.GetDataSet(sql,0,5,"cc");
if(ds.Tables[0].Rows.Count>0)
foreach(DataRow dr in ds.Tables[0].Rows)
{
str+="<tr><td height=23 bgcolor=#D3D3D3 align=left class=wenzi1> :: <span class=linkc><a href=productmore.aspx?id="+dr[0].ToString()+">>"+dr[1].ToString()+"</a></span></td> </tr><tr><td height=1></td></tr>";
}
str+="</table>";
this.Label2.Text=str;
}
//加载最热产品
private void load_hot(bool look)
{
string str="<table width=100% border=0 cellspacing=0 cellpadding=0>";
string sql="";
if(look)
sql = "SELECT id,MERCHANDISE FROM BU_MERCHANDISE where ISOPEN=0 ORDER BY BROWSEDEGREE desc";
else
sql = "SELECT id,MERCHANDISE FROM BU_MERCHANDISE ORDER BY BROWSEDEGREE desc";
ds=myData.GetDataSet(sql,0,6,"cc");
if(ds.Tables[0].Rows.Count>0)
foreach(DataRow dr in ds.Tables[0].Rows)
{
str+="<tr><td height=23 bgcolor=#D3D3D3 align=left class=wenzi1> :: <span class=linkc><a href=productmore.aspx?id="+dr[0].ToString()+">>"+dr[1].ToString()+"</a></span></td> </tr><tr><td height=1></td></tr>";
}
str+="</table>";
this.Label3.Text=str;
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -