private void Bind()
{
DateTime?beginDate = null;
DateTime?endDate = null;
DateTime b;
DateTime e;
if (!DateTime.TryParse(this.txtBeginDate.Text.Trim(), out b) || !DateTime.TryParse(this.txtEndDate.Text.Trim(), out e))
{
if (this.FilterType() == "0")
{
//按天
//string year = DateTime.Now.ToString("yyyy");
//string month = DateTime.Now.ToString("MM");
beginDate = Utils.GetNowBeginDate(); // Convert.ToDateTime(year + "-" + month + "-01 03:00:00");
endDate = Utils.GetNowEndDate(); //Convert.ToDateTime(DateTime.Now.AddDays(1).ToString("yyyy/MM/dd") + " 03:00:00");
}
else
{
//年
beginDate = DateTime.Now.AddYears(-1);
endDate = DateTime.Now;
}
}
else
{
beginDate = Convert.ToDateTime(b.ToString("yyyy/MM/dd") + " 00:03:00");
endDate = Convert.ToDateTime(e.ToString("yyyy/MM/dd") + " 00:03:00");
}
ICountDataService dataService = IoC.Resolve <ICountDataService>();
this.repList.DataSource = dataService.FilterSp_userBannerTypeSuanTable(beginDate.Value, endDate.Value, this.TraceTypeStr, Convert.ToInt32(this.FilterType()));
this.repList.DataBind();
this.repList.Visible = true;
}
private void Bind()
{
DateTime?beginDate = null;
DateTime?endDate = null;
DateTime b;
DateTime e;
if (!DateTime.TryParse(this.txtBeginDate.Text.Trim(), out b) || !DateTime.TryParse(this.txtEndDate.Text.Trim(), out e))
{
if (this.FilterType() == "0")
{
//按天
//string year = DateTime.Now.ToString("yyyy");
//string month = DateTime.Now.ToString("MM");
//beginDate = Convert.ToDateTime(year + "-" + month + "-01 03:00:00");
//endDate = Convert.ToDateTime(DateTime.Now.AddDays(1).ToString("yyyy/MM/dd") + " 03:00:00");
beginDate = Utils.GetNowBeginDate(); // Convert.ToDateTime(year + "-" + month + "-01 03:00:00");
endDate = Utils.GetNowEndDate(); //Convert.ToDateTime(DateTime.Now.AddDays(1).ToString("yyyy/MM/dd") + " 03:00:00");
}
else
{
//年
beginDate = DateTime.Now.AddYears(-1);
endDate = DateTime.Now;
}
}
else
{
beginDate = Convert.ToDateTime(b.ToString("yyyy/MM/dd") + " 03:00:00");
endDate = Convert.ToDateTime(e.ToString("yyyy/MM/dd") + " 03:00:00");
}
ICountDataService dataService = IoC.Resolve <ICountDataService>();
if (this.FilterType() == "0")
{
//按日
var dayRes = dataService.FilterSp_DayJieSuanTable(beginDate.Value, endDate.Value);
this.repList.DataSource = dayRes;
this.repList.DataBind();
this.repList.Visible = true;
this.RepeaterMonth.Visible = false;
this.rptSum.DataSource = SumDayRes(dayRes);
this.rptSum.DataBind();
}
else
{
//按月
var res = dataService.FilterSp_MonthJieSuanTable(beginDate.Value, endDate.Value);
this.RepeaterMonth.DataSource = res;
this.RepeaterMonth.DataBind();
this.repList.Visible = false;
this.RepeaterMonth.Visible = true;
this.rptSum.DataSource = SumRes(res);
this.rptSum.DataBind();
}
}
private void BindData()
{
string beginDate = Utils.GetNowBeginDateStr(); //业务开始日期
string endDate = Utils.GetNowEndDateStr(); //业务截止日期
ICountDataService countDataService = IoC.Resolve <ICountDataService>();
var result = countDataService.GetCountData(beginDate, endDate);
if (result == null)
{
return;
}
//盈亏统计
// result.yesterDayData
//统计
this.mUserData = result.userData;
if (this.mUserData == null)
{
mUserData = new UserData();
}
//rptList.DataSource = result.playTypeRadioDataList;//玩法
//rptList.DataSource = result.lotteryDataList;//彩种
//rptList.DataBind();
//彩票投注金额
rptlotteryType.DataSource = result.lotteryTypeDataList.OrderByDescending(x => x.BetMoney);//彩票投注
rptlotteryType.DataBind();
//树图
//mStatDataStr
StringBuilder builder = new StringBuilder();
foreach (var item in result.toDayData)
{
string period = item.OccDate;
builder.Append("{");
builder.AppendFormat("period:'{0}',yk: {1},tz:{2}", period, item.ProfitAndLossMoney, item.BetMoney);
builder.Append("},");
}
mStatDataStr = builder.ToString();
if (mStatDataStr.EndsWith(","))
{
mStatDataStr = "{data:[" + mStatDataStr.Substring(0, mStatDataStr.Length - 1) + "]}";
}
BindYingKuiStat();//盈亏报表
}
private void BindResult()
{
string beginDate = this.txtBeginDate.Text.Trim(); //业务开始日期
string endDate = this.txtEndDate.Text.Trim(); //业务截止日期
ICountDataService countDataService = IoC.Resolve <ICountDataService>();
var result = countDataService.GetCountData(beginDate, endDate);
if (result != null)
{
var res = result.lotteryDataList.Where(x => x.LotteryCode == this.txtLotteryId.Value).FirstOrDefault();
if (null == res || res.playTypeRadioDataList == null)
{
return;
}
this.rptList1.DataSource = res.playTypeRadioDataList;
this.rptList1.DataBind();
}
}
private void Bind()
{
ICountDataService countDataService = IoC.Resolve <ICountDataService>();
var source = countDataService.GetClearDataStat().FirstOrDefault();
if (null == source)
{
return;
}
lbCustomer.Text = source.UserCount.ToString();
lbBettcount.Text = source.bettCount.ToString();
lbCusLoginLog.Text = source.CusLoginLog.ToString();
lbIssue.Text = source.OpenIssue.ToString();
lbManLogCount.Text = source.SysLoginLog.ToString();
lbCusChartCount.Text = source.CusMessage.ToString();
lbsockChart.Text = source.ChartMsg.ToString();
lbrechangeCount.Text = source.rechangeCount.ToString();
lbTiXian.Text = source.TiXian.ToString();
lbZhanBian.Text = source.ZhanBian.ToString();
}
/// <summary>
/// 盈亏统计
/// </summary>
private void BindYingKuiStat()
{
List <Sp_DayJieSuanTable> showResult = new List <Sp_DayJieSuanTable>();
ICountDataService dataService = IoC.Resolve <ICountDataService>();
//获取今日盈亏统计
DateTime beginDate = Utils.GetNowBeginDate();
DateTime endDate = Utils.GetNowEndDate();
var nowResult = dataService.FilterSp_DayJieSuanTable(beginDate, endDate);
if (null != nowResult && nowResult.Count > 0)
{
var nowStat = this.EmptySp_DayJieSuanTable("今日统计");
foreach (var item in nowResult)
{
nowStat.Activity += item.Activity;
nowStat.Chongzhi += item.Chongzhi;
nowStat.FenHong += item.FenHong;
nowStat.Jiangjinpaisong += item.Jiangjinpaisong;
nowStat.QianDao += item.QianDao;
nowStat.tiXian += item.tiXian;
nowStat.TouZhu += item.TouZhu;
nowStat.YingKui += item.YingKui;
nowStat.YongJing += item.YongJing;
nowStat.Youxifandian += item.Youxifandian;
nowStat.ZhuChe += item.ZhuChe;
}
showResult.Add(nowStat);
}
else
{
showResult.Add(EmptySp_DayJieSuanTable("今日统计"));
}
//昨日统计
var preResult = dataService.FilterSp_DayJieSuanTable(beginDate.AddDays(-1), endDate.AddDays(-1));
if (null != preResult && preResult.Count > 0)
{
var nowStat = this.EmptySp_DayJieSuanTable("昨日统计");
foreach (var item in preResult)
{
nowStat.Activity += item.Activity;
nowStat.Chongzhi += item.Chongzhi;
nowStat.FenHong += item.FenHong;
nowStat.Jiangjinpaisong += item.Jiangjinpaisong;
nowStat.QianDao += item.QianDao;
nowStat.tiXian += item.tiXian;
nowStat.TouZhu += item.TouZhu;
nowStat.YingKui += item.YingKui;
nowStat.YongJing += item.YongJing;
nowStat.Youxifandian += item.Youxifandian;
nowStat.ZhuChe += item.ZhuChe;
}
showResult.Add(nowStat);
}
else
{
showResult.Add(EmptySp_DayJieSuanTable("昨日统计"));
}
//当月统计
beginDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 3, 0).AddDays(-1);//当月第一天
endDate = beginDate.AddMonths(1).AddDays(-1);
var nowMonthResult = dataService.FilterSp_MonthJieSuanTable(beginDate, endDate);
if (null != nowMonthResult && nowMonthResult.Count > 0)
{
var nowStat = this.EmptySp_DayJieSuanTable("当月统计");
foreach (var item in nowMonthResult)
{
nowStat.Activity += item.Activity;
nowStat.Chongzhi += item.Chongzhi;
nowStat.FenHong += item.FenHong;
nowStat.Jiangjinpaisong += item.Jiangjinpaisong;
nowStat.QianDao += item.QianDao;
nowStat.tiXian += item.tiXian;
nowStat.TouZhu += item.TouZhu;
nowStat.YingKui += item.YingKui;
nowStat.YongJing += item.YongJing;
nowStat.Youxifandian += item.Youxifandian;
nowStat.ZhuChe += item.ZhuChe;
}
showResult.Add(nowStat);
}
else
{
showResult.Add(EmptySp_DayJieSuanTable("当月统计"));
}
beginDate = beginDate.AddMonths(-1);
endDate = endDate.AddMonths(-1);
//上月统计
var preMonthResult = dataService.FilterSp_MonthJieSuanTable(beginDate, endDate);
if (null != preMonthResult && preMonthResult.Count > 0)
{
var nowStat = this.EmptySp_DayJieSuanTable("上月统计");
foreach (var item in preMonthResult)
{
nowStat.Activity += item.Activity;
nowStat.Chongzhi += item.Chongzhi;
nowStat.FenHong += item.FenHong;
nowStat.Jiangjinpaisong += item.Jiangjinpaisong;
nowStat.QianDao += item.QianDao;
nowStat.tiXian += item.tiXian;
nowStat.TouZhu += item.TouZhu;
nowStat.YingKui += item.YingKui;
nowStat.YongJing += item.YongJing;
nowStat.Youxifandian += item.Youxifandian;
nowStat.ZhuChe += item.ZhuChe;
}
showResult.Add(nowStat);
}
else
{
showResult.Add(EmptySp_DayJieSuanTable("上月统计"));
}
this.repListYingKui.DataSource = showResult;
this.repListYingKui.DataBind();
}
protected void btnClear_Click(object sender, EventArgs e)
{
var btn = sender as Button;
// 0 用户数 1投注、追号、账变 2会员登录日志 3开奖期数 4管理员登录日志 5客户消息 6聊天消息 7充值记录 8充值记录
int tp = 0;
decimal monery = 0m;
int day = 60;
switch (btn.ID)
{
case "btnClear":
if (!decimal.TryParse(this.txtMinMoner.Text.Trim(), out monery))
{
JsAlert("金额格式输入错误！");
return;
}
tp = 0;
day = GetDrpDay(drpCode);
break;
case "btnClearBett":
tp = 1;
day = GetDrpDay(drpBet);
break;
case "btnCusLog":
tp = 2;
day = GetDrpDay(drpCusLog);
break;
case "btnIssue":
tp = 3;
day = GetDrpDay(drpIssue);
break;
case "btnManLog":
tp = 4;
day = GetDrpDay(drpMaLog);
break;
case "btnChartCount":
tp = 5;
day = GetDrpDay(drpChartCount);
break;
case "btnSockChart":
tp = 6;
day = GetDrpDay(drpSockChart);
break;
case "btnrechangeCount":
tp = 7;
day = GetDrpDay(drprechangeCount);
break;
case "btnTiXian":
tp = 8;
day = GetDrpDay(drpTiXian);
break;
case "btnZhanBian":
tp = 9;
day = GetDrpDay(drpZhangBian);
break;
}
ICountDataService countDataService = IoC.Resolve <ICountDataService>();
countDataService.ClearData(tp, monery, day);
JsAlert("数据清理成功！");
this.Bind();
}
