memberaccess.cs

ASP.NET 2.0动态网站设计实例源代码,本书介绍了ASP.NET2.0的基础知识

///////////////////////////////////////////////////////////
//  MemberAccess.cs
//  Implementation of the Class MemberAccess
//  Generated by Enterprise Architect
//  Created on:      07-五月-2006 14:00:59
///////////////////////////////////////////////////////////




using BookShop.Entity;
using System.Data.SqlClient;
using System.Data;
using System;
namespace BookShop.DataAccess
{
  /// <summary>
  /// 与会员有关的数据操作
  /// </summary>
  public class MemberAccess
  {

    public MemberAccess()
    {

    }

    ~MemberAccess()
    {

    }

    public virtual void Dispose()
    {

    }

    /// <summary>
    /// 检查指定的用户名是否存在
    /// </summary>
    /// <param name="memberName"></param>
    public bool IsMemberNameExist(string memberName)
    {
      SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@MemberName",SqlDbType.NVarChar,30)
   };
      parms[0].Value = memberName;
      if (DbTools.ExecuteQuery("IsMembernameExist", parms).Tables[0].Rows.Count != 0)
        return true;
      else
        return false;
    }

    /// <summary>
    /// 登录用户
    /// </summary>
    /// <param name="member"></param>
    public bool Login(ref MemberEntity member)
    {
      if (!IsMemberNameExist(member.MemberName))
        return false;
      SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@MemberName",SqlDbType.NVarChar,30),
    new SqlParameter("@Password",SqlDbType.NVarChar,32)
   };
      parms[0].Value = member.MemberName;
      parms[1].Value = Common.md5(member.Password);

      DataSet ds = DbTools.ExecuteQuery("Login", parms);

      if (ds.Tables[0].Rows.Count != 0)
      {
        member.MemberID = Convert.ToInt32(ds.Tables[0].Rows[0]["MbID"]);
        member.Bonus = Convert.ToInt32(ds.Tables[0].Rows[0]["MbBonus"]);
        member.Delete = Convert.ToBoolean(ds.Tables[0].Rows[0]["MbDeleted"]);
        member.TrueName = Convert.ToString(ds.Tables[0].Rows[0]["MbTrueName"]);
        member.Email = Convert.ToString(ds.Tables[0].Rows[0]["MbEmail"]);
        if (member.Delete)
          return false;
        return true;
      }
      else
        return false;
    }

    /// <summary>
    /// 修改会员信息
    /// </summary>
    /// <param name="member"></param>
    public bool ModifyInfo(MemberEntity member)
    {
      SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@MemberID",SqlDbType.Int),
    new SqlParameter("@MbTrueName",SqlDbType.NVarChar,50),
    new SqlParameter("@Email",SqlDbType.NVarChar,200)
   };
      parms[0].Value = member.MemberID;
      parms[1].Value = member.TrueName;
      parms[2].Value = member.Email;

      if (DbTools.ExectueNoQuery("ModifyMemberInfo", parms) > 0)
        return true;
      else
        return false;
    }

    /// <summary>
    /// 修改密码
    /// </summary>
    /// <param name="member"></param>
    /// <param name="oldPwd"></param>
    /// <param name="newPwd"></param>
    public bool ModifyPassword(MemberEntity member, string oldPwd, string newPwd)
    {
      if (!Login(ref member))
        return false;
      SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@MemberID",SqlDbType.Int),
    new SqlParameter("@Password",SqlDbType.NVarChar,32)
   };
      parms[0].Value = member.MemberID;
      parms[1].Value = Common.md5(newPwd);
      if (DbTools.ExectueNoQuery("ModifyPassword", parms) > 0)
        return true;
      else
        return false;
    }

    /// <summary>
    /// 注册新用户
    /// </summary>
    /// <param name="member"></param>
    public bool Register(MemberEntity member)
    {
      if (IsMemberNameExist(member.MemberName))
        return false;
      else
      {
        SqlParameter[] parms = new SqlParameter[]{
     new SqlParameter("@MemberName",SqlDbType.NVarChar,30),
     new SqlParameter("@Password",SqlDbType.NVarChar,32),
     new SqlParameter("@MbTrueName",SqlDbType.NVarChar,50),
     new SqlParameter("@Email",SqlDbType.NVarChar,200)
    };
        parms[0].Value = member.MemberName;
        parms[1].Value = Common.md5(member.Password);
        parms[2].Value = member.TrueName;
        parms[3].Value = member.Email;
        if (DbTools.ExectueNoQuery("Register", parms) > 0)
          return true;
        else
          return false;
      }
    }

    /// <summary>
    /// 获取所有未被删除的会员列表
    /// </summary>
    public DataTable GetMemberList()
    {
      return DbTools.ExecuteQuery("GetMemberList").Tables[0];
    }

    /// <summary>
    /// 更新会员积分
    /// </summary>
    /// <param name="member"></param>
    public bool UpdateBonus(MemberEntity member)
    {
      SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@MemberID",SqlDbType.Int),
    new SqlParameter("@Bouns",SqlDbType.NVarChar,32)
   };
      parms[0].Value = member.MemberID;
      parms[0].Value = member.Bonus;
      if (DbTools.ExectueNoQuery("UpdateBouns", parms) > 0)
        return true;
      else
        return false;
    }

    /// <summary>
    /// 根据ID获取会员信息
    /// </summary>
    internal DataTable GetMemberByID(int p)
    {
      SqlParameter[] parms = new SqlParameter[]{
          new SqlParameter("@MemberID",SqlDbType.Int)
      };
      parms[0].Value = p;

      return DbTools.ExecuteQuery("GetMemberByID", parms).Tables[0];
    }
    /// <summary>
    /// 根据ID删除会员
    /// </summary>
    internal void DeleteMember(MemberEntity member)
    {
      SqlParameter[] parms = new SqlParameter[]{
          new SqlParameter("@MemberID",SqlDbType.Int)
      };
      parms[0].Value = member.MemberID;
      DbTools.ExectueNoQuery("DeleteMemberByID", parms);
    }
    /// <summary>
    /// 根据会员ID获取会员信息
    /// </summary>
    //internal DataTable GetMemberAddress(MemberEntity member)
    //{
    //  SqlParameter[] parms = new SqlParameter[]{
    //      new SqlParameter("@MemberID",SqlDbType.Int)
    //  };
    //  parms[0].Value = member.MemberID;
    //  return DbTools.ExecuteQuery("GetMemberAddress",parms).Tables[0];
    //}
  }//end MemberAccess

}//end namespace DataAccess