当前文件路径：MyShop/BLL/Class.cs 
1
using System;
2using System.Collections.Generic;
3using System.Data;
4
5using MyShop.DALFactory;
6using MyShop.IDAL;
7using MyShop.Model;
8
9namespace MyShop.BLL
10
...{
11
public class Class
12
...{
13 private IClass dal = DataAccess.CreateClass();
14
15 private int _id;
16
17 public Class() ...{ }
18 public Class(int id)
19 ...{
20 this._id = id;
21
}
22
23 IClass#region IClass
24
25 /**//// <summary>
26 ///
27 /// </summary>
28 /// <param name="model"></param>
29 /// <returns></returns>
30 protected int Add(ClassInfo model)
31 ...{
32 if (model == null)
33 ...{
34 return 0;
35 }
36 return dal.Add(model);
37 }
38
39 protected int Delete(string filter)
40 ...{
41 if (string.IsNullOrEmpty(filter))
42 return 0;
43 return dal.Delete(filter);
44 }
45
46 public bool Exist(string filter)
47 ...{
48 filter = filter.Trim();
49 if (string.IsNullOrEmpty(filter))
50 return false;
51 return dal.Exist(filter);
52 }
53 public DataSet GetDataSet()
54 ...{
55 return dal.GetDataSet();
56 }
57
58 public DataSet GetDataSet(string filter)
59 ...{
60 filter = filter.Trim();
61 if (string.IsNullOrEmpty(filter))
62 return null;
63 return dal.GetDataSet(filter);
64 }
65
66 public ClassInfo GetModel(DataRow dr)
67 ...{
68 if (dr == null)
69 return null;
70 return dal.GetModel(dr);
71 }
72
73 private DataSet Query(string sql)
74 ...{
75 sql = sql.Trim();
76 if (string.IsNullOrEmpty(sql))
77 return null;
78 return dal.Query(sql);
79 }
80
81 public int Update(ClassInfo model, string filter)
82 ...{
83 if (model == null)
84 return 0;
85 filter = filter.Trim();
86 if (string.IsNullOrEmpty(filter))
87 return 0;
88 return dal.Update(model, filter);
89 }
90
91 #endregion
92
93 common#region common
94
95 /**//// <summary>
96 /// 加入栏目
97 /// </summary>
98 /// <param name="model"></param>
99 /// <param name="msg"></param>
100 /// <returns></returns>
101 public int Add(ClassInfo model, out string msg)
102 ...{
103 msg = "";
104 if (model == null)
105 ...{
106 msg = msg + "<li>数据不能为空</li>";
107 return 0;
108 }
109 bool isErr = false;
110
111 if (isErr)
112 return 0;
113
114 int count = 0;
115 count = Add(model);
116 if (count == 0)
117 msg = "<li>系统发生错误,请重新添加!</li>";
118 if (count == 1)
119 msg = "<li>添加成功!</li>";
120 return count;
121 }
122
123 /**//// <summary>
124 /// 删除Class栏目,只能用于删除无孩子的结点，否则目录树结构将被破坏
125 /// </summary>
126 /// <param name="classId"></param>
127 /// <returns></returns>
128 protected int Delete(int classId)
129 ...{
130 ClassInfo model = new ClassInfo();
131 model = GetModel(classId);
132 if (model == null)
133 return 0;
134
135 string filer;
136 filer = " ClassId =" + classId;
137 return Delete(filer);
138 }
139
140
141 public int Update(ClassInfo model)
142 ...{
143
144 if (model == null)
145 ...{
146 return 0;
147 }
148 string filter;
149 filter = " ClassId=" + model.ClassID;
150 return Update(model, filter);
151 }
152
153 public ClassInfo GetModel(int classId)
154 ...{
155 DataSet dataset = new DataSet();
156 dataset = GetDataSet(" ClassId=" + classId);
157 if (dataset != null && dataset.Tables[0].Rows.Count > 0)
158 return GetModel(dataset.Tables[0].Rows[0]);
159 return null;
160 }
161 public ClassInfo GetModel(string className)
162 ...{
163 className = Utils.ReplaceBadSQL(className.Trim());
164 if (string.IsNullOrEmpty(className.ToString()))
165 return null;
166 DataSet dataset = new DataSet();
167 dataset = GetDataSet(" className='" + className + "'");
168 if (dataset != null && dataset.Tables[0].Rows.Count > 0)
169 return GetModel(dataset.Tables[0].Rows[0]);
170 return null;
171 }
172
173 #endregion
174
175
176 前台#region 前台
177
178 /**//// <summary>
179 /// 得到以classId为父栏目的子栏目列表
180 /// </summary>
181 /// <param name="classId"></param>
182 /// <returns></returns>
183 public DataSet GetClassList(int classId)
184 ...{
185 return GetDataSet(" [parentId] = " + classId + " and [disabled] = 0 Order by orderId ");
186 }
187
188 /**//// <summary>
189 /// 得到以channelId频道的一级栏目列表
190 /// </summary>
191 /// <param name="channelId"></param>
192 /// <returns></returns>
193 public DataSet GetTopClassList(int channelId)
194 ...{
195 return GetDataSet(" [parentId] = 0 and [channelId] = " + channelId + " and [disabled] = 0 Order by orderId ");
196 }
197
198 #endregion
199
200 以下过程要用Class cls = new Class(id)实例化后才能进行调用#region 以下过程要用Class cls = new Class(id)实例化后才能进行调用
201
202
203
204
205 property#region property
206
207 /**//// <summary>
208 /// 获取当前项目ID
209 /// </summary>
210 public int ID
211 ...{
212 get
213 ...{
214 return this._id;
215 }
216 }
217
218 /**//// <summary>
219 /// 获取调查项目的实体
220 /// </summary>
221 public ClassInfo Model
222 ...{
223 get
224 ...{
225 return GetModel(this._id);
226 }
227 set
228 ...{
229 Update(value);
230 }
231 }
232
233 /**//// <summary>
234 /// 获取当前对象是否存在
235 /// </summary>
236 public bool isExist
237 ...{
238 get
239 ...{
240 return Model == null ? false : true;
241 }
242 }
243
244 #endregion
245
246 #endregion
247
248
249 /**//// <summary>
250 /// 得到顶部导航栏目数据
251 /// </summary>
252 /// <param name="channelId"></param>
253 /// <returns></returns>
254 public DataSet GetDataSetTopNav(int channelId)
255 ...{
256 return GetDataSet(" [channelId] = " + channelId + " and [depth] = 1 Order by parentpath,depth,orderId ");
257 }
258 后台管理#region 后台管理
259
260 public DataSet GetDataSetOrderByOrderId()
261 ...{
262 return GetDataSet(" [classId] > 0 order by channelId, parentpath,orderId ");
263 }
264
265 public DataSet GetDataSetOrderByOrderId(int channelId)
266 ...{
267 return GetDataSet(" [channelId] = " + channelId + " Order by parentpath,depth,orderId ");
268 }
269 /**//// <summary>
270 /// 启用或禁用
271 /// </summary>
272 /// <param name="classId"></param>
273 /// <returns></returns>
274 public int Enable(int classId, bool action)
275 ...{
276 ClassInfo model = new ClassInfo();
277 model = GetModel(classId);
278 if (model == null)
279 return 0;
280
281 model.Disabled = action ? 0 : 1;
282 return Update(model);
283 }
284
285
286 /**//// <summary>
287 /// 频道是否存在
288 /// </summary>
289 /// <param name="className"></param>
290 /// <returns></returns>
291 public bool IsExist(string className)
292
