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 List<MemberModel> GetOnlineUsers()
{
if (mysession == null)
mysession = Connect("121.41.46.175");
var rs = mysession.Execute("SELECT * FROM onlineusers");
List<MemberModel> result = new List<MemberModel>();
//Iterate through the RowSet
foreach (var row in rs)
{
MemberModel mm = new MemberModel();
mm.email = row.GetValue<string>("email");
mm.cellphone = row.GetValue<string>("cellphone");
mm.token = row.GetValue<string>("auth_token");
result.Add(mm);
}
return result;
}
public static MemberModel GetMember(string token)
{
var member_id = NoSqlDataObject.IsTokenValid(token);
var member = new MemberModel(member_id);
member.token = token;
return member;
}
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();
}
}
