internal static AllFesLogin GetFestivalLogin(FestivalBaseData fbd)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
AllFesLogin i;
using (var multi = cn.QueryMultiple("" + database3 + @".sys_get_515", new { }, null, null, CommandType.StoredProcedure))
{
var thirdDay = multi.Read <FestivalLogin>().ToList();
var second = multi.Read <FestivalLogin>().ToList();
var one = multi.Read <FestivalLogin>().ToList();
i = new AllFesLogin();
i.OneDay = one;
i.SecDay = second;
i.thirdDay = thirdDay;
}
cn.Close();
return(i);
}
}
public ActionResult ChessFestival(Dictionary <string, string> queryvalues)
{
int _ClientType = queryvalues.ContainsKey("ClientType") ? Convert.ToInt32(queryvalues["ClientType"]) : 0;
string _StartDate = queryvalues.ContainsKey("StartTime") ? queryvalues["StartTime"] : 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");
FestivalBaseData fbd = new FestivalBaseData()
{
StartTime = _StartDate,
ExpirationDate = _ExpirationDate,
ClientType = _ClientType
};
IEnumerable <Festival515> fes515 = QQZoneRechargeBLL.GetFestival515(fbd);
AllFesLogin login515 = QQZoneRechargeBLL.GetFestivalLogin(fbd);
FestivalVIP vip515 = QQZoneRechargeBLL.GetFestivalVIP(fbd);
List <object> objList = new List <object>();
objList.Add(fes515);
objList.Add(login515);
objList.Add(vip515);
fbd.objects = objList;
return(View(fbd));
}
internal static IEnumerable <Festival515> GetFestival515(FestivalBaseData fbd)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
StringBuilder str = new StringBuilder();
//str.Append("SELECT DATE_FORMAT(curdate(), '%Y-%m-%d') as date, a.count as count, b.count as activeuser FROM (SELECT count(0) as count FROM Role where Gold > 10) as a, (SELECT count(0) as count FROM Role where Gold <= 10) as b;");
str.AppendFormat(@"
SELECT (select COUNT(DISTINCT UserID) from " + database1 + @".BG_LoginRecord
where LoginTime >= t1.CreateTime and LoginTime<DATE_ADD(t1.CreateTime,INTERVAL 1 DAY)
and LoginAgent!=10010) as DAU,
t1.CreateTime as DateTime,
COUNT(t1.UserID) as IconPCount,
SUM(t1.clickcount) as IconPNum,
SUM(t1.dtcount) as DIconPCount,
SUM(t1.dtnum) as DIconPNum,
SUM(t1.fjcount) as FIconPCount,
SUM(t1.fjnum) as FIconPNum
from (
select t.CreateTime,t.UserID,sum(t.ClickCount) as clickcount,SUM( DISTINCT t.dtcount) as dtcount,SUM(t.dtnum) as dtnum,
SUM( DISTINCT t.fjcount ) as fjcount,SUM(t.fjnum) as fjnum from (
select DATE_FORMAT(CreateTime,'%Y-%m-%d') as CreateTime,UserID,ClickCount,
case SiteID
when 1 then 1
else 0
end as dtcount,
case SiteID
when 1 then ClickCount
else 0
end as dtnum,
case SiteID
when 2 then 1
else 0
end as fjcount,
case SiteID
when 2 then ClickCount
else 0
end as fjnum
from " + database3 + @".BG_ClickRcord
where CreateTime BETWEEN @StartTime and @ExpirationDate {0}
) as t
GROUP BY t.CreateTime,t.UserID
) as t1
GROUP BY t1.CreateTime;
", fbd.ClientType > 0 ? " and PlatType=@ClientType" : "");
IEnumerable <Festival515> i = cn.Query <Festival515>(str.ToString(), fbd);
cn.Close();
return(i);
}
}
internal static FestivalVIP GetFestivalVIP(FestivalBaseData fbd)
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
StringBuilder str = new StringBuilder();
IEnumerable <FestivalVIP> i = cn.Query <FestivalVIP>(@"" + database3 + @".sys_get_active_vip
", new { }, null, true, null, CommandType.StoredProcedure);
cn.Close();
return(i.FirstOrDefault());
}
}
public static FestivalVIP GetFestivalVIP(FestivalBaseData fbd)
{
return(DAL.QQZoneRechargeDAL.GetFestivalVIP(fbd));
}
public static AllFesLogin GetFestivalLogin(FestivalBaseData fbd)
{
return(DAL.QQZoneRechargeDAL.GetFestivalLogin(fbd));
}
public static IEnumerable <Festival515> GetFestival515(FestivalBaseData fbd)
{
return(DAL.QQZoneRechargeDAL.GetFestival515(fbd));
}
