图书管理系统详细设计说明书

五、详细设计说明书详细设计说明书1．引言 11.1编写目的 11.2项目背景 11.3定义 21.4参考资料 22．总体设计 22.1需求概述 22.2软件构架 23．程序描述 23.1功能 33.2性能 33.3输入项目 33.4输出项目 33.5算法 33.6程序逻辑 33.7接口 33.8存储分配 33.9限制条件 33.10测试要点 31．引言1.1编写目的本阶段将确认需要怎样准确地推动所规定的平台，以便在编码阶段可以把这个表述直接翻译成用准确的程序语言书写的程序。主要的工作有：很据软件需求说明书中所表述的数据、功能、运行、性能需求，并根据概要说明书所确认的处理步骤、总体构架和组件内部设计，设计工具系统的构架设计、逐个模块的程序描述（包括各组件的功用、性能、输入、输出、算法、程序逻辑、接口等）1.2项目背景开发工具名称：图书馆管理平台工程开发者：乐山师范学院计算机科学学院理工班“图书馆管理系统”开发小组组员：严晓晓 成员:张伟，张莉苹，张宇，肖婷婷图书管理系统详细设计说明书，谢春霞1.3定义1）Sql Sever2005:管理工具2）DBMS：管理系统3）Windows 2000及以上：运行环境C#：软件开发语言1.4参考资料1.《技术与应用》——贺利坚、李茹、谭瑛、魏怀明 编著，宇航出版社2.《C#上机实训指导 》——李继泽 主编，中国水电水利出版社3.《C#开发实例精粹》——郭瑞军、唐邦民、谢晗昕等 编著，电子工业出版社4.《SQL Server实用基础教程》——郭东恩 主编，航空工业出版社 5《C# Winform 实践开发教程》——钱哨，中国水电水利出版社2．总体设计2.1需求概述本平台通过强大的计算机科技给图书管理人员和观众借、还书带给便利。

本平台不仅图书馆内管理的通常用途还精度数据类别作者人名2<字符<5Vchar(10)汉子或英文索引号字母加数字<20Vchar(20)字符出版社出版社名<25char(50)汉字或日文出版日期日期8char(8)日期型图书编号数字10char(10)数字串图书查询查询类型格式数据范围精度数据类别按作者人名无无无按索引号字符无无无按编号无无无无按出版社无无无无按出版日期1990无无日期型3.4输出项目学生借书格式数据范围精度数据类别作者人名2<字符<5Vchar(10)汉字或日文图书编号数字10Char(10)数字串学生还书格式数据范围精度数据类别作者人名2<字符<5Vchar(10)汉字或日文图书编号数字10Char(10)数字串图书查询格式数据范围精度数据类别作者人名2<字符<5Vchar(10)汉字或中文索引号字母加数字<20Vchar(20)字符出版社出版社名<25Vchar(50)汉字或中文出版日期日期8Char(8)日期型图书编号数字10Char(10)数字串应还日期日期8Char(8)日期型3.5算法【模块所采用的算法。

