/// <summary>
/// 分页查询数据
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="sidx"></param>
/// <param name="sord"></param>
/// <returns></returns>
public ActionResult GetPageDataListForContacts(int page = 1, int rows = 50, string sidx = "", string sord = "")
{
string Manager = Request["Manager"];
//分页
PageInfo pager = new PageInfo();
pager.CurrentPageIndex = page;
pager.PageSize = rows;
pager.Sidx = sidx;
pager.Sord = sord;
long total = 0;
QueryDocument query = new QueryDocument();
if (!string.IsNullOrWhiteSpace(Manager))
{
query.Set("_id", new MongoDB.Bson.BsonRegularExpression(Manager));
}
SortByDocument sortBy = new SortByDocument();
sortBy.Set("LatestTime", -1);
var list = appService.GetPageListAppContacts(query, sortBy, pager.CurrentPageIndex, pager.PageSize, out total);
#region 分页处理
//翻页处理
SubPageResult <AppContactsInfo> result = new SubPageResult <AppContactsInfo>();
result.rows = list;
result.page = page;
result.records = (int)total;
result.total = (result.records + pager.PageSize - 1) / pager.PageSize;
#endregion
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取客户登记列表
/// </summary>
/// <param name="pager">分页</param>
/// <param name="loginName">登录名</param>
/// <returns></returns>
public SubPageResult <tblAdOperationRegist> GetAdOperationRegistList(PageInfo pager, string loginName)
{
SubPageResult <tblAdOperationRegist> result = new SubPageResult <tblAdOperationRegist>();
result = CommonHelper.ListSubPageResult <tblAdOperationRegist>(pager);
return(result);
}
/// <summary>
/// 获取款项收付款明细列表
/// </summary>
/// <param name="pager">分页</param>
/// <param name="loginName">登陆名</param>
/// <returns></returns>
public SubPageResult <View_FinanceDetails> GetAdOrderFundList(PageInfo pager, string loginName)
{
SubPageResult <View_FinanceDetails> result = new SubPageResult <View_FinanceDetails>();
result = CommonHelper.ListSubPageResult <View_FinanceDetails>(pager);
return(result);
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <typeparam name="T">Model中名称必须和数据库表名一致</typeparam>
/// <param name="page">数据参数</param>
/// <returns></returns>
public static SubPageResult <T> ListSubPageResult <T>(PageInfo page) where T : new()
{
SubPageResult <T> result = new SubPageResult <T>();
try
{
List <T> list = new List <T>();
int totalCount = 0;
if (String.IsNullOrWhiteSpace(page.Orderby))
{
if (!String.IsNullOrWhiteSpace(page.Sidx))
{
page.Orderby = page.Sidx + " " + page.Sord;
}
else
{
page.Orderby = "Rid desc";
}
}
//获取数据
DataTable ds = DBContext.DataDecision.QueryPageByProc(typeof(T).Name, page.Orderby, out totalCount, "*", page.Where, page.CurrentPageIndex, page.PageSize);
//对数据进行封装
result.page = page.CurrentPageIndex;
result.rows = ds.ToList <T>();
result.total = (totalCount + page.PageSize - 1) / page.PageSize;
result.records = totalCount;
}
catch (Exception ex)
{
LogManager.Error("ListPageResult<" + typeof(T).Name + ">", ex);
}
return(result);
}
/// <summary>
/// 分页查询数据
/// </summary>
/// <param name="serviceId"></param>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="sidx"></param>
/// <param name="sord"></param>
/// <returns></returns>
public ActionResult GetPageDataListForContacts(string serviceId, int page = 1, int rows = 50, string sidx = "", string sord = "")
{
//分页
var pager = new PageInfo
{
CurrentPageIndex = page,
PageSize = rows,
Sidx = sidx,
Sord = sord
};
long total = 0;
var query = new QueryDocument();
var sortBy = new SortByDocument();
sortBy.Set("LatestTime", -1);
var list = new List <ServiceAlertContactsInfo>();
int id;
if (!string.IsNullOrWhiteSpace(serviceId) && int.TryParse(serviceId, out id))
{
query.Set("ServiceId", id);
list = AppService.GetPageListServiceAlertContactsInfos(query, sortBy, pager.CurrentPageIndex, pager.PageSize, out total);
}
#region 分页处理
//翻页处理
SubPageResult <ServiceAlertContactsInfo> result = new SubPageResult <ServiceAlertContactsInfo>();
result.rows = list;
result.page = page;
result.records = (int)total;
result.total = (result.records + pager.PageSize - 1) / pager.PageSize;
#endregion
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 车辆修补列表
/// </summary>
/// <param name="pager">分页</param>
/// <param name="loginName">登录名</param>
/// <returns></returns>
public SubPageResult <tblAdVehicleRepair> GetAdVehicleRepairList(PageInfo pager, string loginName)
{
SubPageResult <tblAdVehicleRepair> result = new SubPageResult <tblAdVehicleRepair>();
result = CommonHelper.ListSubPageResult <tblAdVehicleRepair>(pager);
return(result);
}
/// <summary>
/// 获取自行车广告媒体查询列表
/// </summary>
/// <param name="pager"></param>
/// <param name="loginName"></param>
/// <returns></returns>
public SubPageResult <View_BicycleMediaQuery> GetView_BicycleMediaAdList(PageInfo pager, string loginName)
{
SubPageResult <View_BicycleMediaQuery> result = new SubPageResult <View_BicycleMediaQuery>();
result = CommonHelper.ListSubPageResult <View_BicycleMediaQuery>(pager);
return(result);
}
/// <summary>
/// 获取媒体制作列表数据
/// </summary>
/// <param name="pager">分页对象</param>
/// <param name="loginName">登陆名</param>
/// <returns></returns>
public SubPageResult <tblAdOrder> GetZAdOrderList(PageInfo pager, string loginName, string title)
{
SubPageResult <tblAdOrder> result = new SubPageResult <tblAdOrder>();
result = CommonHelper.ListSubPageResult <tblAdOrder>(pager);
return(result);
}
/// <summary>
/// 根据订单单号获取媒体调整明细
/// </summary>
/// <param name="orderId">订单号</param>
/// <param name="page">基础页对象</param>
/// <returns></returns>
public SubPageResult <tblMessage> GettblMessagePageResult(string orderId, PageInfo page)
{
SubPageResult <tblMessage> result = new SubPageResult <tblMessage>();
try
{
page.Where = " AdorderId='" + orderId + "' and MsgTitle='媒体调整通知'";
result = CommonHelper.ListSubPageResult <tblMessage>(page);
}
catch (Exception ex)
{
LogManager.Error("GettblMessagePageResult", ex);
}
return(result);
}
/// <summary>
/// 根据订单单号获取自行车媒体明细
/// </summary>
/// <param name="orderId">订单号</param>
/// <param name="page">基础页对象</param>
/// <returns></returns>
public SubPageResult <tblBicycleMadialist> GettblBicycleMadialistPageResult(string orderId, PageInfo page)
{
SubPageResult <tblBicycleMadialist> result = new SubPageResult <tblBicycleMadialist>();
try
{
page.Where = " AdorderId='" + orderId + "'";
result = CommonHelper.ListSubPageResult <tblBicycleMadialist>(page);
}
catch (Exception ex)
{
LogManager.Error("GettblBicycleMadialistPageResult", ex);
}
return(result);
}
/// <summary>
/// 根据订单单号获取媒体明细
/// </summary>
/// <param name="orderId">订单号</param>
/// <param name="page">基础页对象</param>
/// <returns></returns>
public SubPageResult <tblOutdoorAdOrderMedia_Zi> GettblOutdoorAdOrderMedia_ZiPageDate(string orderId, PageInfo page)
{
SubPageResult <tblOutdoorAdOrderMedia_Zi> result = new SubPageResult <tblOutdoorAdOrderMedia_Zi>();
try
{
page.Where = " AdorderId='" + orderId + "'";
result = CommonHelper.ListSubPageResult <tblOutdoorAdOrderMedia_Zi>(page);
}
catch (Exception ex)
{
LogManager.Error("GettblOutdoorAdOrderMedia_ZiPageDate", ex);
}
return(result);
}
/// <summary>
/// 根据订单单号获取到款明细
/// </summary>
/// <param name="orderId">订单号</param>
/// <param name="page">基础页对象</param>
/// <returns></returns>
public SubPageResult <tblAdFinance> GettblAdFinancePageResult(string orderId, PageInfo page)
{
SubPageResult <tblAdFinance> result = new SubPageResult <tblAdFinance>();
try
{
page.Where = " AdorderId='" + orderId + "'";
page.Orderby = "ArriveDate";
result = CommonHelper.ListSubPageResult <tblAdFinance>(page);
}
catch (Exception ex)
{
LogManager.Error("GettblAdFinancePageResult", ex);
}
return(result);
}
/// <summary>
/// 根据订单单号获取款项进度明细
/// </summary>
/// <param name="orderId">订单号</param>
/// <param name="page">基础页对象</param>
/// <returns></returns>
public SubPageResult <tblAdOrderFundSet> GettblAdOrderFundSetPageResult(string orderId, PageInfo page)
{
SubPageResult <tblAdOrderFundSet> result = new SubPageResult <tblAdOrderFundSet>();
try
{
page.Where = " AdOrderId='" + orderId + "'";
page.Orderby = "OughtDate,OughtNum";
result = CommonHelper.ListSubPageResult <tblAdOrderFundSet>(page);
}
catch (Exception ex)
{
LogManager.Error("GettblAdOrderFundSetPageResult", ex);
}
return(result);
}
/// <summary>
/// 分页获取媒体预定数据列表
/// </summary>
/// <param name="loginName">登录名</param>
/// <param name="pageIndex">查询页码</param>
/// <param name="pageSize">分页大小</param>
/// <param name="queryFields">查询字段,默认查询全部</param>
/// <param name="orderBy">排序条件</param>
/// <param name="keyword">关键字</param>
/// <param name="seller">业务员</param>
/// <param name="contractType">合同类型</param>
/// <param name="dept">部门</param>
/// <param name="trade">广告行业</param>
/// <param name="quickType">快捷查询.eg:到期合同</param>
/// <param name="EndDate">结束日期</param>
/// <param name="StartDate">开始日期</param>
/// <param name="Look"></param>
/// <returns>返回对象</returns>
public SubPageResult <tblAdOrder> GetMediaOrderPageResult(string loginName, string Look, int pageIndex = 1, int pageSize = 50, string queryFields = "*", string orderBy = "",
string keyword = null, string seller = null, string contractType = null, string dept = null, string trade = null, string quickType = null, string AdOrderId = null, string MediaTypeName = null, string AdContent = null, string StartDate = null, string EndDate = null)
{
SubPageResult <tblAdOrder> result = new SubPageResult <tblAdOrder>();
try
{
PageInfo page = GetPageInfo(loginName, Look, pageIndex, pageSize, queryFields, orderBy, keyword, seller, contractType, dept, trade, AdOrderId, MediaTypeName, AdContent, StartDate, EndDate);
AppendExtraWhere(ref page, AdOrderTypeEnum.MediaOrder, quickType, loginName);
result = CommonHelper.ListSubPageResult <tblAdOrder>(page);
}
catch (Exception ex)
{
Bitshare.PTMM.Common.LogManager.Error("GetMediaOrderPageResult", ex);
}
return(result);
}
public ActionResult GetPageResult(string keyword = null, int page = 1, int rows = 50, string sidx = "", string sord = "")
{
SystemServiceFactory factory = new SystemServiceFactory();
ISystemService service = factory.GetInstance();
SubPageResult <tblAdOrder> result = new SubPageResult <tblAdOrder>();
string LoginName = CurrentHelper.CurrentUser.User.LoginName;
string Authority = FlowHelper.GetBusinessAuthority("订单查询");
switch (Authority)
{
case "查看所有":
result = service.GetSchedulePageResult(LoginName, keyword, page, rows, sidx, sord); break;
case "查看下级":
result = service.GetSchedulePageResultForMeUnderling(LoginName, keyword, page, rows, sidx, sord); break;
default:
result = service.GetSchedulePageResultForMe(LoginName, keyword, page, rows, sidx, sord);; break;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
