public void Init()
{
var trans = MyDBHelper.Instance.CreateTrans();
try
{
//GlobalConfig.IncomeMoneyAccount = DBProvider.SystemDBProvider.GetIncomeMoneyAccountConfig();
//if (GlobalConfig.IncomeMoneyAccount == null)
//{
// //LogHelper.Instance.AddErrorLog("没有设置收款信息。", null);
//}
GlobalConfig.GameConfig = DBProvider.SystemDBProvider.GetGameConfig();
if (GlobalConfig.GameConfig == null)
{
GlobalConfig.GameConfig = new GameConfig();
DBProvider.SystemDBProvider.SaveGameConfig(GlobalConfig.GameConfig, trans);
}
GlobalConfig.RegisterPlayerConfig = DBProvider.SystemDBProvider.GetRegisterUserConfig();
if (GlobalConfig.RegisterPlayerConfig == null)
{
GlobalConfig.RegisterPlayerConfig = new RegisterUserConfig();
DBProvider.SystemDBProvider.SaveRegisterUserConfig(GlobalConfig.RegisterPlayerConfig, trans);
}
GlobalConfig.AwardReferrerLevelConfig = new AwardReferrerLevelConfig();
GlobalConfig.AwardReferrerLevelConfig.SetListAward(DBProvider.SystemDBProvider.GetAwardReferrerConfig());
if (GlobalConfig.AwardReferrerLevelConfig.AwardLevelCount == 0)
{
var config = new AwardReferrerConfig();
List <AwardReferrerConfig> listConfig = new List <AwardReferrerConfig>();
listConfig.Add(config);
DBProvider.SystemDBProvider.SaveAwardReferrerConfig(listConfig, trans);
GlobalConfig.AwardReferrerLevelConfig.SetListAward(listConfig);
}
GlobalConfig.RouletteConfig = DBProvider.SystemDBProvider.GetRouletteConfig();
trans.Commit();
}
catch (Exception exc)
{
trans.Rollback();
throw exc;
}
finally
{
trans.Dispose();
}
}
public AwardReferrerConfig ToDBObject()
{
AwardReferrerConfig dbConfig = new AwardReferrerConfig()
{
AwardReferrerDiamond = this.AwardReferrerDiamond,
AwardReferrerExp = this.AwardReferrerExp,
AwardReferrerGoldCoin = this.AwardReferrerGoldCoin,
AwardReferrerMiners = this.AwardReferrerMiners,
AwardReferrerMines = this.AwardReferrerMines,
AwardReferrerStones = this.AwardReferrerStones,
ReferLevel = this.ReferLevel
};
return(dbConfig);
}
public List <AwardReferrerConfig> GetAwardReferrerConfig()
{
List <AwardReferrerConfig> listAwardConfig = new List <AwardReferrerConfig>();
MySqlConnection myconn = null;
try
{
myconn = MyDBHelper.Instance.CreateConnection();
myconn.Open();
DataTable table = new DataTable();
string cmdText = "SELECT * FROM awardreferrerconfig";
MySqlCommand mycmd = new MySqlCommand(cmdText, myconn);
MySqlDataAdapter adapter = new MySqlDataAdapter(mycmd);
adapter.Fill(table);
for (int i = 0; i < table.Rows.Count; i++)
{
AwardReferrerConfig config = new AwardReferrerConfig();
config.ReferLevel = Convert.ToInt32(table.Rows[i]["ReferLevel"]);
config.AwardReferrerExp = Convert.ToDecimal(table.Rows[i]["AwardReferrerExp"]);
config.AwardReferrerGoldCoin = Convert.ToDecimal(table.Rows[i]["AwardReferrerGoldCoin"]);
config.AwardReferrerMines = Convert.ToDecimal(table.Rows[i]["AwardReferrerMines"]);
config.AwardReferrerMiners = Convert.ToInt32(table.Rows[i]["AwardReferrerMiners"]);
config.AwardReferrerStones = Convert.ToDecimal(table.Rows[i]["AwardReferrerStones"]);
config.AwardReferrerDiamond = Convert.ToDecimal(table.Rows[i]["AwardReferrerDiamond"]);
listAwardConfig.Add(config);
}
table.Clear();
table.Dispose();
adapter.Dispose();
mycmd.Dispose();
return(listAwardConfig);
}
catch (Exception exc)
{
throw exc;
}
finally
{
MyDBHelper.Instance.DisposeConnection(myconn);
}
}
public static AwardReferrerConfigUIModel CreateFromDBObject(AwardReferrerConfig parent)
{
if (parent == null)
{
return(new AwardReferrerConfigUIModel());
}
AwardReferrerConfigUIModel uiConfig = new AwardReferrerConfigUIModel()
{
AwardReferrerDiamond = parent.AwardReferrerDiamond,
AwardReferrerExp = parent.AwardReferrerExp,
AwardReferrerGoldCoin = parent.AwardReferrerGoldCoin,
AwardReferrerMiners = parent.AwardReferrerMiners,
AwardReferrerMines = parent.AwardReferrerMines,
AwardReferrerStones = parent.AwardReferrerStones,
ReferLevel = parent.ReferLevel
};
return(uiConfig);
}
