keywordadmin.ascx.cs

这是我编的一小软件。请等级等待指教。呵呵。ASP的

namespace Seaskyer.WebApp.skyNews.Pages.UserMSC
{
	using System;
	using System.Collections;
	using System.Data;
	using System.Drawing;
	using System.Web;
	using System.Web.UI;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;
	using Seaskyer.Strings;

	/// <summary>
	///		KeywordAdmin : 管理站内关键词。
	/// </summary>
	public class KeywordAdmin : basePage
	{
		protected DataGrid DataGrid1;
		protected Label searchLabel, label1 ,pageLabel;
		protected Button delBtn;

		private void Page_Load(object sender, System.EventArgs e)
		{
			if( !power.GPB("Admin") )
			{
				base.strError.Add(lang["sharePage", "denyViewErrorInfo"]);
				return;
			}

			this.InitPage();

			if( !Page.IsPostBack )
			{
				this.BindData();
			}
		}

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

		}

		/// <summary>
		/// 页面起始时的初始化操作
		/// </summary>
		private void InitPage()
		{
			label1.Visible			= false;
			DataGrid1.Visible		= false;
			pageLabel.Visible		= false;
		}
		#endregion


		void BindData()
		{
			if( Object.Equals(Request.QueryString["type"], null)  || Object.Equals(Request.QueryString["type"], "") )
			{
				// 非搜索页面数据绑定
				this.GridBind();
			}
			else
			{
				// 搜索页面数据绑定
				this.SearchGridBind();
			}
		}

		#region 绑定数据
		void GridBind()
		{
			dp.CommandText = cmd["aKey", "COUNT"];
			bind.totalRecord = dp.ScalarSQL();

			if( bind.totalRecord == 0 )
			{
				label1.Text = "还没有添加任何关键字"; label1.ForeColor = Color.Red;
				label1.Visible = true;
			}
			else
			{
				dp.CommandText = cmd["aKey", "SELECT"];
				bind.BindInfo_SplitPageDataGrid(DataGrid1, dp, "");

				pageLabel.Text			= base.GetSplitPageString("/skyNews/UserMSC/KeywordAdmin.aspx?");
				pageLabel.Visible	= true;
			}

		}
		#endregion

		#region 去掉DataGrid1的EnableViewState属性，减少发向客户端的数据
		protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
		{
			//DataGrid1.Controls[0].EnableViewState = false;
		}
		#endregion

		#region 响应删除事件
		protected void Delete_OnClick(object sender, EventArgs e)
		{
			

			
			if( Object.Equals(Request.Form["chk"], null) || Object.Equals(Request.Form["chk"], "") )
			{
				label1.Text = "请先选中要删除的记录(可多选)"; label1.ForeColor = Color.Red;
				DataGrid1.Visible		= true;
			}
			else
			{
				dp.CommandText = String.Format(cmd["aKey", "DELETE"], Request.Form["chk"].ToString());
				int delNum = dp.NonQuerySQL();
				if( delNum > 0)
				{
					label1.Text = delNum + "条记录删除成功！"; label1.ForeColor = Color.BlueViolet;
					this.BindData();
				}
				else
				{
					label1.Text = "删除失败 ..."; label1.ForeColor = Color.Red;
					DataGrid1.Visible		= true;
				}
			}
			label1.Visible = true;

		}
		#endregion

		#region 初始化DataGrid中子控件的属性
		protected void DataGrid1_ItemCreated(object sender, DataGridItemEventArgs e)
		{
			if(e.Item.ItemIndex >= 0)
			{
				e.Item.Attributes.Add("onmouseover","this.className='tdbg-dark';");
				e.Item.Attributes.Add("onmouseout","this.className='tdbg';");
			}
		}
		#endregion

		#region 响应搜索事件
		void SearchGridBind()
		{
			if( !Object.Equals(Request.QueryString["key"], null) && !Object.Equals(Request.QueryString["key"], "") )
			{
				searchLabel.Text	= "搜索 &nbsp; <font color=red>" + Request.QueryString["key"] + "</font>";
				searchLabel.Visible = true;
			}

//			strCmd = String.Format(user.GetCommand("aKey_SELECT_SEARCH"), Request.QueryString["type"], Request.QueryString["key"]);
//			Hashtable ht = dp.SplitPageInfo(strCmd, base.PageIndex, base.PageSize);
//			base.totalRecord	= int.Parse(ht["totalRecord"].ToString());
//			base.pageNum		= int.Parse(ht["pageNum"].ToString());
//			base.indexSTR		= ht["indexStrs"].ToString();
//			ht.Clear();
//
//			if( !Object.Equals(base.indexSTR , "") )
//			{
//				strCmd = String.Format(user.GetCommand("aKey_SELECT_STR"), base.indexSTR);
//				DataTable Dt = dp.DataTableSQL(strCmd);
//
//				DataGrid1.DataSource	= Dt.DefaultView;
//				DataGrid1.DataBind();
//				DataGrid1.Visible		= true;
//				pageLabel.Text			= 
//					String.Format( user.GetAppInfo("splitPageInfo", "sharePage"), 
//					base.PageIndex, 
//					base.pageNum, 
//					base.PageSize, 
//					base.totalRecord, 
//					user.SplitPages(base.basePath + base.Parame + "=MSC^KeywordAdmin&type=" + Request.QueryString["type"] + "&key=" + Request.QueryString["key"] + "&", base.PageIndex, base.pageNum, base.totalRecord )
//					);
//				pageLabel.Visible		= true;
//				delBtn.Visible			= true;
//			}
//			else
//			{
//				label1.Text = "您搜索的内容不存在"; label1.ForeColor = Color.Red;
//				label1.Visible = true;
//			}
		}
		#endregion
	}
}