adminarticlelist.aspx.cs

来自「中国海洋大学211工程网站的全部源码」· CS 代码 · 共 162 行

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>
	/// AdminArticleList 的摘要说明。
	/// </summary>
	public partial class AdminArticleList : 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)
			{
				BindClass();
				BindPage();
				BindArt();
			}

			Button1.Attributes["onclick"]="return confirm('你确定要删除它们？？')";
		}

		private void BindClass()
		{
			c.DataSource=TableQuery.ClassQuery();
			c.DataTextField="ClassName";
			c.DataValueField="ClassId";
			c.DataBind();
		}

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

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

			p.Items.Clear();

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

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

			art.DataSource=TableQuery.ArticleQuery(pagesize,page,c.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 p_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			BindArt();
		}

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

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

			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(CreateClass cc=new CreateClass(Convert.ToInt32(c.SelectedValue)))
			{
				cc.Add();
			}

			DataTable dt=TableQuery.ItemQuery(c.SelectedValue);
			for(int i=0;i<dt.Rows.Count;i++)
			{
				int pagecount=0;
				int temp=(int)DBQuery.ExecuteScalar("select count(ArticleId) from [Article] where Article.ItemId="+dt.Rows[i][0].ToString());
				if(temp%pagesize==0)pagecount=temp/pagesize-1;
				else pagecount=temp/pagesize;
				FileInfo fi=new FileInfo(Request.ServerVariables["APPL_PHYSICAL_PATH"].ToString()+"Item_"+dt.Rows[i][0].ToString()+"_"+(pagecount+1)+".htm");
				if(fi.Exists)fi.Delete();

				using(CreateItem ci=new CreateItem(Convert.ToInt32(dt.Rows[i][0].ToString())))
				{
					ci.Add();
				}
			}

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

			BindArt();
		}
	}
}