当前文件路径：MyShop/BLL/Help.cs

		            
  1using 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 Help
 12    ...{
 13        private IHelp dal = DataAccess.CreateHelp();
 14
 15        IHelp#region  IHelp
 16        protected int Add(HelpInfo model)
 17        ...{
 18            if (model == null)
 19            ...{
 20                return 0;
 21            }
 22            return dal.Add(model);
 23        }
 24
 25        protected int Delete(string filter)
 26        ...{
 27            if (string.IsNullOrEmpty(filter))
 28                return 0;
 29            return dal.Delete(filter);
 30        }
 31
 32        public bool Exist(string filter)
 33        ...{
 34            filter = filter.Trim();
 35            if (string.IsNullOrEmpty(filter))
 36                return false;
 37            return dal.Exist(filter);
 38        }
 39        public DataSet GetDataSet()
 40        ...{
 41            return dal.GetDataSet();
 42        }
 43
 44        public DataSet GetDataSet(string filter)
 45        ...{
 46            filter = filter.Trim();
 47            if (string.IsNullOrEmpty(filter))
 48                return null;
 49            return dal.GetDataSet(filter);
 50        }
 51
 52        public HelpInfo GetModel(DataRow dr)
 53        ...{
 54            if (dr == null)
 55                return null;
 56            return dal.GetModel(dr);
 57        }
 58
 59        private DataSet Query(string sql)
 60        ...{
 61            sql = sql.Trim();
 62            if (string.IsNullOrEmpty(sql))
 63                return null;
 64            return dal.Query(sql);
 65        }
 66
 67        public int Update(HelpInfo model, string filter)
 68        ...{
 69            if (model == null)
 70                return 0;
 71            filter = filter.Trim();
 72            if (string.IsNullOrEmpty(filter))
 73                return 0;
 74            return dal.Update(model, filter);
 75        }
 76
 77        #endregion
 78
 79        common#region common
 80
 81        /**//// <summary>
 82        /// 
 83        /// </summary>
 84        /// <param name="model"></param>
 85        /// <param name="msg"></param>
 86        /// <returns></returns>
 87        public int Add(HelpInfo model, out string msg)
 88        ...{
 89            msg = "";
 90            if (model == null)
 91            ...{
 92                msg = msg + "<li>数据不能为空</li>";
 93                return 0;
 94            }
 95            bool isErr = false;
 96
 97            if (isErr)
 98                return 0;
 99
100            int count = 0;
101            count = Add(model);
102            if (count == 0)
103                msg = "<li>系统发生错误,请重新添加!</li>";
104            if (count == 1)
105                msg = "<li>添加成功!</li>";
106            return count;
107        }
108
109        /**//// <summary>
110        /// 删除Help
111        /// </summary>
112        /// <param name="articleId"></param>
113        /// <returns></returns>
114        public int Delete(int articleId)
115        ...{
116            HelpInfo model = new HelpInfo();
117            model = GetModel(articleId);
118            if (model == null)
119                return 0;
120
121            string filer;
122            filer = " articleId =" + articleId;
123            return Delete(filer);
124        }
125
126        public int Update(HelpInfo model)
127        ...{
128
129            if (model == null)
130            ...{
131                return 0;
132            }
133            string filter;
134            filter = " articleId=" + model.ArticleID;
135            return Update(model, filter);
136        }
137
138        public HelpInfo GetModel(int articleId)
139        ...{
140            DataSet dataset = new DataSet();
141            dataset = GetDataSet(" articleId=" + articleId);
142            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
143                return GetModel(dataset.Tables[0].Rows[0]);
144            return null;
145        }
146        public HelpInfo GetModel(string title)
147        ...{
148            title = Utils.ReplaceBadSQL(title.Trim());
149            if (string.IsNullOrEmpty(title.ToString()))
150                return null;
151            DataSet dataset = new DataSet();
152            dataset = GetDataSet(" title='" + title + "'");
153            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
154                return GetModel(dataset.Tables[0].Rows[0]);
155            return null;
156        }
157
158
159
160        #endregion
161
162
163        后台管理#region 后台管理
164
165        #endregion
166    }
167}
168