// 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("单服作业失败"); } }