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); }