public JsonResult PagerHandler(Int32 page, Int32 size, string pid, string sid, string start, string end, string type, string playername)
{
if (pid == "0" && sid == "0")
{
var api = new ApiReceive()
{
URL = string.Format("{0}", ConfigHelper.GetApiUrl()),
Resource = string.Format("api/Pay?token={0}&role={1}&pid={2}&index={3}&size={4}", user.token, user.role, user.pid, page, size),
};
var result = api.PostJsonToFromBody();
api.Dispose();
var totalpay = CommonHelper.Deserialize <PagerPay>(result);
return(Json(totalpay, JsonRequestBehavior.AllowGet));
}
else
{
var pager = new PagerTotalPay();
if (start != "" && start != "0" && end == "" || end == "0")
{
pager.result = -1;
pager.message = "没有选结束时间";
return(Json(pager, JsonRequestBehavior.AllowGet));
}
if (end != "" && end != "0" && start == "" || start == "0")
{
pager.result = -1;
pager.message = "没有选开始时间";
return(Json(pager, JsonRequestBehavior.AllowGet));
}
if (sid == "0")
{
pager.result = -1;
pager.message = "没有选服务器";
return(Json(pager, JsonRequestBehavior.AllowGet));
}
if (playername == "")
{
pager.result = -1;
pager.message = "没有选玩家";
return(Json(pager, JsonRequestBehavior.AllowGet));
}
Int64 stick = 0;
Int64 etick = 0;
if (start != "" && start != "0" && end != "" && end != "0")
{
stick = DateTime.Parse(start).Ticks;
etick = DateTime.Parse(end).Ticks;
}
var api = new ApiReceive()
{
URL = string.Format("{0}", ConfigHelper.GetApiUrl()),
Resource = string.Format("api/Pay?token={0}&pid={1}&sid={2}&start={3}&end={4}&type={5}&playname={6}&userpid={7}&role={8}&index={9}&size={10}", user.token, Convert.ToInt32(pid), Convert.ToInt32(sid), stick, etick, Convert.ToInt32(type), playername, user.pid, user.role, page, size),
};
var result = api.PostJsonToFromBody();
api.Dispose();
var totalpay = CommonHelper.Deserialize <PagerPay>(result);
return(Json(totalpay, JsonRequestBehavior.AllowGet));
}
}
// POST api/Pay?token={token}&pid={pid}&sid={sid}&start={start}&end={end}&index={index}&size={size}
/// <summary>查询玩家总充值信息</summary>
/// <param name="token">令牌</param>
/// <param name="pid">平台id</param>
/// <param name="sid">服务器id</param>
/// <param name="start">开始时间</param>
/// <param name="end">结束时间</param>
/// <param name="index">分页索引</param>
/// <param name="size">分页大小</param>
/// <returns></returns>
public PagerTotalPay PostPay(string token, int pid, int sid, Int64 start, Int64 end, Int32 index = 1, Int32 size = 10)
{
var pager = new PagerTotalPay();
var paylist = new List <TotalRecordPay>();
if (!IsToken(token))
{
return(pager); //验证会话
}
tgm_platform.SetDbConnName(tgm_connection);
var pf = tgm_platform.FindByid(pid);
if (pf == null)
{
return(pager);
}
var count = 0;
if (sid == 0) //全服
{
tgm_server.SetDbConnName(tgm_connection);
var list = tgm_server.GetServerList(pid).ToList();
if (list.Count == 0)
{
return(pager);
}
var sids = string.Join(",", list.ToList().Select(m => m.id).ToArray());
if (start > 0 && end > 0) //查时间的
{
tgm_record_pay.SetDbConnName(tgm_connection); //充值记录
//var plist = tgm_record_pay.GetTimeSidsList(start, end, sids);
var plist = tgm_record_pay.GetTimeSidsList(start, end, sids, index, size, out count).ToList();
if (plist.Count == 0)
{
return(pager);
}
foreach (var item in list)
{
var r = GetPayList(item, plist, pf.name);
paylist.AddRange(r);
}
}
else
{
tgm_record_pay.SetDbConnName(tgm_connection); //充值记录
var plist = tgm_record_pay.GetListBySids(sids, index, size, out count);
if (plist.Count == 0)
{
return(pager);
}
foreach (var r in list.Select(item => GetPayList(item, plist, pf.name)))
{
paylist.AddRange(r);
}
}
}
else //单服
{
tgm_server.SetDbConnName(tgm_connection);
var server = tgm_server.FindByid(Convert.ToInt32(sid));
if (server == null)
{
return(pager);
}
if (start > 0 && end > 0)
{
tgm_record_pay.SetDbConnName(tgm_connection); //充值记录
var plist = tgm_record_pay.GetTimeSidList(start, end, Convert.ToInt32(sid), index, size, out count);
if (plist.Count == 0)
{
return(pager);
}
var r = GetPayList(server, plist, pf.name);
paylist.AddRange(r);
}
else
{
tgm_record_pay.SetDbConnName(tgm_connection); //充值记录
var plist = tgm_record_pay.GetListBySid(Convert.ToInt32(sid), index, size, out count);
if (plist.Count == 0)
{
return(pager);
}
var r = GetPayList(server, plist, pf.name);
paylist.AddRange(r);
}
}
pager = new PagerTotalPay()
{
result = 1,
Recordpay = paylist,
Pager = new PagerInfo {
CurrentPageIndex = index, PageSize = size, RecordCount = count
},
};
return(pager);
}
// POST api/Pay?token={token}&role={role}&pid={pid}&sign={sign}&index={index}&size={size}
/// <summary>进入界面时，显示充值所有记录</summary>
/// <param name="token"></param>
/// <param name="role"></param>
/// <param name="pid"></param>
/// <param name="sign"></param>
/// <param name="index"></param>
/// <param name="size"></param>
/// <returns></returns>
public PagerTotalPay PostTotalPay(string token, Int64 role, Int32 pid, bool sign, Int32 index = 1, Int32 size = 10)
{
var pager = new PagerTotalPay();
if (!IsToken(token))
{
return(pager); //验证会话
}
List <tgm_record_pay> paylist;
List <tgm_server> list;
var plist = new List <TotalRecordPay>();
var count = 0;
if (role == 10000)
{
tgm_server.SetDbConnName(tgm_connection);
list = tgm_server.FindAll().ToList();
if (list.Count == 0)
{
return(pager);
}
tgm_record_pay.SetDbConnName(tgm_connection);
paylist = tgm_record_pay.GetListByPids(index, size, out count);
var platforms = tgm_platform.FindAll().ToList();
if (paylist.Count == 0 || platforms.Count == 0)
{
return(pager);
}
foreach (var item in list)
{
var p = platforms.FirstOrDefault(m => m.id == item.pid);
if (p == null)
{
continue;
}
plist.AddRange(GetPayList(item, paylist, p.name));
}
}
else
{
tgm_server.SetDbConnName(tgm_connection);
list = tgm_server.GetServerList(pid).ToList();
if (list.Count == 0)
{
return(pager);
}
var sids = string.Join(",", list.ToList().Select(m => m.id).ToArray());
tgm_record_pay.SetDbConnName(tgm_connection);
paylist = tgm_record_pay.GetListByPid(index, size, sids, out count);
if (paylist == null)
{
return(pager);
}
tgm_platform.SetDbConnName(tgm_connection);
var platform = tgm_platform.FindByid(pid);
if (platform == null)
{
return(pager);
}
foreach (var item in list)
{
plist.AddRange(GetPayList(item, paylist, platform.name));
}
}
pager = new PagerTotalPay()
{
result = 1,
Recordpay = plist,
Pager = new PagerInfo {
CurrentPageIndex = index, PageSize = size, RecordCount = count
},
};
return(pager);
}
