admin_xh.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_xh 的摘要说明。
	/// </summary>
	public class admin_xh : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.TextBox txt_xbzy;
		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.Label lbl_sum;
		protected System.Web.UI.WebControls.Label lbl_pagenumber;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.DataGrid dtg_bmk;
	
		
//		private const string order=" order by ID desc";
		

		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";
					
				   ViewState["sql"]="select ID,SFZH,XM,LXDH,LXDZ,ZDYXX,BLCJZL,YZKZH,HAVEXP,JF from bmk";
					rpt_bind("select ID,SFZH,XM,LXDH,LXDZ,ZDYXX,BLCJZL,YZKZH,HAVEXP,JF from bmk");
				}
			}
		}

		#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.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.DataKeyField="ID";
			this.dtg_bmk.DataBind();
			
			
		}

		private void btn_select_Click(object sender, System.EventArgs e)
		{
//			string tem="";
			string sql="select ID,SFZH,XM,LXDH,LXDZ,ZDYXX,BLCJZL,YZKZH,HAVEXP,JF from bmk";
			
			
			if(this.txt_xbzy.Text.Replace(" ","")==""&&this.txt_name.Text.Replace(" ","")=="")
			{
				sql=sql+" where LXDZ='' and  ZDYXX=''";
				
			}
			else if(this.txt_xbzy.Text.Replace(" ","")==""&&this.txt_name.Text.Replace(" ","")!="")
			{
				sql=sql+" where XM='"+this.txt_name.Text.Replace(" ","")+"'";
			}
			else if(this.txt_xbzy.Text!=""&&this.txt_name.Text=="")
			{
				sql=sql+" where LXDZ like '"+this.txt_xbzy.Text.Replace(" ","")+"%' or ZDYXX like '"+this.txt_xbzy.Text.Replace(" ","")+"%'";
			}
			else
			{
				sql=sql+" where XM='"+this.txt_name.Text.Replace(" ","")+"' and ( LXDz like '"+this.txt_xbzy.Text.Replace(" ","")+"%' or ZDYXX like '"+this.txt_xbzy.Text.Replace(" ","")+"%')";

			}
//			if(this.rbl_sel.Items[0].Selected)   //判断选定项
//			{
//				sql=sql +" and JF=True";
//				hxyy_js.jsAlert(sql.ToString());
//			}
//			else if(this.rbl_sel.Items[1].Selected)
//			{				
//				sql=sql +" and JF=False";							
//			}
			ViewState["sql"]=sql+" order by ZDYXX asc";
			this.dtg_bmk.CurrentPageIndex=0;
			this.rpt_bind(sql+" order by ZDYXX asc");
		}

		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.Cells[9].Controls[0]; 

				if(lbt_delete!=null) 

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

			} 

		}

		private void dtg_bmk_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string sql=ViewState["sql"].ToString();
		
			string id = this.dtg_bmk.DataKeys[e.Item.ItemIndex].ToString();
			string strSql="delete from bmk where id="+id;
			database.doSql(strSql);
            this.rpt_bind(sql);
		}

		private void dtg_bmk_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			string sql=ViewState["sql"].ToString();
			this.dtg_bmk.CurrentPageIndex=e.NewPageIndex;
			this.dtg_bmk.DataSource=database.CreateDateSet(sql);
			this.dtg_bmk.DataKeyField="ID";
			this.dtg_bmk.DataBind();
		}

		protected   void   radio_checkchange(object sender  , System.EventArgs e)   
		{
			
			 string strSql;
			CheckBox ckb=(CheckBox)sender;
			DataGridItem dgi=(DataGridItem)ckb.Parent.Parent;                    //获最选项的所在行的主键
//			hxyy_js.jsAlert(ckb.Checked.ToString());
			strSql="update bmk set JF="+ckb.Checked+" where id="+this.dtg_bmk.DataKeys[dgi.ItemIndex];
			database.doSql(strSql);
			
		}

		private void dtg_bmk_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
		{
			//ViewState["Sort"]初始值是ASC
		
			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());
		}
	}
}