/// <summary>
/// 查询分销商EAS关联
/// </summary>
/// <param name="filter">查询参数</param>
/// <returns>分销商EAS关联分页数据</returns>
/// <remarks>2013-10-10 黄志勇 创建</remarks>
public override Pager <CBDsEasAssociation> Query(ParaDsEasFilter filter)
{
const string sql =
@"(SELECT a.SYSNO,a.DEALERMALLSYSNO,a.SELLERNICK,a.CODE,a.STATUS,a.CREATEDBY,a.CREATEDDATE,a.LASTUPDATEBY,a.LASTUPDATEDATE,b.SHOPNAME,b.SHOPACCOUNT,c.MALLNAME
FROM DSEASASSOCIATION a
LEFT JOIN DSDEALERMALL b
ON a.DEALERMALLSYSNO = b.SYSNO
LEFT JOIN DSMALLTYPE c
ON c.SYSNO = b.MALLTYPESYSNO
where
(@0 is null or b.MallTypeSysNo=@0) and
(@1 is null or a.Status=@1) and
(@2 is null or charindex(b.ShopName,@2)>0) and
(@3 is null or charindex(b.ShopAccount,@3)>0) and
(@4 is null or charindex(a.SellerNick,@4)>0) and
(@5 is null or charindex(a.Code,@5)>0) and
(@6 is null or a.CreatedDate>=@6) and --日期(起)
(@7 is null or a.CreatedDate<@7) --日期(止)
) tb";
var paras = new object[]
{
filter.MallTypeSysNo,
filter.Status,
filter.ShopName,
filter.ShopAccount,
filter.SellerNick,
filter.Code,
filter.BeginDate,
filter.EndDate
};
var dataList = Context.Select <CBDsEasAssociation>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(0)").From(sql);
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBDsEasAssociation>
{
PageSize = filter.PageSize,
CurrentPage = filter.Id,
TotalRows = dataCount.QuerySingle(),
Rows = dataList.OrderBy("tb.CreatedDate desc").Paging(filter.Id, filter.PageSize).QueryMany()
};
return(pager);
}
/// <summary> /// 查询分销商EAS关联 /// </summary> /// <param name="filter">查询参数</param> /// <remarks>分销商EAS关联分页数据</remarks> /// <remarks>2013-10-10 黄志勇 创建</remarks> public abstract Pager <CBDsEasAssociation> Query(ParaDsEasFilter filter);
/// <summary>
/// 分页查询分销商EAS关联
/// </summary>
/// <param name="filter">升舱订单查询参数</param>
/// <returns></returns>
/// <remarks>2013-10-10 黄志勇 创建</remarks>
public Pager <CBDsEasAssociation> Query(ParaDsEasFilter filter)
{
return(IDsEasDao.Instance.Query(filter));
}
