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