1using System;
  2using System.Collections.Generic;
  3
  4using System.Data;
  5using System.Data.OleDb;
  6using MyShop.IDAL;
  7using MyShop.Model;
  8
  9namespace MyShop.AccessDAL
 10...{
 11    public class DeliverType : IDeliverType
 12    ...{
 13
 14        private ConfigInfo configInfo = new ConfigInfo();
 15        private string tableName = "Ljh_DeliverType";
 16        public DeliverType()
 17        ...{
 18            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
 19                tableName = configInfo.TablePrefix + "DeliverType";
 20        }
 21
 22        IDeliverType member#region IDeliverType member
 23
 24        /**//// <summary>
 25        /// Ìí¼Ó
 26        /// </summary>
 27        /// <param name="model"></param>
 28        /// <returns>·µ»ØID, Èç¹û·¢Éú´íÎóÔò·µ»Ø-1</returns>
 29        public int Add(DeliverTypeInfo model)
 30        ...{
 31            if (model == null)
 32            ...{
 33                return 0;
 34            }
 35            string commandText = "insert into " + this.tableName + "(typeName,intro,isDefault,isDisabled,orderId,charge) values(@typeName,@intro,@isDefault,@isDisabled,@orderId,@charge) ";
 36            OleDbParameter[] commandParameters = ...{
 37                Database.MakeInParam("@TypeName",OleDbType.VarWChar,50,model.TypeName),
 38                Database.MakeInParam("@Intro",OleDbType.VarWChar,255,model.Intro),
 39                Database.MakeInParam("@IsDefault",OleDbType.UnsignedTinyInt,1,model.IsDefault),
 40                Database.MakeInParam("@IsDisabled",OleDbType.UnsignedTinyInt,1,model.IsDisabled),
 41                Database.MakeInParam("@OrderId",OleDbType.Integer,4,model.OrderId),
 42                Database.MakeInParam("@Charge",OleDbType.Currency,8,model.Charge),
 43                                                           };
 44            int intIdentity = -1;
 45            try
 46            ...{
 47                Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters);
 48            }
 49            catch (Exception exception)
 50            ...{
 51                throw exception;
 52            }
 53            return intIdentity;
 54        }
 55
 56
 57
 58
 59        /**//// <summary>
 60        /// ɾ³ý
 61        /// </summary>
 62        /// <param name="filter">whereºóÃæµÄÌõ¼þÓï¾ä£¬²»¼Ówhere</param>
 63        /// <returns>·µ»ØÓ°ÏìÐÐÊý</returns>
 64        public int Delete(string filter)
 65        ...{
 66            int count = -1;
 67            string sql = @"delete from " + tableName;
 68            if (!string.IsNullOrEmpty(filter.Trim()))
 69            ...{
 70                sql = sql + "  where  " + filter;
 71            }
 72            try
 73            ...{
 74                
 75                count = Database.ExecuteNonQuery(sql);
 76            }
 77            catch (Exception ex)
 78            ...{
 79                throw ex;
 80            }
 81            return count;
 82        }
 83
 84        /**//// <summary>
 85        /// ÅжÏÊÇ·ñ´æÔÚ
 86        /// </summary>
 87        /// <param name="filter">UserName=condition|UserName and password</param>
 88        /// <returns></returns>
 89        public bool Exist(string filter)
 90        ...{
 91            bool result = false;
 92            string sql = @"select * from " + tableName;
 93            if (!string.IsNullOrEmpty(filter.Trim()))
 94            ...{
 95                sql = sql + "  where  " + filter;
 96            }
 97            try
 98            ...{
 99                
100
101                DataSet dataset = new DataSet();
102                dataset = Database.ExecuteDataSet(sql);
103                if (dataset.Tables[0].Rows.Count > 0)
104                ...{
105                    result = true;
106                }
107            }
108            catch (Exception ex)
109            ...{
110                throw ex;
111            }
112            return result;
113        }
114
115        /**//// <summary>
116        /// ·µ»ØËùÓÐ
117        /// </summary>
118        /// <returns>·µ»ØËùÓÐ</returns>
119        public DataSet GetDataSet()
120        ...{
121            string sql = "select * from " + tableName;
122            DataSet dataset = new DataSet();
123            try
124            ...{
125                
126                dataset = Database.ExecuteDataSet(sql);
127
128            }
129            catch (Exception ex)
130            ...{
131                throw ex;
132            }
133            return dataset;
134        }
135
136        /**//// <summary>
137        /// 
138        /// </summary>
139        /// <param name="filter"></param>
140        /// <returns></returns>
141        public DataSet GetDataSet(string filter)
142        ...{
143            if (string.IsNullOrEmpty(filter))
144                return null;
145
146            string sql = "select * from " + tableName + " where " + filter;
147            DataSet dataset = new DataSet();
148            try
149            ...{
150                
151                dataset = Database.ExecuteDataSet(sql);
152            }
153            catch (Exception ex)
154            ...{
155                throw ex;
156            }
157            return dataset;
158        }
159
160        /**//// <summary>
161        /// /
162        /// </summary>
163        /// <param name="dr"></param>
164        /// <returns></returns>
165        public DeliverTypeInfo GetModel(DataRow dr)
166        ...{
167            if (dr == null)
168                return null;
169            DeliverTypeInfo model = new DeliverTypeInfo();
170
171            if (dr["TypeId"].ToString() != "")
172                model.TypeId = Convert.ToInt32(dr["TypeId"]);
173            if (dr["typeName"].ToString() != "")
174                model.TypeName = dr["typeName"].ToString();
175            if (dr["intro"].ToString() != "")
176                model.Intro = dr["intro"].ToString();
177            if (dr["IsDefault"].ToString() != "")
178               model.IsDefault = Convert.ToInt32( dr["IsDefault"]);
179            if (dr["IsDisabled"].ToString() != "")
180               model.IsDisabled =  Convert.ToInt32( dr["IsDisabled"]);
181            if (dr["OrderId"].ToString() != "")
182                model.OrderId = Convert.ToInt32(dr["OrderId"]);
183            if (dr["Charge"].ToString() != "")
184                model.Charge = Convert.ToDecimal(dr["Charge"]);
185
186            return model;
187        }
188
189        /**//// <summary>
190        /// 
191        /// </summary>
192        /// <param name="sql"></param>
193        /// <returns></returns>
194        public DataSet Query(string sql)
195        ...{
196            if (string.IsNullOrEmpty(sql))
197                return null;
198
199            DataSet dataset = new DataSet();
200            try
201            ...{
202                
203                dataset = Database.ExecuteDataSet(sql);
204            }
205            catch (Exception ex)
206            ...{
207                throw ex;
208            }
209            return dataset;
210        }
211
212        /**//// <summary>
213        /// 
214        /// </summary>
215        /// <param name="model"></param>
216        /// <param name="filter"></param>
217        /// <returns></returns>
218        public int Update(DeliverTypeInfo model, string filter)
219        ...{
220            int result;
221            if (string.IsNullOrEmpty(filter))
222            ...{
223                throw new Exception("The 'filter' can not be null!");
224            }
225            string sql = @"update " + tableName + " set  typeName=@typeName,intro=@intro,isDefault=@isDefault,isDisabled=@isDisabled,orderId=@orderId,charge=@charge " + " where " + filter;
226            OleDbParameter[] prams = ...{
227                Database.MakeInParam("@TypeName",OleDbType.VarWChar,50,model.TypeName),
228                Database.MakeInParam("@Intro",OleDbType.VarWChar,255,model.Intro),
229                Database.MakeInParam("@IsDefault",OleDbType.UnsignedTinyInt,1,model.IsDefault),
230                Database.MakeInParam("@IsDisabled",OleDbType.UnsignedTinyInt,1,model.IsDisabled),
231                Database.MakeInParam("@OrderId",OleDbType.Integer,4,model.OrderId),
232                Database.MakeInParam("@Charge",OleDbType.Currency,8,model.Charge),
233                                                           };
234
235            try
236            ...{
237                
238                result = Database.ExecuteNonQuery(sql, prams);
239            }
240            catch (Exception ex)
241            ...{
242                throw ex;
243            }
244            return result;
245        }
246
247        #endregion
248
249
250    }
251}
252