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

		            
  1using System;
  2using System.Collections.Generic;
  3
  4using System.Data;
  5
  6
  7using MyShop.DALFactory;
  8using MyShop.IDAL;
  9using MyShop.Model;
 10namespace MyShop.BLL
 11...{
 12    public class DeliverItem
 13    ...{
 14
 15        private IDeliverItem dal = DataAccess.CreateDeliverItem();
 16        private ConfigInfo configInfo = new ConfigInfo();
 17        private string tableName = "Ljh_DeliverItem";
 18        public DeliverItem()
 19        ...{
 20            Config config = new Config();
 21            configInfo = config.GetModel();
 22
 23            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
 24                tableName = configInfo.TablePrefix + "DeliverItem";
 25        }
 26
 27        IDeliverItem#region IDeliverItem
 28
 29        public int Add(DeliverItemInfo model)
 30        ...{
 31            if (model == null)
 32            ...{
 33                return 0;
 34            }
 35            return dal.Add(model);
 36        }
 37
 38        public int Delete(string filter)
 39        ...{
 40            if (string.IsNullOrEmpty(filter))
 41                return 0;
 42            return dal.Delete(filter);
 43        }
 44
 45        public bool Exist(string filter)
 46        ...{
 47            filter = filter.Trim();
 48            if (string.IsNullOrEmpty(filter))
 49                return false;
 50            return dal.Exist(filter);
 51        }
 52        public DataSet GetDataSet()
 53        ...{
 54            return dal.GetDataSet();
 55        }
 56
 57        public DataSet GetDataSet(string filter)
 58        ...{
 59            filter = filter.Trim();
 60            if (string.IsNullOrEmpty(filter))
 61                return null;
 62            return dal.GetDataSet(filter);
 63        }
 64
 65        public DeliverItemInfo GetModel(DataRow dr)
 66        ...{
 67            if (dr == null)
 68                return null;
 69            return dal.GetModel(dr);
 70        }
 71
 72        private DataSet Query(string sql)
 73        ...{
 74            sql = sql.Trim();
 75            if (string.IsNullOrEmpty(sql))
 76                return null;
 77            return dal.Query(sql);
 78        }
 79
 80        public int Update(DeliverItemInfo model, string filter)
 81        ...{
 82            if (model == null)
 83                return 0;
 84            filter = filter.Trim();
 85            if (string.IsNullOrEmpty(filter))
 86                return 0;
 87            return dal.Update(model, filter);
 88        }
 89
 90        #endregion
 91
 92        common#region common
 93
 94        public int Add(DeliverItemInfo model, out string msg)
 95        ...{
 96            msg = "";
 97            if (model == null)
 98            ...{
 99                msg = msg + "<li>数据不能为空</li>";
100                return 0;
101            }
102            bool isErr = false;
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 deliverId)
117        ...{
118            if (string.IsNullOrEmpty(deliverId.ToString()))
119                return 0;
120            string filer;
121            filer = " deliverId =" + deliverId;
122            return Delete(filer);
123        }
124        public int Update(DeliverItemInfo model)
125        ...{
126
127            if (model == null)
128            ...{
129                return 0;
130            }
131            string filter;
132            filter = " deliverId=" + model.DeliverID;
133            return Update(model, filter);
134        }
135
136        public DeliverItemInfo GetModel(int deliverId)
137        ...{
138            DataSet dataset = new DataSet();
139            dataset = GetDataSet(" deliverId=" + deliverId);
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        后台管理#region 后台管理
148
149        /**//// <summary>
150        /// 发退货快速搜索
151        /// </summary>
152        /// <param name="searchType"></param>
153        /// <returns></returns>
154        public DataSet QuickSearch(int searchType)
155        ...{
156            return dal.QuickSearch(searchType);
157
158        }
159
160        /**//// <summary>
161        ///发退货高级查询
162        /// </summary>
163        /// <param name="field"></param>
164        /// <param name="keywords"></param>
165        /// <returns></returns>
166        public DataSet KeywordsSearch(string field, string keywords)
167        ...{
168            field = Utils.ReplaceBadSQL(field.Trim().ToLower());
169            keywords = Utils.ReplaceBadSQL(keywords.ToLower().Trim());
170            if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords))
171                return null;
172            return dal.KeywordsSearch(field, keywords);
173        }
174
175        public DataSet GetDateSetOrderByIdDesc()
176        ...{
177            return GetDataSet(" DeliverID > 0 order by DeliverId Desc ");
178        }
179        #endregion
180
181    
182    }
183}
184