public static void Insert(string topUpData)
{
string insertSql = "INSERT INTO TopUpHistory " +
" VALUES( '" + PlayerDataBaseControl.playerID + "', '" + PointCardDataBaseControl.pointCardID + "', '" + topUpData + "' );";
DataBaseControl.ExecuteSql(insertSql);
}
public static void Updata_isEnglish(bool updataValue)
{
isEnglish = updataValue;
string updateSql = "UPDATE Staff SET isEnglish = " + updataValue +
" WHERE StaffID = \'" + staffID + "\' ;";
DataBaseControl.ExecuteSql(updateSql);
}
public static void Insert()
{
string insertSql = "INSERT INTO ProblemReport " +
" VALUES( '" + "R" + (SystemDataBaseControl.Get_ProblemReportNum() + 1).ToString().PadLeft(7, '0')
+ "', '" + PlayerDataBaseControl.playerID + "', '" + title + "', '" + detail + "' );";
DataBaseControl.ExecuteSql(insertSql);
}
public static void Insert(string playerAccountName, string playerPassword, string playerEmail)
{
string insertSql = "INSERT INTO Player(PlayerID, PlayerAccountName, PlayerPassword, PlayerEmail)" +
" VALUES( \"P" + (SystemDataBaseControl.Get_PlayerNum() + 1).ToString().PadLeft(7, '0') + "\", \"" + playerAccountName + "\", \"" + playerPassword + "\", \"" + playerEmail + "\");";
DataBaseControl.ExecuteSql(insertSql);
SystemDataBaseControl.Updata_PlayerNum_PlusOne();
}
public static void Insert()
{
string insertSql = "INSERT INTO PointCard " +
" VALUES( '" + pointCardID + "', '" +
activePwd + "', " +
retailValue + ", " +
goldCoins + ", " +
remainLuckyDrawTimes + ", '" +
status + "', '" +
generationDate + "');";
DataBaseControl.ExecuteSql(insertSql);
}
public static void Updata_ProblemReportNum_PlusOne()
{
string updateSql = "UPDATE System SET ProblemReportNum = ProblemReportNum + 1;";
DataBaseControl.ExecuteSql(updateSql);
}
public static void Updata_ProblemReportNum(int value)
{
string updateSql = "UPDATE System SET ProblemReportNum = " + value + ";";
DataBaseControl.ExecuteSql(updateSql);
}
public static void Updata_PointCardNum_PlusOne()
{
string updateSql = "UPDATE System SET PointCardNum = PointCardNum + 1;";
DataBaseControl.ExecuteSql(updateSql);
}
