admin_baoming.aspx.cs

一个供大家参考的自己做的计算机等级考试网上系统

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 djks.admin
{
	/// <summary>
	/// admin_baoming 的摘要说明。
	/// </summary>
	public class admin_baoming : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Repeater Repeater1;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.TextBox txt_pid;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.TextBox txt_name;
		protected System.Web.UI.WebControls.Button btn_select;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.DataGrid dtg_bmk;
		protected System.Web.UI.WebControls.Label lbl_sum;
		
		protected System.Web.UI.WebControls.Label lbl_pagenumber;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		protected System.Web.UI.WebControls.RadioButtonList rbl_sel;    		
		

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面

			if(!this.IsPostBack)
			{
				if(Session["admin_name_login_user"]==null)
				{
					Response.Redirect("manager_login.aspx");
				}
				else
				{
					ViewState["Order_tier"]="id";				

					ViewState["Sort"]="ASC";

					string strSql="select ID,BMH,XM,SFZH,LXDZ,LXDH,JF,ZDYXX,HAVEXP from bmk order by ID desc";
					ViewState["sql"]=strSql;
					rpt_bind(strSql);
				}
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btn_select.Click += new System.EventHandler(this.btn_select_Click);
			this.dtg_bmk.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dtg_bmk_ItemCreated);
			this.dtg_bmk.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dtg_bmk_ItemCommand);
			this.dtg_bmk.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dtg_bmk_PageIndexChanged);
			this.dtg_bmk.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.dtg_bmk_SortCommand);
			this.dtg_bmk.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dtg_bmk_DeleteCommand);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	
		private void rpt_bind(string strSql)
		{
			int sum;                //检索出的记录数
			string sort=ViewState["Order_tier"].ToString()+" "+ViewState["Sort"].ToString();
			DataSet ds=new DataSet();
			ds=database.CreateDateSet(strSql);
			DataView dv = ds.Tables[0].DefaultView;
			sum=ds.Tables[0].Rows.Count;
			this.lbl_sum.Text=sum.ToString();
			if(sum>0)
			{
				this.lbl_pagenumber.Text=Convert.ToString(sum/20+1);
			}
			else
			{
				this.lbl_pagenumber.Text="0";
			}
		
			
			//数据绑定
			dv.Sort=sort;
			this.dtg_bmk.DataSource=dv;
			//			this.dtg_bmk.VirtualItemCount=10;
			
			this.dtg_bmk.DataKeyField="ID";
			this.dtg_bmk.DataBind();
			
			
		}

		private void btn_select_Click(object sender, System.EventArgs e)
		{
			string tem="";
			string strSql="select ID,BMH,XM,SFZH,LXDZ,LXDH,JF,ZDYXX,HAVEXP from bmk";
			if(this.rbl_sel.Items[0].Selected)   //判断选定项
			{
				tem="JF=true";
				//				strSql=strSql+""
			}
			else
			{
				if(this.rbl_sel.Items[1].Selected)
				{
					tem="JF=false";
				}
				
			}
			if(this.txt_pid.Text==""&&this.txt_name.Text=="")
			{
				if(tem!="")
				{
					strSql=strSql+" where "+tem;
				}
			}
			else
			{
				strSql=strSql+" where ";
				if(this.txt_pid.Text!=""&&this.txt_name.Text=="")
				{
					strSql=strSql+"SFZH='"+this.txt_pid.Text+"'";
				}					
				if(this.txt_pid.Text==""&&this.txt_name.Text!="")
				{
					strSql=strSql+"XM='"+this.txt_name.Text.Replace(" ","")+"'";
				}
				if(this.txt_pid.Text!=""&&this.txt_name.Text!="")
				{
					strSql=strSql+"XM='"+this.txt_name.Text.Replace(" ","")+"' and SFZH='"+this.txt_pid.Text+"'";
				}
				if(tem!="")
				{				
					strSql=strSql+" and "+tem;
				}
			}
			ViewState["sql"]=strSql;
			this.dtg_bmk.CurrentPageIndex=0;
			this.rpt_bind(strSql+" order by ID desc");
		}

		private void dtg_bmk_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			//			string xm=e.Item.Cells[1].Text.ToString();
			//			string sfzh=e.Item.Cells[2].Text.ToString();
			string id=this.dtg_bmk.DataKeys[e.Item.ItemIndex].ToString();
			string strSql=ViewState["sql"].ToString();
			//			hxyy_js.jsAlert(id);
			string strSql_delete="delete from bmk where ID="+id;			
			database.doSql(strSql_delete);
