/// <summary>
/// 分页获取促销规则
/// </summary>
/// <param name="filter">筛选条件</param>
/// <returns>分页列表</returns>
/// <remarks>2013-08-21 黄志勇 创建</remarks>
public override Pager <SpPromotionRule> GetPromotionRule(ParaPromotionRule filter)
{
const string sql =
@"(select a.*
from SpPromotionRule a
where
(@0 is null or charindex(a.Name,@0)>0) and --规则名称
(@1 is null or a.PromotionType=@1) and
--促销类型
(@2 is null or a.RuleType=@2) and
--促销类型
(@3 is null or charindex(a.Description,@3)>0) and
--规则描述
(@4 is null or a.Status=@4)
--状态
) tb";
var dataList = Context.Select <SpPromotionRule>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(0)").From(sql);
var paras = new object[]
{
filter.Name,
filter.PromotionType,
filter.RuleType,
filter.Description,
filter.Status
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <SpPromotionRule>
{
CurrentPage = filter.Id,
PageSize = filter.PageSize
};
var totalRows = dataCount.QuerySingle();
var rows = dataList.OrderBy("tb.LastUpdateDate desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = totalRows;
pager.Rows = rows;
return(pager);
}
/// <summary>
/// 分页获取促销规则
/// </summary>
/// <param name="filter">筛选条件</param>
/// <returns>分页列表</returns>
/// <remarks>2013-08-21 黄志勇 创建</remarks>
public Pager <SpPromotionRule> DoPromotionRuleQuery(ParaPromotionRule filter)
{
return(ISpPromotionRuleDao.Instance.GetPromotionRule(filter));
}
/// <summary> /// 分页获取促销规则 /// </summary> /// <param name="filter">筛选条件</param> /// <returns>分页列表</returns> /// <remarks>2013-08-21 黄志勇 创建</remarks> public abstract Pager <SpPromotionRule> GetPromotionRule(ParaPromotionRule filter);
