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); }