//			hxyy_js.jsAlert("删除成功！");
			rpt_bind(strSql);
		}

		private void dtg_bmk_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			//			hxyy_js.jsAlert(e.NewPageIndex.ToString());
			string strSql=ViewState["sql"].ToString();
			this.dtg_bmk.CurrentPageIndex=e.NewPageIndex;
			
			//			string strSql="select top 20 *  from where id<(select min(ID) from (select top 20 ID from bmk order by ID desc) ) bmk order by ID desc";
		
			//数据绑定
			//			hxyy_js.jsAlert(strSql);
			this.dtg_bmk.DataSource=database.CreateDateSet(strSql);
			//			this.dtg_bmk.VirtualItemCount=Recrodcount/pageSize;
			this.dtg_bmk.DataKeyField="ID";
			this.dtg_bmk.DataBind();			
			
		}

		private void dtg_bmk_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.Item.ItemType == ListItemType.Pager)
			{
				return ;
			}
		}

		private void dtg_bmk_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			
			if(e.Item.ItemType==ListItemType.AlternatingItem || e.Item.ItemType==ListItemType.Item) 

			{
				//				LinkButton	lbt_delete =(LinkButton) e.Item.FindControl("LinkButton1");

				LinkButton lbt_delete=(LinkButton)e.Item.Cells[8].Controls[0]; 

				if(lbt_delete!=null) 

				{ 

					lbt_delete.Attributes.Add("OnClick","return confirm('确定要删除吗?');");

				} 

			} 


		}

//		private void btn_bmh_Click(object sender, System.EventArgs e)
//		{
//			string strSql="select ID,BMH,XM,SFZH,LXDZ,LXDH,JF,ZDYXX,HAVEXP from bmk order by BMH desc";
//			ViewState["sql"]=strSql;
//
//			this.dtg_bmk.DataSource=database.CreateDateSet(strSql);			
//			this.dtg_bmk.DataKeyField="ID";
//			this.dtg_bmk.DataBind();
//		}
//
//		private void btn_xm_Click(object sender, System.EventArgs e)
//		{
//			string strSql="select ID,BMH,XM,SFZH,LXDZ,LXDH,JF,ZDYXX,HAVEXP from bmk order by XM desc";
//			ViewState["sql"]=strSql;
//
//			this.dtg_bmk.DataSource=database.CreateDateSet(strSql);			
//			this.dtg_bmk.DataKeyField="ID";
//			this.dtg_bmk.DataBind();
//		}
//
//		private void btn_sfzh_Click(object sender, System.EventArgs e)
//		{
//			string strSql="select ID,BMH,XM,SFZH,LXDZ,LXDH,JF,ZDYXX,HAVEXP from bmk order by SFZH desc";
//			ViewState["sql"]=strSql;
//
//			this.dtg_bmk.DataSource=database.CreateDateSet(strSql);			
//			this.dtg_bmk.DataKeyField="ID";
//			this.dtg_bmk.DataBind();
//		}
//
//		private void Button2_Click(object sender, System.EventArgs e)
//		{
//			string strSql="select ID,BMH,XM,SFZH,LXDZ,LXDH,JF,ZDYXX,HAVEXP from bmk order by JF desc";
//			ViewState["sql"]=strSql;
//
//			this.dtg_bmk.DataSource=database.CreateDateSet(strSql);			
//			this.dtg_bmk.DataKeyField="ID";
//			this.dtg_bmk.DataBind();
//		}
//
//		private void Button3_Click(object sender, System.EventArgs e)
//		{
//			string strSql="select ID,BMH,XM,SFZH,LXDZ,LXDH,JF,ZDYXX,HAVEXP from bmk order by HAVEXP desc";
//			ViewState["sql"]=strSql;
//
//			this.dtg_bmk.DataSource=database.CreateDateSet(strSql);			
//			this.dtg_bmk.DataKeyField="ID";
//			this.dtg_bmk.DataBind();
//		}

		private void dtg_bmk_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
		{
			string Order_tier=ViewState["Order_tier"].ToString();
			
			if(Order_tier==e.SortExpression)      //判断此次排序的字段是否于上次排序字段相同
			{
				if(ViewState["Sort"].ToString()=="ASC")				
					ViewState["Sort"]="Desc";
				else
					ViewState["Sort"]="ASC";
				
			}
			else
			{
				
				ViewState["Order_tier"]=e.SortExpression;
			
			}
			this.rpt_bind(ViewState["sql"].ToString());
		}

	}
	
}