/// <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>
/// 运输计划 保存
/// </summary>
/// <param name="orderids"></param>
/// <returns></returns>
public JsonResult OrderDeliveryPlanProcess(string orderids, string carrierName, int carrierId, string temp, string deliveryType,
string driverName, string driverTelephone, string carModel, string carNo, string deliverDate, string remark, string oilcardNo,
string oilCardBalance, string gpsNo, string needTicket, int planID)
{
bool result = false;
if (CurrentUser != null)
{
OrderDeliverPlanEntity entity = new OrderDeliverPlanEntity();
entity.PlanID = planID;
entity.DeliveryNo = "YD" + DateTime.Now.ToString("yyyyMMddhhmmsss");
entity.OrderIDS = orderids;
entity.CarrierName = carrierName;
entity.CarrierID = carrierId;
entity.Temp = temp;
entity.DeliveryType = deliveryType;
entity.DriverName = driverName;
entity.DriverTelephone = driverTelephone;
entity.CarModel = carModel;
entity.CarNo = carNo;
entity.DeliverDate = !string.IsNullOrEmpty(deliverDate) ? Convert.ToDateTime(deliverDate) : DateTime.Now;
entity.Remark = remark;
entity.OilCardNo = oilcardNo;
entity.OilCardBalance = !string.IsNullOrEmpty(oilCardBalance) ? Convert.ToDecimal(oilCardBalance) : 0;
entity.GPSNo = gpsNo;
entity.NeedTicket = !string.IsNullOrEmpty(needTicket) && needTicket.Equals("T") ? true : false;
entity.OperatorID = CurrentUser != null?CurrentUser.UserID.ToString().ToInt(0) : -1;
LogHelper.WriteTextLog("运输计划", "保存参数：" + JsonHelper.ToJson(entity) + "操作人：" + CurrentUser.UserID);
//运输计划保存
int UpdatePlanID = OrderDeliverPlanService.ModifyOrderDeliverPlan(entity);
//更新订单承运商
if (!string.IsNullOrEmpty(orderids))
{
string[] ids = orderids.Split(',');
foreach (string id in ids)
{
if (!string.IsNullOrEmpty(id))
{
LogHelper.WriteTextLog("承运商更新", "订单ID：" + id + "承运商名称：" + carrierName);
//更新订单承运商
OrderService.UpdateOrderCarrier(id.ToInt(0), carrierId, UpdatePlanID);
}
}
}
}
return(new JsonResult
{
Data = result
});
}
/// <summary>
/// 获取配送计划
/// </summary>
/// <param name="planID"></param>
/// <returns></returns>
public JsonResult GetOrderDeliverPlanByPlanID(int planID)
{
OrderDeliverPlanEntity entity = OrderDeliverPlanService.GetOrderDeliverPlanEntityById(planID);
return(Json(entity));
}
/// <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());
}