using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
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 System.Text.RegularExpressions;
using System.Text;


namespace Web
{
	/// <summary>
	/// WebForm1 的摘要說明。
	/// </summary>
	public class BBS : System.Web.UI.Page
	{
		protected System.Web.UI.HtmlControls.HtmlForm Form1;		
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.DropDownList dlPage;
		protected System.Web.UI.WebControls.Repeater repView;
		protected System.Web.UI.WebControls.Button firstPage;
		protected System.Web.UI.WebControls.Button previousPage;
		protected System.Web.UI.WebControls.Button nextPage;
		protected System.Web.UI.WebControls.Button lastPage;
		protected System.Web.UI.WebControls.Table tblMain;

        protected System.Web.UI.WebControls.DropDownList dlPicSelect;    
        protected System.Web.UI.WebControls.Image imghead;
        protected System.Web.UI.WebControls.TextBox txtname;
        protected System.Web.UI.WebControls.TextBox txtqq;
        protected System.Web.UI.WebControls.TextBox txthttp;
        protected System.Web.UI.WebControls.TextBox content;
        protected System.Web.UI.WebControls.TextBox txtaddr;
        protected System.Web.UI.WebControls.TextBox txtemail;
        protected System.Web.UI.WebControls.Button btnsend;
        protected System.Web.UI.WebControls.Button btnreset;

		private Web.DataAccess.DataAccess Das = new DataAccess.DataAccess();
		int iPageSize=10;
		public string strUserName;

		private void dbinit()
		{
			DataSet myDataSet=new DataSet();
			myDataSet = Das.GetDataSet("select * from BBS order by PostDate desc");

			repView.DataSource=myDataSet.Tables[0];		
			repView.DataBind();
			int i,j;
			i = myDataSet.Tables[0].Rows.Count;
            ViewState["RecordCount"]=i;
		    j = i;			
            i = i / iPageSize;
						
            if (j % iPageSize != 0) 
				i = i + 1;
			dlPage.Items.Clear();
			for (j=1;j<=i;j++)
			{
                  dlPage.Items.Add (j.ToString());
			}
		}

		private void db()
		{
			int i,j;
			i=0;
			j=0;
			if(dlPage.SelectedIndex > 0)
				i=dlPage.SelectedIndex * iPageSize;
			j=(int)ViewState["RecordCount"];
			OleDbConnection mycn=Das.GetConnect();
			OleDbDataAdapter myDataAdapter=new OleDbDataAdapter("select  * from BBS order by PostDate desc",mycn );
			DataSet myDataSet=new DataSet();
			if ((i + iPageSize) > j)             
				myDataAdapter.Fill(myDataSet,i,j-i,"BBS");
			else
				myDataAdapter.Fill(myDataSet,i,iPageSize,"BBS");
			repView.DataSource=myDataSet.Tables["BBS"];
			repView.DataBind();          
		}

		private void Page_Load(object sender, System.EventArgs e)
		{
			if (!Page.IsPostBack)
			{
				dbinit();
			}
			strUserName = Session["UserName"].ToString();
		}

		private void firstPage_Click(object sender,System.EventArgs e)
		{
			dlPage.SelectedIndex=0;           	
			db();
		}

		private void previousPage_Click(object sender,System.EventArgs e)
		{
           int i;
           i=dlPage.SelectedIndex;
			if (i>0)
			{
				dlPage.SelectedIndex=i-1;                
				db();

			}
			
               
		}
		private void nextPage_Click(object sender,System.EventArgs e)
		{
           int i;
			i=dlPage.SelectedIndex;
			if (i<(dlPage.Items.Count-1))
			{
               dlPage.SelectedIndex=i+1;
				db();
			}
		}

		private void lastPage_Click(object sender,System.EventArgs e)
		{
			dlPage.SelectedIndex=dlPage.Items.Count-1;			
			db();
		}
		private void dlPage_SelectedIndexChanged(object sender,System.EventArgs e)
		{
            int i;
			i=dlPage.SelectedIndex+1;			
			db();
		}

		private void btnreset_Click(object sender,System.EventArgs e )
		{
			
			ClearContent();
            db();
		}

		private void btnsend_Click(object sender,System.EventArgs e )
		{

            string strSql ;
            string  stxtname;
            string  stxtcontent;
			

            stxtname = strUserName;
            stxtcontent = HTMLEncode(content.Text);
			
            strSql = "insert into BBS values (";            
            strSql = strSql + "'" + stxtcontent.Replace("'", "''") + "',";
			strSql = strSql + "'" + stxtname.Replace("'", "''") + "',";						
            strSql = strSql + "'" + DateTime.Now.ToString() + "')";

			if(Das.ExecSql(strSql))
			{
				Response.Write("<script language='javascript'>alert('保存成功！');</script>");
			}
			db();
		}

		private string HTMLEncode(string str)
		{
			            
			str = str.Replace(">", "&gt;");
			
            str = str.Replace("<", "&lt;");
			char ch;
			ch=(char)32;
            str = str.Replace(ch.ToString(), "&nbsp;");
			ch=(char)34;
            str = str.Replace(ch.ToString(), "&quot;");
			ch=(char)39;
            str = str.Replace(ch.ToString(), "&#39;");
			ch=(char)13;
            str = str.Replace(ch.ToString(), "");
			ch=(char)10;
            str = str.Replace(ch.ToString(), "<BR> ");

            return str;

		}

		private void ClearContent()
		{
			content.Text="";

		}

		public string  getip(string ip) 
		{  
          string[] ips=new string[4];
		  ips=ip.Split('.');
          return ips[0]+"."+ips[1]+".*.*";

		}

		private void rw(string str)
		{
			Response.Write (str);
		}

//		this.firstPage.Click += new System.EventHandler(this.firstPage_Click);
//		this.previousPage.Click += new System.EventHandler(this.previousPage_Click);
//		this.nextPage.Click += new System.EventHandler(this.nextPage_Click);
//		this.lastPage.Click += new System.EventHandler(this.lastPage_Click);
//		this.dlPage.SelectedIndexChanged += new System.EventHandler(this.dlPage_SelectedIndexChanged);
//		this.Load += new System.EventHandler(this.Page_Load);
//		this.btnsend.Click +=new System.EventHandler(this.btnsend_Click);
//		this.btnreset.Click +=new System.EventHandler(this.btnreset_Click);
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{    
					this.firstPage.Click += new System.EventHandler(this.firstPage_Click);
					this.previousPage.Click += new System.EventHandler(this.previousPage_Click);
					this.nextPage.Click += new System.EventHandler(this.nextPage_Click);
					this.lastPage.Click += new System.EventHandler(this.lastPage_Click);
					this.dlPage.SelectedIndexChanged += new System.EventHandler(this.dlPage_SelectedIndexChanged);
					this.Load += new System.EventHandler(this.Page_Load);
					this.btnsend.Click +=new System.EventHandler(this.btnsend_Click);
					this.btnreset.Click +=new System.EventHandler(this.btnreset_Click);

		}
		#endregion

		
	}
}