positon_list.aspx.cs

来自「企业网站前台后台源程序,用于大中小型企业网站后台程序开发」· CS 代码 · 共 203 行

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 BLL;
using Socut.Data;
namespace Websystem.admin
{
	/// <summary>
	/// Positon_list 的摘要说明。
	/// </summary>
	public class Positon_list : System.Web.UI.Page
	{
			protected user us=new user();
		protected other ot=new other();
		protected MagicAjax.UI.Controls.AjaxPanel AjaxPanel1;
		protected System.Web.UI.WebControls.DataGrid MyDataGrid;
		protected System.Web.UI.WebControls.Label lblPageCount;
		protected System.Web.UI.WebControls.Label lblCurrentIndex;
		protected System.Web.UI.WebControls.LinkButton btnFirst1;
		protected System.Web.UI.WebControls.LinkButton btnPrev1;
		protected System.Web.UI.WebControls.LinkButton btnNext1;
		protected System.Web.UI.WebControls.LinkButton btnLast1;
		protected positon po=new positon();
		protected int type_id=1;

		private void Page_Load(object sender, System.EventArgs e)
		{CData myData=new CData();
			other ot = new other();
			if(ot.isDefined("TYPE"))
			{
				try
				{
					type_id=Convert.ToInt32(Request.QueryString["TYPE"].ToString().Trim().Replace("'",""));
				}
				catch
				{
					System.Web.HttpContext.Current.Response.Redirect("../error.aspx?message=该类别暂时锁定");
				}
			}

	
	//删除数据
			if(ot.isDefined("delid"))
			{
				string[] rowid=Request.Form["delid"].ToString().Split(new char[]{','});
				for(int i=0;i<rowid.Length;i++)
				{
			
					delrow(Convert.ToInt32(rowid[i]));
				}
				Response.Redirect("Positon_list.aspx?type="+type_id,true);

			}
//对于‘可见’，‘有效’的设置
			if(ot.isDefined("flog_type"))
			{
				string sql="";
				string flog_type=Request.QueryString["flog_type"].ToString().Trim().Replace("'","");
				int flog_int=Convert.ToInt32(Request.QueryString["flog_int"].ToString().Trim().Replace("'",""));
				int id=Convert.ToInt32(Request.QueryString["id"].ToString().Trim().Replace("'",""));
				sql="update BU_MERCHANDISE set ";
				switch (flog_type)
				{
					case "b1": 
						sql+=" ISOPEN="+flog_int+" where id="+id;
						break;
					case "b2":
						sql+=" ISAVAILABILITY="+flog_int+" where id="+id;
						break;
				
				}
				myData.GetExecuteNonQuery(sql);

			}
//数据显示
			ot.chk_user();
			btnFirst1.Text = "最首页";
			btnPrev1.Text = "前一页";
			btnNext1.Text = "下一页";
			btnLast1.Text = "最后页";
			if(!this.IsPostBack)
				BindGrid();
		}
		//删除记录
		protected void delrow(int id)
		{
			CData myData=new CData();

			string sql="delete from BU_MERCHANDISE where ID="+id;
			myData.GetExecuteNonQuery(sql);
			sql="delete from MESSAGE_again where  MESSAGE_id="+id;
			try
			{
				myData.GetExecuteNonQuery(sql);
			}
			catch
			{

			}

		}
		protected void BindGrid()
		{
			DataSet ds=new DataSet();
			CData myData=new CData();
			string sql = "";
			if(type_id==1)
			{
				sql = "select id,MERCHANDISE,THESORTID,BRANDID,MODEL,BEWRITE,EXPONENT,ISOPEN,ISAVAILABILITY,BROWSEDEGREE,inputtime from BU_MERCHANDISE order by id desc";
			}
			else
			{
				sql = "select id,MERCHANDISE,THESORTID,BRANDID,MODEL,BEWRITE,EXPONENT,ISOPEN,ISAVAILABILITY,BROWSEDEGREE,inputtime from BU_MERCHANDISE where THESORTID="+type_id+" order by id desc";
			}
				
				ds = myData.GetDataSet(sql, 0, 0, "Document");
			this.MyDataGrid.DataSource = ds.Tables["Document"].DefaultView;
			MyDataGrid.DataBind();
			ShowStats();

		}
		private void ShowStats()
		{
			lblCurrentIndex.Text = "第 " + (MyDataGrid.CurrentPageIndex + 1).ToString() + " 页";
			lblPageCount.Text = "总共 " + MyDataGrid.PageCount.ToString() + " 页";
		}

		public void PagerButtonClick(object sender, EventArgs e)
		{
			string arg = ((LinkButton)sender).CommandArgument.ToString();
			switch(arg)
			{
				case "next":
					if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
					{
						MyDataGrid.CurrentPageIndex += 1;
					}
					break;
				case "prev":
					if (MyDataGrid.CurrentPageIndex > 0)
					{
						MyDataGrid.CurrentPageIndex -= 1;
					}
					break;
				case "last":
					MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
					break;
				default:
					MyDataGrid.CurrentPageIndex = System.Convert.ToInt32(arg);
					break;
			}
			BindGrid();
			ShowStats();
		}


		public void MyDataGrid_Page(object sender, DataGridPageChangedEventArgs e)
		{
			int startIndex ;
			startIndex = MyDataGrid.CurrentPageIndex * MyDataGrid.PageSize;
			MyDataGrid.CurrentPageIndex = e.NewPageIndex;
			BindGrid();
			ShowStats();
		}
		private void MyDataGrid_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}
	
		


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

		}
		#endregion
	}
}