bbs.aspx.cs

asp做的新闻系统

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;

namespace Web.Admin
{
	/// <summary>
	/// BBS 的摘要说明。
	/// </summary>
	public class BBS : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Panel Panel2;
		protected System.Web.UI.WebControls.ImageButton Imagebutton1;
		protected System.Web.UI.WebControls.TextBox Textbox7;
		protected System.Web.UI.HtmlControls.HtmlTable Table1;

		protected System.Web.UI.WebControls.DataGrid GrdBBS;
		protected System.Web.UI.WebControls.Label LabRowCount;
		protected System.Web.UI.WebControls.Label LabRowID;
		protected System.Web.UI.WebControls.Label LabID;
		protected System.Web.UI.WebControls.Button BtnDel;

		private DataSet OleDs;
		private Web.DataAccess.DataAccess Das = new DataAccess.DataAccess();
	
		const int nGrdRows = 10;
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)
			{ 
				BindGrdBBS();
			}

			GrdBBS.Attributes.Add("onclick","javascript:Click('GrdBBS');");
			BtnDel.Attributes.Add("OnClick","javascript:return Del('GrdBBS');");
		}

		//刷新GrdBBS
		private void BindGrdBBS()
		{

			OleDs = new DataSet();

			OleDs=Das.GetDataSet("select bbsid,substring(content,0,50) content,username,postdate from bbs");
			GrdBBS.DataSource=OleDs;
			
			int nPage=0;
			nPage = GrdBBS.CurrentPageIndex;
			GrdBBS.CurrentPageIndex = 0;
			GrdBBS.DataBind();

			if ((nPage >= GrdBBS.PageCount) && (GrdBBS.PageCount > 0))
			{
				nPage = GrdBBS.PageCount - 1;
			}
			
			LabRowCount.Text=OleDs.Tables[0].Rows.Count.ToString();

			GrdBBS.CurrentPageIndex = nPage;
			GrdBBS.DataBind();
		}

		//检查用户选择DataGrid中记录的总数，返回DG中单选的记录号，多选的记录号保存LabDeptID中。
		private int CheckCbx()
		{
			int nRow = -1;
			LabID.Text = "";
			for (int i = 0;i < GrdBBS.Items.Count;i++)
			{
				CheckBox CbxTable = (CheckBox)GrdBBS.Items[i].FindControl("CbxSelect");
				if(CbxTable.Checked == true)
				{
					if(LabID.Text == "")
					{
						LabID.Text = GrdBBS.Items[i].Cells[4].Text.Trim();
						nRow = i;
					}
					else
					{
						LabID.Text = LabID.Text + "," + GrdBBS.Items[i].Cells[4].Text.Trim();
					}
				}
			}
			return nRow;
		}

		//返回当前选中的记录行数。
		private int GetRow()
		{
			int nRow,nPage;
			nPage = GrdBBS.CurrentPageIndex;
			nRow = nPage * nGrdRows + CheckCbx() + 1;
			return nRow;
		}

		//换页
		private void GrdBBS_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			GrdBBS.CurrentPageIndex = e.NewPageIndex;
			BindGrdBBS();
		}

		//排序
		private void GrdBBS_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
		{
			DataView dv = new DataView();
			BindGrdBBS();
			dv.Table = OleDs.Tables[0];
			dv.Sort = e.SortExpression;
			GrdBBS.DataSource = dv;
			GrdBBS.DataBind();
			GrdBBS.EditItemIndex = -1;
			GrdBBS.SelectedIndex = 0;
		}

		//删除信息
		private void BtnDel_Click(object sender, System.EventArgs e)
		{
			int nRow = 0;
			string strTableID,strSql;

			nRow = CheckCbx();
			strTableID = LabID.Text.Trim();

			strSql = "delete from bbs where bbsid in(" + strTableID + ")";

			if (Das.ExecSql(strSql))
			{
				Response.Write("<script>alert('删除成功！');</script>");
				BindGrdBBS();
			}
			else
			{
				Response.Write("<script>alert('删除不成功,请稍后再试！');</script>");
			}
		}
		#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.BtnDel.Click += new System.EventHandler(this.BtnDel_Click);
			this.GrdBBS.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.GrdBBS_PageIndexChanged);
			this.GrdBBS.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.GrdBBS_SortCommand);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

	}
}