booklist.aspx.cs

一个用csharp做的简单图书管理系统,用sql数据库连接.

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 Com.LXJ.Example.Book
{
	/// <summary>
	/// BookList 的摘要说明。
	/// </summary>
	public class BookList : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox tbBookName;
		protected System.Web.UI.WebControls.DataGrid dgList;
		protected System.Web.UI.WebControls.Button bAdd;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!IsPostBack)
			{
				BindGrid();  //邦定数据
			}
		}


		/// <summary>
		/// 邦定数据
		/// </summary>
		private void BindGrid()
		{
			Com.LXJ.Example.Book.Business.Book book = new Com.LXJ.Example.Book.Business.Book();
			dgList.DataSource = book.List();
			dgList.DataBind();
		}




		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.bAdd.Click += new System.EventHandler(this.bAdd_Click);
			this.dgList.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgList_CancelCommand);
			this.dgList.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgList_EditCommand);
			this.dgList.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgList_UpdateCommand);
			this.dgList.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgList_DeleteCommand);
			this.dgList.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dgList_ItemDataBound);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		
		private void bAdd_Click(object sender, System.EventArgs e)
		{
			string bookName = tbBookName.Text.ToString().Trim();
			if(bookName=="")
			{
				Response.Write("<Script>");
				Response.Write("alert('书名不能空！');");
				Response.Write("history.go(-1);");
				Response.Write("</Script>");
				Response.End();
			}
			Com.LXJ.Example.Book.Business.Book book = new Com.LXJ.Example.Book.Business.Book();
			book.BookName = bookName;
			if(!book.Create())
			{
				Response.Write("<Script>");
				Response.Write("alert('新增失败！');");
				Response.Write("history.go(-1);");
				Response.Write("</Script>");
				Response.End();
			}
			//重新加载数据
			BindGrid();
			tbBookName.Text = "";
		}

		private void dgList_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			dgList.EditItemIndex = -1;
			BindGrid();
		}

		private void dgList_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			int bookId = int.Parse(e.Item.Cells[0].Text.ToString());
			Com.LXJ.Example.Book.Business.Book book = new Com.LXJ.Example.Book.Business.Book();
			book.BookId = bookId;
			if(!book.Delete())
			{
				Response.Write("<Script>");
				Response.Write("alert('删除失败！');");
				Response.Write("history.go(-1);");
				Response.Write("</Script>");
				Response.End();
			}
			//重新加载数据
			BindGrid();
		}

		private void dgList_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			dgList.EditItemIndex = e.Item.ItemIndex;
			BindGrid();
		}

		private void dgList_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			int bookId = int.Parse(e.Item.Cells[0].Text.ToString());
			string bookName = ((TextBox)e.Item.Cells[1].FindControl("BookName")).Text.ToString().Trim();
			if(bookName=="")
			{
				Response.Write("<Script>");
				Response.Write("alert('书名不能空！');");
				Response.Write("history.go(-1);");
				Response.Write("</Script>");
				Response.End();
			}

			Com.LXJ.Example.Book.Business.Book book = new Com.LXJ.Example.Book.Business.Book(bookId); 
			book.BookName = bookName;
			if(!book.Update())
			{
				Response.Write("<Script>");
				Response.Write("alert('修改失败！');");
				Response.Write("history.go(-1);");
				Response.Write("</Script>");
				Response.End();
			}
			//重新加载数据
			BindGrid();
		}

		private void dgList_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			switch(e.Item.ItemType)
			{
				case ListItemType.Item:
				case ListItemType.AlternatingItem:
				case ListItemType.EditItem:
				{
					LinkButton button = (LinkButton)e.Item.FindControl("lbDelete");
					button.Attributes.Add("onclick", "javascript:return confirm('删除后不可恢复，确定删除这条记录吗？');");
					break;
				}
			}
		}




	}//
}//