public async Task <JsonResult> GetRegionList(RegionVm model)
{
string strwhere = "1=1";
if (model.Region != null && model.Region != "")
{
strwhere += $" and region={model.Region} or realregion={model.Region}";
}
model.Sql = $"select * from region_real where " + strwhere;
var result = await CommonRespository.GetQueryResult(_SqlDB, model);
return(Json(result));
}
public async Task <JsonResult> GetMieShenList(MieShenVm model)
{
string strwhere = "1=1";
if (model.UserName != null && model.UserName != "")
{
strwhere += $" and a.username='******'";
}
model.Sql = $"select * from region_real where " + strwhere;
model.Sql = @"select a.*,ISNULL(b.status,a.status) sta from mieshen_info a left join mieshen_online b
on a.platfrom = b.platfrom and a.region = b.region and a.gamename = b.gamename and a.username = b.username where " + strwhere;
var result = await CommonRespository.GetQueryResult(_SqlDB, model);
return(Json(result));
}
public async Task <JsonResult> GetMieShenEveryList(MieShenEveryVm model)
{
string strwhere = "1=1";
model.Sql = @"select * from mieshen_every ss where ";
if (model.Bdate != null && model.Bdate != "")
{
if (Convert.ToDateTime(model.Bdate).Date == DateTime.Now.Date)
{
model.Sql = @" select * from (select aa.platfrom,aa.region,CONVERT(VARCHAR(10),GETDATE(),111) bdate,bb.BindMoney,bb.Money,
bb.BindMoney-aa.BindMoney yesBindMoney,bb.Money-aa.Money yesMoney from (
SELECT a.platfrom,b.realregion region,SUM(BindMoney) BindMoney,SUM(Money) Money FROM mieshen_every (NOLOCK) a,dbo.region_real b
WHERE a.platfrom=b.platform AND a.region=b.region AND a.bdate=CONVERT(VARCHAR(10),DATEADD(DAY,-1,GETDATE()),111)
GROUP BY a.platfrom,b.realregion) aa,
(
SELECT a.platfrom,b.realregion region,SUM(ISNULL(a.BindMoney,0)) BindMoney,sum(ISNULL(a.Money,0)) Money FROM dbo.mieshen_info (NOLOCK) a,dbo.region_real b
WHERE a.platfrom=b.platform AND a.region=b.region AND a.gamename=b.gamename
GROUP BY a.platfrom,b.realregion) bb where aa.platfrom=bb.platfrom
and aa.region=bb.region) ss where
";
}
else
{
strwhere += $" and ss.bdate='" + Convert.ToDateTime(model.Bdate).ToString("yyyy-MM-dd") + "'";
}
}
if (model.Region != null && model.Region != "")
{
strwhere += $" and ss.region in (select realregion from region_real where region=" + model.Region + ")";
}
if (model.Platform != null && model.Platform != "")
{
strwhere += $" and ss.platfrom='" + model.Platform + "'";
}
model.Sql = model.Sql + strwhere;
var result = await CommonRespository.GetQueryResult(_SqlDB, model);
return(Json(result));
}
