// public static User GetUserByLoginId(string loginId)
// {
// string sql = "SELECT * FROM Users WHERE LoginId = @loginId";
// SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@LoginId", loginId));
// if (reader.Read())
// {
// User user = new User();
// user.Id = (int)reader["Id"];
// user.LoginId = (string)reader["LoginId"];
// user.LoginPwd = (string)reader["LoginPwd"];
// user.Name = (string)reader["Name"];
// user.QQ = (string)reader["QQ"];
// user.Mail = (string)reader["Mail"];
// reader.Close();
// return user;
// }
// else
// {
// reader.Close();
// return null;
// }
public Userinfo GetUserById(int id)
{
string sql = "SELECT * FROM Users WHERE Id = @Id";
SqlDataReader reader = Helper.GetReader(sql, new SqlParameter("@Id", id));
if (reader.Read())
{
Userinfo user = new Userinfo();
user.Id = (int)reader["Id"];
user.UserId = (string)reader["UserId"];
user.Pwd = (string)reader["Pwd"];
user.UserName = reader["UserName"] == DBNull.Value ? null : (string)reader["UserName"];
user.Email = (string)reader["Email"];
user.QQ = (string)reader["QQ"];
reader.Close();
return(user);
}
else
{
reader.Close();
return(null);
}
}
//public bool LoginIdExists(string UserId)
//{
// if (GetUserByLoginId(UserId) != true;
// return true;
//}
//判断用户是否存在
public bool GetUserByLoginId(string UserId)
{
Userinfo info = new Userinfo();
info = null;
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@UserId", UserId)
};
object obj = Helper.ExecuteScalar("GetUserByLoginId", CommandType.StoredProcedure, param);
return(Convert.ToBoolean(obj));
}
//注册用户
public void Add_Users(Userinfo info)
{
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@UserId", info.UserId),
new SqlParameter("@NickName", info.NickName),
new SqlParameter("@Pwd", info.Pwd),
new SqlParameter("@Email", info.Email),
new SqlParameter("@QQ", info.QQ),
};
object obj = Helper.ExecuteScalar("Add_Users", CommandType.StoredProcedure, paras);
//if (obj != null)
//{
// int Suid = Convert.ToInt32(obj);
// SqlParameter[] param = new SqlParameter[]
// {
// new SqlParameter ("@Suid",SqlDbType.Int,4),
// new SqlParameter ("@Number",SqlDbType.Int,4),
// new SqlParameter ("@Name",SqlDbType.VarChar,100)
// };
}
/// <returns></returns>
public Userinfo GetUserById(string UserId)
{
List <Userinfo> list = new List <Userinfo>();
Userinfo info = new Userinfo();
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter("@UserId", UserId)
};
using (SqlDataReader dr = Helper.ExecuteReader("GetUsersinfo", CommandType.StoredProcedure, parm))
{
while (dr.Read())
{
//info = new ProductInfo(Convert.ToInt32(dr["ProductId"]), dr["ProductName"].ToString(), dr["Brand"].ToString(), Convert.ToDecimal(dr["Price"]), dr["PublishDate"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["publishDate"]), Convert.ToBoolean(dr["Vis"]));
info.Id = Convert.ToInt32(dr["Id"]);
info.UserId = dr["UserId"].ToString();
info.Pwd = dr["Pwd"].ToString();
info.NickName = dr["NickName"].ToString();
info.Email = dr["Email"].ToString();
info.QQ = dr["QQ"].ToString();
}
}
return(info);
}
