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

		            
  1using System;
  2using System.Collections;
  3using System.Data;
  4
  5
  6using MyShop.DALFactory;
  7using MyShop.IDAL;
  8using MyShop.Model;
  9
 10namespace MyShop.BLL
 11...{
 12    public class PaymentType
 13    ...{
 14        private IPaymentType dal = DataAccess.CreatePaymentType();
 15
 16        public PaymentType() ...{ }
 17
 18        IPaymentType#region IPaymentType
 19
 20        public int Add(PaymentTypeInfo 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 PaymentTypeInfo 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(PaymentTypeInfo 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(PaymentTypeInfo model, out string msg)
 86        ...{
 87            msg = "";
 88            if (model == null)
 89            ...{
 90                msg = msg + "<li>数据不能为空</li>";
 91                return 0;
 92            }
 93
 94            bool isErr = false;
 95
 96            if (string.IsNullOrEmpty(model.typeName.Trim()))
 97            ...{
 98                msg = msg + "请输入类型名称";
 99                isErr = true;
100            }
101
102            if (isErr)
103                return 0;
104
105            int count = 0;
106            count = Add(model);
107            if (count == 0)
108                msg = "<li>系统发生错误,请重新添加!</li>";
109            if (count == 1)
110                msg = "<li>添加成功!</li>";
111            return count;
112        }
113
114        public int Delete(int typeId)
115        ...{
116            if ( string.IsNullOrEmpty( typeId.ToString()) )
117                return 0;
118            string filer;
119            filer = " typeId =" + typeId;
120            return Delete(filer);
121        }
122        public int Update(PaymentTypeInfo model)
123        ...{
124
125            if (model == null)
126            ...{
127                return 0;
128            }
129            string filter;
130            filter = " typeId=" + model.typeId;
131            return Update(model, filter);
132        }
133
134        public PaymentTypeInfo GetModel(int typeId)
135        ...{
136            DataSet dataset = new DataSet();
137            dataset = GetDataSet(" typeId=" + typeId);
138            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
139                return GetModel(dataset.Tables[0].Rows[0]);
140            return null;       
141        }
142
143        public PaymentTypeInfo GetModel(string typeName)
144        ...{
145            if (string.IsNullOrEmpty(typeName))
146                return null;
147            DataSet dataset = new DataSet();
148            dataset = GetDataSet(" typeName='" + typeName + "'");
149            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
150                return GetModel(dataset.Tables[0].Rows[0]);
151            return null;
152        }
153
154        #endregion  
155
156
157        后台管理#region 后台管理
158        public DataSet GetDataSetOrderByOrderId()
159        ...{
160            return GetDataSet(" typeId > 0 Order by  OrderId  ");
161        }
162
163       
164        /**//// <summary>
165        /// 把为typeId的记录改为默认,同时将其它记录改为不是默认
166        /// </summary>
167        /// <param name="typeId"></param>
168        /// <returns></returns>
169        public int  MakeDefault(int typeId)
170        ...{
171            string filter = " [Isdefault] = 1 ";
172            DataSet dataset = new DataSet();
173            PaymentTypeInfo model = new PaymentTypeInfo();
174
175            dataset = GetDataSet(filter);
176            //把其它的改为不是默认
177            if (dataset.Tables[0].Rows.Count > 0)
178            ...{
179                for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
180                ...{
181                    model = GetModel(dataset.Tables[0].Rows[i]);
182                    model.isDefault = 0;
183                    Update(model);
184                }
185            }
186
187            model = GetModel(typeId);
188            model.isDefault = 1;
189            return Update(model);
190        }
191
192        /**//// <summary>
193        /// 检查付款方式名称是否存在
194        /// </summary>
195        /// <param name="typeName"></param>
196        /// <returns></returns>
197        public bool IsExist(string typeName)
198        ...{
199            typeName = Utils.ReplaceBadSQL(typeName.Trim());
200            if (string.IsNullOrEmpty(typeName))
201                return false;
202            string filter = " typeName='" + typeName + "'";
203
204           return Exist(filter);
205        }
206
207
208        #endregion
209    }
210}
211