public ActionResult GameOutputDetail2(Dictionary <string, string> queryvalues)
{
int _Channels = queryvalues.ContainsKey("Channels") ? Convert.ToInt32(queryvalues["Channels"]) : 0;
string _StartDate = queryvalues.ContainsKey("StartDate") ? queryvalues["StartDate"] : DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
groupby _Groupby = (groupby)(queryvalues.ContainsKey("groupby") ? Convert.ToInt32(queryvalues["groupby"]) : 1);
int MasterID = User.Identity.GetUserId <int>();
if (AgentUserBLL.CheckUser(_Channels, MasterID))
{
_Channels = MasterID;
}
string _UserList = AgentUserBLL.GetUserListString(_Channels);
string _MasterList = AgentUserBLL.GetUserListString(MasterID);
BaseDataView vbd = new BaseDataView {
UserList = _UserList, StartDate = _StartDate, Groupby = _Groupby, Channels = _Channels
};
vbd.BaseDataList = BaseDataBLL.GetGameOutputDetail2(vbd);
if (Request.IsAjaxRequest())
{
return(PartialView("GameOutputDetail2", vbd));
}
return(View(vbd));
}
public ActionResult QQZoneRecharge(Dictionary <string, string> queryvalues)
{
int page = queryvalues.ContainsKey("page") ? Convert.ToInt32(queryvalues["page"]) : 1;
int _UserID = queryvalues.ContainsKey("UserID") ? string.IsNullOrWhiteSpace(queryvalues["UserID"]) ? 0 : Convert.ToInt32(queryvalues["UserID"]) : 0;
int _Channels = queryvalues.ContainsKey("Channels") ? Convert.ToInt32(queryvalues["Channels"]) : 0;
string _StartDate = queryvalues.ContainsKey("StartDate") ? queryvalues["StartDate"] : DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
string _ExpirationDate = queryvalues.ContainsKey("ExpirationDate") ? queryvalues["ExpirationDate"] : DateTime.Now.AddDays(1).ToString("yyyy-MM-dd 00:00:00");
groupby _Groupby = (groupby)(queryvalues.ContainsKey("groupby") ? Convert.ToInt32(queryvalues["groupby"]) : 1);
BaseDataView vbd = new BaseDataView {
UserID = _UserID, StartDate = _StartDate, ExpirationDate = _ExpirationDate, Groupby = _Groupby, Channels = _Channels
};
ViewData["groupby"] = vbd.Groupby.ToSelectListItemForSelect();
ViewData["SumRecharge"] = QQZoneRechargeBLL.GetSumRecharge(vbd);
if (Request.IsAjaxRequest())
{
return(PartialView("QQZoneRecharge_PageList", QQZoneRechargeBLL.GetListByPage(page, vbd)));
}
vbd.BaseDataList = QQZoneRechargeBLL.GetListByPage(page, vbd);
return(View(vbd));
}
public ActionResult GameOutput2(Dictionary <string, string> queryvalues)
{
int _Channels = queryvalues.ContainsKey("Channels") ? Convert.ToInt32(queryvalues["Channels"]) : 0;
string _StartDate = queryvalues.ContainsKey("StartDate") ? queryvalues["StartDate"] : DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
string _ExpirationDate = queryvalues.ContainsKey("ExpirationDate") ? queryvalues["ExpirationDate"] : DateTime.Now.AddDays(1).ToString("yyyy-MM-dd 00:00:00");
groupby _Groupby = (groupby)(queryvalues.ContainsKey("groupby") ? Convert.ToInt32(queryvalues["groupby"]) : 1);
int MasterID = User.Identity.GetUserId <int>();
if (AgentUserBLL.CheckUser(_Channels, MasterID))
{
_Channels = MasterID;
}
string _UserList = AgentUserBLL.GetUserListString(_Channels);
string _MasterList = AgentUserBLL.GetUserListString(MasterID);
BaseDataView vbd = new BaseDataView {
UserList = _UserList, StartDate = _StartDate, ExpirationDate = _ExpirationDate, Groupby = _Groupby, Channels = _Channels
};
ViewData["groupby"] = vbd.Groupby.ToSelectListItemForSelect();
ViewData["Channels"] = AgentUserBLL.GetUserList(_MasterList).Select(x => new SelectListItem {
Text = x.AgentName, Value = x.Id.ToString(), Selected = x.Id == _Channels
});
vbd.BaseDataList = BaseDataBLL.GetGameOutput2(vbd);
return(View(vbd));
}
public ActionResult NumberOfRegisteredUsersDetail(Dictionary <string, string> queryvalues)
{
//oper
string oper = queryvalues.ContainsKey("oper") ? queryvalues["oper"] : "";
int _page = queryvalues.ContainsKey("page") ? Convert.ToInt32(queryvalues["page"]) : 1;
int _Channels = queryvalues.ContainsKey("Channels") ? Convert.ToInt32(queryvalues["Channels"]) : 0;
string _StartDate = queryvalues.ContainsKey("StartDate") ? queryvalues["StartDate"] : DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
var arr = _StartDate.Split('-');
DateTime dts = new DateTime(Convert.ToInt32(arr[0]), Convert.ToInt32(arr[1]), Convert.ToInt32(_StartDate.Substring(8, 2)), 0, 0, 0);
DateTime dte = dts.AddDays(1);
string _ExpirationDate = dts.AddDays(1).ToString("yyyy-MM-dd 00:00:00");
groupby _Groupby = (groupby)(queryvalues.ContainsKey("groupby") ? Convert.ToInt32(queryvalues["groupby"]) : 1);
int MasterID = User.Identity.GetUserId <int>();
if (AgentUserBLL.CheckUser(_Channels, MasterID))
{
_Channels = MasterID;
}
string _UserList = AgentUserBLL.GetUserListString(_Channels);
BaseDataView vbd = new BaseDataView {
UserList = _UserList, Channels = _Channels, StartDate = _StartDate, ExpirationDate = _ExpirationDate, Groupby = _Groupby, SearchExt = oper
};
vbd.BaseDataList = new List <BaseDataInfo>(BaseDataBLL.GetRegisteredUsersOnHour(vbd));
//通过时间查询role列表
BaseDataView vbd2 = new BaseDataView {
UserList = _UserList, Channels = _Channels, StartDate = dts.ToString("yyyy-MM-dd 00:00:00"), ExpirationDate = dte.ToString("yyyy-MM-dd 00:00:00"), Groupby = _Groupby, SearchExt = oper
};
//通过渠道查询注册信息
string target = queryvalues.ContainsKey("target") ? queryvalues["target"] : "";
return(View(vbd));
}
public ActionResult OnlinePlay(Dictionary <string, string> queryvalues)
{
int _Channels = queryvalues.ContainsKey("Channels") ? Convert.ToInt32(queryvalues["Channels"]) : 0;
string _StartDate = queryvalues.ContainsKey("StartDate") ? queryvalues["StartDate"] : DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
string _ExpirationDate = queryvalues.ContainsKey("ExpirationDate") ? queryvalues["ExpirationDate"] : DateTime.Now.AddDays(1).ToString("yyyy-MM-dd 00:00:00");
groupby _Groupby = (groupby)(queryvalues.ContainsKey("groupby") ? Convert.ToInt32(queryvalues["groupby"]) : 1);
int MasterID = User.Identity.GetUserId <int>();
if (AgentUserBLL.CheckUser(_Channels, MasterID))
{
_Channels = MasterID;
}
string _UserList = AgentUserBLL.GetUserListString(_Channels);
string _MasterList = AgentUserBLL.GetUserListString(MasterID);
BaseDataView vbd = new BaseDataView {
UserList = _UserList, StartDate = _StartDate, ExpirationDate = _ExpirationDate, Groupby = _Groupby, Channels = _Channels
};
ViewData["groupby"] = vbd.Groupby.ToSelectListItemForSelect();
var cha = AgentUserBLL.GetUserList(_MasterList).Select(x => new SelectListItem {
Text = x.AgentName.AddBlank((int)x.AgentLv),
Value = x.Id.ToString(),
Selected = x.Id == _Channels
});
if (cha.Count() <= 1)
{
ViewData["cCount"] = 1;
}
else
{
ViewData["cCount"] = 2;
}
ViewData["Channels"] = cha;
vbd.BaseDataList = new List <BaseDataInfoForOnlinePlay>(BaseDataBLL.GetOnlinePlay(vbd));
return(View(vbd));
}
public ActionResult DailyOutput(Dictionary <string, string> queryvalues)
{
int _Channels = queryvalues.ContainsKey("Channels") ? Convert.ToInt32(queryvalues["Channels"]) : 0;
terminals _Terminals = (terminals)(queryvalues.ContainsKey("Terminals") ? Convert.ToInt32(queryvalues["Terminals"]) : 0);
string _StartDate = queryvalues.ContainsKey("StartDate") ? queryvalues["StartDate"] : DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
string _ExpirationDate = queryvalues.ContainsKey("ExpirationDate") ? queryvalues["ExpirationDate"] : DateTime.Now.AddDays(1).ToString("yyyy-MM-dd 00:00:00");
groupby _Groupby = (groupby)(queryvalues.ContainsKey("groupby") ? Convert.ToInt32(queryvalues["groupby"]) : 1);
BaseDataView vbd = new BaseDataView {
Terminals = _Terminals, StartDate = _StartDate, ExpirationDate = _ExpirationDate, Groupby = _Groupby
};
ViewData["groupby"] = vbd.Groupby.ToSelectListItemForSelect();
ViewData["Terminals"] = vbd.Terminals.ToSelectListItemForSelect();
vbd.BaseDataList = new List <BaseDataInfoForDailyOutput>(BaseDataBLL.GetDailyOutput(vbd));
return(View(vbd));
}
public ActionResult TexasGameGetAward(Dictionary <string, string> queryvalues)
{
int page = queryvalues.ContainsKey("page") ? Convert.ToInt32(queryvalues["page"]) : 1;
int _UserID = queryvalues.ContainsKey("UserID") ? string.IsNullOrWhiteSpace(queryvalues["UserID"]) ? 0 : Convert.ToInt32(queryvalues["UserID"]) : 0;
int _Channels = queryvalues.ContainsKey("Channels") ? Convert.ToInt32(queryvalues["Channels"]) : 0;
//GetGameActiveTime
GL.Data.ActiveTime time = QQZoneRechargeBLL.GetGameActiveTime(GL.Data.ActiveType.德州玩牌领奖);
string _StartDate = queryvalues.ContainsKey("StartDate") ? queryvalues["StartDate"] : DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
string _ExpirationDate = queryvalues.ContainsKey("ExpirationDate") ? queryvalues["ExpirationDate"] : DateTime.Now.AddDays(1).ToString("yyyy-MM-dd 00:00:00");
groupby _Groupby = (groupby)(queryvalues.ContainsKey("groupby") ? Convert.ToInt32(queryvalues["groupby"]) : 1);
BaseDataView vbd = new BaseDataView {
UserID = _UserID, StartDate = _StartDate, ExpirationDate = _ExpirationDate, Groupby = _Groupby, Channels = _Channels
};
ViewData["groupby"] = vbd.Groupby.ToSelectListItemForSelect();
ViewData["ActiveTime"] = time;
//if (Request.IsAjaxRequest())
//{
// return PartialView("QQZoneRecharge_PageList", QQZoneRechargeBLL.GetListByPage(page, vbd));
//}
vbd.BaseDataList = QQZoneRechargeBLL.GetTexasGameGetAwardItemCount(vbd);
vbd.StartDate = _StartDate;
return(View(vbd));
}
public ActionResult Test(Dictionary <string, string> queryvalues)
{
int _Channels = queryvalues.ContainsKey("Channels") ? Convert.ToInt32(queryvalues["Channels"]) : 0;
string _StartDate = queryvalues.ContainsKey("StartDate") ? queryvalues["StartDate"] : DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
string _ExpirationDate = queryvalues.ContainsKey("ExpirationDate") ? queryvalues["ExpirationDate"] : DateTime.Now.AddDays(1).ToString("yyyy-MM-dd 00:00:00");
groupby _Groupby = (groupby)(queryvalues.ContainsKey("groupby") ? Convert.ToInt32(queryvalues["groupby"]) : 1);
string _UserList = AgentUserBLL.GetUserListString(0); //new
string _MasterList = AgentUserBLL.GetUserListString(0); //new
if (_Channels != 0)
{
_UserList = _Channels.ToString();
}
BaseDataView vbd = new BaseDataView {
UserList = _UserList, StartDate = _StartDate, ExpirationDate = _ExpirationDate, Groupby = _Groupby, Channels = _Channels
};
List <SelectListItem> ieList = AgentUserBLL.GetUserList(_MasterList).Select(
x => new SelectListItem {
Text = x.AgentName, Value = x.Id.ToString(), Selected = x.Id == _Channels
}
).ToList();
ieList.Insert(0, new SelectListItem {
Text = "所有渠道", Value = "0", Selected = 0 == _Channels
});
ViewData["Channels"] = ieList;
vbd.BaseDataList = new List <BaseDataInfo>(BaseDataBLL.GetActiveUsers(vbd));
return(View(vbd));
}
public ActionResult NewYearCharge(Dictionary <string, string> queryvalues)
{
int page = queryvalues.ContainsKey("page") ? Convert.ToInt32(queryvalues["page"]) : 1;
int _UserID = queryvalues.ContainsKey("UserID") ? string.IsNullOrWhiteSpace(queryvalues["UserID"]) ? 0 : Convert.ToInt32(queryvalues["UserID"]) : 0;
int _Channels = queryvalues.ContainsKey("Channels") ? Convert.ToInt32(queryvalues["Channels"]) : 0;
// string _StartDate = "";
// string _ExpirationDate = "";
//if (queryvalues.ContainsKey("StartDate"))
//{
// _StartDate = queryvalues["StartDate"];
//}
//else
//{
// GL.Data.ActiveTime time = QQZoneRechargeBLL.GetGameActiveTime(GL.Data.ActiveType.充值礼包奖励);
// _StartDate = time.StartTime.ToString();
//}
//if (queryvalues.ContainsKey("ExpirationDate"))
//{
// _ExpirationDate = queryvalues["ExpirationDate"];
//}
//else
//{
// GL.Data.ActiveTime time = QQZoneRechargeBLL.GetGameActiveTime(GL.Data.ActiveType.充值礼包奖励);
// _ExpirationDate = time.EndTime.ToString();
//}
string _StartDate = queryvalues.ContainsKey("StartDate") ? queryvalues["StartDate"] : DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
string _ExpirationDate = queryvalues.ContainsKey("ExpirationDate") ? queryvalues["ExpirationDate"] : DateTime.Now.AddDays(1).ToString("yyyy-MM-dd 00:00:00");
groupby _Groupby = (groupby)(queryvalues.ContainsKey("groupby") ? Convert.ToInt32(queryvalues["groupby"]) : 1);
BaseDataView vbd = new BaseDataView {
UserID = _UserID, StartDate = _StartDate, ExpirationDate = _ExpirationDate, Groupby = _Groupby, Channels = _Channels
};
ViewData["groupby"] = vbd.Groupby.ToSelectListItemForSelect();
// select UserID, sum(money) / 100 from 515game.QQZoneRecharge
//where CreateTime BETWEEN '2016-1-5 00:05:00' and '2016-1-15 23:59:00'
//group by UserID
//新年充值活动数据
ViewData["NewYear"] = QQZoneRechargeBLL.GetNewYearCharge(vbd);
//充值排行前10数据
//ViewData["RechargeRank"] = QQZoneRechargeBLL.NewYearChargeRank(vbd);
return(View(vbd));
}
public ActionResult QQZoneRechargeCount(Dictionary <string, string> queryvalues)
{
int _Channels = queryvalues.ContainsKey("Channels") ? Convert.ToInt32(queryvalues["Channels"]) : -1;
int _page = queryvalues.ContainsKey("page") ? Convert.ToInt32(queryvalues["page"]) : 1;
int _pageGroup = queryvalues.ContainsKey("pageGroup") ? Convert.ToInt32(queryvalues["pageGroup"]) : 1;
string _StartDate = queryvalues.ContainsKey("StartDate") ? queryvalues["StartDate"] : DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
string _ExpirationDate = queryvalues.ContainsKey("ExpirationDate") ? queryvalues["ExpirationDate"] : DateTime.Now.AddDays(1).ToString("yyyy-MM-dd 00:00:00");
groupby _Groupby = (groupby)(queryvalues.ContainsKey("groupby") ? Convert.ToInt32(queryvalues["groupby"]) : 1);
string _target = queryvalues.ContainsKey("target") ? queryvalues["target"] : "";
int MasterID = User.Identity.GetUserId <int>();
if (AgentUserBLL.CheckUser(_Channels, MasterID))
{
_Channels = MasterID;
}
string _MasterList = AgentUserBLL.GetUserListString(MasterID);
if (_MasterList == MasterID.ToString())
{
_Channels = MasterID;
}
string _UserList = AgentUserBLL.GetUserListString(_Channels);
BaseDataView vbd = new BaseDataView {
UserList = _UserList, StartDate = _StartDate, ExpirationDate = _ExpirationDate, Groupby = _Groupby, Channels = _Channels, Page = _page
};
ViewData["groupby"] = vbd.Groupby.ToSelectListItemForSelect();
List <SelectListItem> ieList = AgentUserBLL.GetUserList(_MasterList).Select(
x => new SelectListItem {
Text = x.AgentName, Value = x.Id.ToString(), Selected = x.Id == _Channels
}
).ToList();
ieList.Insert(0, new SelectListItem {
Text = "所有渠道", Value = "0", Selected = 0 == _Channels
});
var cha = AgentUserBLL.GetUserList(_MasterList).Select(x => new SelectListItem {
Text = x.AgentName, Value = x.Id.ToString(), Selected = x.Id == _Channels
});
if (cha.Count() <= 1)
{
ViewData["cCount"] = 1;
}
else
{
ViewData["cCount"] = 2;
}
ViewData["Channels"] = cha;
ViewData["SumRecharge"] = QQZoneRechargeBLL.GetSumRecharge(vbd);
if (_target == "box")
{
vbd.Page = _page;
ViewData["data"] = QQZoneRechargeBLL.GetListByPage(_page, vbd);
return(PartialView("QQZoneRechargeCount_PageList", ViewData["data"]));
}
else if (_target == "boxGroup")
{
vbd.Page = _pageGroup;
Webdiyer.WebControls.Mvc.PagedList <GL.Data.Model.QQZoneRechargeCount> pa = new Webdiyer.WebControls.Mvc.PagedList <GL.Data.Model.QQZoneRechargeCount>(BaseDataBLL.GetQQZoneRechargeCount(vbd), _pageGroup, 10);
vbd.BaseDataList = pa;
ViewData["dataGroup"] = vbd.BaseDataList;
return(PartialView("QQZoneRechargeCountGroup_PageList", ViewData["dataGroup"]));
}
else
{
ViewData["data"] = QQZoneRechargeBLL.GetListByPage(_page, vbd);
Webdiyer.WebControls.Mvc.PagedList <GL.Data.Model.QQZoneRechargeCount> pa = new Webdiyer.WebControls.Mvc.PagedList <GL.Data.Model.QQZoneRechargeCount>(BaseDataBLL.GetQQZoneRechargeCount(vbd), _page, 10);
vbd.BaseDataList = pa;
ViewData["dataGroup"] = vbd.BaseDataList;
}
return(View(vbd));
}
