当前文件路径：MyShop/BLL/BankrollItem.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 BankrollItem
 15    ...{
 16        private IBankrollItem dal = DataAccess.CreateBankrollItem();
 17
 18        private ConfigInfo configInfo = new ConfigInfo();
 19        private string tableName = "ljh_BankrollItem";
 20
 21        public BankrollItem()
 22        ...{
 23            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
 24                tableName = configInfo.TablePrefix + "BankrollItem";
 25        }
 26
 27        IBankrollItem#region  IBankrollItem
 28
 29        public int Add(BankrollItemInfo 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 BankrollItemInfo 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(BankrollItemInfo 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(BankrollItemInfo 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             msg = count < 1 ?  "<li>系统发生错误,请重新添加!</li>" : "<li>添加成功!</li>";
110            return count;
111        }
112
113        public int Delete(int itemId)
114        ...{
115            if (string.IsNullOrEmpty(itemId.ToString()))
116                return 0;
117            string filer;
118            filer = " itemId =" + itemId;
119            return Delete(filer);
120        }
121        public int Update(BankrollItemInfo model)
122        ...{
123
124            if (model == null)
125            ...{
126                return 0;
127            }
128            string filter;
129            filter = " itemId=" + model.ItemId;
130            return Update(model, filter);
131        }
132
133        public BankrollItemInfo GetModel(int itemId)
134        ...{
135            DataSet dataset = new DataSet();
136            dataset = GetDataSet(" itemId=" + itemId);
137            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
138                return GetModel(dataset.Tables[0].Rows[0]);
139            return null;
140        }
141
142        #endregion
143
144
145        后台管理#region 后台管理
146
147
148        /**//// <summary>
149        /// 资金明细快速搜索
150        /// </summary>
151        /// <param name="searchType"></param>
152        /// <returns></returns>
153        public DataSet QuickSearch(int searchType)
154        ...{
155            return dal.QuickSearch(searchType);
156
157        }
158
159        /**//// <summary>
160        /// 资金明细高级查询
161        /// </summary>
162        /// <param name="field"></param>
163        /// <param name="keywords"></param>
164        /// <returns></returns>
165        public DataSet KeywordsSearch(string field, string keywords)
166        ...{
167            field = Utils.ReplaceBadSQL(field.Trim().ToLower());
168            keywords = Utils.ReplaceBadSQL(keywords.ToLower().Trim());
169            if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords))
170                return null;
171            return dal.KeywordsSearch(field, keywords);
172        }
173
174        public DataSet GetDateSetOrderByItemIdDesc()
175        ...{
176            return GetDataSet(" itemId > 0 order by itemId Desc ");
177        }
178        #endregion
179
180    }
181}
182