/// <summary>
/// 用户登录
/// </summary>
/// <param name="account"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public bool login(string account, string pwd,ref table_repark_user userinfo)
{
string sql = "select * from repark_user where account='" + account + "' and password='******'";
SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql);
if (reader != null) {
if (reader.Read()) {
userinfo.id = int.Parse(reader["id"].ToString());
userinfo.account = reader["account"].ToString();
userinfo.password =reader["password"].ToString();
userinfo.nickname =reader["nickname"].ToString();
userinfo.level = reader["level"].ToString();
userinfo.group_ids = reader["group_ids"].ToString();
userinfo.email = reader["email"].ToString();
userinfo.ctime = reader["ctime"].ToString();
reader.Close();
return true;
}
reader.Close();
}
return false;
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="account"></param>
/// <returns></returns>
public table_repark_user get_user(string account)
{
string sql = "select * from repark_user where account='" + account + "'";
SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql);
if (reader != null)
{
if (reader.Read())
{
table_repark_user userinfo = new table_repark_user();
userinfo.id = int.Parse(reader["id"].ToString());
userinfo.account = reader["account"].ToString();
userinfo.password = reader["password"].ToString();
userinfo.nickname = reader["nickname"].ToString();
userinfo.email = reader["email"].ToString();
userinfo.ctime = reader["ctime"].ToString();
reader.Close();
return userinfo;
}
reader.Close();
}
return null;
}
