/// <summary>
/// 快速搜索
/// </summary>
/// <param name="condition">搜索条件实体</param>
/// <param name="pageIndex">页索引</param>
/// <returns>符合搜索条件的实体集合</returns>
/// <remarks>2013-09-04 周瑜 创建</remarks>
public PagedList <CBDsSpecialPrice> QuickSearch(DsSpecialPriceSearchCondition condition, int pageIndex)
{
var model = new PagedList <CBDsSpecialPrice>();
if (condition == null)
{
return(model);
}
var result = IDsSpecialPriceDao.Instance.QuickSearch(condition, pageIndex, model.PageSize);
model.TData = result.Rows;
model.TotalItemCount = result.TotalRows;
model.CurrentPageIndex = pageIndex;
return(model);
}
/// <summary>
/// 快速搜索
/// </summary>
/// <param name="condition">搜索条件实体</param>
/// <param name="pageIndex">页索引</param>
/// <param name="pageSize">页大小</param>
/// <returns>符合搜索条件的实体集合</returns>
/// <remarks>2013-08-12 周瑜 创建</remarks>
public override Pager <CBDsSpecialPrice> QuickSearch(DsSpecialPriceSearchCondition condition, int pageIndex, int pageSize)
{
//2015-12-19 王耀发 创建
var DealerSysNoList = string.Empty;
if (null != condition.DealerSysNoList)
{
DealerSysNoList = string.Join(",", condition.DealerSysNoList);
}
var pager = new Pager <CBDsSpecialPrice>();
using (var context = Context.UseSharedConnection(true))
{
const string @where = @"
(@0 is null or (a.ProductSysNo = @0 or a.DealerSysNo = @0))
and (@1 is null or (charindex(b.DealerName,@1)> 0 or charindex(c.ProductName,@1)> 0))
and (@2 is null or a.Status = @2)
and (a.dealersysno = @3 or a.dealersysno in (select col from splitstr(@4, ',')))
";
var parms = new object[]
{
condition.SysNo,
condition.Name,
condition.Status,
condition.DealerSysNo,
DealerSysNoList
};
pager.TotalRows = context.Sql(@"select count(1) from DsSpecialPrice a
left join dsdealer b on a.dealersysno = b.sysno
left join pdproduct c on a.productsysno = c.sysno where " + where)
.Parameters(parms)
.QuerySingle <int>();
pager.Rows = context.Select <CBDsSpecialPrice>("a.*,b.DealerName,c.ProductName,c.ErpCode")
.From(@"DsSpecialPrice a
left join dsdealer b on a.dealersysno = b.sysno
left join pdproduct c on a.productsysno = c.sysno")
.AndWhere(where)
.Parameters(parms)
.OrderBy("a.SysNo desc")
.Paging(pageIndex, pageSize)
.QueryMany();
}
return(pager);
}
/// <summary> /// 快速搜索 /// </summary> /// <param name="condition">搜索条件实体</param> /// <param name="pageIndex">页索引</param> /// <param name="pageSize">页大小</param> /// <returns>符合搜索条件的实体集合</returns> /// <remarks>2013-09-04 周瑜 创建</remarks> public abstract Pager <CBDsSpecialPrice> QuickSearch(DsSpecialPriceSearchCondition condition, int pageIndex, int pageSize);
