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