/// <summary>RecordServer 实体转换</summary> public static RecordServer ToRecordServer(tgm_record_server model) { var d = DateTime.Now.Ticks - model.createtime; var days = Convert.ToInt32(new TimeSpan(d).TotalDays); var time = new DateTime(model.createtime).ToString("yyyy-MM-dd HH:mm:ss"); var apru = 0.0;//当日总收入/付费人数 if (model.pay_number != 0 && model.pay_taday != 0) { apru = Math.Round(Convert.ToDouble(model.pay_taday) / Convert.ToDouble(model.pay_number), 2); } var cost_rate = 0.00;//每天的总消耗的元宝数量/单服每天充值的元宝数量*100% if (model.taday_cost != 0 && model.pay_taday != 0) { cost_rate = Math.Round(Convert.ToDouble(model.taday_cost) / Convert.ToDouble(model.pay_taday), 2); } return(new RecordServer { pid = model.pid, sid = model.sid, server_name = model.server_name, offline = model.offline, online = model.online, history_online = model.history_online, register = model.register, register_total = model.register_total, taday_login = model.taday_login, taday_online = model.taday_online, pay_count = model.pay_count, pay_number = model.pay_number, pay_taday = model.pay_taday, pay_total = model.pay_total, pay_month = model.pay_month, createtime = time, total_days = days, apru = apru, taday_cost = model.taday_cost, cost_rate = cost_rate, }); }
/// <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("单服作业失败"); } }