public ActionResult DownLoadExcel() { List <OrderBookingListViewModel> orderData = new List <OrderBookingListViewModel>(); string beginDateTime = SessionDispatchSearchModel.BeginDateTime.HasValue ? SessionDispatchSearchModel.BeginDateTime.Value.ToString("yyyy/MM/dd") : string.Empty; string endDateTime = SessionDispatchSearchModel.EndDateTime.HasValue ? SessionDispatchSearchModel.EndDateTime.Value.ToString("yyyy/MM/dd") : string.Empty; string postalName = string.Empty; if (SessionDispatchSearchModel.PostalCode.HasValue) { var queryPostal = _codeDetailService.GetLabel("PostalCode", SessionDispatchSearchModel.PostalCode.Value); if (!string.IsNullOrEmpty(queryPostal)) { postalName = queryPostal; } } string searchText = string.Format("任務調派查詢條件:起訖時間({0}~{1}),地區({2}),車主({3})", beginDateTime, endDateTime, postalName, SessionDispatchSearchModel.DriverName); //限制只能為公司報價的 var user = _aspNetUsersService.GetUserModelByName(User.Identity.Name); SessionDispatchSearchModel.QuotedCompanyId = user.CompanyId; orderData = _bookingService.GetDispatchBookingList(SessionDispatchSearchModel); string searchDateStr = "任務調派報表_" + DateTime.Now.ToString("yyyyMMddHHmm"); var fileStream = _bookingService.GenerateDispatchOrderXlsx(orderData, "任務調派報表", searchText, searchDateStr + ".xlsx"); return(File(fileStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "QueryOrderData.xlsx")); }
public ActionResult DownLoadExcel() { List <OrderBookingListViewModel> orderData = new List <OrderBookingListViewModel>(); ResponseViewModel result = new ResponseViewModel(); string beginDateTime = SessionOrderSearchModel.BeginDateTime.HasValue ? SessionOrderSearchModel.BeginDateTime.Value.ToString("yyyy/MM/dd") : string.Empty; string endDateTime = SessionOrderSearchModel.EndDateTime.HasValue ? SessionOrderSearchModel.EndDateTime.Value.ToString("yyyy/MM/dd") : string.Empty; string postalName = string.Empty; if (SessionOrderSearchModel.PostalCode.HasValue) { var queryPostal = _codeDetailService.GetLabel("PostalCode", SessionOrderSearchModel.PostalCode.Value); if (!string.IsNullOrEmpty(queryPostal)) { postalName = queryPostal; } } string searchText = string.Format("網路搶單查詢條件:起訖時間({0}~{1}),地區({2})", beginDateTime, endDateTime, postalName); // 限制只能為公司報價的 var user = _aspNetUsersService.GetUserModelByName(User.Identity.Name); //不能顯示公司下的訂單 SessionOrderSearchModel.ExcludeCompanyId = user.CompanyId; SessionOrderSearchModel.ProcessStatusList.Add((byte)BookingProcessStatusEnum.Quote); orderData = _bookingService.GetOrderBookingList(SessionOrderSearchModel); string searchDateStr = "網路搶單報表_" + DateTime.Now.ToString("yyyyMMddHHmm"); var fileStream = _bookingService.GenerateGrabOrderXlsx(orderData, "網路搶單報表", searchText, searchDateStr + ".xlsx"); return(File(fileStream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "QueryOrderData.xlsx")); }