当前文件路径：MyShop/BLL/InvoiceItem.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 InvoiceItem
 14    ...{
 15
 16        private IInvoiceItem dal = DataAccess.CreateInvoiceItem();
 17        private ConfigInfo configInfo = new ConfigInfo();
 18        private string tableName = "Ljh_InvoiceItem";
 19
 20        public InvoiceItem()
 21        ...{
 22            Config config = new Config();
 23            configInfo = config.GetModel();
 24
 25            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
 26                tableName = configInfo.TablePrefix + "InvoiceItem";
 27        }
 28        IInvoiceItem#region IInvoiceItem
 29
 30        public int Add(InvoiceItemInfo model)
 31        ...{
 32            if (model == null)
 33            ...{
 34                return 0;
 35            }
 36            return dal.Add(model);
 37        }
 38
 39        public int Delete(string filter)
 40        ...{
 41            if (string.IsNullOrEmpty(filter))
 42                return 0;
 43            return dal.Delete(filter);
 44        }
 45
 46        public bool Exist(string filter)
 47        ...{
 48            filter = filter.Trim();
 49            if (string.IsNullOrEmpty(filter))
 50                return false;
 51            return dal.Exist(filter);
 52        }
 53        public DataSet GetDataSet()
 54        ...{
 55            return dal.GetDataSet();
 56        }
 57
 58        public DataSet GetDataSet(string filter)
 59        ...{
 60            filter = filter.Trim();
 61            if (string.IsNullOrEmpty(filter))
 62                return null;
 63            return dal.GetDataSet(filter);
 64        }
 65
 66        public InvoiceItemInfo GetModel(DataRow dr)
 67        ...{
 68            if (dr == null)
 69                return null;
 70            return dal.GetModel(dr);
 71        }
 72
 73        private DataSet Query(string sql)
 74        ...{
 75            sql = sql.Trim();
 76            if (string.IsNullOrEmpty(sql))
 77                return null;
 78            return dal.Query(sql);
 79        }
 80
 81        public int Update(InvoiceItemInfo model, string filter)
 82        ...{
 83            if (model == null)
 84                return 0;
 85            filter = filter.Trim();
 86            if (string.IsNullOrEmpty(filter))
 87                return 0;
 88            return dal.Update(model, filter);
 89        }
 90
 91        #endregion
 92
 93
 94        common#region common
 95
 96        public int Add(InvoiceItemInfo model, out string msg)
 97        ...{
 98            msg = "";
 99            if (model == null)
100            ...{
101                msg = msg + "<li>数据不能为空</li>";
102                return 0;
103            }
104            bool isErr = false;
105
106            if (isErr)
107                return 0;
108
109            int count = 0;
110            count = Add(model);
111            if (count == 0)
112                msg = "<li>系统发生错误,请重新添加!</li>";
113            if (count == 1)
114                msg = "<li>添加成功!</li>";
115            return count;
116        }
117
118        public int Delete(int invoiceID)
119        ...{
120            if (string.IsNullOrEmpty(invoiceID.ToString()))
121                return 0;
122            string filer;
123            filer = " invoiceID =" + invoiceID;
124            return Delete(filer);
125        }
126        public int Update(InvoiceItemInfo model)
127        ...{
128
129            if (model == null)
130            ...{
131                return 0;
132            }
133            string filter;
134            filter = " invoiceID=" + model.InvoiceID;
135            return Update(model, filter);
136        }
137
138        public InvoiceItemInfo GetModel(int invoiceID)
139        ...{
140            DataSet dataset = new DataSet();
141            dataset = GetDataSet(" invoiceID=" + invoiceID);
142            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
143                return GetModel(dataset.Tables[0].Rows[0]);
144            return null;
145        }
146
147        #endregion
148
149        后台管理#region 后台管理
150
151        /**//// <summary>
152        /// 快速搜索
153        /// </summary>
154        /// <param name="searchType"></param>
155        /// <returns></returns>
156        public DataSet QuickSearch(int searchType)
157        ...{
158            return dal.QuickSearch(searchType);
159
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
178
179        public DataSet GetDateSetOrderByIdDesc()
180        ...{
181            return GetDataSet(" InvoiceID > 0  order by invoiceId Desc ");
182        }
183        #endregion
184    }
185}
186