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