/// <summary> /// 根据用户名,返回用户实体 /// </summary> /// <param name="strUserName">用户名</param> /// <returns>User</returns> public static User GetUserByUserName(string strUserName) { //根据用户名,查询是否存在此用户 string strSqlGetUser = "******"; SQLHelp help = new SQLHelp(); SqlDataReader dr = null; SqlParameter[] para = { new SqlParameter("@UserName", strUserName) }; //根据用户名,返回dataReader对象 dr = help.GetDRWithPara(strSqlGetUser, para); //数据流中是否有数据 if (dr.Read()) { //声明User对象,将数据流中的值赋给User对象 User newUser = new User(); newUser.UserID = Convert.ToInt32(dr["UserID"]); newUser.UserName = dr["UserName"].ToString(); newUser.Pwd = dr["Pwd"].ToString(); newUser.Email = dr["Email"].ToString(); newUser.Score = Convert.ToInt32(dr["Score"]); //关闭SqlDataReader对象,此时连接同时关闭 //详见SQLHelp:GetDRWithPara(string cmdText, SqlParameter[] para) //mycom.ExecuteReader(CommandBehavior.CloseConnection); dr.Close(); return(newUser); } else { dr.Close(); return(null); } }