/// <summary> /// 查询商城地区关联 /// </summary> /// <param name="filter">查询参数</param> /// <returns>商城地区关联分页数据</returns> /// <remarks>2014-10-14 缪竞华 创建</remarks> public override Model.Pager <Model.Transfer.CBDsMallAreaRelation> Query(Model.Parameter.ParaDsMallAreaRelationFilter filter) { const string sql = @"(SELECT a.*,b.DealerName,c.MallName,d.AreaName from DsMallAreaAssociation a LEFT JOIN DsDealer b on a.DealerSysNo = b.SysNo LEFT JOIN DsMallType c on a.malltypesysno = c.sysno LEFT JOIN BsArea d on a.hytareasysno = d.sysno WHERE (@0 is null or charindex(lower(b.DealerName),lower(@0))>0) OR --分销商名称 (@1 is null or charindex(lower(c.MallName),lower(@1))>0) OR --商城名称 (@2 is null or charindex(lower(a.MallAreaName),lower(@2))>0) OR --商城地区名称 (@3 is null or charindex(lower(d.AreaName),lower(@3))>0) --商城地区名称 ) tb "; var paras = new object[] { filter.DealerName, filter.MallName, filter.MallAreaName, filter.AreaName }; var dataList = Context.Select <CBDsMallAreaRelation>("tb.*").From(sql); var dataCount = Context.Select <int>("count(0)").From(sql); dataList.Parameters(paras); dataCount.Parameters(paras); var pager = new Pager <CBDsMallAreaRelation> { PageSize = filter.PageSize, CurrentPage = filter.Id, TotalRows = dataCount.QuerySingle(), Rows = dataList.OrderBy("tb.sysNo desc").Paging(filter.Id, filter.PageSize).QueryMany() }; return(pager); }
/// <summary> /// 查询商城地区关联 /// </summary> /// <param name="filter">查询参数</param> /// <returns>商城地区关联分页数据</returns> /// <remarks>2014-10-14 缪竞华 创建</remarks> public Model.Pager <Model.Transfer.CBDsMallAreaRelation> Query(Model.Parameter.ParaDsMallAreaRelationFilter filter) { return(IDsMallAreaRelationDao.Instance.Query(filter)); }