】管理员属性类namespace library.LibraryModel{public class admin {private string _adminId;public string AdminId { get { return _adminId; } set { _adminId = value; } } private string _adminName; public string AdminName { get { return _adminName; } set { _adminName = value; } } private string _adminSex; public string AdminSex { get { return _adminSex; } set { _adminSex = value; } } private string _adminAge; public string AdminAge { get { return _adminAge; } set { _adminAge = value; } } private string _adminPass; public string AdminPass { get { return _adminPass; } set { _adminPass = value; } } public admin() { } public admin(string adminName, string adminPass) { this._adminName = adminName; this._adminPass = adminPass; } }}管理员借阅情况类namespace library.LibraryModel{public class adminborrow { public adminborrow() { } private string _adminId; public string AdminId { get { return _adminId; } set { _adminId = value; } } private string _bookId; public string BookId { get { return _bookId; } set { _bookId = value; } } private string _borrowTime; public string BorrowTime { get { return _borrowTime; } set { _borrowTime = value; } } private string _returnTime; public string ReturnTime { get { return _returnTime; } set { _returnTime = value; } } private string _outTime; public string OutTime { get { return _outTime; } set { _outTime = value; } } }}图书属性类 namespace library.LibraryModel{ public class book { //无参构造函数 public book() { } private string _bookId; public string BookId { get { return _bookId; } set { _bookId = value; } } private string _bookName; public string BookName { get { return _bookName; } set { _bookName = value; } } private string _bookWritter; public string BookWritter { get { return _bookWritter; } set { _bookWritter = value; } } private int _bookTypeId; public int BookTypeId { get { return _bookTypeId; } set { _bookTypeId = value; } } private string _publisherId; public string PublisherId { get { return _publisherId; } set { _publisherId = value; } } private float _bookPrice; public float BookPrice { get { return _bookPrice; } set { _bookPrice = value; } } private string _ifborrow; public string Ifborrow { get { return _ifborrow; } set { _ifborrow = value; } } }}图书类型类namespace library.LibraryModel{ public class booktype { private int _bookTypeId; public int BookTypeId { get { return _bookTypeId; } set { _bookTypeId = value; } } private string _bookTypeName; public string BookTypeName { get { return _bookTypeName; } set { _bookTypeName = value; } } private string _flow; public string Flow { get { return _flow; } set { _flow = value; } } }}图书借阅情况类namespace library.LibraryModel{ public class borrow { private int _borrowId; public int BorrowId { get { return _borrowId; } set { _borrowId = value; } } private string _bookId; public string BookId { get { return _bookId; } set { _bookId = value; } } private string _readerId; public string ReaderId { get { return _readerId; } set { _readerId = value; } } private DateTime _borrowTime; public DateTime BorrowTime { get { return _borrowTime; } set { _borrowTime = value; } } private DateTime _returnTime; public DateTime ReturnTime { get { return _returnTime; } set { _returnTime = value; } } private string outTime; public string OutTime { get { return outTime; } set { outTime = value; } } }}读者情况类namespace library.LibraryModel{ public class reader { private string _readerId; public string ReaderId { get { return _readerId; } set { _readerId = value; } } private string _readerPass; public string ReaderPass { get { return _readerPass; } set { _readerPass = value; } } private string _readerName; public string ReaderName { get { return _readerName; } set { _readerName = value; } } private string _readerSex; public string ReaderSex { get { return _readerSex; } set { _readerSex = value; } } private string _readerAge; public string ReaderAge { get { return _readerAge; } set { _readerAge = value; } } private string _readerDept; public string ReaderDept { get { return _readerDept; } set { _readerDept = value; } } private string _readerzhuanye; public string Readerzhuanye { get { return _readerzhuanye; } set { _readerzhuanye = value; } } public reader() { } public reader(string readername, string readerpass) { this._readerName= readername; this._readerPass = readerpass; } }}4.2 数据访问层类设计与推动数据访问层包涵七个类，各类以及用途举例如下：1．public class adminborrowSever { //删除管理员借书记录 public static int adminborrow_delete(adminborrow a) { try { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@adminId",a.AdminId),new SqlParameter("@bookId",a.BookId) }; string str = "delete adminborrow where adminId=@adminId and bookId=@bookId"; int i = Database.ExecuteNoQuery(str, param); return i; } catch { return 0; } }} public class adminServer { static string sqlstr; public adminServer() { } //管理员地数据访问层 1. public class adminServer { static string sqlstr; public adminServer() { } //管理员地数据访问层 //管理员注册，增加用户 public static int Addadmin(admin a) { try { SqlParameter[] param = new SqlParameter[]{new SqlParameter("@adminId",a.AdminId), new SqlParameter("@adminName",a.AdminName), new SqlParameter("@adminSex",a.AdminSex), new SqlParameter("@adminAge",a.AdminAge), new SqlParameter("@adminPass",a.AdminPass)}; string str = "insert into [admin] values (@adminId,@adminName,@adminSex,@adminAge,@adminPass)"; int i = Database.ExecuteNoQuery(str, param); return i; } catch { return 0; } }3. public class readerServer { static string sqlstr; public readerServer() { } //添加读者信息 public static int AddReader(reader r) { try { SqlParameter[] param = new SqlParameter[]{new SqlParameter("@readerId",r.ReaderId), new SqlParameter("@readerPass",r.ReaderPass), new SqlParameter("@readerName",r.ReaderName), new SqlParameter("@readerSex",r.ReaderSex), new SqlParameter("@readerAge",r.ReaderAge), new SqlParameter("@readerDept",r.ReaderDept), new SqlParameter("@readerzhuanye",r.Readerzhuanye)}; string str = "insert into [reader](readerId,readerPass,readerName,readerSex,readerAge,readerDept,readerzhuanye) values(@readerId,@readerPass,@readerName,@readerSex,@readerAge,@readerDept,@readerzhuanye)"; int i = Database.ExecuteNoQuery(str, param); return i; } catch { return 0; } } //修改读者信息 public static int updateReader(reader r) { try { SqlParameter[] param = new SqlParameter[]{new SqlParameter("@readerId",r.ReaderId), new SqlParameter("@readerPass",r.ReaderPass), new SqlParameter("@readerName",r.ReaderName), new SqlParameter("@readerSex",r.ReaderSex), new SqlParameter("@readerAge",r.ReaderAge), new SqlParameter("@readerDept",r.ReaderDept), new SqlParameter("@readerzhuanye",r.Readerzhuanye)}; string str = "update reader set readerPass=@readerPass,readerName=@readerName,readerSex=@readerSex,readerAge=@readerAge,readerDept=@readerDept,readerzhuanye=@readerzhuanye where readerId='"+r.ReaderId+"'"; int i = Database.ExecuteNoQuery(str, param); return i; } catch { return 0; } } //删除读者信息 public static int reader_delete(reader r) { try { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@readerId", r.ReaderId) }; string str = "delete reader where readerId=@readerId"; int i = Database.ExecuteNoQuery(str, param); return i; } catch { return 0; } } //读者登录 public static bool readerLogin(reader a) { try { SqlParameter[] param = new SqlParameter[]{ new SqlParameter("@readerName",a.ReaderName), new SqlParameter("@readerPass",a.ReaderPass)}; sqlstr = "select * from reader where readerName='" + a.ReaderName + "'and readerPass='" + a.ReaderPass + "'"; int i = Convert.ToInt32(Database.GetValue(sqlstr)); if (i > 0) { return true; } else { return false; } } catch { return false; } } //读者修改密码 public static int passupdate(reader r) { try { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@readerId", r.ReaderId),new SqlParameter("@readerPass",r.ReaderPass) }; string str = "update reader set readerPass=@readerPass where readerId=@readerId"; int i = Database.ExecuteNoQuery(str, param); return i; } catch { return 0; } } //读者修改借阅图书状态 public static int bookstateupdate(string readerId,string bookId) { try { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@readerId",readerId), new SqlParameter("@bookId",bookId) }; string str

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/ruanjian/article-136855-1.html