public FileStreamResult CreateExcelToClient()
{
int page = 0, rows = 0;
string orderId = Request.QueryString["orderId"];
ExportParam ep = new ExportParam();
ep.DT1 = SortOrderDetailService.GetSortOrderDetail(page, rows, orderId);
ep.HeadTitle1 = "分拣订单管理";
return(PrintService.Print(ep));
}
public FileStreamResult CreateExcelToClient()
{
int page = 0, rows = 0;
string orderId = Request.QueryString["orderId"];
System.Data.DataTable dt = SortOrderDetailService.GetSortOrderDetail(page, rows, orderId);
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"));
}
//查询细单
// GET: /SortingOrder/sortOrderDetails/
public ActionResult sortOrderDetails(int page, int rows, string OrderID)
{
var SortOrderDetail = SortOrderDetailService.GetDetails(page, rows, OrderID);
return(Json(SortOrderDetail, "text", JsonRequestBehavior.AllowGet));
}
