图书馆管理系统---类目录1. DataBase.cs 数据库类 (2)2.AdminManage.cs （管理员类） (7)3. BookcaseManage.cs （书架类） (11)4. BookManage.cs（图书信息类） (14)5. BorrowandBackManage.cs（图书借还类） (22)6. BTypeManage.cs（图书类型类） (30)7. LibraryManage.cs（图书馆信息类） (34)8. OperatorClass.cs（日期管理类） (37)9. PubManage.cs（出版社类） (39)10. PurviewManage.cs（管理员权限类） (42)11. ReaderManage.cs（读者信息类） (46)12. RTypeManage.cs（读者类型类） (54)13. ValidateClass.cs 控件校验类 (57)1. DataBase.cs 数据库类using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;///<summary>/// DataBase 的摘要说明///</summary>public class DataBase:IDisposable{public DataBase(){//// TODO: 在此处添加构造函数逻辑//}private SqlConnection con; //创建连接对象#region打开数据库连接///<summary>///打开数据库连接.///</summary>private void Open(){// 打开数据库连接if (con == null){con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); }if (con.State == System.Data.ConnectionState.Closed)con.Open();}#endregion#region关闭连接///<summary>///关闭数据库连接///</summary>public void Close(){if (con != null)con.Close();}#endregion#region释放数据库连接资源///<summary>///释放资源///</summary>public void Dispose(){// 确认连接是否已经关闭if (con != null){con.Dispose();con = null;}}#endregion#region传入参数并且转换为SqlParameter类型///<summary>///转换参数///</summary>///<param name="ParamName">存储过程名称或命令文本</param>///<param name="DbType">参数类型</param></param>///<param name="Size">参数大小</param>///<param name="Value">参数值</param>///<returns>新的 parameter 对象</returns>public SqlParameter MakeInParam(string ParamName, SqlDbType DbType, int Size, object Value) {return MakeParam(ParamName, DbType, Size, ParameterDirection.Input, Value);}///<summary>///初始化参数值///</summary>///<param name="ParamName">存储过程名称或命令文本</param>///<param name="DbType">参数类型</param>///<param name="Size">参数大小</param>///<param name="Direction">参数方向</param>///<param name="Value">参数值</param>///<returns>新的 parameter 对象</returns>public SqlParameter MakeParam(string ParamName, SqlDbType DbType, Int32 Size, ParameterDirection Direction, object Value){SqlParameter param;if (Size > 0)param = new SqlParameter(ParamName, DbType, Size);elseparam = new SqlParameter(ParamName, DbType);param.Direction = Direction;if (!(Direction == ParameterDirection.Output && Value == null))param.Value = Value;return param;}#endregion#region执行参数命令文本(无数据库中数据返回)///<summary>///执行命令///</summary>///<param name="procName">命令文本</param>///<param name="prams">参数对象</param>///<returns></returns>public int RunProc(string procName, SqlParameter[] prams){SqlCommand cmd = CreateCommand(procName, prams);cmd.ExecuteNonQuery();this.Close();//得到执行成功返回值return (int)cmd.Parameters["ReturnValue"].Value;}///<summary>///直接执行SQL语句///</summary>///<param name="procName">命令文本</param>///<returns></returns>public int RunProc(string procName){this.Open();SqlCommand cmd = new SqlCommand(procName, con);cmd.ExecuteNonQuery();this.Close();return 1;}#endregion#region执行参数命令文本(有返回值)///<summary>///执行查询命令文本，并且返回DataSet数据集///</summary>///<param name="procName">命令文本</param>///<param name="prams">参数对象</param>///<param name="tbName">数据表名称</param>///<returns></returns>public DataSet RunProcReturn(string procName, SqlParameter[] prams, string tbName) {SqlDataAdapter dap = CreateDataAdaper(procName, prams);DataSet ds = new DataSet();dap.Fill(ds, tbName);this.Close();//得到执行成功返回值return ds;}///<summary>///执行命令文本，并且返回DataSet数据集///</summary>///<param name="procName">命令文本</param>///<param name="tbName">数据表名称</param>///<returns>DataSet</returns>public DataSet RunProcReturn(string procName, string tbName){SqlDataAdapter dap = CreateDataAdaper(procName, null);DataSet ds = new DataSet();dap.Fill(ds, tbName);this.Close();//得到执行成功返回值return ds;}#endregion#region将命令文本添加到SqlDataAdapter///<summary>///创建一个SqlDataAdapter对象以此来执行命令文本///</summary>///<param name="procName">命令文本</param>///<param name="prams">参数对象</param>///<returns></returns>private SqlDataAdapter CreateDataAdaper(string procName, SqlParameter[] prams){this.Open();SqlDataAdapter dap = new SqlDataAdapter(procName, con);mandType = CommandType.Text; //执行类型：命令文本if (prams != null){foreach (SqlParameter parameter in prams)dap.SelectCommand.Parameters.Add(parameter);}//加入返回参数dap.SelectCommand.Parameters.Add(new SqlParameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.ReturnValue, false, 0, 0,string.Empty, DataRowVersion.Default, null));return dap;}#endregion#region将命令文本添加到SqlCommand///<summary>///创建一个SqlCommand对象以此来执行命令文本///</summary>///<param name="procName">命令文本</param>///<param name="prams"命令文本所需参数</param>///<returns>返回SqlCommand对象</returns>private SqlCommand CreateCommand(string procName, SqlParameter[] prams){// 确认打开连接this.Open();SqlCommand cmd = new SqlCommand(procName, con);mandType = CommandType.Text; //执行类型：命令文本// 依次把参数传入命令文本if (prams != null){foreach (SqlParameter parameter in prams)cmd.Parameters.Add(parameter);}// 加入返回参数cmd.Parameters.Add(new SqlParameter("ReturnValue", SqlDbType.Int, 4,ParameterDirection.ReturnValue, false, 0, 0,string.Empty, DataRowVersion.Default, null));return cmd;}#endregion}2.AdminManage.cs （管理员类）using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;///<summary>/// AdminManage 的摘要说明///</summary>public class AdminManage{public AdminManage(){//// TODO: 在此处添加构造函数逻辑//}DataBase data = new DataBase();#region定义管理员信息--数据结构private string id = "";private string name = "";private string pwd = "";///<summary>///管理员编号///</summary>public string ID{get { return id; }set { id = value; }}///<summary>///管理员名称///</summary>public string Name{get { return name; }set { name = value; }}///<summary>///管理员密码///</summary>public string Pwd{get { return pwd; }set { pwd = value; }}#endregion#region自动生成管理员编号///<summary>///自动生成管理员编号///</summary>///<returns></returns>public string GetAdminID(){DataSet ds = GetAllAdmin("tb_admin");string strAdminID = "";if (ds.Tables[0].Rows.Count == 0)strAdminID = "GLY1001";elsestrAdminID = "GLY" + (Convert.ToInt32(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1][0].ToString().Substring(3, 4)) + 1);return strAdminID;}#endregion#region添加--管理员信息///<summary>///添加--管理员信息///</summary>///<param name="adminmanage"></param>///<returns></returns>public int AddAdmin(AdminManage adminmanage){SqlParameter[] prams = {data.MakeInParam("@id", SqlDbType.VarChar, 50, adminmanage.ID),data.MakeInParam("@name", SqlDbType.VarChar, 50,),data.MakeInParam("@pwd", SqlDbType.VarChar, 30, adminmanage.Pwd),};return (data.RunProc("INSERT INTO tb_admin (id,name,pwd) VALUES(@id,@name,@pwd)", prams));}#endregion#region修改--管理员信息///<summary>///修改--管理员信息///</summary>///<param name="adminmanage"></param>///<returns></returns>public int UpdateAdmin(AdminManage adminmanage){SqlParameter[] prams = {data.MakeInParam("@name", SqlDbType.VarChar, 50,),data.MakeInParam("@pwd", SqlDbType.VarChar, 30, adminmanage.Pwd),};return (data.RunProc("update tb_admin set pwd=@pwd where name=@name", prams));}#endregion#region删除--管理员信息///<summary>///删除--管理员信息///</summary>///<param name="adminmanage"></param>///<returns></returns>public int DeleteAdmin(AdminManage adminmanage){SqlParameter[] prams = {data.MakeInParam("@name", SqlDbType.VarChar, 50,),};return (data.RunProc("delete from tb_admin where name=@name", prams));}#endregion#region管理员登录///<summary>///管理员登录///</summary>///<param name="adminmanage"></param>///<returns></returns>public DataSet Login(AdminManage adminmanage){SqlParameter[] prams = {data.MakeInParam("@name", SqlDbType.VarChar, 50,),data.MakeInParam("@pwd", SqlDbType.VarChar, 30, adminmanage.Pwd),};return(data.RunProcReturn("SELECT * FROM tb_admin WHERE (name = @name) AND (pwd = @pwd)", prams, "tb_admin"));}#endregion#region查询--管理员信息///<summary>///根据管理员名称得到--管理员信息///</summary>///<param name="adminmanage"></param>///<param name="tbName"></param>///<returns></returns>public DataSet GetAllAdminByName(AdminManage adminmanage, string tbName){SqlParameter[] prams = {data.MakeInParam("@name", SqlDbType.VarChar, 50, +"%"),};return (data.RunProcReturn("select * from tb_admin where name like @name", prams, tbName));}///<summary>///得到所有--管理员信息///</summary>///<param name="tbName"></param>///<returns></returns>public DataSet GetAllAdmin(string tbName){return (data.RunProcReturn("select * from tb_admin ORDER BY id", tbName)); }#endregion}3. BookcaseManage.cs （书架类）using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;///<summary>/// BookcaseManage 的摘要说明///</summary>public class BookcaseManage{public BookcaseManage(){//// TODO: 在此处添加构造函数逻辑//}DataBase data = new DataBase();#region定义书架信息--数据结构private string id = "";private string name = "";///<summary>///书架编号///</summary>public string ID{get { return id; }set { id = value; }}///<summary>///书架名称///</summary>public string Name{get { return name; }set { name = value; }}#endregion#region自动生成书架编号///<summary>///自动生成书架编号///</summary>///<returns></returns>public string GetBcaseID(){DataSet ds = GetAllBCase("tb_bookcase");string strBcaseID = "";if (ds.Tables[0].Rows.Count == 0)strBcaseID = "SJ1001";elsestrBcaseID = "SJ" + (Convert.ToInt32(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1][0].ToString().Substring(2, 4)) + 1);return strBcaseID;}#endregion#region添加--书架信息///<summary>///添加--书架信息///</summary>///<param name="bookcasemanage"></param>///<returns></returns>public int AddBookcase(BookcaseManage bookcasemanage){SqlParameter[] prams = {data.MakeInParam("@id", SqlDbType.VarChar, 30, bookcasemanage.ID),data.MakeInParam("@name", SqlDbType.VarChar, 50,),};return (data.RunProc("INSERT INTO tb_bookcase (id,name) VALUES(@id,@name)", prams)); }#endregion#region修改--书架信息///<summary>///修改--书架信息///</summary>///<param name="bookcasemanage"></param>///<returns></returns>public int UpdateBookcase(BookcaseManage bookcasemanage){SqlParameter[] prams = {data.MakeInParam("@id", SqlDbType.VarChar, 30, bookcasemanage.ID),data.MakeInParam("@name", SqlDbType.VarChar, 50,), };return (data.RunProc("update tb_bookcase set name=@name where id=@id", prams)); }#endregion#region删除--书架信息///<summary>///删除--书架信息///</summary>///<param name="bookcasemanage"></param>///<returns></returns>public int DeleteBookcase(BookcaseManage bookcasemanage){SqlParameter[] prams = {data.MakeInParam("@id", SqlDbType.VarChar, 30, bookcasemanage.ID),};return (data.RunProc("delete from tb_bookcase where id=@id", prams));}#endregion#region查询--书架信息///<summary>///根据--书架编号--得到书架信息///</summary>///<param name="bookcasemanage"></param>///<param name="tbName"></param>///<returns></returns>public DataSet FindBCaseByID(BookcaseManage bookcasemanage, string tbName){SqlParameter[] prams = {data.MakeInParam("@id", SqlDbType.VarChar, 30, bookcasemanage.ID+"%"),};return (data.RunProcReturn("select * from tb_bookcase where id like @id", prams,tbName));}///<summary>///根据--书架名称--得到书架信息///</summary>///<param name="bookcasemanage"></param>///<param name="tbName"></param>///<returns></returns>public DataSet FindBCaseByName(BookcaseManage bookcasemanage, string tbName){SqlParameter[] prams = {data.MakeInParam("@name", SqlDbType.VarChar, 50,+"%"),};return (data.RunProcReturn("select * from tb_bookcase where name like @name", prams, tbName));}///<summary>///得到所有--书架信息///</summary>///<param name="tbName"></param>///<returns></returns>public DataSet GetAllBCase(string tbName){return (data.RunProcReturn("select * from tb_bookcase ORDER BY id", tbName));}#endregion}4. BookManage.cs（图书信息类）using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;///<summary>/// BookManage 的摘要说明///</summary>public class BookManage{public BookManage(){//// TODO: 在此处添加构造函数逻辑//}DataBase data = new DataBase();#region定义图书信息--数据结构private string bookcode = "";private string bookname = "";private string type = "";private string author = "";private string translator = "";private string pubname = "";private decimal price = 0;private int page = 0;private string bcase = "";private int storage = 0;private DateTime intime = Convert.ToDateTime(DateTime.Now.ToShortDateString());private string oper = "";private int borrownum = 0;///<summary>///条形码///</summary>public string BookCode{get { return bookcode; }set { bookcode = value; }}///<summary>///书名///</summary>public string BookName{get { return bookname; }set { bookname = value; }}///<summary>///类型编号///</summary>public string Type{get { return type; }set { type = value; }}///<summary>///作者///</summary>public string Author{get { return author; }set { author = value; }}///<summary>///译者///</summary>public string Translator{get { return translator; }set { translator = value; } }///<summary>///出版社///</summary>public string PubName{get { return pubname; }set { pubname = value; }}///<summary>///价格///</summary>public decimal Price{get { return price; }set { price = value; }}///<summary>///页码///</summary>public int Page{get { return page; }set { page = value; }}///<summary>///书架///</summary>public string Bcase{get { return bcase; }set { bcase = value; }}///<summary>///库存量///</summary>public int Storage{get { return storage; }set { storage = value; } }///<summary>///录入时间///</summary>public DateTime InTime{get { return intime; }set { intime = value; }}///<summary>///操作员///</summary>public string Oper{get { return oper; }set { oper = value; }}///<summary>///借阅次数///</summary>public int BorrowNum{get { return borrownum; }set { borrownum = value; } }#endregion#region添加--图书信息///<summary>///添加--图书信息///</summary>///<param name="bookmanage"></param>///<returns></returns>public int AddBook(BookManage bookmanage){SqlParameter[] prams = {data.MakeInParam("@bookcode", SqlDbType.VarChar, 30, bookmanage.BookCode),data.MakeInParam("@bookname", SqlDbType.VarChar, 50,bookmanage.BookName ),data.MakeInParam("@type", SqlDbType.VarChar, 50, bookmanage.Type ),data.MakeInParam("@author", SqlDbType.VarChar, 50, bookmanage.Author ),data.MakeInParam("@translator", SqlDbType.VarChar, 50, bookmanage.Translator ), data.MakeInParam("@pubname", SqlDbType.VarChar, 100, bookmanage.PubName ),data.MakeInParam("@price", SqlDbType.Money, 8, bookmanage.Price ),data.MakeInParam("@page", SqlDbType.Int, 4,bookmanage.Page ),data.MakeInParam("@bcase", SqlDbType.VarChar, 50, bookmanage.Bcase ),data.MakeInParam("@storage", SqlDbType.BigInt, 8, bookmanage.Storage ),data.MakeInParam("@inTime", SqlDbType.DateTime, 8, bookmanage.InTime ),data.MakeInParam("@oper", SqlDbType.VarChar, 30, bookmanage.Oper ),};return (data.RunProc("INSERT INTO tb_bookinfo(bookcode,bookname,type,author,translator,pubname,price,page,bcase,storage,inTime,oper) "+ "VALUES(@bookcode,@bookname,@type,@author,@translator,@pubname,@price,@page,@bcase,@storage,@inTime ,@oper)", prams));}#endregion#region修改--图书信息///<summary>///修改--图书信息///</summary>///<param name="bookmanage"></param>///<returns></returns>public int UpdateBook(BookManage bookmanage){SqlParameter[] prams = {data.MakeInParam("@bookcode", SqlDbType.VarChar, 30, bookmanage.BookCode),data.MakeInParam("@bookname", SqlDbType.VarChar, 50,bookmanage.BookName ),data.MakeInParam("@type", SqlDbType.VarChar, 50, bookmanage.Type ),data.MakeInParam("@author", SqlDbType.VarChar, 50, bookmanage.Author ),data.MakeInParam("@translator", SqlDbType.VarChar, 50, bookmanage.Translator ), data.MakeInParam("@pubname", SqlDbType.VarChar, 100, bookmanage.PubName),data.MakeInParam("@price", SqlDbType.Money, 8, bookmanage.Price ),data.MakeInParam("@page", SqlDbType.Int, 4,bookmanage.Page ),data.MakeInParam("@bcase", SqlDbType.VarChar, 50, bookmanage.Bcase ),data.MakeInParam("@storage", SqlDbType.BigInt, 8, bookmanage.Storage ),data.MakeInParam("@inTime", SqlDbType.DateTime, 8, bookmanage.InTime ),data.MakeInParam("@oper", SqlDbType.VarChar, 30, bookmanage.Oper),};return (data.RunProc("update tb_bookinfo setbookname=@bookname,type=@type,author=@author,translator=@translator,pubname=@pubname,price=@ price,"+ "page=@page,bcase=@bcase,storage=@storage,inTime=@inTime,oper=@oper where bookcode=@bookcode", prams));}///<summary>///每借一次图书就将图书的所借次数加一///</summary>///<param name="bookmanage"></param>///<returns></returns>public int UpdateBorrowNum(BookManage bookmanage){SqlParameter[] prams = {data.MakeInParam("@bookcode", SqlDbType.VarChar, 30, bookmanage.BookCode),data.MakeInParam("@borrownum", SqlDbType.Int, 4, bookmanage.BorrowNum), };return (data.RunProc("update tb_bookinfo set borrownum=@borrownum wherebookcode=@bookcode", prams));}#endregion#region删除--图书信息///<summary>///删除--图书信息///</summary>///<param name="bookmanage"></param>///<returns></returns>public int DeleteBook(BookManage bookmanage){SqlParameter[] prams = {data.MakeInParam("@bookcode", SqlDbType.VarChar, 30, bookmanage.BookCode),};return (data.RunProc("delete from tb_bookinfo where bookcode=@bookcode", prams));}#endregion#region查询--图书信息///<summary>///根据--图书编号--得到图书信息///</summary>///<param name="bookmanage"></param>///<param name="tbName"></param>///<returns></returns>public DataSet FindBookByCode(BookManage bookmanage, string tbName){SqlParameter[] prams = {data.MakeInParam("@bookcode", SqlDbType.VarChar, 30, bookmanage.BookCode+"%"),};return (data.RunProcReturn("select * from tb_bookinfo where bookcode like @bookcode", prams, tbName));}///<summary>///根据--图书名称--得到图书信息///</summary>///<param name="bookmanage"></param>///<param name="tbName"></param>///<returns></returns>public DataSet FindBookByName(BookManage bookmanage, string tbName){SqlParameter[] prams = {data.MakeInParam("@bookname", SqlDbType.VarChar,50,"%"+bookmanage.BookName+"%"),};return (data.RunProcReturn("select * from tb_bookinfo where bookname like @bookname", prams, tbName));}///<summary>///根据--图书类型--得到图书信息///</summary>///<param name="bookmanage"></param>///<param name="tbName"></param>///<returns></returns>public DataSet FindBookByType(BookManage bookmanage, string tbName){SqlParameter[] prams = {data.MakeInParam("@type", SqlDbType.VarChar, 50, "%"+bookmanage.Type+"%"),};return (data.RunProcReturn("select * from tb_bookinfo where type like @type", prams,}///<summary>///根据--图书作者--得到图书信息///</summary>///<param name="bookmanage"></param>///<param name="tbName"></param>///<returns></returns>public DataSet FindBookByAuthor(BookManage bookmanage, string tbName){SqlParameter[] prams = {data.MakeInParam("@author", SqlDbType.VarChar, 50, "%"+bookmanage.Author +"%"),};return(data.RunProcReturn("select * from tb_bookinfo where author like @author", prams, tbName));}///<summary>///根据--出版社--得到图书信息///</summary>///<param name="bookmanage"></param>///<param name="tbName"></param>///<returns></returns>public DataSet FindBookByPub(BookManage bookmanage, string tbName){SqlParameter[] prams = {data.MakeInParam("@pubname", SqlDbType.VarChar, 100, "%"+bookmanage.PubName +"%"),};return (data.RunProcReturn("select * from tb_bookinfo where pubname like @pubname", prams, tbName));}///<summary>///根据--书架--得到图书信息///</summary>///<param name="bookmanage"></param>///<param name="tbName"></param>///<returns></returns>public DataSet FindBookByBCase(BookManage bookmanage, string tbName){SqlParameter[] prams = {data.MakeInParam("@bcase", SqlDbType.VarChar, 50, "%"+bookmanage.Bcase +"%"),};return (data.RunProcReturn("select * from tb_bookinfo where bcase like @bcase", prams,}///<summary>///得到所有--图书信息///</summary>///<param name="tbName"></param>///<returns></returns>public DataSet GetAllBook(string tbName){return (data.RunProcReturn("select * from tb_bookinfo ORDER BY bookcode", tbName));}///<summary>///得到图书借阅排行的前5名///</summary>///<param name="tbName"></param>///<returns></returns>public DataSet GetBookSort(string tbName){return (data.RunProcReturn("select top 5* from tb_bookinfo where borrownum<>0 ORDER BY borrownum desc", tbName));}///<summary>///得到所有图书借阅排行///</summary>///<param name="tbName"></param>///<returns></returns>public DataSet GetAllBookSort(string tbName){return (data.RunProcReturn("select * from tb_bookinfo where borrownum<>0 ORDER BY borrownum desc", tbName));}#endregion}5. BorrowandBackManage.cs（图书借还类）using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;///<summary>/// BorrowandBackManage 的摘要说明///</summary>public class BorrowandBackManage{public BorrowandBackManage(){//// TODO: 在此处添加构造函数逻辑//}DataBase data = new DataBase();#region定义图书借还信息--数据结构private string id = "";private string readid = "";private string bookcode = "";private DateTime borrowtime = Convert.ToDateTime(DateTime.Now.ToShortDateString());private DateTime ygbacktime = Convert.ToDateTime(DateTime.Now.ToShortDateString());private DateTime sjbacktime = Convert.ToDateTime(DateTime.Now.ToShortDateString());private string borrowoper = "";private string backoper = "";private bool isback = false;private string bookname = "";private string name = "";private DateTime fromtime = Convert.ToDateTime(DateTime.Now.ToShortDateString());private DateTime totime = Convert.ToDateTime(DateTime.Now.ToShortDateString());///<summary>///借书编号///</summary>public string ID{get { return id; }set { id = value; }}///<summary>///读者编号。
