data.MakeInParam(\ SqlDbType.VarChar, 4000, readermanage.Remark ), }; return (data.RunProc(\tb_reader set name=@name,sex=@sex,type=@type,birthday=@birthday,paperType=@papertype,paperNum=@papernum,\ +
\where id=@id\ }
public int UpdateBorrowNum(ReaderManage readermanage) {
SqlParameter[] prams = {
data.MakeInParam(\ data.MakeInParam(\ SqlDbType.Int, 4, readermanage.BorrowNum),
data.MakeInParam(\ };
return (data.RunProc(\where id=@id\ }
public int DeleteReader(ReaderManage readermanage) {
SqlParameter[] prams = {
data.MakeInParam(\ };
return (data.RunProc(\ }
public DataSet QueryReaderByCode(ReaderManage readermanage, string name) {
SqlParameter[] prams = {
data.MakeInParam(\ SqlDbType.VarChar, 30, readermanage.ID +\
};
return (data.RunProcReturn(\prams, name)); }
public DataSet QueryReaderByName(ReaderManage readermanage, string name)
{
SqlParameter[] prams = {
data.MakeInParam(\ SqlDbType.VarChar, 50,readermanage.Name+\ }; return (data.RunProcReturn(\* from tb_reader where name like @name\prams, name)); }
public DataSet QueryReaderByType(ReaderManage readermanage, string name) {
SqlParameter[] prams = {
data.MakeInParam(\ SqlDbType.VarChar, 50, readermanage.Type+\ }; return (data.RunProcReturn(\* from tb_reader where type like @type\prams, name)); }
public DataSet GetAllReader(string name) {
return (data.RunProcReturn(\* from tb_reader ORDER BY id\name)); }
public DataSet ReaderLogin(ReaderManage readermanage) {
SqlParameter[] prams = {
data.MakeInParam(\ data.MakeInParam(\ SqlDbType.VarChar, 50,readermanage.Name ), };
return (data.RunProcReturn(\(name = @name)\ } }
3 登陆系统（Module Name）
3.1 描述（Description） 登陆系统的实现编码。 3.2 代码(Program) 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;
public class AdminManage {
private string id; private string name; private string pwd;
public AdminManage() {
//
// TODO: 在此处添加构造函数逻辑 // }
DataBase data = new DataBase();
public string ID {
get { return id; } set { id = value; } }
public string Name {
get { return name; } set { name = value; } }
public string Pwd {
get { return pwd; } set { pwd = value; } }
public string GetAdminID() {
DataSet ds = GetAdmin(\ string str = \
if (ds.Tables[0].Rows.Count == 0) str = \ else str = \+ (Convert.ToInt32(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1][0].ToString().Substring(1, 4)) + 1); return str; }
public int AddAdmin(AdminManage adminM) {
SqlParameter[] prams = {
data.MakeInParam(\ data.MakeInParam(\ data.MakeInParam(\ }; return (data.RunProc(\INTO tb_admin (id,name,pwd) VALUES(@id,@name,@pwd)\ }
public int UpdateAdmin(AdminManage adminM) {
SqlParameter[] prams = {
data.MakeInParam(\ data.MakeInParam(\ };
return (data.RunProc(\tb_admin set pwd=@pwd where name=@name\prams)); }
public int DeleteAdmin(AdminManage adminM) {
SqlParameter[] prams = {
data.MakeInParam(\ };
return (data.RunProc(\ }
public DataSet Login(AdminManage adminM) {
SqlParameter[] prams = {
data.MakeInParam(\ data.MakeInParam(\ }; return (data.RunProcReturn(\* FROM tb_admin WHERE (name = @name) AND (pwd = @pwd)\ }
public DataSet GetAllAdminByName(AdminManage adminM, string tbName) {
SqlParameter[] prams = {
data.MakeInParam(\ };
return (data.RunProcReturn(\* from tb_admin where name like @name\prams, tbName)); }
public DataSet GetAdmin(string tbName) {
return (data.RunProcReturn(\* from tb_admin ORDER BY id\tbName)); } }
四、测试报告
完成人：
1. 概述(Summary)
1.1 项目简介(Project Synopsis)
该项目为简单的管理系统，主要实现图书借还处理，以及图书馆内的相关图书管理工作。目标是实现读者借还书的信息化，并且利用Internet网络实现读者与图书馆之间的互动和图书馆的人性化管理。
1.2 术语定义(Terms Glossary)
需求分析：在建立一个新的或改变一个现存的电脑系统时描写新系统的目的、范围、定义和功能时所要做的所有的工作。
系统设计：设计数据库的结构以及设计模块的控制流程，明确软件系统\如何做\。 需求规格说明书：经可行性研究后，对要求解的问题重新进行描述，使之更能准确地反映实际业务流程，导出并评价可供选择的解法，推荐行动方针。