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