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