public OrderDetailAllModel GetData(string orderID) { OrderDetailAllModel orders = new OrderDetailAllModel(); orders.listOrderDetail = GetDetailOrder(orderID); var data = (from a in _dbContext.TtWebHatsuchuumeisai.Where(x => x.FChuumonNo == orderID) from b in _dbContext.TtWebShiiresaki.Where(x => x.FShiiresakiCd == a.FShiiresakiCd).DefaultIfEmpty() from c in _dbContext.TtWebRoguinyuza.Where(x => x.FShiiresakiCd == b.FShiiresakiCd).DefaultIfEmpty() select new { a.FChuumonNo, a.FShiiresakiCd, b.FShiiresakiMei, c.FTantoushaMei, b.FToiawaseTel, b.FToiawaseFax, a.FChuumonHi, a.FJushinNichiji, a.FKakuninNichiji }).FirstOrDefault(); orders.FChuumonNo = data.FChuumonNo; orders.FShiiresakiCd = data.FShiiresakiCd; orders.FShiiresakiMei = data.FShiiresakiMei; orders.FTantoushaMei = data.FTantoushaMei; orders.FToiawaseTel = data.FToiawaseTel; orders.FToiawaseFax = data.FToiawaseFax; orders.FChuumonHi = data.FChuumonHi; orders.FJushinNichiji = data.FJushinNichiji; orders.FKakuninNichiji = data.FKakuninNichiji; return(orders); }
public IActionResult ZipFile(int index) { OrderDetailAllModel Order = _IOrderDetailService.GetData("2"); string pathAttachFile = Order.listOrderDetail[index - 1].pathAttachFile; //string[] listPath = Directory.GetFiles(pathAttachFile); string fileName = Order.listOrderDetail[index - 1].FChuumonNo + "_" + Order.listOrderDetail[index - 1].FChuumonMeisaiGyou.ToString() + "_temp.zip"; var zipfile = FileUtils.ZipFolder(pathAttachFile); return(File(zipfile, "application/x-compressed", fileName)); }
public IActionResult ZipMultiSelect(List <int> index) { OrderDetailAllModel Order = _IOrderDetailService.GetData("2"); List <string> listPath = new List <string>(); List <string> listFileName = new List <string>(); foreach (var i in index) { OrderDetailModel orderDetail = Order.listOrderDetail[i - 1]; string fileName = orderDetail.FChuumonNo + "_" + orderDetail.FChuumonMeisaiGyou.ToString() + "_temp.zip"; listPath.Add(orderDetail.pathAttachFile); listFileName.Add(fileName); } var zipfile = FileUtils.ZipMultiFolders(listPath.ToArray(), listFileName.ToArray()); return(File(zipfile, "application/x-compressed", "temp.zip")); }
public IActionResult Index() { var orderid = HttpContext.Request.Query["orderid"]; //List<OrderDetailModel> ListOrderDetail = _IOrderDetailAllService.GetData("00002").listOrderDetail; OrderDetailAllModel Order = _IOrderDetailService.GetData(orderid); decimal SumAmount = 0; decimal? SumTexAmount = 0; foreach (var Nouhin in Order.listOrderDetail) { SumAmount += Nouhin.FChuumonKingaku; SumTexAmount += Nouhin.FShouhizeiKingaku; } ViewBag.sumAmount = SumAmount; ViewBag.sumTexAmount = SumTexAmount; return(View(Order)); }