public void Query(out string pageHtml) { pageHtml = string.Empty; var request = new TicketOffRequest(); if ((request.type == OffTypes.ALL)) { request.type = null; } request.Bdate = Data.Start; request.Edate = Data.End; if (request.pageIndex == null || request.pageIndex <= 0) { request.pageIndex = 1; } if (request.pageSize == null || request.pageSize <= 0) { request.pageSize = 10; } var query = TicketOffService.Query(request); if (query != null) { List = query.ModelList.ToList(this, u => new ListTicketOff(u)); pageHtml = MvcPage.AjaxPager((int)request.pageIndex, (int)request.pageSize, query.TotalCount); } }
public List <ListTicketOff> AjaxGet(TicketOffRequest request, out string pageHtml) { List <ListTicketOff> data = null; pageHtml = string.Empty; if ((request.type == OffTypes.ALL)) { request.type = null; } if (request.pageIndex == null || request.pageIndex <= 0) { request.pageIndex = 1; } if (request.pageSize == null || request.pageSize <= 0) { request.pageSize = 10; } var query = TicketOffService.Query(request); if (query != null) { data = query.ModelList.Select(u => new ListTicketOff(u)).ToList(); pageHtml = MvcPage.AjaxPager((int)request.pageIndex, (int)request.pageSize, query.TotalCount); } return(data); }
public ActionResult ListPost(TicketOffRequest request) { var createRole = _unityContainer.Resolve <ListTicketOffs>(); string pageHtml = string.Empty; var datas = createRole.AjaxGet(request, out pageHtml); return(Json(new { tables = datas, html = pageHtml })); }
public DataTables <TicketOffs> Query(TicketOffRequest request) { SqlParameter[] param = { new SqlParameter("@type", request.type), new SqlParameter("@Bdate", request.Bdate), new SqlParameter("@Edate", request.Edate), new SqlParameter("@mobile", request.mobile), new SqlParameter("@shopDisplayName", request.shopDisplayName), new SqlParameter("@shopName", request.shopName), new SqlParameter("@pageIndex", request.pageIndex), new SqlParameter("@pageSize", request.pageSize) }; StoreProcedure sp = new StoreProcedure("P_getTicketOff", param); return(_databaseInstance.GetTables <TicketOffs>(sp)); }