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