当前文件路径：MyShop/BLL/OrderItem.cs 
1
using System;
2using System.Collections.Generic;
3
4using System.Data;
5
6using MyShop.DALFactory;
7using MyShop.IDAL;
8using MyShop.Model;
9
10namespace MyShop.BLL
11
...{
12
public class OrderItem
13
...{
14 private IOrderItem dal = DataAccess.CreateOrderItem();
15
16 private ConfigInfo configInfo = new ConfigInfo();
17 private string tableName = "Ljh_OrderItems";
18 public OrderItem()
19 ...{
20 Config config = new Config();
21 configInfo = config.GetModel();
22 if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
23 tableName = configInfo.TablePrefix + "OrderItems";
24
}
25
26 IOrderItem#region IOrderItem
27
28
29 /**//// <summary>
30 /// 添加记录
31 /// </summary>
32 /// <param name="model"></param>
33 /// <returns>返回刚插入的记录的itemId</returns>
34 public int Add(OrderItemInfo model)
35 ...{
36 if (model == null)
37 ...{
38 return 0;
39 }
40 return dal.Add(model);
41 }
42
43 public int Delete(string filter)
44 ...{
45 if (string.IsNullOrEmpty(filter))
46 return 0;
47 return dal.Delete(filter);
48 }
49
50 public bool Exist(string filter)
51 ...{
52 filter = filter.Trim();
53 if (string.IsNullOrEmpty(filter))
54 return false;
55 return dal.Exist(filter);
56 }
57 public DataSet GetDataSet()
58 ...{
59 return dal.GetDataSet();
60 }
61
62 public DataSet GetDataSet(string filter)
63 ...{
64 filter = filter.Trim();
65 if (string.IsNullOrEmpty(filter))
66 return null;
67 return dal.GetDataSet(filter);
68 }
69
70 public OrderItemInfo GetModel(DataRow dr)
71 ...{
72 if (dr == null)
73 return null;
74 return dal.GetModel(dr);
75 }
76
77 private DataSet Query(string sql)
78 ...{
79 sql = sql.Trim();
80 if (string.IsNullOrEmpty(sql))
81 return null;
82 return dal.Query(sql);
83 }
84
85 public int Update(OrderItemInfo model, string filter)
86 ...{
87 if (model == null)
88 return 0;
89 filter = filter.Trim();
90 if (string.IsNullOrEmpty(filter))
91 return 0;
92 return dal.Update(model, filter);
93 }
94
95 #endregion
96
97 common#region common
98
99 public int Add(OrderItemInfo model, out string msg)
100 ...{
101 msg = "";
102 if (model == null)
103 ...{
104 msg = "<li>数据不能为空</li>";
105 return 0;
106 }
107 return Add(model);
108 }
109
110 public int Delete(int itemId)
111 ...{
112 if (string.IsNullOrEmpty(itemId.ToString()))
113 return 0;
114 string filer;
115 filer = " itemId =" + itemId;
116 return Delete(filer);
117 }
118 public int Update(OrderItemInfo model)
119 ...{
120
121 if (model == null)
122 ...{
123 return 0;
124 }
125 string filter;
126 filter = " itemId=" + model.ItemId;
127 return Update(model, filter);
128 }
129
130 public OrderItemInfo GetModel(int itemId)
131 ...{
132 DataSet dataset = new DataSet();
133 dataset = GetDataSet(" itemId=" + itemId);
134 if (dataset != null && dataset.Tables[0].Rows.Count > 0)
135 return GetModel(dataset.Tables[0].Rows[0]);
136 return null;
137
138 }
139
140 public DataSet GetDataSet(int orderId)
141 ...{
142 string filter = " orderId=" + orderId;
143 return GetDataSet(filter);
144 }
145
146
147
148 #endregion
149
150
151 public DataSet GetDataSetByProductId(int productId)
152 ...{
153 return GetDataSet(" productId=" + productId);
154 }
155
156
157 public int DeleteByOrderId(int orderId)
158 ...{
159 string filter = " orderId =" + orderId;
160 return Delete(filter);
161 }
162
163
164 SearchOrderItem#region SearchOrderItem
165 /**//// <summary>
166 /// 销售明细快速搜索
167 /// </summary>
168 /// <param name="searchType"></param>
169 /// <returns></returns>
170 public DataSet QuickSearch(int searchType)
171 ...{
172
173
174 return dal.QuickSearch(searchType);
175
176 }
177
178 /**//// <summary>
179 /// 销售明细高级查询
180 /// </summary>
181 /// <param name="field"></param>
182 /// <param name="keywords"></param>
183 /// <returns></returns>
184 public DataSet KeywordsSearch(string field, string keywords)
185 ...{
186 field = Utils.ReplaceBadSQL(field.Trim().ToLower());
187 keywords = Utils.ReplaceBadSQL(keywords.ToLower().Trim());
188 if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords))
189 return null;
190 return dal.KeywordsSearch(field, keywords);
191 }
192
193 /**//// <summary>
194 /// 所有商品销售统计
195 /// </summary>
196 /// <returns></returns>
197 public DataSet SaleCount(int countType)
198 ...{
199 return dal.SaleCount(countType);
200 }
201
202
203 /**//// <summary>
204 /// 商品销售统计快速搜索
205 /// </summary>
206 /// <param name="searchType"></param>
207 /// <returns></returns>
208 public DataSet SaleCount_QuickSearch(int searchType,int countType)
209 ...{
210
211 return dal.SaleCount_QuickSearch(searchType,countType);
212
213 }
214
215
216 /**//// <summary>
217 /// 商品销售统计高级查询
218 /// </summary>
219 /// <param name="field"></param>
220 /// <param name="keywords"></param>
221 /// <returns></returns>
222 public DataSet SaleCount_KeywordsSearch(string field, string keywords,int countType)
223 ...{
224 field = Utils.ReplaceBadSQL(field.Trim().ToLower());
225 keywords = Utils.ReplaceBadSQL(keywords.ToLower().Trim());
226 if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords))
227 return null;
228 return dal.SaleCount_KeywordsSearch(field, keywords,countType);
229 }
230 #endregion
231 }
232
}
233
打包下载该项目完整源码：MyShop网络商城源码(mvc开发)
