admin_manageaffiche.aspx.cs

网上自动答疑系统(C#)

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.Text;

namespace dayi
{
	/// <summary>
	/// admin_manageAffiche 的摘要说明。
	/// </summary>
	public class admin_manageAffiche : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblAfficheList;
		protected System.Web.UI.WebControls.Button btnDelete;
		dayi.controlDatabase cd=new controlDatabase();

		private string showAffiche(int curPage,int pageCount)
		{
			try
			{
				//显示公告列表
				StringBuilder returnValue=new StringBuilder();

				string image="<img src='images/file.gif'>";
				string viewAffichePage="<a href=showAffiche.aspx?id=";

				if(pageCount<=0)
					pageCount=20;

				
				string sql="select * from [affiche] order by adder asc";
				DataTable dt=cd.getDataTable(sql);

				int totalRecord=dt.Rows.Count;
				int totalPage=(totalRecord+pageCount-1)/pageCount;

				if(curPage<=0)
					curPage=1;
				else if(curPage>totalPage)
					curPage=totalPage;

				if(totalRecord>0)
				{
					returnValue.Append("<table width=\"600\" border=\"0\" cellpadding=\"1\" cellspacing=\"1\" bgcolor=\"#003366\"><tr bgcolor=\"#0066CC\">");
					returnValue.Append("<td><div align=\"center\" class=\"style1\">删除</div></td>");
					returnValue.Append("<td><div align=\"center\" class=\"style1\">公告标题</div></td>");
					returnValue.Append("<td><div align=\"center\" class=\"style1\">添加者</div></td>");
					returnValue.Append("<td><div align=\"center\" class=\"style1\">添加时间</div></td>");
					returnValue.Append("<td><div align=\"center\" class=\"style1\">操作</div></td></tr>");
					//实现分页
					int startLine=(curPage-1)*pageCount;

					DataRow row;
					for(int i=startLine;i<(pageCount+startLine);i++)
					{
						if(i<totalRecord)
						{
							row=dt.Rows[i];
							string manage="<a href=addAffiche.aspx?type=modify&id="+row["id"].ToString()+">修改</a>";

							returnValue.Append("<tr bgcolor=\"#FFFFFF\"><td><div align=\"center\"><INPUT type=\"checkbox\" name=\"chkDelete\" value=\""+row["id"].ToString()+"\"></div></td>");
							returnValue.Append("<td><div align=\"left\">&nbsp;"+image+viewAffichePage+row["id"].ToString()+" target=\"_black\">"+row["subject"].ToString()+"</a></div></td>");
							returnValue.Append("<td><div align=\"center\">"+row["adder"].ToString().Trim()+"</div></td>");
							returnValue.Append("<td><div align=\"center\">"+row["addTime"].ToString().Trim()+"</div></td>");
							returnValue.Append("<td><div align=\"center\">"+manage+"</div></td></tr>");
						}
						else
						{
							break;
						}
					}
					returnValue.Append("</table>");
					if(totalPage>1)
					{
						returnValue.Append(cd.showPageString("<a href=admin_manageAffiche.aspx",curPage,totalPage,pageCount,totalRecord));
					}
					return returnValue.ToString();
				}
				else
				{
					//返回空
					return "";
				}
			}
			catch(Exception)
			{
				Response.Redirect("err.aspx?err=出现错误,可能执行了非法操作");
				return "";
			}
		}

		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!this.IsPostBack)
			{
				if(Session["userType"].ToString()!="admin")
				{
					//确认身份
					Response.Redirect("err.aspx?err=没有权限");
				}
				try
				{
					int page;
					if(Request.QueryString["page"]!=null)
					{
						page=Convert.ToInt32(Request.QueryString["page"]);
					}
					else
					{
						page=1;
					}
					this.lblAfficheList.Text=this.showAffiche(page,20);
					if(this.lblAfficheList.Text.Trim()=="")
					{
						this.btnDelete.Visible=false;
						this.lblAfficheList.Text="没有任何公告";
					}
					else
					{
						this.btnDelete.Visible=true;
					}
				}
				catch(Exception)
				{
					
					Response.Redirect("err.aspx?err=出现错误,可能执行了非法操作");
				}
			}
		}

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

		}
		#endregion

		private void btnDelete_Click(object sender, System.EventArgs e)
		{
			//删除选中公告
			try
			{
				if(Request.Form["chkDelete"]!=null)
				{
					string idList=Request.Form["chkDelete"].ToString();
					string sql="delete from [affiche] where [id] in("+idList+")";
					if(idList.Trim()!="")
					{
						cd.updateDatabase(sql);//删除公告
					}

					int page;
					if(Request.QueryString["page"]!=null)
					{
						page=Convert.ToInt32(Request.QueryString["page"]);
					}
					else
					{
						page=1;
					}
					this.lblAfficheList.Text=this.showAffiche(page,20);
					if(this.lblAfficheList.Text.Trim()=="")
					{
						this.btnDelete.Visible=false;
						this.lblAfficheList.Text="没有任何公告";
					}
					else
					{
						this.btnDelete.Visible=true;
					}
				}

			}
			catch(Exception)
			{
				//Response.Redirect("err.aspx?err="+ee.Message);
			}
		}
	}
}