当前文件路径:MyShop/BLL/OrderItem.cs 
1
using System;
2
using System.Collections.Generic;
3
4
using System.Data;
5
6
using MyShop.DALFactory;
7
using MyShop.IDAL;
8
using MyShop.Model;
9
10
namespace 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