当前文件路径：ClothesShop/OleDbDAL/userinfo.cs

		            
  1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using ClothesShop.DBUtility;
  5using System.Data;
  6using System.Data.OleDb;
  7
  8namespace ClothesShop.OleDbDAL
  9...{
 10    public class userinfo : ClothesShop.IDAL.Iuserinfo
 11    ...{
 12        /**//// <summary>
 13        /// 创建一个新用户
 14        /// </summary>
 15        /// <param name="username">用户名称</param>
 16        /// <param name="password">用户密码</param>
 17        /// <param name="email">电子邮件</param>
 18        /// <param name="question">密码问题</param>
 19        /// <param name="answer">问题答案</param>
 20        /// <returns></returns>
 21        public int createUser(string username, string password,int power, string email, string question, string answer)
 22        ...{
 23            StringBuilder sb = new StringBuilder();
 24            sb.Append("insert into userinfo ([username],[password],[power],email,question,answer) values ");
 25            sb.Append(" (@username,@password,@power,@email,@question,@answer)");
 26            OleDbParameter[] param = 
 27                                    ...{
 28                                        OleDbHelper.GetParameter("@username",OleDbType.Char,50,"[username]",username),
 29                                        OleDbHelper.GetParameter("@password",OleDbType.Char,50,"[password]",password),
 30                                         OleDbHelper.GetParameter("@power",OleDbType.Integer,4,"[power]",power),
 31                                        OleDbHelper.GetParameter("@email",OleDbType.Char,50,"email",email),
 32                                        OleDbHelper.GetParameter("@question",OleDbType.Char,50,"question",question),
 33                                        OleDbHelper.GetParameter("@answer",OleDbType.Char,50,"answer",answer)
 34                                    };
 35            return OleDbHelper.ExecuteSql(sb.ToString(), param);
 36        }
 37
 38        /**//// <summary>
 39        /// 获得一个用户资料
 40        /// </summary>
 41        /// <param name="userid"></param>
 42        /// <returns></returns>
 43        public DataTable getUser(int userid)
 44        ...{
 45            StringBuilder sb = new StringBuilder();
 46            sb.Append("select [userid],[username],[password],[power],email,question,answer ");
 47            sb.Append("from userinfo where [userid]=@userid");
 48            OleDbParameter[] param = ...{ OleDbHelper.GetParameter("@userid", OleDbType.Integer, 4, "[userid]", userid) };
 49            return OleDbHelper.ExecuteDt(sb.ToString(), param);
 50        }
 51
 52        /**//// <summary>
 53        /// 获得一个用户资料
 54        /// </summary>
 55        /// <param name="userid"></param>
 56        /// <returns></returns>
 57        public DataTable getUser(string username)
 58        ...{
 59            StringBuilder sb = new StringBuilder();
 60            sb.Append("select [userid],[password],[username],[power],email,question,answer ");
 61            sb.Append("from userinfo where [username]=@username");
 62            OleDbParameter[] param = ...{ OleDbHelper.GetParameter("@username", OleDbType.Char, 50, "[username]", username) };
 63            return OleDbHelper.ExecuteDt(sb.ToString(), param);
 64        }
 65
 66        /**//// <summary>
 67        /// 删除一个用户
 68        /// </summary>
 69        /// <param name="userid">用户编号</param>
 70        /// <returns></returns>
 71        public int delelteUser(int userid)
 72        ...{
 73            StringBuilder sb = new StringBuilder();
 74            sb.Append("delete from userinfo where [userid]=@userid");
 75            OleDbParameter[] param = ...{ OleDbHelper.GetParameter("@userid", OleDbType.Integer, 4, "[userid]", userid) };
 76            return OleDbHelper.ExecuteSql(sb.ToString(), param);
 77        }
 78
 79        /**//// <summary>
 80        /// 修改用户资料
 81        /// </summary>
 82        /// <param name="userid">用户编号</param>
 83        /// <param name="password">用户密码</param>
 84        /// <param name="email">电子邮件</param>
 85        /// <param name="question">密码问题</param>
 86        /// <param name="answer">问题答案</param>
 87        /// <returns></returns>
 88        public int updateUser(int userid, string password, string email, string question, string answer)
 89        ...{
 90            StringBuilder sb = new StringBuilder();
 91            sb.Append("update userinfo set [password]=@password,email=@email,question=@question,");
 92            sb.Append("answer=@answer where [userid]=@userid");
 93            OleDbParameter[] param = 
 94                                    ...{
 95                                        OleDbHelper.GetParameter("@userid",OleDbType.Integer,4,"[userid]",userid),
 96                                        OleDbHelper.GetParameter("@password",OleDbType.Char,50,"[password]",password),
 97                                        OleDbHelper.GetParameter("@email",OleDbType.Char,50,"email",email),
 98                                        OleDbHelper.GetParameter("@question",OleDbType.Char,50,"question",question),
 99                                        OleDbHelper.GetParameter("@answer",OleDbType.Char,50,"answer",answer)
100                                    };
101            return OleDbHelper.ExecuteSql(sb.ToString(), param);
102        }
103
104        /**//// <summary>
105        /// 修改密码
106        /// </summary>
107        /// <param name="userid">用户编号</param>
108        /// <param name="newpassword">新密码</param>
109        /// <returns></returns>
110        public int updateUserPassword(int userid, string newpassword)
111        ...{
112            StringBuilder sb = new StringBuilder();
113            sb.Append("update userinfo set [password]=@newpassword where [userid]=@userid");
114            OleDbParameter[] param = 
115                                   ...{ 
116                                       OleDbHelper.GetParameter("@userid", OleDbType.Integer, 4, "[userid]", userid) ,
117                                       OleDbHelper.GetParameter("@newpassword",OleDbType.Char,50,"[password]",newpassword)
118                                   };
119            return OleDbHelper.ExecuteSql(sb.ToString(), param);
120        }
121
122        /**//// <summary>
123        /// 找回用户密码
124        /// </summary>
125        /// <param name="username">用户名</param>
126        /// <param name="question">密码问题</param>
127        /// <param name="answer">问题答案</param>
128        /// <returns></returns>
129        public string researchPassword(string username, string question, string answer)
130        ...{
131            StringBuilder sb = new StringBuilder();
132            sb.Append("select [password] from userinfo where [username]=@username ");
133            sb.Append("and question=@question and answer=@answer");
134            OleDbParameter[] param = 
135                                    ...{
136                                        OleDbHelper.GetParameter("@username",OleDbType.Char,50,"[username]",username),
137                                        OleDbHelper.GetParameter("@question",OleDbType.Char,50,"question",question),
138                                        OleDbHelper.GetParameter("@answer",OleDbType.Char,50,"answer",answer)
139                                    };
140            DataTable table = OleDbHelper.ExecuteDt(sb.ToString(), param);
141            if (table.Rows.Count > 0)
142            ...{
143                return table.Rows[0]["password"].ToString();
144            }
145            else
146            ...{
147                return "";
148            }
149        }
150
151        /**//// <summary>
152        /// 验证用户登陆
153        /// </summary>
154        /// <param name="username">用户名称</param>
155        /// <param name="password">用户密码</param>
156        /// <returns></returns>
157        public bool validUser(string username, string password,int power)
158        ...{
159            StringBuilder sb = new StringBuilder();
160            sb.Append("select [username] from userinfo where [username]=@username ");
161            sb.Append("and [password]=@password and [power]=@power");
162            OleDbParameter[] param = 
163                                    ...{
164                                        OleDbHelper.GetParameter("@username",OleDbType.Char,50,"[username]",username),
165                                        OleDbHelper.GetParameter("@password",OleDbType.Char,50,"[password]",password),
166                                        OleDbHelper.GetParameter("@power",OleDbType.Integer,4,"[power]",power)
167                                    };
168            DataTable table = OleDbHelper.ExecuteDt(sb.ToString(), param);
169            if (table.Rows.Count > 0)
170            ...{
171                return true;
172            }
173            else
174            ...{
175                return false;
176            }
177        }
178
179        /**//// <summary>
180        /// 用户名是否已经存在
181        /// </summary>
182        /// <param name="username">用户名称</param>
183        /// <returns></returns>
184        public bool IsExtie(string username)
185        ...{
186            StringBuilder sb = new StringBuilder();
187            sb.Append("select [username] from userinfo where [username]=@username ");
188            OleDbParameter[] param = 
189                                    ...{
190                                        OleDbHelper.GetParameter("@username",OleDbType.Char,50,"[username]",username),
191                                    };
192            DataTable table = OleDbHelper.ExecuteDt(sb.ToString(), param);
193            if (table.Rows.Count > 0)
194            ...{
195                return true;
196            }
197            else
198            ...{
199                return false;
200            }
201        }
202
203        /**//// <summary>
204        /// 获得一般用户或者管理员用户列表
205        /// </summary>
206        /// <param name="power"></param>
207        /// <returns></returns>
208        public DataTable getUserlist(string name,int power)
209        ...{
210            StringBuilder sb = new StringBuilder();
211            sb.Append("select [userid],[username],email from userinfo where [power]=@power");
212            List<OleDbParameter> list = new List<OleDbParameter>();
213            list.Add(OleDbHelper.GetParameter("@power", OleDbType.Integer, 4, "[power]", power));
214
215            if (name != "")
216            ...{
217                sb.Append(" and [username] like '%' + @name + '%'");
218                list.Add(OleDbHelper.GetParameter("@name", OleDbType.Char, 50, "[username]", name));
219            }
220
221            return OleDbHelper.ExecuteDt(sb.ToString(), list.ToArray());
222        }
223    }
224}
225