OleDbDAL/cart.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using ClothesShop.DBUtility;
using System.Data;


namespace ClothesShop.OleDbDAL
{
    public class cart:ClothesShop.IDAL.Icart
    {
        /// <summary>
        /// 添加到购物车
        /// </summary>
        /// <param name="product"></param>
        /// <param name="count"></param>
        /// <param name="checkout"></param>
        /// <returns></returns>
        public int createcart(int productid,int userid, int count, bool checkout)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("insert into cart (productid,[userid],[count],checkout) ");
            sb.Append("values (@productid,@userid,@count,@checkout)");
            OleDbParameter[] parem =
                                   {
                                       OleDbHelper.GetParameter("@productid",OleDbType.Integer,4,"productid",productid),
                                       OleDbHelper.GetParameter("@userid",OleDbType.Integer,4,"[userid]",userid),
                                       OleDbHelper.GetParameter("@count",OleDbType.Integer,4,"[count]",count),
                                       OleDbHelper.GetParameter("@checkout",OleDbType.Boolean,1,"checkout",checkout)
                                   };
            return OleDbHelper.ExecuteSql(sb.ToString(), parem);
        }

        /// <summary>
        /// 删除一件商品
        /// </summary>
        /// <param name="cartid"></param>
        /// <returns></returns>
        public int deletecart(int cartid)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("delete from cart where cartid=@cartid");
            OleDbParameter[] param = { OleDbHelper.GetParameter("@cartid", OleDbType.Integer, 4, "cartid", cartid) };
            return OleDbHelper.ExecuteSql(sb.ToString(), param);
        }

        /// <summary>
        /// 批量删除商品
        /// </summary>
        /// <param name="cartids"></param>
        /// <returns></returns>
        public int deltecartlist(int[] cartids)
        {
            List<OleDbParameter []> paramlist = new List<OleDbParameter []>();
            List<string> sqls = new List<string>();
            for (int i = 0; i < cartids.Length; i++)
            {
                sqls.Add("delete from cart where cartid=@cartid" + i.ToString());
                OleDbParameter[] param = { OleDbHelper.GetParameter("@cartid" + i.ToString(), OleDbType.Integer, 4, "cartid", cartids[i]) };