public ActionResult WindowTicketingLogsPost(WindowTicketingRequest request) { var createRole = _unityContainer.Resolve <ListWindowTicketings>(); string pageHtml = string.Empty; var datas = createRole.AjaxGet(request, out pageHtml); return(Json(new { tables = datas, html = pageHtml })); }
public DataTables <WindowTicketings> Query(WindowTicketingRequest request) { SqlParameter[] param = { new SqlParameter("@admissionTicketId", request.admissionTicketId), new SqlParameter("@shopId", request.shopId), new SqlParameter("@Bdate", request.Bdate), new SqlParameter("@Edate", request.Edate), new SqlParameter("@mobile", request.mobile), new SqlParameter("@payType", request.payType), new SqlParameter("@shopName", request.shopName), new SqlParameter("@pageIndex", request.pageIndex), new SqlParameter("@pageSize", request.pageSize) }; StoreProcedure sp = new StoreProcedure("P_getWindowTicketings", param); return(_databaseInstance.GetTables <WindowTicketings>(sp)); }
public void Query(out string pageHtml) { pageHtml = string.Empty; var request = new WindowTicketingRequest(); if ((request.payType == WindowTicketingPayType.All)) { request.payType = null; } if ((request.admissionTicketId == Globals.All)) { request.admissionTicketId = null; } var user = SecurityHelper.GetCurrentUser().CurrentUser; if (user is ShopUser) { request.shopId = (user as ShopUser).ShopId; } 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 = windowTicketingService.Query(request); if (query != null) { List = query.ModelList.ToList(this, u => new ListWindowTicketing(u)); pageHtml = MvcPage.AjaxPager((int)request.pageIndex, (int)request.pageSize, query.TotalCount); } }
public List <ListWindowTicketing> AjaxGet(WindowTicketingRequest request, out string pageHtml) { List <ListWindowTicketing> data = null; pageHtml = string.Empty; if ((request.payType == WindowTicketingPayType.All)) { request.payType = null; } if ((request.admissionTicketId == Globals.All)) { request.admissionTicketId = null; } var user = SecurityHelper.GetCurrentUser().CurrentUser; if (user is ShopUser) { request.shopId = (user as ShopUser).ShopId; } if (request.pageIndex == null || request.pageIndex <= 0) { request.pageIndex = 1; } if (request.pageSize == null || request.pageSize <= 0) { request.pageSize = 10; } var query = windowTicketingService.Query(request); if (query != null) { data = query.ModelList.Select(u => new ListWindowTicketing(u)).ToList(); pageHtml = MvcPage.AjaxPager((int)request.pageIndex, (int)request.pageSize, query.TotalCount); } return(data); }