public FileStreamResult CreateExcelToClient()
{
int page = 0, rows = 0;
string sortingLineCode = Request.QueryString["sortingLineCode"];
string sortingLineName = Request.QueryString["sortingLineName"];
string productName = Request.QueryString["productName"];
string productCode = Request.QueryString["productCode"];
string isActive = Request.QueryString["IsActive"];
System.Data.DataTable dt = SortingLowerlimitService.GetSortingLowerlimit(page, rows, sortingLineCode, sortingLineName, productName, productCode, isActive);
string headText = "备货区下限设置";
string headFont = "微软雅黑"; Int16 headSize = 20;
string colHeadFont = "Arial"; Int16 colHeadSize = 10;
string[] HeaderFooder =
{
"……" //眉左
, "……" //眉中
, "……" //眉右
, "&D" //脚左 日期
, "……" //脚中
, "&P" //脚右 页码
};
System.IO.MemoryStream ms = THOK.Common.ExportExcel.ExportDT(dt, null, headText, null, headFont, headSize
, 0, true, colHeadFont, colHeadSize, 0, true, 0, HeaderFooder, null, 0);
return(new FileStreamResult(ms, "application/ms-excel"));
}
public FileStreamResult CreateExcelToClient()
{
int page = 0, rows = 0;
string sortingLineCode = Request.QueryString["sortingLineCode"];
string sortingLineName = Request.QueryString["sortingLineName"];
string productName = Request.QueryString["productName"];
string productCode = Request.QueryString["productCode"];
string isActive = Request.QueryString["IsActive"];
ExportParam ep = new ExportParam();
ep.DT1 = SortingLowerlimitService.GetSortingLowerlimit(page, rows, sortingLineCode, sortingLineName, productName, productCode, isActive);
ep.HeadTitle1 = "备货区下限设置";
return(PrintService.Print(ep));
}