当前文件路径：MyShop/BLL/Announce.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 Announce
 14    ...{
 15        private IAnnounce dal = DataAccess.CreateAnnounce();
 16
 17        public Announce() ...{ }
 18
 19        IAnnounce#region IAnnounce
 20
 21        public int Add(AnnounceInfo model)
 22        ...{
 23            if (model == null)
 24            ...{
 25                return 0;
 26            }
 27            return dal.Add(model);
 28        }
 29
 30        public int Delete(string filter)
 31        ...{
 32            if (string.IsNullOrEmpty(filter))
 33                return 0;
 34            return dal.Delete(filter);
 35        }
 36
 37        public bool Exist(string filter)
 38        ...{
 39            filter = filter.Trim();
 40            if (string.IsNullOrEmpty(filter))
 41                return false;
 42            return dal.Exist(filter);
 43        }
 44        public DataSet GetDataSet()
 45        ...{
 46            return dal.GetDataSet();
 47        }
 48
 49        public DataSet GetDataSet(string filter)
 50        ...{
 51            filter = filter.Trim();
 52            if (string.IsNullOrEmpty(filter))
 53                return null;
 54            return dal.GetDataSet(filter);
 55        }
 56
 57        public AnnounceInfo GetModel(DataRow dr)
 58        ...{
 59            if (dr == null)
 60                return null;
 61            return dal.GetModel(dr);
 62        }
 63
 64        private DataSet Query(string sql)
 65        ...{
 66            sql = sql.Trim();
 67            if (string.IsNullOrEmpty(sql))
 68                return null;
 69            return dal.Query(sql);
 70        }
 71
 72        public int Update(AnnounceInfo model, string filter)
 73        ...{
 74            if (model == null)
 75                return 0;
 76            filter = filter.Trim();
 77            if (string.IsNullOrEmpty(filter))
 78                return 0;
 79            return dal.Update(model, filter);
 80        }
 81
 82        #endregion
 83
 84        common#region common
 85
 86        public int Add(AnnounceInfo model, out string msg)
 87        ...{
 88            msg = "";
 89            if (model == null)
 90            ...{
 91                msg = msg + "<li>数据不能为空</li>";
 92                return 0;
 93            }
 94            
 95            bool isErr = false;
 96
 97            if (string.IsNullOrEmpty(model.Title.Trim()))
 98            ...{
 99                msg = msg + "请输入标题";
100                isErr = true;
101            }
102
103            if (isErr)
104                return 0;
105
106            int count = 0;
107            count = Add(model);
108            if (count == 0)
109                msg = "<li>系统发生错误,请重新添加!</li>";
110            if (count == 1)
111                msg = "<li>添加成功!</li>";
112            return count;
113        }
114
115        public int Delete(int Id)
116        ...{
117            if (string.IsNullOrEmpty(Id.ToString()))
118                return 0;
119            string filer;
120            filer = " Id =" + Id;
121            return Delete(filer);
122        }
123        public int Update(AnnounceInfo model)
124        ...{
125
126            if (model == null)
127            ...{
128                return 0;
129            }
130            string filter;
131            filter = "Id=" + model.Id;
132            return Update(model, filter);
133        }
134
135        public AnnounceInfo GetModel(int  Id)
136        ...{
137            DataSet dataset = new DataSet();
138            dataset = GetDataSet(" Id=" + Id);
139            if (dataset.Tables[0].Rows.Count > 0)
140                return GetModel(dataset.Tables[0].Rows[0]);
141            return null;
142
143        }
144
145        #endregion
146
147
148        /**//// <summary>
149        /// 首页公告
150        /// </summary>
151        public DataSet GetSelectedAnnounce()
152        ...{
153            string filter;
154            filter = " isSelected=1 ";
155            return GetDataSet(filter);
156        }
157
158        /**//// <summary>
159        /// 得到在有有效时间内的公告列表
160        /// </summary>
161        /// <returns></returns>
162        public DataSet GetList()
163        ...{
164            return dal.GetList();
165        }
166
167
168        后台管理#region 后台管理
169
170        public DataSet GetDataSetOrderById()
171        ...{
172            return GetDataSet(" [Id] > 0 Order by  [Id]  ");
173        }
174
175
176        /**//// <summary>
177        /// 把为Id的记录改为最新公告,同时将其它记录改为不是最新公告
178        /// </summary>
179        /// <param name="id"></param>
180        /// <returns></returns>
181        public int Select(int id,bool action)
182        ...{
183            AnnounceInfo model = new AnnounceInfo();
184
185            if (action)
186            ...{
187                string filter = " [isSelected] = 1 ";
188                DataSet dataset = new DataSet();
189
190                dataset = GetDataSet(filter);
191                //把其它的改为不是默认
192                if (dataset.Tables[0].Rows.Count > 0)
193                ...{
194                    for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
195                    ...{
196                        model = GetModel(dataset.Tables[0].Rows[i]);
197                        model.IsSelected = 0;
198                        Update(model);
199                    }
200                }
201            }
202
203            model = GetModel(id);
204            model.IsSelected = action ? 1 : 0; ;
205            return Update(model);
206        }
207
208        /**//// <summary>
209        /// 检查标题是否存在
210        /// </summary>
211        /// <param name="title"></param>
212        /// <returns></returns>
213        public bool IsExist(string title)
214        ...{
215            title = Utils.ReplaceBadSQL(title.Trim());
216            if (string.IsNullOrEmpty(title))
217                return false;
218            string filter = " title='" + title + "'";
219
220            return Exist(filter);
221        }
222
223        /**//// <summary>
224        /// 快速搜索
225        /// </summary>
226        /// <param name="searchType"></param>
227        /// <returns></returns>
228        public DataSet QuickSearch(int searchType)
229        ...{
230            return dal.QuickSearch(searchType);
231        }
232
233        /**//// <summary>
234        /// 高级查询
235        /// </summary>
236        /// <param name="field"></param>
237        /// <param name="keywords"></param>
238        /// <returns></returns>
239        public DataSet KeywordsSearch(string field, string keywords)
240        ...{
241            field = Utils.ReplaceBadSQL(field.Trim().ToLower());
242            keywords = Utils.ReplaceBadSQL(keywords.ToLower().Trim());
243            if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords))
244                return null;
245            return dal.KeywordsSearch(field, keywords);
246        }
247
248        #endregion
249    }
250}
251