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