public static DataSet GetList()
{
mariasql m = new mariasql();
string sql = "SELECT A.*,B.NICK_NAME FROM LOGIN_HISTORY AS A INNER JOIN USER AS B ON A.USER_ID=B.USER_ID ORDER BY CREATE_DATE DESC;";
return(m.GetDataset(sql));
}
public static DataSet GetList(string uid)
{
mariasql m = new mariasql();
string sql = "SELECT A.*,B.NICK_NAME FROM LOGIN_HISTORY AS A INNER JOIN USER AS B ON A.USER_ID=B.USER_ID WHERE A.USER_ID=@USER_ID ORDER BY CREATE_DATE DESC;";
List <MySqlParameter> l = new List <MySqlParameter>();
l.Add(new MySqlParameter("@USER_ID", uid));
return(m.GetDataset(sql, l));
}