public MemberModel(int member_id)
{
SqlDataObject dbo = new SqlDataObject();
dbo.SqlComm = "select * from t_member where member_id = @member_id";
DataTable dt = dbo.GetDataTable(new MySqlParameter("@member_id", member_id));
if (dt.Rows.Count == 0)
throw new Exception("Can't find member with member_id:" + member_id.ToString());
//member
DataRow dr = dt.Rows[0];
this.member_id = (int)dr["member_id"];
this.email = dr["email"].ToString();
this.cellphone = dr["cellphone"].ToString();
}
public static List<MemberModel> GetAllMembers(bool include_disabled)
{
List<MemberModel> members = new List<MemberModel>();
SqlDataObject dbo = new SqlDataObject();
dbo.SqlComm = "select * from t_member";
DataTable dt = dbo.GetDataTable();
foreach(DataRow dr in dt.Rows)
{
var member = new MemberModel();
member.cellphone = dr["cellphone"].ToString();
member.email = dr["email"].ToString();
members.Add(member);
}
return members;
}
public static MemberModel SignIn(string email, string cellphone, string password)
{
SqlDataObject dbo = new SqlDataObject();
dbo.SqlComm = "select * from t_member where cellphone = @cellphone";
DataTable dt = dbo.GetDataTable(new MySqlParameter("@cellphone", email));
if (dt.Rows.Count == 0)
return null;//没找到
DataRow dr = dt.Rows[0];
MemberModel mm = new MemberModel();
mm.cellphone = dr["cellphone"].ToString();
mm.email = dr["email"].ToString();
mm.enc_password = dr["enc_password"].ToString();
if (Common.PasswordCompare(mm.enc_password,password))
{
return mm;
}
else
{
throw new AuthenticationException();
}
}
public static bool SignUp(string email, string cellphone, string password)
{
SqlDataObject dbo = new SqlDataObject();
dbo.SqlComm = "select * from t_member where member_id = -1";
DataTable dt = dbo.GetDataTable();
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
dr["email"] = email;
dr["cellphone"] = cellphone;
dr["enc_password"] = Common.Encrypt(password);
dbo.Update(dt);
return true;
}
public static MemberModel Login(string email, string cellphone, string plain_password)
{
SqlDataObject dbo = new SqlDataObject();
dbo.SqlComm = "select * from t_member where email=@email or cellphone=@cellphone";
DataTable dt = dbo.GetDataTable(new MySqlParameter("@email", email), new MySqlParameter("@cellphone", cellphone));
if (dt.Rows.Count == 0)
throw new AuthenticationException("用户没有找到");
DataRow dr = dt.Rows[0];
var enc_password = dr["enc_password"].ToString();
if (Common.PasswordCompare(enc_password,plain_password))
{
//password is good
MemberModel mm = MemberModel.GetMember((int)dr["member_id"]);
//put to onlineuser
var token = Guid.NewGuid().ToString();
NoSqlDataObject.AddOnlineUser(mm.member_id, token);
mm.token = token;
return mm;
}
else
{
throw new AuthenticationException("密码错误");
}
}