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 System.Data.OleDb;


namespace txl
{
	/// <summary>
	/// lockmsg 的摘要說明。
	/// </summary>
	public class lockmsg : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataList dltBoard;
		protected System.Web.UI.WebControls.Button btnOK;
		protected System.Web.UI.WebControls.Button btnReturn;
		OleDbConnection cn;
		OleDbCommand cmd;
		OleDbDataReader dr;
		OleDbDataAdapter da;
		DataSet ds;
		string strConn,strSQL;
		public string strClid;
		int i;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此處放置用戶代碼以初始化頁面]
			if(Session.Count==0) Page.Response.Redirect("default.aspx");
			else 
				if(Session["uid"].ToString()=="") Page.Response.Redirect("default.aspx");
			
			strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("txl.aspx");
			cn=new OleDbConnection(strConn);
			cn.Open();

			strSQL="select b_uid,cl_m1,cl_m2,b_clid from board,classinfo where cl_id=(select b_clid from board where b_id="+Page.Request["msgid"].ToString()+") and b_id="+Page.Request["msgid"].ToString();
			cmd=new OleDbCommand(strSQL,cn);
			dr=cmd.ExecuteReader();
			while(dr.Read())
				if(!(Session["uid"].ToString()==dr[0].ToString()|Session["uid"].ToString()==dr[1].ToString()|Session["uid"].ToString()==dr[2].ToString()))
				{
					strClid=dr["b_clid"].ToString();
					dr.Close();
					cn.Close();
					Page.Response.Redirect("board.aspx?clid="+strClid);					
				}
			dr.Close();
			


			strSQL="select b_theme,b_uid,b_date,b_clid,b_cnt from board where b_id="+Page.Request["msgid"].ToString();
			
			da=new OleDbDataAdapter(strSQL,cn);
			ds=new DataSet();
			da.Fill(ds,"msg");
			strClid=ds.Tables["msg"].Rows[0]["b_clid"].ToString();// 取出所屬于班級id，以便返回
			
			ds.Tables["msg"].Columns.Add("name");

			for(i=0;i<ds.Tables[0].Rows.Count;i++)
			{
				strSQL="select u_name from userinfo where u_id="+ds.Tables[0].Rows[i]["b_uid"].ToString();
				cmd=new OleDbCommand(strSQL,cn);
				dr=cmd.ExecuteReader();
				while(dr.Read())
					ds.Tables[0].Rows[i]["name"]=dr[0].ToString();
				cmd.Dispose();
				dr.Close();
			}

			
			dltBoard.DataSource=ds.Tables["msg"].DefaultView;
			dltBoard.DataBind();
			ds.Dispose();
			cn.Close();
		}

		#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.btnOK.Click += new System.EventHandler(this.btnOK_Click);
			this.btnReturn.Click += new System.EventHandler(this.btnReturn_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnOK_Click(object sender, System.EventArgs e)
		{
			strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("txl.aspx");
			strSQL="Update board SET b_top='0' where b_id="+Page.Request["msgid"].ToString();
			cn=new OleDbConnection(strConn);
			cn.Open();
			cmd=new OleDbCommand(strSQL,cn);
			cmd.ExecuteNonQuery();
			cmd.Dispose();
			cn.Close();
			//Page.Response.Write("123456486789hkhkhkjhjhgcf"+strClid);
			Page.Response.Redirect("board.aspx?clid="+strClid);
		
		}

		private void btnReturn_Click(object sender, System.EventArgs e)
		{
			Page.Response.Redirect("board.aspx?clid="+strClid);
		}
	}
}