shopcartaccess.cs

来自「ASP.NET 2.0动态网站设计实例源代码,本书介绍了ASP.NET2.0的基」· CS 代码 · 共 69 行

///////////////////////////////////////////////////////////
//  ShopCartAccess.cs
//  Implementation of the Class ShopCartAccess
//  Generated by Enterprise Architect
//  Created on:      07-五月-2006 14:01:00
///////////////////////////////////////////////////////////
using BookShop.Entity;
using System.Data.SqlClient;
using System.Data;
using System;



namespace BookShop.DataAccess {
	/// <summary>
	/// 与购物车有关的数据操作
	/// </summary>
	public class ShopCartAccess {

		public ShopCartAccess(){

		}

		~ShopCartAccess(){

		}

		public virtual void Dispose(){

		}


		/// <summary>
		/// 将购物车保存在数据库中
		/// </summary>
		/// <param name="cart"></param>
		public bool SaveCart(ShopcartEntity cart){
   SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@MemberID",SqlDbType.Int),
    new SqlParameter("@Shopcart",SqlDbType.NText)
   };
   parms[0].Value = cart.MemberID;
   parms[1].Value = Common.SerializeIt(cart);

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

		/// <summary>
		/// 根据会员ID获取上次保存的购物车的序列化的字符串
		/// </summary>
		/// <param name="memberID"></param>
		public string GetCartByMemberID(int memberID){
   SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@MemberID",SqlDbType.Int)
   };
   parms[0].Value = memberID;
   DataSet ds = DbTools.ExecuteQuery("GetCartByMemberID", parms);
   if (ds.Tables[0].Rows.Count != 0)
    return Convert.ToString(ds.Tables[0].Rows[0]["ScShopCart"]);
   else
    return null;
		}

	}//end ShopCartAccess

}//end namespace DataAccess