linksort.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.WebControls;
	using System.Web.UI.HtmlControls;
	using Seaskyer.Strings;

	/// <summary>
	///		LinkSort : 链接分类管理。
	/// </summary>
	public class LinkSort : basePage
	{
		protected Panel Panel1, Panel2;
		protected TextBox SortName;
		protected Label label1, pageLabel;
		protected DataGrid DataGrid1;


		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.BindDataGrid();
			}
		}

		#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()
		{
			Panel1.Visible		= false;
			Panel2.Visible		= false;
			label1.Visible			= false;
			DataGrid1.Visible		= false;
			pageLabel.Visible		= false;
		}
		#endregion


		#region 绑定数据
		/// <summary>
		/// 绑定专题信息数据
		/// </summary>
		void BindDataGrid()
		{
			dp.CommandText = "SELECT COUNT(*) FROM aLinkSort";
			bind.totalRecord = dp.ScalarSQL();

			if( bind.totalRecord == 0 )
			{
				label1.Text			= "还没有添加任何链接分类"; label1.ForeColor = Color.Red;
				label1.Visible		= true;
				DataGrid1.Visible	= false;
			}
			else
			{
				dp.CommandText = Function.ConstructSplitSQL("aLinkSort", "id", bind.PageIndex, bind.PageSize, "*", 1, "");
				bind.BindInfo_DataGrid(DataGrid1, dp, "");
				pageLabel.Text	= base.GetSplitPageString("/skyNews/UserMSC/LinkSort.aspx?");
				pageLabel.Visible	= true;

				if( DataGrid1.CurrentPageIndex > bind.pageNum -1 ) DataGrid1.CurrentPageIndex = bind.pageNum -1;
			}

			Panel1.Visible = true;
		}
		#endregion

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

		#region 处理更新、撤销事件
		// 处理编辑事件。将DataGrid的EditItemIndex属性设为选中数据项的索引，然后重载DataGrid
		protected void DataGrid1_Edit( object sender,DataGridCommandEventArgs e )
		{
			DataGrid1.EditItemIndex = (int)e.Item.ItemIndex;
			BindDataGrid();
		}
    
		// 处理取消更改事件。将DataGrid的EditItemIndex属性设为-1，表示退出编辑状态，然后重载DataGrid
		protected void DataGrid1_Cancel( object sender,DataGridCommandEventArgs e )
		{
			DataGrid1.EditItemIndex = -1;
			BindDataGrid();
		}

		// 处理更新事件
		protected void DataGrid1_Update( object sender,DataGridCommandEventArgs e )
		{
			string linkSortName = ((TextBox)e.Item.Cells[1].Controls[1]).Text;
			int item = (int) DataGrid1.DataKeys[(int)e.Item.ItemIndex];

			dp.CommandText = cmd["aLinkSort", "UPDATE"];
			dp.Parameter.Add("name",	linkSortName);
			dp.Parameter.Add("id",		item);

			if( dp.NonQuerySQL() == 1 )
			{
				label1.Text = "链接分类修改成功！";label1.ForeColor = Color.BlueViolet;
			}
			else
			{
				label1.Text = "链接分类修改失败 ...";label1.ForeColor = Color.Red;
			}
			label1.Visible = true;


			// 退出编辑状态
			DataGrid1.EditItemIndex = -1;
			// 更新DataGrid
			this.BindDataGrid();
		}

		
		#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["aLinkSort", "DELETE"], Request.Form["chk"].ToString());
				int delNum = dp.NonQuerySQL();
				if( delNum > 0)
				{
					label1.Text = delNum + "条记录删除成功！";	label1.ForeColor = Color.BlueViolet;
				}
				else
				{
					label1.Text = "删除失败 ...";				label1.ForeColor = Color.Red;
					DataGrid1.Visible		= true;
				}
			}
			label1.Visible = true;
			BindDataGrid();
		}
		#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';");
			}

			switch(e.Item.ItemType)
			{
				case ListItemType.Item				:
				case ListItemType.AlternatingItem	:
				case ListItemType.EditItem			:
					break;
			}
			e.Item.Cells[0].Visible = true;
		}
		#endregion

		#region 响应添加链接分类事件
		protected void AddLinkSort_OnClick(object sender, EventArgs e)
		{
			string sortName = SortName.Text.Trim();

			
			if( !user.CheckValiable(sortName) )
			{
				label1.Text = "请填写链接分类名称"; label1.ForeColor = Color.Red;
			}
			else
			{
				dp.CommandText = cmd["aLinkSort", "INSERT"];
				dp.Parameter.Add("name",	sortName);

				if( dp.NonQuerySQL() == 1 )
				{
					label1.Text = "链接分类“" + sortName + "”添加成功！";		label1.ForeColor = Color.BlueViolet;
				}
				else
				{
					label1.Text = "链接分类“" + sortName + "”添加失败 ...";	label1.ForeColor = Color.Red;
				}

			}
			label1.Visible = true;
			BindDataGrid();
		}

		protected void Add_OnClick(object sender, EventArgs e)
		{
			Panel2.Visible	= true;
			SortName.Text	= "";
		}
		#endregion


	}
}