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

		            
  1using System;
  2using System.Collections.Generic;
  3
  4using System.Data;
  5
  6
  7using MyShop.DALFactory;
  8using MyShop.IDAL;
  9using MyShop.Model;
 10
 11
 12namespace MyShop.BLL
 13...{
 14    public class Trademark
 15    ...{
 16        private ITrademark dal = DataAccess.CreateTrademark();
 17
 18        ITrademark#region  ITrademark
 19
 20        public int Add(TrademarkInfo model)
 21        ...{
 22            if (model == null)
 23            ...{
 24                return 0;
 25            }
 26            return dal.Add(model);
 27        }
 28
 29        public int Delete(string filter)
 30        ...{
 31            if (string.IsNullOrEmpty(filter))
 32                return 0;
 33            return dal.Delete(filter);
 34        }
 35
 36        public bool Exist(string filter)
 37        ...{
 38            filter = filter.Trim();
 39            if (string.IsNullOrEmpty(filter))
 40                return false;
 41            return dal.Exist(filter);
 42        }
 43        public DataSet GetDataSet()
 44        ...{
 45            return dal.GetDataSet();
 46        }
 47
 48        public DataSet GetDataSet(string filter)
 49        ...{
 50            filter = filter.Trim();
 51            if (string.IsNullOrEmpty(filter))
 52                return null;
 53            return dal.GetDataSet(filter);
 54        }
 55
 56        public TrademarkInfo GetModel(DataRow dr)
 57        ...{
 58            if (dr == null)
 59                return null;
 60            return dal.GetModel(dr);
 61        }
 62
 63        private DataSet Query(string sql)
 64        ...{
 65            sql = sql.Trim();
 66            if (string.IsNullOrEmpty(sql))
 67                return null;
 68            return dal.Query(sql);
 69        }
 70
 71        public int Update(TrademarkInfo model, string filter)
 72        ...{
 73            if (model == null)
 74                return 0;
 75            filter = filter.Trim();
 76            if (string.IsNullOrEmpty(filter))
 77                return 0;
 78            return dal.Update(model, filter);
 79        }
 80
 81        #endregion
 82
 83        common#region common
 84
 85        public int Add(TrademarkInfo model, out string msg)
 86        ...{
 87            msg = "";
 88            if (model == null)
 89            ...{
 90                msg = msg + "<li>数据不能为空</li>";
 91                return 0;
 92            }
 93            bool isErr = false;
 94
 95            if (string.IsNullOrEmpty(model.TrademarkName.Trim()))
 96            ...{
 97                msg = msg + "<li>品牌名称不能为空</li>";
 98                isErr = true;
 99            }
100            if (isErr)
101                return 0;
102
103            int count = 0;
104            count = Add(model);
105            if (count == 0)
106                msg = "<li>系统发生错误,请重新添加!</li>";
107            if (count == 1)
108                msg = "<li>添加成功!</li>";
109            return count;
110        }
111
112        public int Delete(int trademarkId)
113        ...{
114            if (string.IsNullOrEmpty(trademarkId.ToString()))
115                return 0;
116            string filer;
117            filer = " trademarkId =" + trademarkId;
118            return Delete(filer);
119        }
120        public int Update(TrademarkInfo model)
121        ...{
122
123            if (model == null)
124            ...{
125                return 0;
126            }
127            string filter;
128            filter = " trademarkId=" + model.TrademarkID;
129            return Update(model, filter);
130        }
131
132        public TrademarkInfo GetModel(int trademarkId)
133        ...{
134            DataSet dataset = new DataSet();
135            dataset = GetDataSet(" trademarkId=" + trademarkId);
136            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
137                return GetModel(dataset.Tables[0].Rows[0]);
138            return null;
139        }
140
141        #endregion
142
143
144        后台管理#region 后台管理
145
146        /**//// <summary>
147        /// 快速搜索
148        /// </summary>
149        /// <param name="trademarkType"></param>
150        /// <returns></returns>
151        public DataSet QuickSearchByTrademarkType(int trademarkType )
152        ...{
153            DataSet ds = new DataSet();
154            string filter = " trademarkType=" + trademarkType;
155            return GetDataSet(filter);
156        }
157
158        /**//// <summary>
159        /// 高级查询
160        /// </summary>
161        /// <param name="field"></param>
162        /// <param name="keywords"></param>
163        /// <returns></returns>
164        public DataSet KeywordsSearch(string field, string keywords)
165        ...{
166            field = Utils.ReplaceBadSQL(field.Trim().ToLower());
167            keywords = Utils.ReplaceBadSQL(keywords.ToLower().Trim());
168            if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords))
169                return null;
170            return dal.KeywordsSearch(field, keywords);
171        }
172
173        
174        public DataSet GetDataSet(int producerId)
175        ...{
176            string filter = " producerId=" + producerId.ToString();
177            if (string.IsNullOrEmpty(filter))
178                return null;
179            return GetDataSet(filter);
180        }
181
182        public DataSet GetDataSetPassedTrademarkList()
183        ...{
184            return GetDataSet(" passed=1  ");
185        }
186
187        #endregion
188    }
189}
190