bookmanagement.aspx.cs

基于web的图书管理系统 (SQL Server 2000)

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 WebApplication1
{
	public class BookManagement : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		public string str_bookid="";
		private Access acc=new Access();
		private DataSet ds=new DataSet();
		private DataView MyDV=new DataView();
		protected System.Web.UI.WebControls.DropDownList search_state;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.CheckBox check_bookname;
		protected System.Web.UI.WebControls.CheckBox check_type;
		protected System.Web.UI.WebControls.CheckBox check_state;
		protected System.Web.UI.WebControls.TextBox search_BookName;
		protected System.Web.UI.WebControls.DropDownList search_Type;
		protected System.Web.UI.WebControls.Label Label1;
		protected string sFormAction="bookinfo.aspx?";
		protected System.Web.UI.WebControls.Button Button2;
		protected string     str_sql="select * from DB_bookinfo";
		protected CCUtility Utility;//=new CCUtility(this);

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{	
			InitializeComponent();
			base.OnInit(e);
		}
		#endregion
		private void InitializeComponent()
		{
			this.DataGrid1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemCreated);
			this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
			this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
			this.DataGrid1.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.DataGrid1_SortCommand);
			this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
			this.Button2.Click += new System.EventHandler(this.Button2_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		public void MsgBox( string msg )
		{
			string strScript =  "<script language='Javascript'>alert('" + msg + "');</script>";
			Page.RegisterStartupScript("alert", strScript);
		}
		private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			System.Web.UI.WebControls.Image    TempImg;
			TempImg=(System.Web.UI.WebControls.Image)e.Item.FindControl("ib_delete") ;
			if(object.Equals(TempImg,null)==false)
			{TempImg.Attributes.Add("onClick","javascript:return confirm('你能确定要删除此记录吗？')");}
		}

		
		private void Page_Load(object sender, System.EventArgs e)
		{
			this.Utility=new CCUtility(this);
			Utility.CheckSecurity();
		 if (!(this.IsPostBack))
		 {
			 this.Data_Bind();
		
		 }
		}
		private void Data_Bind()
		{
			acc.GetDataSet(str_sql,ds);
			MyDV=ds.Tables[0].DefaultView;
			this.DataGrid1.DataSource=MyDV;
			DataGrid1.DataBind();
			ViewState["Sort"]="";
			ViewState["Page"]="0";
			if (ViewState["SortExpression"] != null)
				MyDV.Sort = ViewState["SortExpression"].ToString().Trim();
			if (ViewState["NowPage"] != null)
				DataGrid1.CurrentPageIndex = int.Parse(ViewState["NowPage"].ToString().Trim());
			try
			{
				DataGrid1.DataBind();
			}
			catch  //比如查询时过滤掉了很多,ViewState["NowPage"]中保存的页数已经偏大
			{
				DataGrid1.CurrentPageIndex = DataGrid1.PageCount-1;
				DataGrid1.DataBind();
			}
ds.Clear();
		}
		private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{	
			string book_id;
			try
			{
			  book_id=e.Item.Cells[0].Text.Trim();
			  Response.Redirect(this.sFormAction+"ID="+book_id+"&");
			}
			catch(Exception ex)
			{
			this.MsgBox(ex.Message);
			}
          
		}
		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
	       string book_id;
		   book_id=e.Item.Cells[0].Text.Trim();
           string delete_sql="delete from DB_bookinfo where BookID='"+book_id+"'";
		   bool success=acc.ExecuteSQL(delete_sql);		
		   if(success==true)
		   {this.MsgBox("更新成功!");this.Data_Bind();}
		   else {this.MsgBox("更新失败!");}
		}
		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			ViewState["NowPage"] = e.NewPageIndex;
			this.Data_Bind();	
		}
		private void DataGrid1_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
		{
			string strSortBy = "";
			string strSortAscending = "";
			//缓存当前信息
			if (ViewState["SortExpression"] != null)
				strSortBy = ViewState["SortExpression"].ToString().Trim();
			if (ViewState["SortAscending"] != null)
				strSortAscending = ViewState["SortAscending"].ToString().Trim();
			//设置新的排序表达式
			ViewState["SortExpression"] = e.SortExpression;
			//如果单击排序列，排序顺序颠倒!
			if (e.SortExpression == strSortBy)
			{
				ViewState["SortExpression"]=e.SortExpression + " desc";
				ViewState["SortAscending"]="no";
			}
			else
			{
				ViewState["SortExpression"] = e.SortExpression;
				ViewState["SortAscending"]="yes";
			}
			this.Data_Bind();			
		}

		private void Button2_Click(object sender, System.EventArgs e)
		{
			//ViewState["NowPage"]=2;
			//this.Data_Bind();
			//this.DataGrid1.CurrentPageIndex=4;
			//this.MsgBox(this.GetDataGridValue(this.DataGrid1,17,2,16)); 
			this.MsgBox(Server.UrlEncode(Request.ServerVariables["QUERY_STRING"]));// + "&ret_page=" + 
			//this.MsgBox(Server.UrlEncode(Request.ServerVariables["SCRIPT_NAME"]));
		}

		public string GetDataGridValue(System.Web.UI.WebControls.DataGrid dg,int pagenum,int rownum,int colnum)
		{
			int temp=dg.CurrentPageIndex;
			string result="";
			try
			{
				ViewState["NowPage"]=pagenum;
				this.Data_Bind();
				result=dg.Items[rownum].Cells[colnum].Text;
				ViewState["NowPage"]=temp;this.Data_Bind();
			}
			catch(Exception ex){this.MsgBox(ex.Message);}
			return result;
		}
	
	
	
	}
}