waring.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>
	/// waring 的摘要说明。
	/// </summary>
	public class waring : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label2;
	
		protected CData myData=new CData();
		protected DataSet ds=new DataSet();
		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;
					}
				}
		
			
			load_new(look);
			load_hot(look);
		}
		//加载最新产品
		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,8,"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>&nbsp;&nbsp;&nbsp;&nbsp;::&nbsp;&nbsp;&nbsp;&nbsp;<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,8,"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>&nbsp;&nbsp;&nbsp;&nbsp;::&nbsp;&nbsp;&nbsp;&nbsp;<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
	}
}