/// <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); }