母婴用品店会员管理系统

母婴用品店会员管理系统1.功能描述：1.1用户进入系统前必须进行身份认证（系统提供两种用户类型：店员，店长）。

1.2店员实现新增会员信息（会员信息：姓名，性别，电话，孩子姓名，孩子性别，孩子生日）。

1.3店员实现会员信息的展示和搜索（会员信息：姓名，性别，电话，积分，孩子姓名，孩子性别，孩子生日）。

1.4店员记录会员消费情况及积分的增加（消费金额，时间）。

1.5店员实现会员的赠品、赠劵的兑换。

（通过会员的ID或者姓名搜索可以兑换的赠品、赠劵）。

1.6店主可以修改删除会员信息（会员信息：姓名，性别，电话，积分，孩子姓名，孩子性别，孩子生日）。

1.7店主可以修改删除店员信息（店员信息：用户名，密码）。

1.8店主可以添加赠品、赠劵信息（名称、描述、图片、剩余数量）。

1.9店主可以查看、搜索、修改、删除赠品赠劵信息。

2.流程图3.用例图4.类图5.架构图6. 数据库表结构用户表：会员表：赠品表：消费记录表：兑换记录表：7.存储过程1.ALTER PROCEDURE [dbo].[AddExchangeRecord] (@strMemName nvarchar(20),@strUserIntegral int,@strGetGift nvarchar(20),@strERTime datetime)ASBEGININSERT INTO dbo.ExchangeRecord([MemName],[UseIntegral],GiftName,[ERTime])VALUES(@strMemName,@strUserIntegral,@strGetGift,@strERTime)END2.ALTER PROCEDURE [dbo].[AddExpenseRecord] (@strMemName nvarchar(20),@strUseRmb float,@strGetIntegral int,@strDTime datetime)ASBEGININSERT INTO dbo.ExpenseRecord(MemName,UseRMB,GetIntegral,DTime)VALUES(@strMemName,@strUseRmb,@strGetIntegral,@strDTime)END3.ALTER PROCEDURE [dbo].[GetMemInfoByName] (@strName nvarchar(20))ASBEGINSELECT*FROM [MemberManagementSystem].[dbo].[MemberInfo] where MemName=@strNameEND4.ALTER PROCEDURE [dbo].[AddGiftInfo](@strGName nvarchar(20),@strNum int,@strDescribe nvarchar(50),@strIntegral int,@strImgPath nvarchar(200))ASBEGININSERT INTO [MemberManagementSystem].[dbo].[GiftInfo] ([GiftName],[GiftNum],[describe],[RequiredIntegral],[ImgPath])VALUES(@strGName,@strNum,@strDescribe,@strIntegral,@strImgPath)END5.ALTER PROCEDURE [dbo].[AlterGiftInfo](@strGName nvarchar(20),@StrNewGName nvarchar(20),@strNum int,@strDescribe nvarchar(50),@strIntegral int)ASBEGINUPDATE [MemberManagementSystem].[dbo].[GiftInfo]SET [GiftName] = @StrNewGName,[GiftNum] = @strNum,[describe] = @strDescribe,[RequiredIntegral] = @strIntegralWHERE [GiftName]=@strGNameEND6.ALTER PROCEDURE [dbo].[AlterMember](@MemName nvarchar(20),@NewMemName nvarchar(20),@Sex char(2),@Tel nvarchar(20),@Address nvarchar(200),@ChildName nvarchar(20),@ChildSex char(2),@ChildBirthday datetime)ASBEGINUPDATE [MemberManagementSystem].[dbo].[MemberInfo] SET [MemName] = @NewMemName,[sex] = @Sex,[Tel] = @Tel,ImgPath = @Address,[ChildName] = @ChildName,[ChildSex] = @ChildSex,ChildBirthday = @ChildBirthdayWHERE MemName=@MemNameEND7.ALTER PROCEDURE [dbo].[AlterUser](@UserName nvarchar(20),@NewUserName nvarchar(20),@Pwd nvarchar(20),@Type nvarchar(20))ASBEGINUPDATE [MemberManagementSystem].[dbo].[UserInfo] SET [UserName] = @NewUserName,[Password] = @PwdWHERE [UserName]=@UserName and UserType=@TypeENDALTER PROCEDURE [dbo].[GetGiftInfoAndMemberInfoByName] (@strName nvarchar(20))ASBEGINselect*from dbo.MemberInfo mi join dbo.GiftInfo gion mi.Integral>=gi.RequiredIntegralwhere MemName=@strNameEND8.ALTER PROCEDURE [dbo].[UpdateIntegral](@strMemName nvarchar(20),@strIntegral int)ASBEGINUPDATE [MemberManagementSystem].[dbo].[MemberInfo] SET [Integral] = @strIntegral+[Integral]WHERE MemName=@strMemNameEND9.ALTER PROCEDURE [dbo].[DelGift](@strName nvarchar(20))ASBEGINDELETE FROM [MemberManagementSystem].[dbo].[GiftInfo] WHERE GiftName=@strNameEND10.ALTER PROCEDURE [dbo].[DelMember](@strMemName nvarchar(20))ASBEGINDELETE FROM [MemberManagementSystem].[dbo].[MemberInfo]WHERE MemName=@strMemNameEND11.ALTER PROCEDURE [dbo].[DelUser](@strUserName nvarchar(20))ASBEGINDELETE FROM erInfoWHERE UserName=@strUserNameEND12.ALTER PROCEDURE [dbo].[GetAllGiftInfo]ASBEGINSELECT*FROM [MemberManagementSystem].[dbo].[GiftInfo]END13.ALTER PROCEDURE [dbo].[GetAllMember]ASBEGINSELECT*FROM [MemberManagementSystem].[dbo].[MemberInfo] END14.ALTER PROCEDURE [dbo].[GetAllUserInfo]ASBEGINSELECT*FROM erInfoEND15.ALTER PROCEDURE [dbo].[GetGiftByIntegral](@strIntegral int)ASBEGINSELECT*FROM [MemberManagementSystem].[dbo].[GiftInfo]where RequiredIntegral=@strIntegralEND16.ALTER PROCEDURE [dbo].[GetMemInfoByMemName](@strMemName nvarchar(20))ASBEGINSELECT*FROM [MemberManagementSystem].[dbo].[MemberInfo]where MemName=@strMemNameEND17.ALTER PROCEDURE [dbo].[GetRecordByName](@strName nvarchar(20))ASBEGINselect ERTime,GiftName,UseIntegral,DTime,UseRMB,GetIntegral from dbo.ExchangeRecord ecr join dbo.ExpenseRecord exron ecr.MemName=exr.MemNamewhere ecr.MemName=@strNameEND18.ALTER PROCEDURE [dbo].[GetUserInfoByUName](@strUName nvarchar(20))ASBEGINSELECT*FROM erInfowhere UserName=@strUNameEND19.ALTER PROCEDURE [dbo].[InsertMember](@strMemName nvarchar(20),@strsex char(2),@strTel nvarchar(20),@strImgPath nvarchar(200),@strChildName nvarchar(20),@strChildSex char(2),@strChildBirdthday datetime)ASBEGININSERT INTO [MemberManagementSystem].[dbo].[MemberInfo] ([MemName],[sex],[Tel],ImgPath,[ChildName],[ChildSex],[ChildBirthday])VALUES(@strMemName,@strsex,@strTel,@strImgPath,@strChildName,@strChildSex,@strChildBirdthday)END20.ALTER PROCEDURE [dbo].[Login](@strName nvarchar(20),@strPwd nvarchar(20),@strType nvarchar(20))ASBEGINSELECT*FROM [MemberManagementSystem].[dbo].[UserInfo] where UserName=@strName and Password=@strPwd and UserType=@strTypeEND8.公共类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>/// Sqloperate 的摘要说明///</summary>public class SqlClass{bool f = false;public SqlClass(){//// TODO: 在此处添加构造函数逻辑//}//sqlconnnectionpublic SqlConnection GetDB(){SqlConnection con = newSqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["sqllink"].Co nnectionString);con.Open();return con;}//获取数据并转为数据源wpublic PagedDataSource getpage(string sql){PagedDataSource ps = new PagedDataSource();SqlDataAdapter MyAdapter = new SqlDataAdapter(sql, GetDB());DataSet ds = new DataSet();MyAdapter.Fill(ds, "message");ps.DataSource = ds.Tables["message"].DefaultView;ps.AllowPaging = true;ps.PageSize = 5;return ps;}//修改、插入数据public bool inupde(string sql){try{SqlCommand cmd = new SqlCommand(sql, GetDB());try{cmd.ExecuteNonQuery();f = true;}catch{ }GetDB().Close();}catch{ }return f;}//获取一个DataTablepublic DataTable dt(string sqlstring){SqlDataAdapter sda = new SqlDataAdapter(sqlstring, GetDB());DataSet ds = new DataSet();sda.Fill(ds, "table");GetDB().Close();return ds.Tables["table"];}//获取DataSetpublic DataSet ds(string sqlstring){SqlDataAdapter sda = new SqlDataAdapter(sqlstring, GetDB());DataSet ds = new DataSet();sda.Fill(ds, "table");GetDB().Close();return ds;}//登录public bool denglu(string sqltring){try{SqlCommand cmd = new SqlCommand(sqltring, GetDB());SqlDataReader dr = cmd.ExecuteReader();if (dr.Read()){f = true;}GetDB().Close();}catch{}return f;}}9.分页公共类using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;///<summary>///PageNums 的摘要说明///</summary>public class PageNums{///</summary>///<param name="ds">DataSet实例</param>///<param name="datalistname">DataList名称</param>///<param name="pagesize">分页大小</param>public static string GetPageNum(DataSet ds, DataList datalistname, int pagesize) {PagedDataSource objPds = new PagedDataSource();objPds.DataSource = ds.Tables[0].DefaultView;objPds.AllowPaging = true;int total = ds.Tables[0].Rows.Count;objPds.PageSize = pagesize;int page;if (HttpContext.Current.Request.QueryString["page"] != null) page = Convert.ToInt32(HttpContext.Current.Request.QueryString["page"]);elsepage = 1;objPds.CurrentPageIndex = page - 1;datalistname.DataSource = objPds;datalistname.DataBind();int allpage = 0;int next = 0;int pre = 0;int startcount = 0;int endcount = 0;string pagestr = "";if (page < 1) { page = 1; }//计算总页数if (pagesize != 0){allpage = (total / pagesize);allpage = ((total % pagesize) != 0 ? allpage + 1 : allpage);allpage = (allpage == 0 ? 1 : allpage);}next = page + 1;pre = page - 1;startcount = (page + 5) > allpage ? allpage - 9 : page - 4;//中间页起始序号//中间页终止序号endcount = page < 5 ? 10 : page + 5;if (startcount < 1) { startcount = 1; } //为了避免输出的时候产生负数，设置如果小于1就从序号1开始if (allpage < endcount){ endcount = allpage; } //页码+5的可能性就会产生最终输出序号大于总页码，那么就要将其控制在页码数之内pagestr = "<a >"+"共" + allpage + "页</a>&nbsp;&nbsp;&nbsp;&nbsp;";pagestr += page > 1 ? "<a href=\"" +HttpContext.Current.Request.CurrentExecutionFilePath + "?page=1\">首页</a>&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + pre + "\">上一页</a>" : "<a>首页</a>" + "&nbsp;&nbsp;" + "<a>上一页</a>";//中间页处理，这个增加时间复杂度，减小空间复杂度for (int i = startcount; i <= endcount; i++){pagestr += page == i ? "&nbsp;&nbsp;" +"<a class=\"cpb\">"+ i + "</a>" : "&nbsp;&nbsp;<a href=\""+ HttpContext.Current.Request.CurrentExecutionFilePath + "?page="+ i + "\">" + i + "</a>";}pagestr += page != allpage ? "&nbsp;&nbsp;<a href=\"" +HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + next + "\">下一页</a>&nbsp;&nbsp;<a href=\"" + HttpContext.Current.Request.CurrentExecutionFilePath + "?page=" + allpage + "\">末页</a>" : "&nbsp;&nbsp;" + "<a >下一页</a>" + "&nbsp;&nbsp;" + "<a >末页</a>";return pagestr;}}10.业务逻辑类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>/// OperateClass 的摘要说明///</summary>public class OperateClass{SqlClass sqlc = new SqlClass();public OperateClass(){//// TODO: 在此处添加构造函数逻辑//}//登陆public bool Login(string strUserName,string strPwd,string strType){string strsql = "Login'"+strUserName+"','"+strPwd+"','"+strType+"'";return sqlc.denglu(strsql);}//会员注册public bool InsertMember(string strMemName,string strsex,string strTel,string strImgPath,string strChildName,string strChildSex,DateTime strbirthday){string strsql = "InsertMember'" + strMemName + "','" + strsex + "','" + strTel + "','"+ strImgPath + "','"+ strChildName + "','"+ strChildSex + "','"+ strbirthday + "'";return sqlc.inupde(strsql);}//删除会员public bool DelMember(string strMemName){string strsql="DelMember'"+strMemName+"'";return sqlc.inupde(strsql);}//修改会员public bool AlterMember(string strMemName,string strNewName, string strsex,string strtel,string strImgPath,string ChildName,string ChildSex,DateTime strChildBirthday){string strsql = "AlterMember'" + strMemName + "','" + strNewName + "','" + strsex + "','" + strtel + "','" + strImgPath + "','" + ChildName + "','" + ChildSex + "','" + strChildBirthday + "'";return sqlc.inupde(strsql);}//删除店员public bool DelUser(string strUserName){string sql = "DelUser'"+strUserName+"'";return sqlc.inupde(sql);}//修改店员public bool AlterUser(string strUserName,string strNewName, string strPwd,string StrType){string sql = "AlterUser'"+ strUserName + "','"+ strNewName + "','"+ strPwd + "','" + StrType + "'";return sqlc.inupde(sql);}//获取所有店员信息public DataSet GetAllUserInfo(){string sql = "GetAllUserInfo";return sqlc.ds(sql);}//通过用户名获取店员信息public DataSet GetUserInfoByUName(string strUName){string sql = "GetUserInfoByUName'"+strUName+"'";return sqlc.ds(sql);}//获取所有会员信息public DataSet GetAllMember(){string strsql = "GetAllMember";return sqlc.ds(strsql);}//根据名字获取会员信息public DataSet GetMemberByName(string strname){string strsql = "GetMemInfoByName'" + strname + "'";return sqlc.ds(strsql);}//添加消费记录public bool AddExpenseRecord(string strName, float strRmb, int strGetIntegral,DateTime strDtime){string strsql ="AddExpenseRecord'"+strName+"','"+strRmb+"','"+strGetIntegral+"','"+strDtime+"'";return sqlc.inupde(strsql);}//更新积分public bool UpdateIntegral(string strMemName,int strIntegral){string strsql = "UpdateIntegral'"+strMemName+"','"+strIntegral+"'";return sqlc.inupde(strsql);}//添加会员兑换记录public bool AddEchangRecord(string strMemName, int strUserIntegral, string strGetGift, DateTime strERTime){string strsql = "AddExchangeRecord'"+ strMemName + "','"+ strUserIntegral + "','" + strGetGift + "','" + strERTime + "'";return sqlc.inupde(strsql);}//根据积分获取可兑换赠品public PagedDataSource GetGiftByIntegral(int strIntegral){string strsql = "GetGiftByIntegral'"+strIntegral+"'";return sqlc.getpage(strsql);}//获取所有赠品信息public DataSet GetAllGiftInfo(){string strsql = "GetAllGiftInfo";return sqlc.ds(strsql);}//通过姓名获取会员信息及可兑换的赠品信息public DataSet GetMemInfoAndGiftInfoByName(string strName){string strsql = "GetGiftInfoAndMemberInfoByName'"+strName+"'";return sqlc.ds(strsql);}//添加赠品信息public bool AddGiftInfo(string strName,int strNum,string strDescribe,int strIntegral,string strImgPath){string sql ="AddGiftInfo'"+strName+"','"+strNum+"','"+strDescribe+"','"+strIntegral+"','"+strImgPat h+"'";return sqlc.inupde(sql);}//修改赠品信息public bool AlterGiftInfo(string strName,string strNewName,int strNum,string strDescribe,int strIntegral){string sql = "AlterGiftInfo'"+ strName + "','"+ strNewName + "','"+ strNum + "','"+ strDescribe + "','" + strIntegral + "'";return sqlc.inupde(sql);}//删除赠品信息public bool DelGift(string strName){string sql = "DelGift'"+strName+"'";return sqlc.inupde(sql);}//通过姓名获取记录public DataSet GetRecordByName(string strName){string sql = "GetRecordByName'"+strName+"'";return sqlc.ds(sql);}}11.模板页一模板Css代码：body{ margin:0px; font-family:"楷体"; font-size:14px; background-color:#792A30;}.body{ width:900px; height:700px; margin:0auto; background-color:#fcf9f9;margin-left:150px; background:url(Img/shopmanager.png)no-repeat;}.daohang{ width:150px; height:150px; font-family:"楷体"; font-size:14px; line-height:35px;margin-top:48px; margin-left:10px; text-align:center; color:#993300; float:left;}.daohang_one{ width:148px; height:35px; font-family:"楷体"; font-size:14px;text-align:center; margin:1px auto1px auto; line-height:35px;}.daohang_one a{ color:#993300; font-family:"楷体"; font-size:14px; text-decoration:none; }.daohang_one a:hover{ width:148px; height:35px; font-family:"楷体"; font-size:14px;line-height:35px; display:block; color:White; background:#F6A918;}.daohang_one a:visited{ color:#000;}.content{ width:700px; height:450px; float:right; margin-right:8px; margin-top:125px;}.Btn{ width:50px; height:20px;}.paginator { font: 11px Arial,Helvetica,sans-serif;padding:10px20px10px0; margin: 0px;}.paginator a {padding: 1px6px; border: solid1px#ddd; background: #fff;text-decoration: none;margin-right:2px}.paginator a:visited {padding: 1px6px; border: solid1px#ddd; background: #fff;text-decoration: none;}.paginator.cpb {padding: 1px6px;font-weight: bold; font-size: 13px;border:none} .paginator a:hover {color: #fff; background:#ffa501;border-color:#ffa501;text-decoration: none;}.anpager { font: 11px Arial,Helvetica,sans-serif;margin:5px4px00;padding:4px5px0;}.anpager.cpb {background:#1F3A87;border:1px solid#CCCCCC;color:#FFFFFF;font-weight:bold;margin:0;padding:4px5px1px;}.anpager a {background:#FFFFFF;border:1px solid#CCCCCC;color:#1F3A87;margin: 0;padding:4px5px1px;text-decoration:none}.anpager a:hover{background:#1F3A87;border:1px solid#1F3A87;color:#FFFFFF;}.pages { color: #999; }.pages a, .pages.cpb { text-decoration:none;float: left; padding: 05px; border: 1px solid#ddd;background: #ffff;margin:02px; font-size:11px; color:#000;} .pages a:hover { background-color: #E61636; color:#fff;border:1px solid#E61636; text-decoration:none;} .pages.cpb { font-weight: bold; color: #fff; background: #E61636; border:1px solid#E61636;}代码：<%@Master Language="C#"AutoEventWireup="true"CodeFile="MasterPage.master.cs"Inherits="MasterPage" %><!DOCTYPE html PUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type"content="text/html; charset=gb2312"/><title></title><link href="MemberExpense.css"rel="stylesheet"type="text/css"/></head><body><form runat="server"><div class="body"><div class="daohang"><div class="daohang_one"><a href="MemberInfo.aspx">会员信息</a></div><div class="daohang_one"><a href="AddMember.aspx">新增会员</a></div><div class="daohang_one"><a href="MemberExpense.aspx">会员消费</a></div><div class="daohang_one"><a href="GiftExchange.aspx">赠品兑换</a></div> </div><div style="width:60px; height:30px; float:right; margin-top:10px"><ahref="default.aspx">退出系统</a></div><div class="content"><asp:contentplaceholder id="ContentPlaceHolder1"runat="server"></asp:contentplaceholder></div></div></form></body></html>12.模板页二代码：<%@Master Language="C#"AutoEventWireup="true"CodeFile="MasterPage2.master.cs"Inherits="MasterPage2" %><!DOCTYPE html PUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="/1999/xhtml"><head><meta http-equiv="Content-Type"content="text/html; charset=gb2312"/><title></title><link href="MemberExpense.css"rel="stylesheet"type="text/css"/></head><body><form id="Form1"runat="server"><div class="body"><div class="daohang"><div class="daohang_one"><a href="MemberManage.aspx">会员管理</a></div><div class="daohang_one"><a href="ClerkManager.aspx">店员管理</a></div><div class="daohang_one"><a href="GiftAdd.aspx">赠品管理</a></div> </div><div style="width:60px; height:30px; float:right; margin-top:10px"><a href="default.aspx">退出系统</a></div><div class="content"><asp:contentplaceholder id="ContentPlaceHolder1"runat="server"></asp:contentplaceholder></div></div></form></body></html>13.登录界面Css代码：@charset "utf-8";/* CSS Document */.body{ width:700px; height:350px; margin:0auto; background-color:#ffffcc;}.image{ width:340px; height:300px; float:left; margin:25px025px5px;background-image:url(Img/dengluimg.png); background-repeat:no-repeat; float:left;}.denglukuang{ width:339px; height:300px; float:right;background-image:url(Img/dengluimgs.png); background-repeat:no-repeat; margin:25px10px 25px0; font-size:14px; font-weight:bold;}.denglu_top{ width:210px; height:18px; float:left; margin:5px008px; text-align:center;} .top_line{ width:325px; height:1px; margin:25px005px;}.denglu_biaoge{ width:325px; height:230px; margin:10px005px; text-align:center;}.down_line{ width:325px; height:1px; margin:0005px;}后台代码：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;public partial class_Default : System.Web.UI.Page{OperateClass oc = new OperateClass();protected void Page_Load(object sender, EventArgs e){}protected void BtnLogin_Click(object sender, EventArgs e){string strName=TbName.Text.Trim();string strPwd = TbPwd.Text.Trim();string strType = "";if (strName == "" || strPwd == ""){Response.Write("<script>alert('用户名和密码不能为空！');location.href('Default.aspx')</script>");}else if (RadioButton1.Checked==true || RadioButton2.Checked==true) {if (RadioButton1.Checked == true) //店员{strType = RadioButton1.Text;bool b = oc.Login(strName, strPwd, strType);if (b == true){Response.Write("<script>alert('登录成功！');location.href('MemberInfo.aspx')</script>");}else{//Response.Write(strName+strPwd+strType);Response.Write("<script>alert('用户名或密码错误！');location.href('Default.aspx')</script>");}}else if(RadioButton2.Checked==true) //店长{strType = RadioButton2.Text;bool b = oc.Login(strName, strPwd, strType);if (b == true){Response.Write("<script>alert('登录成功！');location.href('MemberManage.aspx')</script>");}else{//Response.Write(strName+strPwd+strType);Response.Write("<script>alert('用户名或密码错误！');location.href('Default.aspx')</script>");}}}else{Response.Write("<script>alert('请选择用户类型！');location.href('Default.aspx')</script>");}}protected void BtnCancel_Click(object sender, EventArgs e) {}}14.会员信息页面代码using System;using System.Data;using System.Configuration;using System.Collections;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;public partial class MemberInfo : System.Web.UI.Page{OperateClass oc = new OperateClass();DataSet ds;protected void Page_Load(object sender, EventArgs e){ds= oc.GetAllMember();this.PageInfo.InnerHtml = PageNums.GetPageNum(ds, DataList1, 3); //传入DataSet,DataList名称和分页大小}protected void BtnSearch_Click(object sender, EventArgs e){string strName = TbName.Text.Trim();ds = oc.GetMemberByName(strName);this.PageInfo.InnerHtml = PageNums.GetPageNum(ds, DataList1, 3); //传入DataSet,DataList名称和分页大小}15.查看消费兑换记录后台代码：using System;using System.Data;using System.Configuration;using System.Collections;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;public partial class GetRecordByName : System.Web.UI.Page{OperateClass oc = new OperateClass();DataSet ds;protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){Label1.Text = Request.Params["Name"].ToString();ds = oc.GetRecordByName(Label1.Text);this.PageInfo.InnerHtml = PageNums.GetPageNum(ds, DataList1, 6); //传入DataSet,DataList名称和分页大小}}16.新增会员代码：using System;using System.Data;using System.Configuration;using System.Collections;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;public partial class AddMember : System.Web.UI.Page{OperateClass oc = new OperateClass();protected void Page_Load(object sender, EventArgs e){}//上传头像protected void BtnUploading_Click(object sender, EventArgs e) {string uploadName = InputFile.Value;//获取待上传图片的完整路径，包括文件名string pictureName = "";//上传后的图片名，以当前时间为文件名，确保文件名没有重复if (InputFile.Value != ""){int idx = stIndexOf(".");string suffix = uploadName.Substring(idx);//获得后缀名pictureName = DateTime.Now.Ticks.ToString() + suffix;}try{if (uploadName != ""){string path = Server.MapPath("~/images/");InputFile.PostedFile.SaveAs(path + pictureName);Label1.Text = "头像上传成功！" ;Label2.Text = "~/images/" + pictureName;}}catch (Exception ex){Response.Write(ex.ToString());}}//确定protected void BtnOK_Click(object sender, EventArgs e){string strName = TbName.Text.Trim();string strSex="";string strTel=TbTel.Text.Trim();string strImgPath = Label2.Text;string strChildName = TbChildName.Text.Trim();string strChildSex="";DateTime strBirthday = Convert.ToDateTime(DDLYear.Text + "-"+ DDLMonth.Text + "-" + DDLDay.Text);if (RBtnsex1.Checked == true){strSex = RBtnsex1.Text;}else if(RBtnSex2.Checked==true){strSex = RBtnSex2.Text;}if (RBtnsex3.Checked == true)。