/// <summary>
/// 查询配送方式列表
/// </summary>
/// <param name="pager">配送方式列表分页对象</param>
/// <param name="filter">查询条件</param>
/// <remarks>
/// 2013-06-21 郑荣华 创建
/// </remarks>
public void GetLgDeliveryTypeList(ref Pager <CBLgDeliveryType> pager, ParaDeliveryTypeFilter filter)
{
ILgDeliveryTypeDao.Instance.GetLgDeliveryTypeList(ref pager, filter);
}
/// <summary>
/// 查询配送方式列表
/// </summary>
/// <param name="pager">配送方式列表分页对象</param>
/// <param name="filter">查询条件</param>
/// <remarks>
/// 2013-06-21 郑荣华 创建
/// </remarks>
public override void GetLgDeliveryTypeList(ref Pager <CBLgDeliveryType> pager, ParaDeliveryTypeFilter filter)
{
using (var context = Context.UseSharedConnection(true))
{
// const string sqlWhere = @"
// (@deliverytypename is null or charindex(t.deliverytypename,@deliverytypename)>0)
// and (@isonlinevisible is null or t.isonlinevisible= @isonlinevisible)
// and (@status is null or t.status= @status)
// and (@parentsysno is null or t.parentsysno=@parentsysno)
// and (@SysNoFilter is null or not exists(select 1 from table(splitstr(@SysNoFilter,',')) z where z.column_value = t.sysno))
// ";
const string sqlWhere = @"
(@deliverytypename is null or charindex(t.deliverytypename,@deliverytypename)>0)
and (@isonlinevisible is null or t.isonlinevisible= @isonlinevisible)
and (@status is null or t.status= @status)
and (@parentsysno is null or t.parentsysno=@parentsysno)
";
#region sqlcount
const string sqlCount = @" select count(1) from lgdeliverytype t where " + sqlWhere;
pager.TotalRows = context.Sql(sqlCount)
.Parameter("deliverytypename", filter.DeliveryTypeName)
//.Parameter("deliverytypename", filter.DeliveryTypeName)
.Parameter("isonlinevisible", filter.IsOnlineVisible)
//.Parameter("isonlinevisible", filter.IsOnlineVisible)
.Parameter("status", filter.Status)
//.Parameter("status", filter.Status)
.Parameter("parentsysno", filter.ParentSysNo)
//.Parameter("parentsysno", filter.ParentSysNo)
.Parameter("SysNoFilter", filter.SysNoFilter)
//.Parameter("SysNoFilter", filter.SysNoFilter)
.QuerySingle <int>();
#endregion
#region 调试Sql
/*
* select t.* from LgDeliveryType t where DeliveryTypeName like :DeliveryTypeName order by deliveryLevel,DisplayOrder
*/
#endregion
pager.Rows = context.Select <CBLgDeliveryType>("t.*,b.deliveryTypeName ParentName")
.From("LgDeliveryType t left join LgDeliveryType b on t.parentsysno=b.sysno")
.Where(sqlWhere)
.Parameter("deliverytypename", filter.DeliveryTypeName)
//.Parameter("deliverytypename", filter.DeliveryTypeName)
.Parameter("isonlinevisible", filter.IsOnlineVisible)
//.Parameter("isonlinevisible", filter.IsOnlineVisible)
.Parameter("status", filter.Status)
//.Parameter("status", filter.Status)
.Parameter("parentsysno", filter.ParentSysNo)
//.Parameter("parentsysno", filter.ParentSysNo)
.Parameter("SysNoFilter", filter.SysNoFilter)
//.Parameter("SysNoFilter", filter.SysNoFilter)
.OrderBy("t.sysno desc")
.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 GetLgDeliveryTypeList(ref Pager <CBLgDeliveryType> pager, ParaDeliveryTypeFilter filter);
