public ActionResult List(string DockDoorID = "", int PageIndex = 1, int PageSize = 10)
{
try
{
//初始化物件
var m = new DockDoorListViewModel();
m.Authority = Tool.GetPageAuthority();
m.Parameters = new Models.ViewModel.DockDoor.QueryParameter();
m.Pages = new Pages();
//設定參數
m.Parameters.DockDoorID = DockDoorID;
m.Pages.PageIndex = PageIndex;
m.Pages.PageSize = PageSize;
//清單資料
var dt = DockDoorDataAccess.GetDockDoorList(DockDoorID, null, null, null, m.Pages);
m.List = Util.ToList <ListItem>(dt);
return(View(m));
}
catch
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Export(DockDoorListViewModel m)
{
//分頁物件，設定單頁筆數為最大值
Pages pages = new Pages();
pages.PageSize = int.MaxValue;
//取回資料
DataTable dt = DockDoorDataAccess.GetDockDoorList(null, m.Parameters.DockDoorID, null, null, pages);
//轉為二進位資料流
var numList = new List <int>();
MemoryStream ms = NPOITools.RenderDataTableToExcel(dt, numList) as MemoryStream;
return(File(ms.ToArray(), "application/vnd.ms-excel"));
}