/// <summary>
/// 获取补贴设置信息
/// danny-20150320
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public PageInfo <T> GetSubsidyList <T>(HomeCountCriteria criteria)
{
string columnList = @" s.[Id]
,s.[OrderCommission]
,s.[DistribSubsidy]
,s.[WebsiteSubsidy]
,s.[StartDate]
,s.[EndDate]
,s.[Status]
,s.[GroupId]
,s.[PKMCost]
,s.[OrderType]
,g.GroupName";
var sbSqlWhere = new StringBuilder(" 1=1 ");
if (criteria.GroupId != null && criteria.GroupId != 0)
{
sbSqlWhere.AppendFormat(" AND s.GroupId={0} ", criteria.GroupId);
}
string tableList = @" subsidy s WITH (NOLOCK) LEFT JOIN dbo.[group] g WITH(NOLOCK) ON g.Id = s.GroupId ";
string orderByColumn = " s.StartDate DESC,s.EndDate DESC ";
return(new PageHelper().GetPages <T>(SuperMan_Read, criteria.PageIndex, sbSqlWhere.ToString(), orderByColumn, columnList, tableList, criteria.PageSize, true));
}
/// <summary>
/// 获取补贴设置信息
/// danny-20150320
/// </summary>
/// <param name="criteria"></param>
/// <returns></returns>
public PageInfo <subsidy> GetSubsidyList(HomeCountCriteria criteria)
{
PageInfo <subsidy> pageinfo = subsidyDao.GetSubsidyList <subsidy>(criteria);
return(pageinfo);
}
