1using System;
  2using System.Collections.Generic;
  3using System.Data;
  4using System.Data.OleDb;
  5using MyShop.IDAL;
  6using MyShop.Model;
  7
  8namespace MyShop.AccessDAL
  9...{
 10    public  class Bank:IBank
 11    ...{
 12        private ConfigInfo configInfo = new ConfigInfo();
 13        private string tableName = "Ljh_Bank";
 14        public Bank()
 15        ...{
 16            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
 17                tableName = configInfo.TablePrefix + "Bank";
 18
 19        }
 20
 21        IOrder member#region IOrder member
 22
 23
 24        /**//// <summary>
 25        /// add  
 26        /// </summary>
 27        /// <param name="model"></param>
 28        /// <returns>返回ID, 如果发生错误则返回-1</returns>
 29        public int Add(BankInfo model)
 30        ...{
 31            if (model == null)
 32            ...{
 33                return -1;
 34            }
 35            string commandText = "insert into " + this.tableName + "(BankShortName,bankName,accounts,cardNum,holderName,bankIntro,bankPic,isDefault,orderId,isDisabled)  values(@BankShortName,@bankName,@accounts,@cardNum,@holderName,@bankIntro,@bankPic,@isDefault,@orderId,@isDisabled)  ";
 36            OleDbParameter[] commandParameters = ...{
 37                    Database.MakeInParam("@BankShortName", OleDbType.VarWChar,20,model.BankShortName),
 38                    Database.MakeInParam("@BankName", OleDbType.VarWChar,50,model.BankName),
 39                    Database.MakeInParam("@Accounts", OleDbType.VarWChar,50,model.Accounts),
 40                    Database.MakeInParam("@CardNum", OleDbType.VarWChar,30,model.CardNum),
 41                    Database.MakeInParam("@HolderName", OleDbType.VarWChar,20,model.HolderName),
 42                    Database.MakeInParam("@BankIntro", OleDbType.VarWChar,255,model.BankIntro),
 43                    Database.MakeInParam("@BankPic", OleDbType.VarWChar,200,model.BankPic),
 44                    Database.MakeInParam("@IsDefault", OleDbType.UnsignedTinyInt,1,model.IsDefault),
 45                    Database.MakeInParam("@OrderId", OleDbType.Integer,4,model.OrderId),
 46                    Database.MakeInParam("@IsDisabled", OleDbType.UnsignedTinyInt,1,model.IsDisabled)
 47         };
 48
 49            int intIdentity = -1;
 50            try
 51            ...{
 52                Database.ExecuteNonQuery(CommandType.Text, out intIdentity, commandText, commandParameters);
 53            }
 54            catch (Exception exception)
 55            ...{
 56                throw exception;
 57            }
 58            return intIdentity;
 59        }
 60
 61
 62
 63        /**//// <summary>
 64        /// 删除 
 65        /// </summary>
 66        /// <param name="filter">where后面的条件语句，不加where</param>
 67        /// <returns>返回影响行数</returns>
 68        public int Delete(string filter)
 69        ...{
 70            int count = -1;
 71            string sql = @"delete from " + tableName;
 72            if (!string.IsNullOrEmpty(filter.Trim()))
 73            ...{
 74                sql = sql + "  where  " + filter;
 75            }
 76            try
 77            ...{
 78
 79                count = Database.ExecuteNonQuery(sql);
 80            }
 81            catch (Exception ex)
 82            ...{
 83                throw ex;
 84            }
 85            return count;
 86        }
 87
 88        /**//// <summary>
 89        /// 
 90        /// </summary>
 91        /// <param name="filter"></param>
 92        /// <returns></returns>
 93        public bool Exist(string filter)
 94        ...{
 95            bool result = false;
 96            string sql = @"select * from " + tableName;
 97            if (!string.IsNullOrEmpty(filter))
 98            ...{
 99                sql = sql + "  where  " + filter;
100            }
101            try
102            ...{
103
104
105                DataSet dataset = new DataSet();
106                dataset = Database.ExecuteDataSet(sql);
107                if (dataset.Tables[0].Rows.Count > 0)
108                ...{
109                    result = true;
110                }
111            }
112            catch (Exception ex)
113            ...{
114                throw ex;
115            }
116            return result;
117        }
118
119        /**//// <summary>
120        /// 返回所有
121        /// </summary>
122        /// <returns>返回所有</returns>
123        public DataSet GetDataSet()
124        ...{
125            string sql = "select * from " + tableName;
126            DataSet dataset = new DataSet();
127            try
128            ...{
129
130                dataset = Database.ExecuteDataSet(sql);
131
132            }
133            catch (Exception ex)
134            ...{
135                throw ex;
136            }
137            return dataset;
138        }
139
140        public DataSet GetDataSet(string filter)
141        ...{
142            if (string.IsNullOrEmpty(filter))
143                return null;
144
145            string sql = "select * from " + tableName + " where " + filter;
146            DataSet dataset = new DataSet();
147            try
148            ...{
149
150                dataset = Database.ExecuteDataSet(sql);
151            }
152            catch (Exception ex)
153            ...{
154                throw ex;
155            }
156            return dataset;
157        }
158
159        /**//// <summary>
160        ///
161        /// </summary>
162        /// <param name="dr"></param>
163        /// <returns></returns>
164        public BankInfo GetModel(DataRow dr)
165        ...{
166            if (dr == null)
167                return null;
168            BankInfo model = new BankInfo();
169
170            if (dr["BankID"].ToString() != "") model.BankID    = Convert.ToInt32( dr["BankID"].ToString());
171            if (dr["BankShortName"].ToString() != "") model.BankShortName    = dr["BankShortName"].ToString();
172            if (dr["BankName"].ToString() != "") model.BankName    = dr["BankName"].ToString();
173            if (dr["Accounts"].ToString() != "") model.Accounts    = dr["Accounts"].ToString();
174            if (dr["CardNum"].ToString() != "") model.CardNum    = dr["CardNum"].ToString();
175            if (dr["HolderName"].ToString() != "") model.HolderName    = dr["HolderName"].ToString();
176            if (dr["BankIntro"].ToString() != "") model.BankIntro    = dr["BankIntro"].ToString();
177            if (dr["BankPic"].ToString() != "") model.BankPic    = dr["BankPic"].ToString();
178            if (dr["IsDefault"].ToString() != "") model.IsDefault    = Convert.ToInt32(  dr["IsDefault"]);
179            if (dr["OrderId"].ToString() != "") model.OrderId = Convert.ToInt32(dr["OrderId"].ToString());
180            if (dr["IsDisabled"].ToString() != "") model.IsDisabled    = Convert.ToInt32(  dr["IsDisabled"]);
181
182
183
184            return model;
185        }
186
187        /**//// <summary>
188        /// 
189        /// </summary>
190        /// <param name="sql"></param>
191        /// <returns></returns>
192        public DataSet Query(string sql)
193        ...{
194            if (string.IsNullOrEmpty(sql))
195                return null;
196
197            DataSet dataset = new DataSet();
198            try
199            ...{
200
201                dataset = Database.ExecuteDataSet(sql);
202            }
203            catch (Exception ex)
204            ...{
205                throw ex;
206            }
207            return dataset;
208        }
209
210
211        /**//// <summary>
212        /// update  
213        /// </summary>
214        /// <param name="model"></param>
215        /// <param name="filter"></param>
216        /// <returns></returns>
217        public int Update(BankInfo model, string filter)
218        ...{
219            int result;
220            if (string.IsNullOrEmpty(filter))
221            ...{
222                throw new Exception("The 'filter' can not be null!");
223            }
224            string sql = @"update " + tableName + " set BankShortName=@BankShortName,BankName=@BankName,Accounts=@Accounts,CardNum=@CardNum,HolderName=@HolderName,BankIntro=@BankIntro,BankPic=@BankPic,IsDefault=@IsDefault,OrderId=@OrderId,IsDisabled=@IsDisabled " + " where " + filter;
225
226
227            OleDbParameter[] prams = ...{
228                Database.MakeInParam("@BankShortName", OleDbType.VarWChar,20,model.BankShortName),
229                Database.MakeInParam("@BankName", OleDbType.VarWChar,50,model.BankName),
230                Database.MakeInParam("@Accounts", OleDbType.VarWChar,50,model.Accounts),
231                Database.MakeInParam("@CardNum", OleDbType.VarWChar,30,model.CardNum),
232                Database.MakeInParam("@HolderName", OleDbType.VarWChar,20,model.HolderName),
233                Database.MakeInParam("@BankIntro", OleDbType.VarWChar,255,model.BankIntro),
234                Database.MakeInParam("@BankPic", OleDbType.VarWChar,200,model.BankPic),
235                Database.MakeInParam("@IsDefault", OleDbType.UnsignedTinyInt,1,model.IsDefault),
236                Database.MakeInParam("@OrderId", OleDbType.Integer,4,model.OrderId),
237                Database.MakeInParam("@IsDisabled", OleDbType.UnsignedTinyInt,1,model.IsDisabled)
238
239         };
240
241
242            try
243            ...{
244
245                result = Database.ExecuteNonQuery(sql, prams);
246            }
247            catch (Exception ex)
248            ...{
249                throw ex;
250            }
251            return result;
252        }
253
254
255        #endregion
256
257
258    }
259}
260