1using System;
  2using System.Collections;
  3using System.Data;
  4using System.Data.SqlClient;
  5
  6using MyBookShop.DataAccessHelper;
  7using MyBookShop.DataAccessLayer;
  8//该源码下载自www.51aspx.com(5１ａｓｐｘ．ｃｏｍ)
  9
 10namespace MyBookShop.BusinessLogicLayer
 11...{
 12    /**//// <summary>
 13    /// Cart 的摘要说明。
 14    /// </summary>
 15    public class Cart
 16    ...{
 17        私有成员#region 私有成员
 18
 19        private int _cartId;        //购物篮ID
 20        private int _userId;        //用户ID
 21        private ArrayList _books=new ArrayList();        //购物篮中的购物篮ID集合
 22        private ArrayList _amount=new ArrayList();        //购物篮中购物篮的数量
 23
 24        private bool _exist;            //是否存在标志
 25
 26        #endregion 私有成员
 27
 28        属性#region 属性
 29        
 30        public int CartId
 31        ...{
 32            set
 33            ...{
 34                this._cartId=value;
 35            }
 36            get
 37            ...{
 38                return this._cartId;
 39            }
 40        }
 41        public int UserId
 42        ...{
 43            set
 44            ...{
 45                this._userId=value;
 46            }
 47            get
 48            ...{
 49                return this._userId;
 50            }
 51        }
 52        public ArrayList Books
 53        ...{
 54            set
 55            ...{
 56                this._books=value;
 57            }
 58            get
 59            ...{
 60                return this._books;
 61            }
 62        }
 63        public ArrayList Amount
 64        ...{
 65            set
 66            ...{
 67                this._amount=value;
 68            }
 69            get
 70            ...{
 71                return this._amount;
 72            }
 73        }
 74        
 75        public bool Exist
 76        ...{
 77            get
 78            ...{
 79                return this._exist;
 80            }
 81        }
 82
 83        #endregion 属性
 84
 85        方法#region 方法
 86        
 87        /**//// <summary>
 88        /// 根据参数userId，获取购物篮详细信息
 89        /// </summary>
 90        /// <param name="userId">用户ID</param>
 91        public void LoadData(int userId)
 92        ...{
 93            Database db=new Database();        //实例化一个Database类
 94
 95            string sql="";
 96            sql="Select * from [Cart] where UserID = "+ userId ;
 97
 98            SqlDataReader reader=db.GetDataReader(sql);    //利用Database类的GetDataRow方法查询用户数据
 99
100            //根据查询得到的数据，对成员安全赋值
101            while(reader.Read())
102            ...{
103                if(this._cartId==0)
104                ...{
105                    this._cartId=GetSafeData.ValidateDataReader_N(reader,"CartId");
106                    this._userId=GetSafeData.ValidateDataReader_N(reader,"UserId");    
107                }
108                this._books.Add(GetSafeData.ValidateDataReader_N(reader,"BookId"));
109                this._amount.Add(GetSafeData.ValidateDataReader_N(reader,"Amount"));
110                
111                this._exist=true;
112            }
113            if(this._cartId==0)
114            ...{
115                this._exist=false;
116            }
117        }
118
119        /**//// <summary>
120        /// 向数据库添加一个购物篮中的一种图书
121        /// </summary>
122        /// <param name="topicInfo">购物篮中的一种图书的信息哈希表</param>
123        public void Add(Hashtable cartInfo)
124        ...{
125            Database db=new Database();        //实例化一个Database类
126            db.Insert("[Cart]",cartInfo );    //利用Database类的Inser方法，插入数据
127        }
128
129        /**//// <summary>
130        /// 修改购物篮中的一种图书内容
131        /// </summary>
132        /// <param name="newCartInfo">新的购物篮信息哈希表</param>
133        /// <param name="condition">Update的Where子句</param>
134        public void Update(Hashtable newCartInfo,int cartId)
135        ...{
136            Database db=new Database();
137            string condition = "Where CartID = "+cartId.ToString();
138            db.Update("[Cart]",newCartInfo,condition);
139        }
140
141        /**//// <summary>
142        /// 删除整个购物篮
143        /// </summary>
144        public void Delete()
145        ...{
146            Database db=new Database();
147            string strSql="Delete From [Cart] Where CartID = "+this._cartId;
148            db.ExecuteSQL(strSql);
149        }
150
151        /**//// <summary>
152        /// 删除购物篮种某种图书
153        /// </summary>
154        /// <param name="cartId">将要删除购物篮的项目编号</param>
155        public void RemoveBook(int cartId)
156        ...{
157            Database db=new Database();
158            string strSql="Delete From [Cart] Where cartId = "+cartId.ToString();
159            db.ExecuteSQL(strSql);
160        }
161
162        /**//// <summary>
163        /// 查询userId的购物篮中的信息，并以DataTable返回
164        /// </summary>
165        /// <param name="userId">用户编号</param>
166        /// <returns>购物篮信息DataTable</returns>
167        public static DataTable Query(int userId)
168        ...{
169            string sql="";
170            sql="Select * From [Cart],[Book] Where [Cart].UserId = "+userId
171                +" And [Cart].bookId=[Book].bookId";
172            Database db=new Database();
173            return db.GetDataTable(sql);
174        }
175
176        #endregion 方法
177    }
178}
179