protected void Page_Load(object sender, EventArgs e)
{
/*
* if(Session["user_name"] == null){
* Response.Redirect("Login.aspx");
* };
*/
//this.session_name = "¶¶°Õ";
DataTable dt;
string cmdSql = string.Format("SELECT * FROM {0}", ComSQL.TABLE_MEMBER);
dt = MySqlDbAccess.ExcuteQueryData(cmdSql, false);
this.json = JsonConvert.SerializeObject(dt.Rows[0]);
//Response.Write(dt.Rows[0]["user_name"]);
//Response.Write(this.json );
/*
* clsMember m = new clsMember();
* m.user_name = this.session_name;
* dt = ComSQL.Member_ExistAccount(m);
* Response.Write(dt.Rows.Count);
*/
}
public static DataTable Member_ExistAccount(clsMember m)
{
DataTable dt = new DataTable();
string cmdSql = string.Format("SELECT * FROM {0} WHERE USER_NAME='{1}'", TABLE_MEMBER, m.user_name);
dt = MySqlDbAccess.ExcuteQueryData(cmdSql, false);
return(dt);
}
public static DataTable Member_ExistPassword(clsMember m)
{
DataTable dt = new DataTable();
string cmdSql = string.Format("SELECT * FROM {0} WHERE PASSWORD='******'", TABLE_MEMBER, m.password);
dt = MySqlDbAccess.ExcuteQueryData(cmdSql, false);
return(dt);
}
public static DataTable Member_ActiveCheck(clsMember m)
{
DataTable dt = new DataTable();
string cmdSql = string.Format("SELECT * FROM {0} WHERE USER_NAME='{1}' AND PASSWORD='******' AND ACTIVE='Y'", TABLE_MEMBER, m.user_name, m.password);
dt = MySqlDbAccess.ExcuteQueryData(cmdSql, false);
return(dt);
}
public static DataTable Member_ExistMail(clsMember m)
{
DataTable dt = new DataTable();
string cmdSql = string.Format("SELECT * FROM {0} WHERE EMAIl='{1}'", TABLE_MEMBER, m.email);
dt = MySqlDbAccess.ExcuteQueryData(cmdSql, false);
return(dt);
}
