/// <summary>
/// 车辆计划报表
/// </summary>
/// <returns></returns>
public ActionResult OrderDeliverPlanReport(int carrierid = -1, string begindate = "", string enddate = "", int p = 1)
{
// 默认当月
if (string.IsNullOrEmpty(begindate) || string.IsNullOrEmpty(enddate))
{
DateTime dt = DateTime.Now;
begindate = dt.Year + "-" + dt.Month + "-" + "01";
enddate = DateTime.Now.ToString("yyyy-MM-dd");
}
List <OrderDeliverPlanEntity> mList = null;
int count = OrderDeliverPlanService.GetOrderDeliverPlanCount(carrierid, begindate, enddate);
PagerInfo pager = new PagerInfo();
pager.PageIndex = p;
pager.PageSize = PAGESIZE;
pager.SumCount = count;
pager.URL = "OrderDeliverPlanReport";
mList = OrderDeliverPlanService.GetOrderDeliverPlanInfoByRule(carrierid, begindate, enddate, pager);
//默认承运商
ViewBag.Carrier = CarrierService.GetCarrierByRule("", 1);//只显示使用中的数据
ViewBag.reportList = mList;
ViewBag.carrierid = carrierid;
ViewBag.BeginDate = begindate;
ViewBag.EndDate = enddate;
ViewBag.Pager = pager;
return(View());
}
/// <summary>
/// 车辆计划报表 Excel导出
/// </summary>
/// <returns></returns>
public ActionResult OrderDeliverPlanReportToExcel(int carrierid = -1, string begindate = "", string enddate = "", int p = 1)
{
// 默认当月
if (string.IsNullOrEmpty(begindate) || string.IsNullOrEmpty(enddate))
{
DateTime dt = DateTime.Now;
begindate = dt.Year + "-" + dt.Month + "-" + "01";
enddate = DateTime.Now.ToString("yyyy-MM-dd");
}
List <OrderDeliverPlanEntity> list = null;
int count = OrderDeliverPlanService.GetOrderDeliverPlanCount(carrierid, begindate, enddate);
PagerInfo pager = new PagerInfo();
pager.PageIndex = p;
pager.PageSize = count;
pager.SumCount = count;
list = OrderDeliverPlanService.GetOrderDeliverPlanInfoByRule(carrierid, begindate, enddate, pager);
//创建Excel文件的对象
HSSFWorkbook book = new HSSFWorkbook();
//添加一个sheet
ISheet sheet1 = book.CreateSheet("Sheet1");
sheet1.SetColumnWidth(0, 15 * 256);
sheet1.SetColumnWidth(1, 15 * 256);
sheet1.SetColumnWidth(2, 15 * 256);
sheet1.SetColumnWidth(3, 15 * 256);
sheet1.SetColumnWidth(4, 15 * 256);
sheet1.SetColumnWidth(5, 15 * 256);
sheet1.SetColumnWidth(6, 15 * 256);
sheet1.SetColumnWidth(7, 15 * 256);
sheet1.SetColumnWidth(8, 15 * 256);
//给sheet1添加第一行的头部标题
int K = 0;
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0);
row1.CreateCell(0).SetCellValue("运输单号");
row1.CreateCell(1).SetCellValue("序号");
row1.CreateCell(2).SetCellValue("承运商名称");
row1.CreateCell(3).SetCellValue("温区");
row1.CreateCell(4).SetCellValue("物流方式");
row1.CreateCell(5).SetCellValue("驾驶员姓名");
row1.CreateCell(6).SetCellValue("联系电话");
row1.CreateCell(7).SetCellValue("车型");
row1.CreateCell(8).SetCellValue("提货时间");
row1.CreateCell(9).SetCellValue("备注");
row1.CreateCell(10).SetCellValue("备注1（客服备注）");
row1.CreateCell(11).SetCellValue("备注2（运营备注）");
//将数据逐步写入sheet1各个行
string remark = "";
string sfhd = "";
int row = 1;
if (list != null && list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(row++);
rowtemp.CreateCell(0).SetCellValue(list[i].DeliveryNo);
rowtemp.CreateCell(1).SetCellValue(list[i].PlanID);
rowtemp.CreateCell(2).SetCellValue(list[i].CarrierName);
rowtemp.CreateCell(3).SetCellValue(list[i].Temp);
rowtemp.CreateCell(4).SetCellValue(list[i].DeliveryType);
rowtemp.CreateCell(5).SetCellValue(list[i].DriverName);
rowtemp.CreateCell(6).SetCellValue(list[i].DriverTelephone);
rowtemp.CreateCell(7).SetCellValue(list[i].CarModel);
rowtemp.CreateCell(8).SetCellValue(list[i].DeliverDate.ToShortDateString());
rowtemp.CreateCell(9).SetCellValue(list[i].Remark);
rowtemp.CreateCell(10).SetCellValue("");
rowtemp.CreateCell(11).SetCellValue("");
}
}
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
return(File(ms, "application/vnd.ms-excel", DateTime.Now.ToString("yyyyMMdd") + "车辆计划报表.xls"));
////默认承运商
//ViewBag.Carrier = CarrierService.GetCarrierByRule("", 1);//只显示使用中的数据
//ViewBag.reportList = mList;
//ViewBag.carrierid = carrierid;
//ViewBag.BeginDate = begindate;
//ViewBag.EndDate = enddate;
//ViewBag.Pager = pager;
return(View());
}