/// <summary> /// 获取明细 /// </summary> /// <param name="pageIndex">页码</param> /// <param name="pageSize">条数</param> /// <param name="queryFields">搜索项,默认全部</param> /// <param name="orderBy">排序</param> /// <param name="sWhere">条件</param> /// <returns></returns> public PageResult GetAllPageResult(int pageIndex = 1, int pageSize = 50, string queryFields = "*", string orderBy = "", string sWhere = null, string type = null) { PageResult result = new PageResult(); try { Bitshare.PTMM.Service.DTO.PageInfo page = new Service.DTO.PageInfo(); page.CurrentPageIndex = pageIndex; page.PageSize = pageSize; page.QueryFields = queryFields; //page.Where = sWhere; page.Orderby = orderBy; //查询数据 if (type == "Vehicle") { page.Where = sWhere + " and EndDate>= getdate()"; result = CommonHelper.ListPageResult <tblAdFixingList_Monitor>(page); } else if (type == "Out") { page.Where = sWhere + " and EndDate>= getdate()"; result = CommonHelper.ListPageResult <tblOutdoorAdOrderMedia_Monitor>(page); } else if (type == "Bicycle") { page.Where = sWhere + " and endDate>= getdate() "; result = CommonHelper.ListPageResult <tblBicycleMadialist_Monitor>(page); } } catch (Exception ex) { Bitshare.PTMM.Common.LogManager.Error("GetAllPageResult()", ex); } return(result); }
/// <summary> /// 获取明细 /// </summary> /// <param name="pageIndex">页码</param> /// <param name="pageSize">条数</param> /// <param name="queryFields">搜索项,默认全部</param> /// <param name="orderBy">排序</param> /// <param name="sWhere">条件</param> /// <returns></returns> public PageResult GetAllPageResult(int pageIndex = 1, int pageSize = 50, string queryFields = "*", string orderBy = "", string sWhere = null, string type = null) { PageResult result = new PageResult(); try { Bitshare.PTMM.Service.DTO.PageInfo page = new Service.DTO.PageInfo(); page.CurrentPageIndex = pageIndex; page.PageSize = pageSize; page.QueryFields = queryFields; page.Where = sWhere; page.Orderby = orderBy; //查询数据 if (type == "媒体明细") { result = CommonHelper.ListPageResult <tblAdOrderMediaList_Design>(page); } else if (type == "车位明细") { result = CommonHelper.ListPageResult <tblAdFixinglist_Design>(page); } else if (type == "户外媒体") { result = CommonHelper.ListPageResult <tblOutdoorAdOrderMedia_Design>(page); } else if (type == "自行车媒体") { result = CommonHelper.ListPageResult <tblBicycleMadialist_Design>(page); } else if (type == "设计稿明细") { result = CommonHelper.ListPageResult <tblDesignPhotos>(page); } } catch (Exception ex) { Bitshare.PTMM.Common.LogManager.Error("GettblAdFixinglistPageResult()", ex); } return(result); }
/// <summary> /// 获取明细 /// </summary> /// <param name="pageIndex">页码</param> /// <param name="pageSize">条数</param> /// <param name="queryFields">搜索项,默认全部</param> /// <param name="orderBy">排序</param> /// <param name="sWhere">条件</param> /// <returns></returns> public PageResult GetAllPageResult(int pageIndex = 1, int pageSize = 50, string queryFields = "*", string orderBy = "", string sWhere = null) { PageResult result = new PageResult(); try { Bitshare.PTMM.Service.DTO.PageInfo page = new Service.DTO.PageInfo(); page.CurrentPageIndex = pageIndex; page.PageSize = pageSize; page.QueryFields = queryFields; //page.Where = sWhere; page.Orderby = orderBy; //查询数据 page.Where = sWhere + " "; result = CommonHelper.ListPageResult <View_Announcement>(page); } catch (Exception ex) { Bitshare.PTMM.Common.LogManager.Error("GetAllPageResult()", ex); } return(result); }