软件工程实验(6)

2019-09-01 11:45

{

foreach (SqlParameter parameter in prams) cmd.Parameters.Add(parameter); }

// 加入返回参数 cmd.Parameters.Add(

new SqlParameter(\ ParameterDirection.ReturnValue, false, 0, 0, string.Empty, DataRowVersion.Default, null));

return cmd; }

#endregion } }

2 读者信息（Module Name）

2.1 描述（Description）读者信息的编码实现 2.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 ReaderManage {

DataBase data = new DataBase(); private string id; private string name; private string sex; private string type ; private DateTime birthday Convert.ToDateTime(DateTime.Now.ToShortDateString()); private string papertype;

private string papernum; private string tel; private string email; private DateTime createdate Convert.ToDateTime(DateTime.Now.ToShortDateString()); private string operater; private string remark; private int borrownum = 0; private int num = 0;

public ReaderManage() {

// TODO: 在此处添加构造函数逻辑 // }

public string ID {

get { return id; } set { id = value; } }

public string Name {

get { return name; } set { name = value; } }

public string Sex {

get { return sex; } set { sex = value; } }

public string Type {

get { return type; } set { type = value; } }

public DateTime Birthday {

get { return birthday; } set { birthday = value; } }

public string PaperType {

get { return papertype; } set { papertype = value; } }

public string PaperNum {

get { return papernum; } set { papernum = value; } }

public string Tel {

get { return tel; } set { tel = value; } }

public string Email {

get { return email; } set { email = value; } }

///

/// 等级日期 ///

public DateTime CreateDate {

get { return createdate; } set { createdate = value; } }

public string Operater {

get { return operater; } set { operater = value; } }

public string Remark {

get { return remark; } set { remark = value; } }

public int BorrowNum {

get { return borrownum; } set { borrownum = value; } }

public int Num {

get { return num; } set { num = value; } }

public string GetReaderID() {

DataSet ds = GetAllReader(\ 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 AddReader(ReaderManage readermanage) {

SqlParameter[] prams = {

data.MakeInParam(\ data.MakeInParam(\ SqlDbType.VarChar, 50,readermanage.Name ),

data.MakeInParam(\ data.MakeInParam(\ SqlDbType.VarChar, 50, readermanage.Type ),

data.MakeInParam(\ SqlDbType.DateTime, 8, readermanage.Birthday ),

data.MakeInParam(\ SqlDbType.VarChar, 20, readermanage.PaperType ),

data.MakeInParam(\ SqlDbType.VarChar, 30, readermanage.PaperNum ),

data.MakeInParam(\ data.MakeInParam(\ SqlDbType.VarChar, 50, readermanage.Email),

data.MakeInParam(\ SqlDbType.DateTime, 8, readermanage.CreateDate ),

data.MakeInParam(\ SqlDbType.VarChar, 30, readermanage.Operater ),

data.MakeInParam(\ SqlDbType.VarChar, 4000, readermanage.Remark ), }; return (data.RunProc(\INTO tb_reader(id,name,sex,type,birthday,paperType,paperNum,tel,email,createDate,operater,remark) \ + \(@id,@name,@sex,@type,@birthday,@papertype,@papernum,@tel,@email,@createdate,@operater,@remark)\ }

public int UpdateReader(ReaderManage readermanage) {