public long GetJackpot(DatabaseService.DatabaseLink dbLink, string game_name, int grade)
{
using (var reader = dbLink.ExecuteReader("get game info", game_name))
{
if (reader == null)
{
return(0);
}
if (!reader.Read())
{
return(0);
}
return(reader.GetInt64Safe(string.Format("grade{0}_jackpot", grade)));
}
}
public int GetBigAwardCounter(DatabaseService.DatabaseLink dbLink, string game_name, int grade)
{
using (var reader = dbLink.ExecuteReader("get game info", game_name))
{
if (reader == null)
{
return(0);
}
if (!reader.Read())
{
return(0);
}
return(reader.GetInt32Safe(string.Format("grade{0}_bigaward_counter", grade)));
}
}
public JObject GetUserGameData(DatabaseService.DatabaseLink dbLink, string game_name, int grade, string show_id)
{
using (var reader = dbLink.ExecuteReader("get user game info", game_name, grade, show_id))
{
if (reader == null)
{
return(null);
}
if (!reader.Read())
{
return(null);
}
string jsonData = reader.GetStringSafe("data");
if (jsonData.Length == 0)
{
return(null);
}
return(JObject.Parse(jsonData));
}
}
public MySqlDataReader GetBackControl(DatabaseService.DatabaseLink dbLink, string cmd, string game_name, int grade)
{
return(dbLink.ExecuteReader("get back control", cmd, game_name, grade));
}
public MySqlDataReader GetGameInfo(DatabaseService.DatabaseLink dbLink, string game_name)
{
return(dbLink.ExecuteReader("get game info", game_name));
}
public MySqlDataReader GetGetNotice(DatabaseService.DatabaseLink dbLink, string type)
{
return(dbLink.ExecuteReader("get notice", type));
}
public MySqlDataReader GetUserBaseInfo(DatabaseService.DatabaseLink dbLink, string show_id)
{
return(dbLink.ExecuteReader("get user base info", show_id));
}
public MySqlDataReader GetGameList(DatabaseService.DatabaseLink dbLink, string kind)
{
return(dbLink.ExecuteReader("get game list", kind));
}
public MySqlDataReader GetRecordBank(DatabaseService.DatabaseLink dbLink, string show_id)
{
return(dbLink.ExecuteReader("get bank record", show_id));
}
public MySqlDataReader GetUserMail(DatabaseService.DatabaseLink dbLink, string show_id)
{
return(dbLink.ExecuteReader("get user mail", show_id));
}
public MySqlDataReader CheckUser(DatabaseService.DatabaseLink dbLink, string account, string login_pwd)
{
return(dbLink.ExecuteReader("check user", account, login_pwd));
}
public MySqlDataReader GetUserInfoByAccount(DatabaseService.DatabaseLink dbLink, string account)
{
return(dbLink.ExecuteReader("get userbaseinfo by account", account));
}