public JsonResult GetSearchx() { IReportPOProcService svc = new ReportPOProcService(); //var model = svc.GetAll(); var model = svc.GetAll(); return(Json(model, JsonRequestBehavior.AllowGet)); }
public ActionResult Download(ListReportProcViewModel model) { try { XLWorkbook xlWorkBook = new XLWorkbook(); var xlWorkSheet = xlWorkBook.Worksheets.Add("Report Procurement");// xlWorkSheet; //xlWorkBook = xlApp.Workbooks.Add(Type.Missing); //xlWorkSheet = (Worksheet)xlWorkBook.Worksheets.get_Item(1); xlWorkSheet.Cell(1, 1).Value = "TanngalPO"; xlWorkSheet.Cell(1, 2).Value = "PONUMBER"; xlWorkSheet.Cell(1, 3).Value = "TYPEUNIT"; xlWorkSheet.Cell(1, 4).Value = "QTYSATUAN"; xlWorkSheet.Cell(1, 5).Value = "WARNA"; xlWorkSheet.Cell(1, 6).Value = "VENDORNAME"; xlWorkSheet.Cell(1, 7).Value = "WILAYAH"; xlWorkSheet.Cell(1, 8).Value = "PROMISEDELIVERYDATE"; xlWorkSheet.Cell(1, 9).Value = "SO"; xlWorkSheet.Cell(1, 10).Value = "DO"; xlWorkSheet.Cell(1, 11).Value = "GO"; xlWorkSheet.Cell(1, 12).Value = "BILLINGNUMBER"; xlWorkSheet.Cell(1, 13).Value = "INVOICERECEIPTDATE"; xlWorkSheet.Cell(1, 14).Value = "KWITANSINUMBER"; xlWorkSheet.Cell(1, 15).Value = "GROUPINGCODE"; xlWorkSheet.Cell(1, 16).Value = "PAYMENTDATE"; xlWorkSheet.Cell(1, 17).Value = "NOCHASISVENDOR"; xlWorkSheet.Cell(1, 18).Value = "NOENGINEVENDOR"; IReportPOProcService svc = new ReportPOProcService(); var Data = svc.GetAll(); int Row = 2; if (Data.Count > 0) { for (int i = 0; i < Data.Count; i++) { xlWorkSheet.Cell(Row + i, 1).Value = Data[i].TGLPO; xlWorkSheet.Cell(Row + i, 2).Value = Data[i].PONUMBER; xlWorkSheet.Cell(Row + i, 3).Value = Data[i].MAINTYPEUNIT; xlWorkSheet.Cell(Row + i, 4).Value = Data[i].POQTY; xlWorkSheet.Cell(Row + i, 5).Value = Data[i].WARNA; xlWorkSheet.Cell(Row + i, 6).Value = Data[i].VENDORNAME; xlWorkSheet.Cell(Row + i, 7).Value = Data[i].CITY; xlWorkSheet.Cell(Row + i, 8).Value = Data[i].DELIVERYDATE; xlWorkSheet.Cell(Row + i, 9).Value = Data[i].SALESORDERNO; xlWorkSheet.Cell(Row + i, 10).Value = Data[i].DONUMBER; xlWorkSheet.Cell(Row + i, 11).Value = Data[i].ACTUALDATEDELIVEREDUNIT; xlWorkSheet.Cell(Row + i, 12).Value = Data[i].BILLINGNO; xlWorkSheet.Cell(Row + i, 13).Value = Data[i].ACTUALRECEIVEDINV; xlWorkSheet.Cell(Row + i, 14).Value = Data[i].INVNO; xlWorkSheet.Cell(Row + i, 15).Value = Data[i].CODEGROUP; xlWorkSheet.Cell(Row + i, 16).Value = Data[i].TGLPEMBAYARAN; xlWorkSheet.Cell(Row + i, 17).Value = Data[i].NOCHASIS_INPUT; xlWorkSheet.Cell(Row + i, 18).Value = Data[i].NOENGINE_INPUT; } xlWorkSheet.Columns().AdjustToContents(); var path = Server.MapPath("..") + "\\Report-Procurement.xlsx"; xlWorkBook.SaveAs(path); xlWorkBook.Dispose(); return(File(path, "application/vnd.ms-excel", "Report-Procurement.xlsx")); } return(RedirectToAction("Index")); } catch (Exception) { throw; } }