using System;
using System.IO;
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;

namespace _211
{
	/// <summary>
	/// AdminSimpleList 的摘要說明。
	/// </summary>
	public partial class AdminSimpleList : System.Web.UI.Page
	{
		private int pagesize=10;
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			if(Session["name"]==null)
			{
				Response.Write("<script>top.location='AdminLogin.aspx'</script>");
				return;
			}

			if(!Page.IsPostBack)
			{
				BindItem();
				BindPage();
				BindArt();
			}

			Button1.Attributes["onclick"]="return confirm('你確定要刪除它們？？')";
		}

		private void BindItem()
		{
			i.DataSource=TableQuery.ItemQuery("0");
			i.DataTextField="ItemName";
			i.DataValueField="ItemId";
			i.DataBind();
		}

		private void BindPage()
		{
			if(i.SelectedItem==null)return;

			int pagecount=0;
			int temp=(int)DBQuery.ExecuteScalar("select count(ArticleId) from [Article] where Article.ItemId="+i.SelectedValue);
			if(temp%pagesize==0)pagecount=temp/pagesize-1;
			else pagecount=temp/pagesize;

			p.Items.Clear();

			for(int ii=0;ii<=pagecount;ii++)
			{
				p.Items.Add(new ListItem("第"+(ii+1)+"頁",ii.ToString()));
			}
		}

		private void BindArt()
		{
			int page;
			if(p.SelectedItem!=null)page=Convert.ToInt32(p.SelectedValue);
			else page=0;

			art.DataSource=TableQuery.ArticleSimpleQuery(pagesize,page,i.SelectedValue);
			art.DataBind();
		}

		#region Web 窗體設計器生成的代碼
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion

		protected void i_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			BindPage();
			BindArt();
		}

		protected void p_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			BindArt();
		}

		protected void Button1_Click(object sender, System.EventArgs e)
		{
			int page=Convert.ToInt32(p.SelectedValue);
			int pc=p.Items.Count;

			CheckBox cb;
			for(int i=0;i<art.Items.Count;i++)
			{
				cb=(CheckBox)art.Items[i].FindControl("CheckBox1");
				if(cb.Checked)
				{
					try
					{
						FileInfo fi=new FileInfo(Request.ServerVariables["APPL_PHYSICAL_PATH"].ToString()+art.DataKeys[i].ToString()+".htm");
						if(fi.Exists)fi.Delete();
							
						DBQuery.ExceuteNonQuery("delete from [Article] where ArticleId="+art.DataKeys[i].ToString());
					}
					catch(Exception ex)
					{
						Response.Write("<script>alert(\""+ex.Message.ToString()+"\");</script>");
					}
				}
			}

			BindPage();

			using(CreateItem ci=new CreateItem(Convert.ToInt32(i.SelectedValue)))
			{
				ci.Add();
			}

			if(pc!=p.Items.Count)
			{
				FileInfo fi=new FileInfo(Request.ServerVariables["APPL_PHYSICAL_PATH"].ToString()+"Item_"+i.SelectedValue+"_"+(pc-1)+".htm");
				if(fi.Exists)fi.Delete();
			}

			using(CreateIndexPage cip=new CreateIndexPage())
			{
				cip.Add();
			}

			if((p.Items.Count-1)<page)
			{
				p.SelectedValue=Convert.ToString(page-1);
			}
			else p.SelectedValue=page.ToString();

			BindArt();
		}
	}
}