public static void DownloadGame2(string sPhoneNumber)
{
DataBase dataBase = new DataBase();
string sql = "exec spDownloadGame2 @CellPhoneNo = @CellPhone";
SqlParameter[] sqlparameter = new SqlParameter[1];
sqlparameter[0] = new SqlParameter("@CellPhone", sPhoneNumber);
dataBase.ExcuteSqlReturnInt(sql, sqlparameter);
}
public static void StoreLotteryUser(string sPhoneNumber)
{
DataBase dataBase = new DataBase();
string sql = "exec spNewPlayer @CellPhoneNo = @CellPhone";
SqlParameter[] sqlparameter = new SqlParameter[1];
sqlparameter[0] = new SqlParameter("@CellPhone", sPhoneNumber);
dataBase.ExcuteSqlReturnInt(sql, sqlparameter);
}
public static bool UpdateAward(string sAwardId,string sAwardName, string sRate, string sTotalCount, string sSurplusCount)
{
DataBase dataBase = new DataBase();
string sql = "update Awards set AwardName = @AwardName ,Rate = @Rate, TotalCount = @TotalCount,SurplusCount = @SurplusCount where AwardId = @AwardId ";
SqlParameter[] sqlparameter = new SqlParameter[5];
sqlparameter[0] = new SqlParameter("@AwardName", sAwardName);
sqlparameter[1] = new SqlParameter("@Rate", sRate);
sqlparameter[2] = new SqlParameter("@TotalCount", sTotalCount);
sqlparameter[3] = new SqlParameter("@SurplusCount", sSurplusCount);
sqlparameter[4] = new SqlParameter("@AwardId", sAwardId);
return dataBase.ExcuteSqlReturnInt(sql, sqlparameter) > 0;
}