admin_photo.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_photo 的摘要说明。
	/// </summary>
	public class admin_photo : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button btn_select;
		protected System.Web.UI.WebControls.DataList DataList1;
		protected System.Web.UI.WebControls.TextBox txt_sfzh;
		protected System.Web.UI.WebControls.TextBox txt_xm;
		protected System.Web.UI.WebControls.Panel pnl_select;
		private string sql="select * from bmk ";
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!this.IsPostBack)
			{
				if(Session["admin_name_login_user"]==null)
				{
					Response.Redirect("manager_login.aspx");
				}	
//				
			}

		}

		#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.DataList1.ItemCreated += new System.Web.UI.WebControls.DataListItemEventHandler(this.DataList1_ItemCreated);
			this.DataList1.DeleteCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList1_DeleteCommand);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btn_select_Click(object sender, System.EventArgs e)
		{
			

			if(this.txt_sfzh.Text.Replace(" ","")!=""&&this.txt_xm.Text.Replace(" ","")!="")
			{
				sql=sql+" where XM='"+this.txt_xm.Text.Replace(" ","")+"' and SFZH='"+this.txt_sfzh.Text.Replace(" ","")+"'";
			}
			else if(this.txt_sfzh.Text.Replace(" ","")==""&&this.txt_xm.Text.Replace(" ","")!="")
			{
				sql=sql+" where XM='"+this.txt_xm.Text.Replace(" ","")+"'";
			}
			else if(this.txt_sfzh.Text!=""&&this.txt_xm.Text=="")
			{
				sql=sql+"where SFZH='"+this.txt_sfzh.Text.Replace(" ","")+"'";
			}
			
//			hxyy_js.jsAlert(sql);
			if(this.txt_sfzh.Text.Replace(" ","")!=""||this.txt_xm.Text.Replace(" ","")!="")
			{
				this.DataList1.DataSource=database.CreateDateSet(sql);
				this.DataList1.DataKeyField="ID";
				this.DataList1.DataBind();
			}
		}

		private void DataList1_DeleteCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
		{
			string id=this.DataList1.DataKeys[e.Item.ItemIndex].ToString();
//			hxyy_js.jsAlert(id);
//			Response.Write("<script>confirm('确定要删除吗?');</script>")
			

//			if()
//			{
				string strSql_delete="delete from bmk where ID="+id;			
				database.doSql(strSql_delete);
//				hxyy_js.jsAlert("删除成功！");
//			}
			this.DataList1.DataSource=database.CreateDateSet(sql);
			this.DataList1.DataKeyField="ID";
			this.DataList1.DataBind();
		}

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

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

//				LinkButton btnLinkDelete=(LinkButton)e.Item.Cells[4].Controls[0]; 

				if(lbt_delete!=null) 

				{ 

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

				} 

			} 


		}

	
	}
}