public static DataTable GetLotteryUser(string sPhoneNumber)
{
DataBase dataBase = new DataBase();
string sql = "select * from Players where CellPhoneNo = @CellPhoneNo";
SqlParameter[] sqlparameter = new SqlParameter[1];
sqlparameter[0] = new SqlParameter("@CellPhoneNo", sPhoneNumber);
return dataBase.ExcuteSqlReturnDataTable(sql, sqlparameter);
}
public static DataTable GetLotteryHistory(string sPhoneNumber)
{
DataBase dataBase = new DataBase();
string sql = "select a.cellphoneno,a.lotterytime,b.awardname,a.cardcode from LotteryHistory a join Awards b on a.AwardId = b.AwardId";
if (!string.IsNullOrWhiteSpace(sPhoneNumber))
{
sql += "where CellPhoneNo = " + sPhoneNumber;
}
return dataBase.ExcuteSqlReturnDataTable(sql);
}
public static DataTable GetUserDownloadInfo(string sPhoneNumber)
{
DataBase dataBase = new DataBase();
string sql = "select * from DownloadHistory where CellPhoneNo = @CellPhoneNo";
SqlParameter[] sqlparameter = new SqlParameter[1];
sqlparameter[0] = new SqlParameter("@CellPhoneNo", sPhoneNumber);
return dataBase.ExcuteSqlReturnDataTable(sql, sqlparameter);
}
public static DataTable GetLotteryAllUser()
{
DataBase dataBase = new DataBase();
string sql = "select * from Players ";
return dataBase.ExcuteSqlReturnDataTable(sql);
}
public static DataTable GetGame2DownTime()
{
DataBase dataBase = new DataBase();
string sql = "select * from DownloadHistory where Game2 = 1";
return dataBase.ExcuteSqlReturnDataTable(sql);
}
public static DataTable GetAllLotteryAwards()
{
DataBase dataBase = new DataBase();
string sql = "select * from Awards";
return dataBase.ExcuteSqlReturnDataTable(sql);
}