internal UserInfo Get(int id)
{
UserInfo user = null;
SqlConnection conn = null;
SqlDataReader reader = null;
try
{
conn = DBUtil.GetConn();
StringBuilder sb = new StringBuilder();
sb.AppendLine("select *");
sb.AppendLine("from userInfo");
sb.AppendLine("where userid = {0}");
string sql = string.Format(sb.ToString(), id);
SqlCommand cmd = new SqlCommand(sql, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
user = new UserInfo();
user.Email = reader["email"].ToString();
user.Pwd = reader["userpwd"].ToString();
user.OnlineDay = Convert.ToDouble(reader["onlineDay"]);
user.Name = reader["username"].ToString();
user.LevelId = (int)reader["levelId"];
user.Id = (int)reader["userid"];
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
DBUtil.CloseAll(conn, reader);
}
return(user);
}
public static List <UserInfo> FindAll()
{
List <UserInfo> list = new List <UserInfo>();
SqlConnection conn = null;
SqlDataReader reader = null;
try
{
conn = DBUtil.GetConn();
StringBuilder sb = new StringBuilder();
sb.AppendLine("select u.*, l.flag");
sb.AppendLine("from userInfo u, level l");
sb.AppendLine("where u.levelId = l.levelId");
SqlCommand cmd = new SqlCommand(sb.ToString(), conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
UserInfo u = new UserInfo();
u.Email = reader["email"].ToString();
u.Pwd = reader["userpwd"].ToString();
u.OnlineDay = Convert.ToDouble(reader["onlineDay"]);
u.Name = reader["username"].ToString();
u.LevelId = (int)reader["levelId"];
u.Id = (int)reader["userid"];
u.Flag = reader["flag"].ToString();
list.Add(u);
}
}catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
DBUtil.CloseAll(conn, reader);
}
return(list);
}
public bool Login(string loginId, string loginPwd)
{
int r = 0;
SqlConnection conn = DBUtil.GetConn();
try
{
string sql = string.Format("select count(0) from admin " +
"where loginId='{0}' and loginPwd = '{1}'",
loginId, loginPwd);
SqlCommand cmd = new SqlCommand(sql, conn);
r = (int)cmd.ExecuteScalar();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
DBUtil.CloseAll(conn, null);
}
return(r > 0);
}