feedback.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;
using System.Net;                     // network stuff

namespace Websystem
{
	/// <summary>
	/// feedback 的摘要说明。
	/// </summary>
	public class feedback : System.Web.UI.Page
	{	protected user us=new user();
		protected messages mes=new messages();
		protected System.Web.UI.WebControls.LinkButton btnLast1;
		protected System.Web.UI.WebControls.LinkButton btnNext1;
		protected System.Web.UI.WebControls.LinkButton btnPrev1;
		protected System.Web.UI.WebControls.LinkButton btnFirst1;
		protected System.Web.UI.WebControls.Label lblCurrentIndex;
		protected System.Web.UI.WebControls.Label lblPageCount;
		protected System.Web.UI.WebControls.DataGrid MyDataGrid;
		protected System.Web.UI.WebControls.Label message;
		protected System.Web.UI.HtmlControls.HtmlInputText Zip;
		protected System.Web.UI.HtmlControls.HtmlTextArea content;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit1;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label2;

	
protected string gourl="msg.aspx";

		private void Page_Load(object sender, System.EventArgs e)
		{
			btnFirst1.Text = "First";
			btnPrev1.Text = "Prev";
			btnNext1.Text = "Next";
			btnLast1.Text = "Last";
			BindGrid();
			CData myData=new CData();
			DataSet ds=new DataSet();
			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);

		}

		#region ＤＡＴＡＧＲＩＤ数据显示
		protected void BindGrid()
		{
			DataSet ds=new DataSet();
			CData myData=new CData();
			string sql = "";
			sql = "select * from MESSAGE order by id desc";
			ds = myData.GetDataSet(sql, 0, 0, "Document");
			this.MyDataGrid.DataSource = ds.Tables["Document"].DefaultView;
			MyDataGrid.DataBind();
			ShowStats();

		}
		public void MyDataGrid_Page(object sender, DataGridPageChangedEventArgs e)
		{
			int startIndex ;
			startIndex = MyDataGrid.CurrentPageIndex * MyDataGrid.PageSize;
			MyDataGrid.CurrentPageIndex = e.NewPageIndex;
			BindGrid();
			ShowStats();
		}


		private void ShowStats()
		{
	//		lblCurrentIndex.Text = "第 " + (MyDataGrid.CurrentPageIndex + 1).ToString() + " 页";
			lblPageCount.Text = "Page: " +(MyDataGrid.CurrentPageIndex + 1).ToString()+" / "+MyDataGrid.PageCount.ToString() + " ";
		}


		private void MyDataGrid_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}
		public void PagerButtonClick(object sender, EventArgs e)
		{
			string arg = ((LinkButton)sender).CommandArgument.ToString();
			switch(arg)
			{
				case "next":
					if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
					{
						MyDataGrid.CurrentPageIndex += 1;
					}
					break;
				case "prev":
					if (MyDataGrid.CurrentPageIndex > 0)
					{
						MyDataGrid.CurrentPageIndex -= 1;
					}
					break;
				case "last":
					MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
					break;
				default:
					MyDataGrid.CurrentPageIndex = System.Convert.ToInt32(arg);
					break;
			}
			BindGrid();
			ShowStats();
		}

		#endregion

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Submit1.ServerClick += new System.EventHandler(this.Submit1_ServerClick);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
		//加载最新产品
		private void load_new(bool look)
		{
				CData myData=new CData();
			DataSet ds=new DataSet();
			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)
		{
				CData myData=new CData();
			DataSet ds=new DataSet();
			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;


		}
		private string lookip()
		{

			string hostname = Dns.GetHostName();
			Console.WriteLine("hostname = {0}", hostname);

			// 显示每个IP地址
			IPHostEntry hostent = Dns.GetHostByName(hostname); // 主机信息
			Array addrs = hostent.AddressList;            // IP地址数组
			IEnumerator it = addrs.GetEnumerator();       // 迭代器
			string a="";
			while(it.MoveNext()) 
			{                     // 循环到下一个IP 地址
				IPAddress ip = (IPAddress)it.Current;      // 获得 IP 地址
//				Console.WriteLine("Address: {0}", ip);     // 显示 IP地址
				a=Convert.ToString( ip);
			}
return a;

		}
/// <summary>
/// 增加提问
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void Submit1_ServerClick(object sender, System.EventArgs e)
		{
			DataSet ds=new DataSet();
			CData myData=new CData();
			string sql = "";
		string str="";
			string subject=Request.Form["subject"].ToString().Trim().Replace("'","＇");
			string Company=Request.Form["company"].ToString().Trim().Replace("'","＇");
			string Name=Request.Form["name"].ToString().Trim().Replace("'","＇");
			string mail=Request.Form["mail"].ToString().Trim().Replace("'","＇");
			string Tel=Request.Form["tel"].ToString().Trim().Replace("'","＇");
			string Fax=Request.Form["fax"].ToString().Trim().Replace("'","＇");
			string Country=Request.Form["Country"].ToString().Trim().Replace("'","＇");
			string Address=Request.Form["Address"].ToString().Trim().Replace("'","＇");
			string Zip=Request.Form["Zip"].ToString().Trim().Replace("'","＇");
			string content=Request.Form["content"].ToString().Trim().Replace("'","＇");

			if(subject=="")str+=" [Subject] ";
				if(Company=="")str+=" [Company] ";
				if(Name=="")str+=" [Name] ";
				if(mail=="")str+=" [mail] ";
				if(Tel=="")str+=" [Tel] ";
				if(Address=="")str+=" [Address] ";
			if(str=="")

			{
				sql="insert into MESSAGE (title,content,inputtime,user_name,user_IP,user_EMAIL,USER_TEL,Company,Fax,Country,Zip,Address) ";
				sql+="values ('"+subject+"','"+content+"','"+System.DateTime.Now+"','"+Name+"','"+lookip()+"','"+mail+"','"+Tel+"','"+Company+"','"+Fax+"','"+Country+"','"+Zip+"','"+Address+"')";
myData.GetExecuteNonQuery(sql);
				Response.Redirect(gourl+"?url=feedback.aspx&message=send ok！");



			}
			else

				str+="不能为空";
this.message.Text="你的"+str;

		}
	}
}