/// <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; }