/// <summary>
/// 获取进行中的活动信息
/// </summary>
/// <param name="pageIndex">页数</param>
/// <param name="pageSize">条数</param>
/// <param name="typeId">类型：0-所有，1-线上活动，2-线下活动,3-要客来访</param>
/// <returns></returns>
public static WXAcivityList GetActivityList(int pageIndex, int pageSize, int typeId = 0)
{
List <ActivityInfo> list = new List <ActivityInfo>();
WXAcivityList billResponse = new WXAcivityList();
var paras = new DynamicParameters();
paras.Add("@pageIndex", pageIndex);
paras.Add("@pageSize", pageSize);
paras.Add("@TypeId", typeId);
paras.Add("@total", 0, DbType.Int32, ParameterDirection.Output);
string sqlText = string.Empty;
sqlText = @"SELECT @total=COUNT(1) FROM( SELECT 1 AS cnt FROM dbo.Activity A
WHERE A.TypeId in(1,3,4) ) AS main;
WITH oa AS(
SELECT ROW_NUMBER() OVER(ORDER BY (CASE WHEN GETDATE()<EndDate THEN 0 ELSE 1 END),SortOrder DESC,EndDate DESC) RowNum,Title, TypeId, Summary, Content, StartDate, EndDate,CreateDate, ImageUrl, LinkUrl, Status
FROM Activity WHERE Status=1 AND TypeId in(4) and getdate() between StartDate and EndDate) SELECT * FROM oa
WHERE RowNum between (@pageIndex-1)*@pageSize+1 and @pageIndex*@pageSize";
list = PublicConn.QueryActivityBySql <ActivityInfo>(sqlText, ref paras);
if (list == null)
{
list = new List <ActivityInfo>();
}
billResponse.List = list;
billResponse.TotalCount = paras.Get <int>("@total");
if (billResponse.TotalCount > 0)
{
billResponse.result = "1";
}
else
{
billResponse.result = "2";
}
return(billResponse);
}
private void GetData()
{
model = GetActivityList(1, PageSize, type);
int recordCount = model.TotalCount;
}
