当前文件路径：MyShop/BLL/Order.cs

		            
  1using System;
  2using System.Collections.Generic;
  3
  4using System.Data;
  5
  6
  7using MyShop.DALFactory;
  8using MyShop.IDAL;
  9using MyShop.Model;
 10
 11namespace MyShop.BLL
 12...{
 13    public class Order
 14    ...{
 15        private IOrder dal = DataAccess.CreateOrder();
 16        
 17        IOrder#region IOrder
 18
 19
 20        /**//// <summary>
 21        /// 添加记录
 22        /// </summary>
 23        /// <param name="model"></param>
 24        /// <returns>返回刚插入的记录的orderId</returns>
 25        public int Add(OrderInfo model)
 26        ...{
 27            if (model == null)
 28            ...{
 29                return -1;
 30            }
 31            return dal.Add(model);
 32        }
 33
 34        public int Delete(string filter)
 35        ...{
 36            if (string.IsNullOrEmpty(filter))
 37                return 0;
 38            return dal.Delete(filter);
 39        }
 40
 41        public bool Exist(string filter)
 42        ...{
 43            filter = filter.Trim();
 44            if (string.IsNullOrEmpty(filter))
 45                return false;
 46            return dal.Exist(filter);
 47        }
 48        public DataSet GetDataSet()
 49        ...{
 50            return dal.GetDataSet();
 51        }
 52
 53        public DataSet GetDataSet(string filter)
 54        ...{
 55            filter = filter.Trim();
 56            if (string.IsNullOrEmpty(filter))
 57                return null;
 58            return dal.GetDataSet(filter);
 59        }
 60
 61        public OrderInfo GetModel(DataRow dr)
 62        ...{
 63            if (dr == null)
 64                return null;
 65            return dal.GetModel(dr);
 66        }
 67
 68        private DataSet Query(string sql)
 69        ...{
 70            sql = sql.Trim();
 71            if (string.IsNullOrEmpty(sql))
 72                return null;
 73            return dal.Query(sql);
 74        }
 75
 76        public int Update(OrderInfo model, string filter)
 77        ...{            
 78            if (model == null)
 79                return 0;
 80            filter = filter.Trim();
 81            if (string.IsNullOrEmpty(filter))
 82                return 0;
 83            return dal.Update(model, filter);
 84        }
 85
 86        #endregion
 87
 88        common#region common
 89
 90        public int Add(OrderInfo model, out string msg)
 91        ...{
 92            msg = "";
 93            if (model == null)
 94            ...{
 95                msg = "<li>数据不能为空</li>";
 96                return -1;
 97            }
 98            return Add(model);
 99        }
100
101        public int Delete(int orderId)
102        ...{
103            if ( string.IsNullOrEmpty( orderId.ToString()) )
104                return 0;
105            string filer;
106            filer = " orderId =" + orderId;
107            return Delete(filer);
108        }
109        public int Update(OrderInfo model)
110        ...{
111
112            if (model == null)
113            ...{
114                return 0;
115            }
116            string filter;
117            filter = " orderId=" + model.orderId;
118            return Update(model, filter);
119        }
120
121        public OrderInfo GetModel(int orderId)
122        ...{
123            DataSet dataset = new DataSet();
124            dataset = GetDataSet(" orderId=" + orderId);
125            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
126                return GetModel(dataset.Tables[0].Rows[0]);
127            return null;
128
129        }
130
131
132
133        #endregion  
134  
135        public DataSet GetDataSet(int userId)
136        ...{
137            string filter = "";
138            if (userId == -1)
139                return null;
140            filter = " [clientId]= " + userId;
141            return dal.GetDataSet(filter);
142        }
143        public DataSet GetDataSetByOrderNum(string orderNum)
144        ...{
145            if (orderNum == string.Empty)
146                return null;
147            string filter;
148            filter = " [orderNum]='" + orderNum + "'";
149            return dal.GetDataSet(" orderNum='" + orderNum + "'");
150        }
151        public OrderInfo GetModel(string orderNum)
152        ...{
153            if ( string.IsNullOrEmpty( orderNum ))
154                return null;
155            if (GetDataSetByOrderNum(orderNum).Tables[0].Rows.Count == 0)
156                return null;
157            return GetModel(GetDataSetByOrderNum(orderNum).Tables[0].Rows[0]);  
158        }
159
160        /**//// <summary>
161        /// 是否已付清
162        /// </summary>
163        /// <param name="orderId"></param>
164        /// <returns></returns>
165        public bool IsPaid(int orderId)
166        ...{
167            OrderInfo model = new OrderInfo();
168            Order order = new Order();
169            model = order.GetModel(orderId);
170            if (model == null)
171                return true; //订单号码错误，直接返回true
172            if (model.status == 3 || model.moneyTotal == model.MoneyReceipt )
173                return true;
174            else
175                return false;
176        }
177
178        /**//// <summary>
179        /// 是否已付清
180        /// </summary>
181        /// <param name="orderId"></param>
182        /// <returns></returns>
183        public bool IsPaid(string orderNum)
184        ...{
185            OrderInfo model = new OrderInfo();
186            Order order = new Order();
187            model = order.GetModel(orderNum);
188            if (model == null)
189                return true; //订单号码错误，直接返回true
190            if (model.status == 3 || model.moneyTotal == model.MoneyReceipt)
191                return true;
192            else
193                return false;
194        }
195
196        SearchOrder#region SearchOrder
197        /**//// <summary>
198        /// 快速搜索
199        /// </summary>
200        /// <param name="searchType"></param>
201        /// <returns></returns>
202        public DataSet QuickSearch(int searchType)
203        ...{
204            return dal.QuickSearch(searchType);
205
206        }
207
208        /**//// <summary>
209        /// 高级查询
210        /// </summary>
211        /// <param name="field"></param>
212        /// <param name="keywords"></param>
213        /// <returns></returns>
214        public DataSet KeywordsSearch(string field, string keywords)
215        ...{
216            field = Utils.ReplaceBadSQL(field.Trim());
217            keywords = Utils.ReplaceBadSQL(keywords.Trim());
218            if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords))
219                return null;
220            return dal.KeywordsSearch( field, keywords);
221        }
222
223        #endregion
224
225        public DataSet GetDataSetByProductId(int productId)
226        ...{
227            if(string.IsNullOrEmpty(productId.ToString()))
228                return null;
229            return GetDataSet(" productId =" + productId);
230        }
231
232        public DataSet GetDataSetByOrderId(int orderId)
233        ...{
234            DataSet dataset = new DataSet();
235            dataset = GetDataSet(" orderId=" + orderId);
236            return dataset;
237        }
238
239        ...#region 
240
241        public int DeleteOrderByOrderId(int orderId)
242        ...{
243            return dal.DeleteOrderByOrderId(orderId);
244        }
245
246        /**//// <summary>
247        /// 当订单结清时，赠送相应会员购物积分
248        /// </summary>
249        /// <param name="orderId"></param>
250        /// <returns></returns>
251        public int AddUserExp(int orderId)
252        ...{
253            return dal.AddUserExp(orderId);
254        }
255
256        public DataSet GetDataSetOrderByDate()
257        ...{
258           return dal.GetDataSetOrderByDate();
259        }
260        #endregion
261
262
263        /**//// <summary>
264        /// 获取今日订单
265        /// </summary>
266        /// <param name="userId"></param>
267        /// <returns></returns>
268        public  DataSet GetTodayOrder(int userId)
269        ...{
270
271            return dal.GetTodayOrder(userId);
272        }
273
274    }
275}
276