/// <summary>
/// 导出Excel
/// </summary>
/// <param name="filter">过滤条件</param>
/// <returns>Excel数据</returns>
/// <remarks>2013-10-16 周唐炬 创建</remarks>
public override List <CBUnAdvertisementLog> GetExcelList(Model.Parameter.ParaUnAdvertisementLogFilter filter)
{
const string sql = @"(SELECT A.*,C.SITENAME,C.SITEURL
FROM UnAdvertisementLog A
LEFT JOIN UnAdvertisement B
ON B.SYSNO = A.ADVERTISEMENTSYSNO
LEFT JOIN UnUnionSite C
ON C.SYSNO = B.UNIONSITESYSNO
WHERE (@0 IS NULL OR A.IsValid = @0)
AND (@1 IS NULL OR A.AdvertisementType = @1)
AND (@2 IS NULL OR C.SYSNO=@2)
AND (@3 IS NULL OR A.UpdateTime >= @3)
AND (@4 IS NULL OR A.UpdateTime<=@4))
) tb";
var dataList = Context.Select <CBUnAdvertisementLog>("tb.*").From(sql);
var paras = new object[]
{
filter.IsValid,
filter.AdvertisementType,
filter.UnionSiteSysNo,
filter.StartTime,
filter.EndTime
};
dataList.Parameters(paras);
return(dataList.OrderBy(@"tb.SysNo desc").Paging(filter.CurrentPage, filter.PageSize).QueryMany());
}
/// <summary>
/// 查询联盟广告日志
/// </summary>
/// <param name="filter">过滤条件</param>
/// <returns>查询数据</returns>
/// <remarks>2013-10-16 周唐炬 创建</remarks>
public override Pager <UnAdvertisementLog> GetList(Model.Parameter.ParaUnAdvertisementLogFilter filter)
{
const string sql = @"(SELECT A.*
FROM UnAdvertisementLog A
LEFT JOIN UnAdvertisement B
ON B.SYSNO = A.ADVERTISEMENTSYSNO
LEFT JOIN UnUnionSite C
ON C.SYSNO = B.UNIONSITESYSNO
WHERE (@0 IS NULL OR A.IsValid = @0)
AND (@1 IS NULL OR A.AdvertisementType = @1)
AND (@2 IS NULL OR C.SYSNO=@2)
AND (@3 IS NULL OR A.AccessTime >= @3)
AND (@4 IS NULL OR A.AccessTime <= @4)
) tb";
var dataList = Context.Select <UnAdvertisementLog>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
if (filter.EndTime.HasValue)
{
var date = Convert.ToDateTime(filter.EndTime.Value);
filter.EndTime = date.AddDays(1);
}
var paras = new object[]
{
filter.IsValid,
filter.AdvertisementType,
filter.UnionSiteSysNo,
filter.StartTime,
filter.EndTime
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <UnAdvertisementLog>
{
Rows = dataList.OrderBy(@"tb.SysNo desc").Paging(filter.CurrentPage, filter.PageSize).QueryMany(),
TotalRows = dataCount.QuerySingle()
};
return(pager);
}
