addressaccess.cs

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

///////////////////////////////////////////////////////////
//  AddressAccess.cs
//  Implementation of the Class AddressAccess
//  Generated by Enterprise Architect
//  Created on:      13-五月-2006 20:49:23
///////////////////////////////////////////////////////////




using BookShop.Entity;
using System.Data.SqlClient;
using System.Data;
using System;
namespace BookShop.DataAccess
{
  public class AddressAccess
  {

    public AddressAccess()
    {

    }

    ~AddressAccess()
    {

    }

    public virtual void Dispose()
    {

    }

    /// <summary>
    /// 添加地址信息
    /// </summary>
    /// <param name="address"></param>
    public bool AddAddress(MemberAddressEntity address)
    {
      if (GetAddressByMemberID(address.MemberID) != null)
      {
        return ModifyAddress(address);
      }
      else
      {

        SqlParameter[] parms = new SqlParameter[]{
            new SqlParameter("@MemberID",SqlDbType.Int,4),
            new SqlParameter("@ContactInfo",SqlDbType.NText)
           };
        parms[0].Value = address.MemberID;
        parms[1].Value = Common.SerializeIt(address);
        if (DbTools.ExectueNoQuery("AddAddress", parms) > 0)
          return true;
        else
          return false;
      }
    }

    /// 
    /// <param name="memberID"></param>
    public DataSet GetAddressByMemberID(int memberID)
    {
      SqlParameter[] parms = new SqlParameter[]{
        new SqlParameter("@MemberID",SqlDbType.Int,4)
        };
      parms[0].Value = memberID;
      return DbTools.ExecuteQuery("GetAddressByMemberID", parms);
      //if (ds.Tables[0].Rows.Count == 0)
      //  return null;
      //else
      //{
      //  string adressString = Convert.ToString(ds.Tables[0].Rows[0]["OaContactInfo"]);
      //  return (MemberAddressEntity)Common.DeserializeIt(adressString, typeof(MemberAddressEntity));
      //}
    }

    /// 
    /// <param name="address"></param>
    public bool ModifyAddress(MemberAddressEntity address)
    {
      SqlParameter[] parms = new SqlParameter[]{
        new SqlParameter("@MemberID",SqlDbType.Int,4),
        new SqlParameter("@ContactInfo",SqlDbType.NText)
       };
      parms[0].Value = address.MemberID;
      parms[1].Value = Common.SerializeIt(address);
      if (DbTools.ExectueNoQuery("ModifyAddressByMemberID", parms) > 0)
        return true;
      else
        return false;
    }

  }//end AddressAccess

}//end namespace DataAccess