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