// POST api/Home?token={token}&sid={sid}
/// <summary>获取首页图表数据</summary>
/// <param name="token">令牌</param>
/// <param name="sid">服务器id</param>
public ChartHome PostChartHome(String token, Int32 sid)
{
if (!IsToken(token))
{
return(new ChartHome()
{
result = -1, message = "令牌不存在"
});
}
tgm_server.SetDbConnName(tgm_connection);
var server = tgm_server.FindByid(sid);
if (server == null)
{
return(new ChartHome()
{
result = -2, message = "服务器不存在"
});
}
var entity = new ChartHome();
SN = server.name;
report_day.SetDbConnName(db_connection);
var player = report_day.Find("");
if (player == null)
{
player = new report_day();
}
entity.server.Add(player.online); //在线人数
entity.server.Add(player.taday_online); //今日最高在线人数
entity.server.Add(player.register); //今日注册人数
entity.server.Add(player.taday_login); //今日登陆人数
tgm_record_hours.SetDbConnName(tgm_connection);
var pay = tgm_record_hours.Proc_sp_pay(sid);
if (pay == null)
{
pay = new tgm_record_hours();
}
entity.pay.Add(pay.pay_number); //今日充值人数
entity.pay.Add(pay.pay_count); //今日充值次数
entity.pay.Add(pay.pay_taday); //今日充值
entity.pay.Add(pay.pay_month); //月充值
return(entity);
}
/// <summary>单服作业</summary>
/// <param name="model"></param>
private static void GetSingleServer(tgm_server model)
{
try
{
report_day.SetDbConnName(DBConnect.GetName(model));
var tgg = report_day.GetFindByTime();
if (tgg == null)
{
tgg = new report_day();
}
tgm_record_pay.SetDbConnName(DBConnect.GetName(null));
var pay = tgm_record_hours.Proc_sp_pay(model.id);
if (pay == null)
{
pay = new tgm_record_hours();
}
tgm_record_hours.SetDbConnName(DBConnect.GetName(null));
var entity = tgm_record_hours.GetFindBySidTime(model.id);
if (entity == null)
{
entity = new tgm_record_hours();
}
entity.pid = model.pid;
entity.sid = model.id;
entity.server_name = model.name;
entity.offline = tgg.offline;
entity.online = tgg.online;
entity.history_online = tgg.history_online;
entity.register = tgg.register;
entity.register_total = tgg.register_total;
entity.taday_login = tgg.taday_login;
entity.taday_online = tgg.taday_online;
entity.pay_count = pay.pay_count;
entity.pay_number = pay.pay_number;
entity.pay_taday = pay.pay_taday;
entity.pay_total = pay.pay_total;
entity.pay_month = pay.pay_month;
entity.createtime = DateTime.Now.Ticks;
entity.Save();
tgm_record_day.SetDbConnName(DBConnect.GetName(null));
var r_day = tgm_record_day.GetFindBySidTime(entity.sid);
//是否没有数据
if (r_day == null)
{
r_day = new tgm_record_day();
}
r_day.pid = entity.pid;
r_day.sid = entity.sid;
r_day.server_name = entity.server_name;
r_day.offline = entity.offline;
r_day.online = entity.online;
r_day.history_online = entity.history_online;
r_day.register = entity.register;
r_day.register_total = entity.register_total;
r_day.taday_login = entity.taday_login;
r_day.taday_online = entity.taday_online;
r_day.pay_count = entity.pay_count;
r_day.pay_number = entity.pay_number;
r_day.pay_taday = entity.pay_taday;
r_day.pay_total = entity.pay_total;
r_day.pay_month = entity.pay_month;
r_day.createtime = DateTime.Now.Ticks;
r_day.Save();
tgm_record_server.SetDbConnName(DBConnect.GetName(null));
var server = tgm_record_server.GetFindBySid(model.id);
if (server == null)
{
server = new tgm_record_server();
}
server.pid = entity.pid;
server.sid = entity.sid;
server.server_name = entity.server_name;
server.offline = entity.offline;
server.online = entity.online;
server.history_online = entity.history_online;
server.register = entity.register;
server.register_total = entity.register_total;
server.taday_login = entity.taday_login;
server.taday_online = entity.taday_online;
server.pay_count = entity.pay_count;
server.pay_number = entity.pay_number;
server.pay_taday = entity.pay_taday;
server.pay_total = entity.pay_total;
server.pay_month = entity.pay_month;
server.createtime = model.createtime;
server.Save();
}
catch (Exception)
{
XTrace.WriteLine("单服作业失败");
}
}
private void SingleServer(tgm_server model)
{
try
{
DisplayGlobal.log.Write("游戏服务器数据统计中...");
report_day.SetDbConnName(DBConnect.GetName(model));
var tgg = report_day.GetFindByTime();
if (tgg == null)
{
tgg = new report_day();
}
tgm_record_pay.SetDbConnName(DBConnect.GetName(null));
var pay = tgm_record_hours.Proc_sp_pay(model.id);
if (pay == null)
{
pay = new tgm_record_hours();
}
tg_log_operate.SetDbConnName(DBConnect.GetName(model));
var cost_gold = tg_log_operate.GetTodayCost((int)GoodsType.TYPE_GOLD, (int)LogType.Use);
if (cost_gold == null)
{
cost_gold = 0;
}
tgm_record_hours.SetDbConnName(DBConnect.GetName(null));
var entity = tgm_record_hours.GetFindBySidTime(model.id);
if (entity == null)
{
entity = new tgm_record_hours();
}
entity.pid = model.pid;
entity.sid = model.id;
entity.server_name = model.name;
entity.offline = tgg.offline;
entity.online = tgg.online;
entity.history_online = tgg.history_online;
entity.register = tgg.register;
entity.register_total = tgg.register_total;
entity.taday_login = tgg.taday_login;
entity.taday_online = tgg.taday_online;
entity.pay_count = pay.pay_count;
entity.pay_number = pay.pay_number;
entity.pay_taday = pay.pay_taday;
entity.pay_total = pay.pay_total;
entity.pay_month = pay.pay_month;
entity.createtime = DateTime.Now.Ticks;
entity.taday_cost = cost_gold;
entity.Save();
tgm_record_day.SetDbConnName(DBConnect.GetName(null));
var r_day = tgm_record_day.GetFindBySidTime(entity.sid);
//是否没有数据
if (r_day == null)
{
r_day = new tgm_record_day();
}
r_day.pid = entity.pid;
r_day.sid = entity.sid;
r_day.server_name = entity.server_name;
r_day.offline = entity.offline;
r_day.online = entity.online;
r_day.history_online = entity.history_online;
r_day.register = entity.register;
r_day.register_total = entity.register_total;
r_day.taday_login = entity.taday_login;
r_day.taday_online = entity.taday_online;
r_day.pay_count = entity.pay_count;
r_day.pay_number = entity.pay_number;
r_day.pay_taday = entity.pay_taday;
r_day.pay_total = entity.pay_total;
r_day.pay_month = entity.pay_month;
r_day.createtime = DateTime.Now.Ticks;
r_day.taday_cost = cost_gold;
r_day.Save();
tgm_record_server.SetDbConnName(DBConnect.GetName(null));
var server = tgm_record_server.GetFindBySid(model.id);
if (server == null)
{
server = new tgm_record_server();
}
server.pid = entity.pid;
server.sid = entity.sid;
server.server_name = entity.server_name;
server.offline = entity.offline;
server.online = entity.online;
server.history_online = entity.history_online;
server.register = entity.register;
server.register_total = entity.register_total;
server.taday_login = entity.taday_login;
server.taday_online = entity.taday_online;
server.pay_count = entity.pay_count;
server.pay_number = entity.pay_number;
server.pay_taday = entity.pay_taday;
server.pay_total = entity.pay_total;
server.pay_month = entity.pay_month;
server.createtime = model.createtime;
server.taday_cost = cost_gold;
server.Save();
}
catch (Exception)
{
DisplayGlobal.log.Write("单服作业失败");
}
}
