当前文件路径：MyShop/BLL/GuestBook.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 GuestBook
 14    ...{
 15        private IGuestBook dal = DataAccess.CreateGuestBook();
 16
 17        public GuestBook() ...{ }
 18
 19        IGuestBook#region IGuestBook
 20
 21        public int Add(GuestBookInfo 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 GuestBookInfo 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(GuestBookInfo 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(GuestBookInfo 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
 98            if (isErr)
 99                return 0;
100
101            int count = 0;
102            count = Add(model);
103            if (count == 0)
104                msg = "<li>系统发生错误,请重新添加!</li>";
105            if (count == 1)
106                msg = "<li>添加成功!</li>";
107            return count;
108        }
109
110        public int Delete(int GuestId)
111        ...{
112            if (string.IsNullOrEmpty(GuestId.ToString()))
113                return 0;
114            string filer;
115            filer = " GuestId =" + GuestId;
116            return Delete(filer);
117        }
118        public int Update(GuestBookInfo model)
119        ...{
120
121            if (model == null)
122            ...{
123                return 0;
124            }
125            string filter;
126            filter = "GuestId=" + model.GuestId;
127            return Update(model, filter);
128        }
129
130        public GuestBookInfo GetModel(int GuestId)
131        ...{
132            DataSet dataset = new DataSet();
133            dataset = GetDataSet(" GuestId=" + GuestId);
134            if (dataset.Tables[0].Rows.Count > 0)
135                return GetModel(dataset.Tables[0].Rows[0]);
136            return null;
137
138        }
139
140        #endregion
141
142
143
144        /**//// <summary>
145        /// 得到通过审核的列表
146        /// </summary>
147        /// <returns></returns>
148        public DataSet GetPassedList()
149        ...{
150            return dal.GetPassedList();
151        }
152
153
154        后台管理#region 后台管理
155
156        public DataSet GetDataSetOrderById()
157        ...{
158            return GetDataSet(" [GuestId] > 0 Order by  [GuestId] Desc ");
159        }
160
161        /**//// <summary>
162        /// 判断该留言是不是审核通过
163        /// </summary>
164        /// <param name="guestId"></param>
165        /// <returns>无该文章时返回false</returns>
166        public bool Pass(int guestId)
167        ...{
168            GuestBookInfo model = new GuestBookInfo();
169            model = GetModel(guestId);
170            if (model == null)
171                return false;
172
173            if (model.IsPassed == 1)
174                return true;
175            else
176                return false;
177        }
178
179        /**//// <summary>
180        /// 取消或设置该文章审核状态
181        /// </summary>
182        /// <param name="guestId"></param>
183        /// <param name="action">true 为审核通过   false为审核未通过</param>
184        /// <returns></returns>
185        public int Pass(int guestId, bool action)
186        ...{
187            GuestBookInfo model = new GuestBookInfo();
188            model = GetModel(guestId);
189            if (model == null)
190                return 0;
191
192            if (action)
193            ...{
194                model.IsPassed = 1;
195            }
196            else
197            ...{
198                model.IsPassed = 0;
199            }
200            return Update(model);
201        }
202
203
204
205        /**//// <summary>
206        /// 快速搜索
207        /// </summary>
208        /// <param name="searchType"></param>
209        /// <returns></returns>
210        public DataSet QuickSearch(int searchType)
211        ...{
212            return dal.QuickSearch(searchType);
213        }
214
215        /**//// <summary>
216        /// 高级查询
217        /// </summary>
218        /// <param name="field"></param>
219        /// <param name="keywords"></param>
220        /// <returns></returns>
221        public DataSet KeywordsSearch(string field, string keywords)
222        ...{
223            field = Utils.ReplaceBadSQL(field.Trim().ToLower());
224            keywords = Utils.ReplaceBadSQL(keywords.ToLower().Trim());
225            if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords))
226                return null;
227            return dal.KeywordsSearch(field, keywords);
228        }
229
230        #endregion
231    }
232}
233