C#制作学生管理系统源代码.doc

建立3层架构Entity层：book.cs using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace ZDSoft.LibraryManage.Entity public class Book public Book() BBookID = 0; MManID = ; BBookName = ; WWriter = ; public Book(int bookid, string manid, string bookname, string writer) BBookID = bookid; MManID = manid; BBookName = bookname; WWriter = writer; private int BBookID; / / 图?书编号? / public int BookID get return BBookID; set BBookID = value; private string MManID; / / 管理编号? / public string ManID get return MManID; set MManID = value; private string BBookName; / / 图?书名? / public string BookName get return BBookName; set BBookName = value; private string WWriter; / / 作者? / public string Writer get return WWriter; set WWriter = value; using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace ZDSoft.LibraryManage.Entity public class Borrow public Borrow() private int BBorrowID; / / 借书编号? / public int BorrowID get return BBorrowID; set BBorrowID = value; private string CCardID; / / 借书证号? / public string CardID get return CCardID; set CCardID = value; private string MManID; / / 管理编号? / public string ManID get return MManID; set MManID = value; private DateTime BBorrowDate; / / 借书日?期 / public DateTime BorrowDate get return BBorrowDate; set BBorrowDate =value; private DateTime RReturnDate; / / 还1书日?期 / public DateTime ReturnDate get return RReturnDate; set RReturnDate = value; Reader.csusing System;using System.Collections.Generic;using System.Linq;using System.Text;namespace ZDSoft.LibraryManage.Entity public class Reader public Reader() this.RReaderID = 0; this.RReaderName = ; this.CCardID = ; this.TTel = ; / / 构1造用?户实体? / / 读者?编号? / 姓?名? / 借书证号? / 联a系电?话 public Reader(int readerid, string readername, string cardid, string tel) this.RReaderID = readerid; this.RReaderName = readername; this.CCardID = cardid; this.TTel = tel; private int RReaderID; / / 读者?编号? / public int ReaderID get return RReaderID; set RReaderID = value; private string CCardID; / / 借书证号? / public string CardID get return CCardID; set CCardID = value; private string RReaderName; / / 姓?名? / public string ReaderName get return RReaderName; set RReaderName = value; private string TTel; / / 联a系电?话 / public string Tel get return TTel; set TTel = value; User.csusing System;using System.Collections.Generic;using System.Linq;using System.Text;namespace ZDSoft.LibraryManage.Entity public class EntityUser public EntityUser() UUserID = 0; UUserName = ; PPassWord = ; LLevel =; private int UUserID; / / 用?户编号? / public int UserID get return UUserID; set UUserID = value; private string UUserName; / / 用?户名? / public string UserName get return UUserName; set UUserName = value; private string PPassWord; / / 登?录?密码? / public string PassWord get return PPassWord; set PPassWord = value; private string LLevel; / / 用?户权限T / public string Level get return LLevel; set LLevel = value; BookDAl.csusing System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;using ZDSoft.LibraryManage.Entity;namespace ZDSoft.LibraryManage.DAL public class BookDal private Book BBook; public Book Book get return BBook; set BBook = value; private Book DataRowToEntity(DataRow dr) Book book = new Book(); book.BookID = int.Parse(drBOOKID.ToString(); book.BookName = drBOOKNAME.ToString(); book.ManID = drMANID.ToString(); book.Writer = drWRITER.ToString(); return book; / / 根据Y图?书编号?获?取?图?书 / / 图?书实体?类 / 对?应|的?图?书信?息 public Book GetByID(string bookID) /SqlParameter sqlp = new SqlParameter new SqlParameter(BookID, bookID) ; DataTable dt = SqlOperator.SelectAll(T_Book_SelectBookID); Book book = null; if (dt.Rows.Count = 1) book = DataRowToEntity(dt.Rows0); return book; public Book SearchBookID() SqlParameter sqlp = new SqlParameter new SqlParameter(BookID, BBook.BookID) ; DataTable dt = SqlOperator.Select(sqlp, T_Book_SelectBookID); Book book = null; if (dt.Rows.Count 0) foreach (DataRow dr in dt.Rows) book = DataRowToEntity(dr); return book; / / 根据Y图?书管理编号?获?取?图?书 / / 图?书信?息实体?类 / 对?应|的?图?书信?息 public IList GetByManageID(string manID) / SqlParameter sqlp = new SqlParameter new SqlParameter(ManID, manID) ; DataTable dt = SqlOperator.SelectAll(T_Book_SelectManID); IList list = null; if (dt.Rows.Count 0) Book book = null; foreach (DataRow dr in dt.Rows) book = DataRowToEntity(dr); if (list = null) list = new List(); list.Add(book); return list; / / 根据Y管理编号?查询图?书 / / 返回?查询结果?DataTable public DataTable Search() SqlParameter sqlp = new SqlParameter new SqlParameter(ManID, BBook.ManID) ; DataTable dt = SqlOperator.Select(sqlp, T_Book_SelectManID); return dt; /public IList Search() / / SqlParameter sqlp = new SqlParameter new SqlParameter(ManID, BBook.ManID) ; / DataTable dt = SqlOperator.Select(sqlp, T_Book_SelectManID); / IList list = null; / if (dt.Rows.Count 0) / / Book book = null; / foreach (DataRow dr in dt.Rows) / / book = DataRowToEntity(dr); / if (list = null) / / list = new List(); / / list.Add(book); / / / return list; / / / 根据Y管理编号?或图?书名?查询图?书信?息 / / 关?键字? / 条?件t / 返回?查询结果? public IList GetByNameAndMainID(string key, string se) SqlConnection conn = new SqlConnection(SqlConnect.ReturnConnection(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = new SqlCommand(); sda.SelectCommand.Connection = conn; sda.SelectCommand.CommandText = select * from T_Book where + se + like %+key+%; sda.SelectCommand.Parameters.Add(key, SqlDbType.NVarChar, 12).Value = key; DataTable dt = new DataTable(); IList list = null; try conn.Open(); sda.Fill(dt); if (dt.Rows.Count 0) Book book = null; book = new Book(); if (list = null) list = new List(); list.Add(book); conn.Close(); catch (SqlException ex) throw new Exception(检索数y据Y发生错误, ex); finally if (conn.State = ConnectionState.Open) conn.Close(); return list; public IList Select(string id) SqlParameter sqlp = new SqlParameter new SqlParameter(ManID, id) ; DataTable dt = SqlOperator.Select(sqlp, T_Book_SelectID); IList list = null; if (dt.Rows.Count 0) Book book = null; foreach (DataRow dr in dt.Rows) book = DataRowToEntity(dr); if (list = null) list = new List(); list.Add(book); return list; / / 查询所有D图?书信?息 / public IList GetAllBook() DataTable dt = new DataTable(); IList listbook = null; dt = SqlOperator.SelectAll(T_Book_Select); if (dt.Rows.Count 0) Book book = null; foreach (DataRow dr in dt.Rows) book = DataRowToEntity(dr); if (listbook = null) listbook = new List(); listbook.Add(book); return listbook; / / 根据Y管理编号?或图?书名?查询图?书信?息 / / 关?键字? / 条?件t / 返回?查询结果? public IList Select(string key, string se) SqlConnection conn = new SqlConnection(SqlConnect.ReturnConnection(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = new SqlCommand(); sda.SelectCommand.Connection = conn; sda.SelectCommand.CommandText = select * from T_Book where + se + like %+key+%; sda.SelectCommand.Parameters.Add(key, SqlDbType.NVarChar, 12).Value = key; DataTable dt = new DataTable(); IList listbook = null; try conn.Open(); sda.Fill(dt); if (dt.Rows.Count 0) Book book = null; foreach (DataRow dr in dt.Rows) book = DataRowToEntity(dr); if (listbook = null) listbook = new List(); listbook.Add(book); conn.Close(); catch (SqlException ex) throw new Exception(检索数y据Y发生错误, ex); finally if (conn.State = ConnectionState.Open) conn.Close(); return listbook; / / 增?加图?书 / / 图?书属?性?类实体? public void InsertBook(Book book) SqlParameter sqlp = new SqlParameter new SqlParameter(ManID, book.ManID), new SqlParameter(BookName, book.BookName), new SqlParameter(Writer, book.Writer) ; int row = SqlOperator.Insert(sqlp, T_Book_Insert); / / 根据Y图?书编号?更新?图?书信?息 / public void UpdateBook(Book book) SqlParameter sqlp = new SqlParameter new SqlParameter(BookID, book.BookID), new SqlParameter(BookName, book.BookName), new SqlParameter(Writer, book.Writer); int row = SqlOperator.Update(sqlp, T_Book_Update); / / 根据Y图?书编号?删?除y图?书 / public void DeleteBook(string bookID) SqlParameter sqlp = new SqlParameter new SqlParameter(BookID, bookID) ; int row = SqlOperator.Delete(sqlp, T_Book_Delete); BorrowDAl.csusing System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;using ZDSoft.LibraryManage.Entity;namespace ZDSoft.LibraryManage.DAL public class BorrowDal private Borrow BBorrow; public Borrow Borrow get return BBorrow; set BBorrow = value; / / 插?入?借书信?息 / / 返回?影响行D数y public int Insert() SqlParameter sqlp = new SqlParameter new SqlParameter(CardID, BBorrow.CardID), new SqlParameter(ManID, BBorrow.ManID), new SqlParameter(BorrowDate, BBorrow.BorrowDate) ; int row = SqlOperator.Insert(sqlp, T_BORROW_Insert); return row; / / 更新?借书信?息 / / 返回?影响行D数y public int Update() SqlParameter sqlp = new SqlParameter new SqlParameter(CardID, BBorrow.CardID), new SqlParameter(ManID, BBorrow.ManID), new SqlParameter(ReturnDate, BBorrow.ReturnDate); int row = SqlOperator.Update(sqlp, T_BORROW_Update); return row; REaderdal.csusing System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;using ZDSoft.LibraryManage.Entity;namespace ZDSoft.LibraryManage.DAL public class ReaderDal private Reader RReader; pu