/// <summary>
/// 查询配送员(业务员)信用配额集合
/// </summary>
/// <param name="pager">配送员(业务员)信用配额集合分页对象</param>
/// <param name="filter">配送员信用查询条件</param>
/// <returns></returns>
/// <remarks>2013-06-21 郑荣华 创建</remarks>
public override void GetLgDeliveryUserCreditList(ref Pager <CBLgDeliveryUserCredit> pager,
ParaDeliveryUserCreditFilter filter)
{
const string whereSql = @"(@username is null or charindex(b.username,@username)>0)
and (@IsAllowBorrow is null or a.IsAllowBorrow=@IsAllowBorrow )
and (@IsAllowDelivery is null or a.IsAllowDelivery=@IsAllowDelivery)
and (@WarehouseSysNo is null or a.WarehouseSysNo=@WarehouseSysNo)";
const string sqlcount = @"select count(1) from LgDeliveryUserCredit a
inner join syuser b on a.DeliveryUserSysNo=b.sysno
where " + whereSql;
const string fromSql = @"lgdeliveryusercredit a inner join syuser b on a.deliveryusersysno=b.sysno
left join whwarehouse d on a.warehousesysno=d.sysno";
using (var context = Context.UseSharedConnection(true))
{
pager.TotalRows = context.Sql(sqlcount)
.Parameter("username", filter.UserName)
.Parameter("IsAllowBorrow", filter.IsAllowBorrow)
.Parameter("IsAllowDelivery", filter.IsAllowDelivery)
.Parameter("WarehouseSysNo", filter.WarehouseSysNo)
.QuerySingle <int>();
pager.Rows = context.Select <CBLgDeliveryUserCredit>("a.*,b.username,b.status,d.warehousename")
.From(fromSql)
.Where(whereSql)
.Parameter("username", filter.UserName)
.Parameter("IsAllowBorrow", filter.IsAllowBorrow)
.Parameter("IsAllowDelivery", filter.IsAllowDelivery)
.Parameter("WarehouseSysNo", filter.WarehouseSysNo)
.OrderBy("a.LastUpdateDate desc,a.warehousesysno,a.remainingdeliverycredit,a.deliveryusersysno")
.Paging(pager.CurrentPage, pager.PageSize)
.QueryMany();
}
}
/// <summary> /// 查询配送员(业务员)信用配额集合 /// </summary> /// <param name="pager">配送员(业务员)信用配额集合分页对象</param> /// <param name="filter">配送员信用查询条件</param> /// <returns></returns> /// <remarks>2013-06-21 郑荣华 创建</remarks> public abstract void GetLgDeliveryUserCreditList(ref Pager <CBLgDeliveryUserCredit> pager, ParaDeliveryUserCreditFilter filter);
/// <summary>
/// 查询配送员(业务员)信用配额集合
/// </summary>
/// <param name="pager">配送员信用配额列表分页对象</param>
/// <param name="filter">配送员信用查询条件</param>
/// <remarks>2013-06-21 郑荣华 创建</remarks>
public void GetLgDeliveryUserCreditList(ref Pager <CBLgDeliveryUserCredit> pager, ParaDeliveryUserCreditFilter filter)
{
ILgDeliveryUserCreditDao.Instance.GetLgDeliveryUserCreditList(ref pager, filter);
}
