private void btnPrint_Click(object sender, EventArgs e) { if (dsReport.tbLand.Rows.Count == 0) { ReportDS.tbLandRow drLand = dsReport.tbLand.NewtbLandRow(); drLand.LandID = Guid.NewGuid().ToString(); drLand.VillageName = txtVillageName.Text; drLand.VillageNo = txtVillageNo.Text; drLand.SubDistrict = txtSubDistrict.Text; drLand.District = txtDistrict.Text; drLand.Province = txtProvince.Text; dsReport.tbLand.AddtbLandRow(drLand); } // Create a new instance of EvidenceInfoForm ReportPreview ReportPreviewForm = new ReportPreview(); // Pass Dataset to PreviewReport From ReportPreviewForm.GetDataSet = dsReport; // Display the form as top most form. ReportPreviewForm.TopMost = true; // Show the settings form ReportPreviewForm.Show(); }
void btnHoVay_Click(object sender, EventArgs e) { DataSet ds = data.BsMain.DataSource as DataSet; if (ds == null) { return; } DataRow drMaster = (data.BsMain.Current as DataRowView).Row; if (drMaster == null) { return; } //Truyền tham số vào ReportPreview Config.NewKeyValue("@MTQDID", drMaster["MTQDID"]); frmDSHoVay = FormFactory.FormFactory.Create(FormType.Report, "1559") as ReportPreview; if (frmDSHoVay == null) { return; } frmDSHoVay.WindowState = FormWindowState.Maximized; frmDSHoVay.ShowDialog(); }
private void Button_Click_1(object sender, RoutedEventArgs e) { if (nfactura.Text != "" && cif.Text != "" && nombre.Text != "" && direccion.Text != "") { DataTable error = FacturaDBHandler.GetFacturaByFactura(nfactura.Text); bool facturaExiste = false; if (error.Rows.Count > 0) { facturaExiste = true; System.Windows.MessageBox.Show("ya existe este numero de factura,pon otro distinto"); } if ((listaproductosF.Count > 0) && (nfactura.Text != "") && (cliente != null) && !facturaExiste) { MessageBoxResult resultado = System.Windows.MessageBox.Show("¿Desea crear la factura?", "Factura", MessageBoxButton.YesNo, MessageBoxImage.Information); switch (resultado) { case MessageBoxResult.Yes: Cliente cliente = new Cliente(cif.Text, nombre.Text, direccion.Text); if (!FacturaDBHandler.ClienteRepetido(cif.Text)) { FacturaDBHandler.AddCliente(cliente); } FacturaDBHandler.AddFactura(cliente, listaproductosF, nfactura.Text); MainWindow.myNavigationFrame.NavigationService.Navigate(new MainPage()); ReportPreview report = new ReportPreview(); string factura = nfactura.Text; if (nfactura.Text != "") { bool okConsulta = report.GetFacturaByFactura(factura); if (okConsulta) { report.Show(); } else { System.Windows.MessageBox.Show("no se ha encontrado el registro por factura"); } } else { System.Windows.MessageBox.Show("es necesario insertar por una factura"); } break; case MessageBoxResult.No: break; } } } else { MessageBox.Show("INTRODUZCA TODOS LOS DATOS DEL CLIENTE"); } }
void btnChon_Click(object sender, EventArgs e) { drCur = (_data.BsMain.Current as DataRowView).Row; if (!gvMain.Editable) { XtraMessageBox.Show("Vui lòng chọn chế độ thêm hoặc sửa phiếu", Config.GetValue("PackageName").ToString()); return; } //dùng report 1514 trong sysReport frmDS = FormFactory.FormFactory.Create(FormType.Report, "1514") as ReportPreview; //định dạng thêm cho grid của report gvDS = (frmDS.Controls.Find("gridControlReport", true)[0] as GridControl).MainView as GridView; StyleFormatCondition hh = new StyleFormatCondition(); gvDS.FormatConditions.Add(hh); hh.Column = gvDS.Columns["SL đã SX"]; hh.Condition = FormatConditionEnum.NotEqual; hh.Value1 = 0; hh.Appearance.BackColor = Color.LightCyan; hh.ApplyToRow = true; gvDS.DataSourceChanged += new EventHandler(gvDS_DataSourceChanged); FormatGrid(); //viết xử lý cho nút F4-Xử lý trong report SimpleButton btnXuLy = (frmDS.Controls.Find("btnXuLy", true)[0] as SimpleButton); btnXuLy.Text = "Chọn LSX"; btnXuLy.Click += new EventHandler(btnXuLy_Click); frmDS.WindowState = FormWindowState.Maximized; frmDS.ShowDialog(); }
void btnChon_Click(object sender, EventArgs e) { if (!gvMain.Editable) { XtraMessageBox.Show("Vui lòng chọn chế độ thêm hoặc sửa phiếu", Config.GetValue("PackageName").ToString()); return; } drCur = (_data.BsMain.Current as DataRowView).Row; string reportId = "1521"; if (_data.DrTable.Table.Columns.Contains("ExtraSql") && _data.DrTable["ExtraSql"].ToString().Contains("'GC'")) { reportId = "1554"; } frmDS = FormFactory.FormFactory.Create(FormType.Report, reportId) as ReportPreview; gvDS = (frmDS.Controls.Find("gridControlReport", true)[0] as GridControl).MainView as GridView; gvDS.Columns["SL tồn cuối"].ColumnEdit = new RepositoryItemCalcEdit(); gvDS.CellValueChanged += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(gvDS_CellValueChanged); gvDS.DataSourceChanged += new EventHandler(gvDS_DataSourceChanged); //viết xử lý cho nút F4-Xử lý trong report SimpleButton btnXuLy = (frmDS.Controls.Find("btnXuLy", true)[0] as SimpleButton); btnXuLy.Text = "Chọn hàng tồn"; btnXuLy.Click += new EventHandler(btnXuLy_Click); frmDS.WindowState = FormWindowState.Maximized; frmDS.ShowDialog(); }
void btnChon_Click(object sender, EventArgs e) { if (!gvMain.Editable) { XtraMessageBox.Show("Vui lòng chọn chế độ thêm hoặc sửa phiếu", Config.GetValue("PackageName").ToString()); return; } drCur = (_data.BsMain.Current as DataRowView).Row; if (drCur["MaNCC"] == DBNull.Value) { XtraMessageBox.Show("Vui lòng chọn nhà cung cấp trước!", Config.GetValue("PackageName").ToString()); return; } //dùng cách này để truyền tham số vào report Config.NewKeyValue("@MaNCC", drCur["MaNCC"]); //dùng report 1514 trong sysReport frmDS = FormFactory.FormFactory.Create(FormType.Report, "1520") as ReportPreview; gvDS = (frmDS.Controls.Find("gridControlReport", true)[0] as GridControl).MainView as GridView; //viết xử lý cho nút F4-Xử lý trong report SimpleButton btnXuLy = (frmDS.Controls.Find("btnXuLy", true)[0] as SimpleButton); btnXuLy.Text = "Chọn đơn hàng"; btnXuLy.Click += new EventHandler(btnXuLy_Click); frmDS.WindowState = FormWindowState.Maximized; frmDS.ShowDialog(); }
private void btnPrint_Click(object sender, EventArgs e) { if (gvHocVien.DataRowCount == 0 || gvHocVien.FocusedRowHandle < 0) { XtraMessageBox.Show("Cần chọn học viên bảo lưu để in phiếu", Config.GetValue("PackageName").ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); return; } DataRow drCur = gvHocVien.GetDataRow(gvHocVien.FocusedRowHandle); if (drCur.RowState != DataRowState.Unchanged || !Convert.ToBoolean(drCur["IsBL"])) { XtraMessageBox.Show("Đang chọn học viên " + drCur["TenHV"] + "\nCần bảo lưu và lưu số liệu trước khi in phiếu", Config.GetValue("PackageName").ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); return; } Config.NewKeyValue("@HVID", drCur["HVID"]); ReportPreview rpDSHV = FormFactory.FormFactory.Create(FormType.Report, "1555") as ReportPreview; if (rpDSHV == null) { return; } rpDSHV.StartPosition = FormStartPosition.CenterScreen; rpDSHV.ShowDialog(); }
public void GetGridReport(GridControl tmp, bool first) { ReportPreview rptPre = new ReportPreview(_data, tmp, first); string[] cls = _drReport["ExtraSql"].ToString().Split(new char[] { ',' }); if (cls.Length == 0) { return; } }
void PrepareReportPreview(Control cp) { ReportPreview reportPreview = (ReportPreview)Page.LoadControl("ReportPreview.ascx"); reportPreview.ControlAdapter = ASPxSchedulerControlPrintAdapter1; reportPreview.ReportTemplateFileName = "SchedulerReportTemplates\\" + GetReportNameBySelectedViewType(); cp.Controls.Clear(); cp.Controls.Add(reportPreview); }
public IActionResult PreviewReport(GenerateConsumptionReportViewModel model) { var report = new ReportPreview { ToConsumptionDate = model.ToConsumptionDate, WarehouseName = model.WarehouseName, FromConsumptionDate = model.FromConsumptionDate, //ReportTable = _farm.ConsumptionReport(model.FromConsumptionDate, model.ToConsumptionDate, model.WarehouseName,false).ToList(), GenerateReport = false }; return(RedirectToAction(nameof(PreviewConsumptionReport), report)); }
public void GetGridReport(GridControl tmp, bool first) { ReportPreview rptPre = new ReportPreview(_data, tmp, first); PluginManager _plugins = new PluginManager(); DataCustomReport cData = new DataCustomReport(_data.DrTable, tmp.FindForm() as XtraForm); _plugins.ExecuteICR(_data.DrTable["sysReportID"].ToString(), cData); string[] cls = _drReport["ExtraSql"].ToString().Split(new char[] { ',' }); if (cls.Length == 0) { return; } }
void btnChon_Click2(object sender, EventArgs e) { drCur = (_data.BsMain.Current as DataRowView).Row; Config.NewKeyValue("@SoPhieu", drCur["SoPhieu"].ToString()); frmDS = FormFactory.FormFactory.Create(FormType.Report, "1598") as ReportPreview; gvDS = (frmDS.Controls.Find("gridControlReport", true)[0] as GridControl).MainView as GridView; var para = (frmDS.Controls.Find("SoPhieu", true)[0] as TextEdit); para.Enabled = false; frmDS.WindowState = FormWindowState.Maximized; frmDS.ShowDialog(); }
private void PreviewReport_Click(object sender, EventArgs e) { ReportPreview reportPreview = new ReportPreview(); try { reportPreview.FileLocation = ExportForPreview(); reportPreview.Show(this); } catch (Exception ex) { AMTLogger.WriteToLog(ex.Message, MethodBase.GetCurrentMethod().Name, 0, AMTLogger.LogInfo.Error); } }
private void init(string rdlcFile, DataTable[] table, System.Collections.Hashtable parameters) { XmlDocument xdoc = getXMLfromRDL(rdlcFile); if (xdoc == null) { return; } ReportPreview report = new ReportPreview(); report.dataTables.AddRange(table); foreach (DictionaryEntry param in parameters) { report.reportParameters.Add(param.Key.ToString(), param.Value.ToString()); } report.reportFile = xdoc; report.ShowDialog(); }
void btnChon_Click(object sender, EventArgs e) { if (!gvMain.Editable) { XtraMessageBox.Show("Vui lòng chọn chế độ thêm hoặc sửa phiếu", Config.GetValue("PackageName").ToString()); return; } drCur = (_data.BsMain.Current as DataRowView).Row; frmDS = FormFactory.FormFactory.Create(FormType.Report, "1555") as ReportPreview; gvDS = (frmDS.Controls.Find("gridControlReport", true)[0] as GridControl).MainView as GridView; //viết xử lý cho nút F4-Xử lý trong report SimpleButton btnXuLy = (frmDS.Controls.Find("btnXuLy", true)[0] as SimpleButton); btnXuLy.Text = "Chọn hàng"; btnXuLy.Click += new EventHandler(btnXuLy_Click); frmDS.WindowState = FormWindowState.Maximized; frmDS.ShowDialog(); }
void btnChon_Click(object sender, EventArgs e) { if (!gvMain.Editable) { XtraMessageBox.Show("Vui lòng chọn chế độ thêm hoặc sửa phiếu", Config.GetValue("PackageName").ToString()); return; } drCur = (_data.BsMain.Current as DataRowView).Row; //phiếu xuất trả nguyên liệu thì bắt buộc chọn nhà cung cấp if (tb == "MT47") { if (drCur["MaNCC"] == DBNull.Value) { XtraMessageBox.Show("Vui lòng chọn nhà cung cấp trước!", Config.GetValue("PackageName").ToString()); return; } Config.NewKeyValue("@MaNCC", drCur["MaNCC"]); } if (drCur["MaKho"] == DBNull.Value) { XtraMessageBox.Show("Vui lòng chọn kho xuất trước!", Config.GetValue("PackageName").ToString()); return; } Config.NewKeyValue("@MaKho", drCur["MaKho"]); frmDS = FormFactory.FormFactory.Create(FormType.Report, "1521") as ReportPreview; gvDS = (frmDS.Controls.Find("gridControlReport", true)[0] as GridControl).MainView as GridView; gvDS.Columns["SL tồn cuối"].ColumnEdit = new RepositoryItemCalcEdit(); gvDS.CellValueChanged += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(gvDS_CellValueChanged); gvDS.DataSourceChanged += new EventHandler(gvDS_DataSourceChanged); //viết xử lý cho nút F4-Xử lý trong report SimpleButton btnXuLy = (frmDS.Controls.Find("btnXuLy", true)[0] as SimpleButton); btnXuLy.Text = "Chọn hàng tồn"; btnXuLy.Click += new EventHandler(btnXuLy_Click); frmDS.WindowState = FormWindowState.Maximized; frmDS.ShowDialog(); }
private async void actgrdPreview(object sender, RoutedEventArgs e) { tblDocumentCommon xDoc = FViewDataContext.CurrentDocument; //(tblDocumentCommon)((Button)sender).Tag; await FViewDataContext.SaveAllCangesAsync(); ReportPreview xReportPreview = new ReportPreview(); //xReportPreview.Owner = this; ReportClass xReport = PrintContext.Instance.GetReport(xDoc); try { xReportPreview.SetReport(xReport); xReportPreview.Show(); } finally { // xReport.Dispose(); } }
private void simpleButton1_Click(object sender, EventArgs e) { // Create a PrintingSystem component. PrintingSystem ps = new PrintingSystem(); // Create a link that will print a control. PrintableComponentLink link = new PrintableComponentLink(ps); // Specify the control to be printed. link.Component = gridControl1; // Subscribe to the CreateReportHeaderArea event used to generate the report header. link.CreateReportHeaderArea += new CreateAreaEventHandler(link_CreateReportHeaderArea); link.CreateDocument(); if (rp == null) { rp = new ReportPreview(); } rp.ShowForm(_ReportName, link.PrintingSystem); }
void btnChon_Click(object sender, EventArgs e) { SimpleButton btn = (SimpleButton)sender; //btnChon2.Name = "btnChon2"; drCur = (_data.BsMain.Current as DataRowView).Row; if (!gvMain.Editable) { XtraMessageBox.Show("Vui lòng chọn chế độ thêm hoặc sửa phiếu", Config.GetValue("PackageName").ToString()); return; } if (drCur["MaKH"] == DBNull.Value) { XtraMessageBox.Show("Vui lòng chọn khách hàng trước!", Config.GetValue("PackageName").ToString()); return; } //dùng cách này để truyền tham số vào report Config.NewKeyValue("@MaKH", drCur["MaKH"]); //dùng report 1514 trong sysReport if (btn.Name.Equals("btnChon")) { frmDS = FormFactory.FormFactory.Create(FormType.Report, "1516") as ReportPreview; } else { frmDS = FormFactory.FormFactory.Create(FormType.Report, "1542") as ReportPreview; } //định dạng thêm cho grid của report gvDS = (frmDS.Controls.Find("gridControlReport", true)[0] as GridControl).MainView as GridView; //viết xử lý cho nút F4-Xử lý trong report SimpleButton btnXuLy = (frmDS.Controls.Find("btnXuLy", true)[0] as SimpleButton); btnXuLy.Text = btn.Name.Equals("btnChon") ? "Chọn đơn hàng" : "Chọn lệnh sản xuất"; btnXuLy.Click += btn.Name.Equals("btnChon") ? new EventHandler(btnXuLy_Click) : new EventHandler(btnXuLy_Click2); frmDS.WindowState = FormWindowState.Maximized; frmDS.ShowDialog(); }
void btnChon_Click2(object sender, EventArgs e) { SimpleButton btn = (SimpleButton)sender; //btnChon2.Name = "btnChon2"; drCur = (_data.BsMain.Current as DataRowView).Row; if (!gvMain.Editable) { XtraMessageBox.Show("Vui lòng chọn chế độ thêm hoặc sửa phiếu", Config.GetValue("PackageName").ToString()); return; } DataRow[] drs = (_data.BsMain.DataSource as DataSet).Tables[1].Select("MT32ID = '" + drCur["MT32ID"].ToString() + "'"); List <string> data = new List <string>(); foreach (DataRow row in drs) { if (row.RowState == DataRowState.Added) { data.Add("''" + row["DTDHID"].ToString() + "''"); } } var dataText = "(" + string.Join(",", data.ToArray()) + ")"; //dùng cách này để truyền tham số vào report Config.NewKeyValue("@DTDHIDs", dataText); frmDS = FormFactory.FormFactory.Create(FormType.Report, "1617") as ReportPreview; //định dạng thêm cho grid của report gvDS = (frmDS.Controls.Find("gridControlReport", true)[0] as GridControl).MainView as GridView; //viết xử lý cho nút F4-Xử lý trong report SimpleButton btnXuLy = (frmDS.Controls.Find("btnXuLy", true)[0] as SimpleButton); btnXuLy.Visible = false; frmDS.WindowState = FormWindowState.Maximized; frmDS.ShowDialog(); }
private void Button_Click_5(object sender, RoutedEventArgs e) { ReportPreview report = new ReportPreview(); string cif = nif.Text; if (nif.Text != "") { bool okConsulta = report.GetFacturaCif(cif); if (okConsulta) { report.Show(); } else { System.Windows.MessageBox.Show("no se ha encontrado el registro por cif"); } } else { System.Windows.MessageBox.Show("es necesario insertar por cif"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string dsName = WebTools.GetExpr("SOURCE", "IPMS_SYS_EXPORT", "EXPT_ID=" + Request.QueryString["ReportID"]); DataTable dt = new DataTable(); String ConnString = ConfigurationManager.ConnectionStrings["ipmsConnectionString"].ConnectionString; OracleConnection conn = new OracleConnection(ConnString); OracleCommand cmd = new OracleCommand("SELECT * FROM " + dsName, conn); cmd.CommandType = CommandType.Text; OracleDataAdapter da = new OracleDataAdapter(cmd); da.Fill(dt); ReportGenerator gen = new ReportGenerator(dt, dsName); ReportDataSource ds = new ReportDataSource(dsName, dt); ReportPreview.Reset(); ReportPreview.LocalReport.DataSources.Add(ds); ReportPreview.LocalReport.DisplayName = dsName; ReportPreview.LocalReport.LoadReportDefinition(gen.GeneraReport()); } }
private void Button_Click_7(object sender, RoutedEventArgs e) { ReportPreview report = new ReportPreview(); string factura = numeroFactura.Text; if (numeroFactura.Text != "") { bool okConsulta = report.GetCrearFactura(factura); if (okConsulta) { report.Show(); } else { System.Windows.MessageBox.Show("no se ha encontrado el registro por factura"); } } else { System.Windows.MessageBox.Show("es necesario insertar por una factura"); } }
private void Button_Click_5(object sender, RoutedEventArgs e) { ReportPreview report = new ReportPreview(); string cif = txb_cif.Text; if (cif != "") { bool okConsulta = report.GetFacturaCIF(cif); if (okConsulta) { report.Show(); } else { MessageBox.Show("No se han econtrado registro para el CIF"); txb_cif.Text = ""; } } else { MessageBox.Show("Es necesario escribir un CIF de cliente"); } }
private void Button_Click_6(object sender, RoutedEventArgs e) { if (fechaInicio.Text != "" && fechaFin.Text != "") { string fechainicio = fechaInicio.Text; string fechafin = fechaFin.Text; ReportPreview report = new ReportPreview(); bool okConsulta = report.GetInformeFecha(fechainicio, fechafin); if (okConsulta) { report.Show(); } else { System.Windows.MessageBox.Show("No existen registros para las fechas seleccionadas"); } } else { System.Windows.MessageBox.Show("Selecciona Fecha Inicio y Fecha Fin"); } }
private void Button_Click_1(object sender, RoutedEventArgs e) { if (listaProductosF.Count > 0 && txb_nFactura.Text != "" && cliente != null) { Cliente nuevocliente = new Cliente(txb_cif.Text, txb_nombre.Text, txb_direccion.Text); FacturaDBHandler.AddClient(nuevocliente); bool okFactura = FacturaDBHandler.AddFactura(nuevocliente, listaProductosF, txb_nFactura.Text); if (okFactura) { MainWindow.myNavigationFrame.NavigationService.Navigate(new MainPage()); ReportPreview report = new ReportPreview(); string factura = txb_nFactura.Text; if (txb_nFactura.Text != "") { bool okConsulta = report.GetCrearFactura(txb_nFactura.Text); if (okConsulta) { report.Show(); } else { System.Windows.MessageBox.Show("no se ha encontrado el registro por factura"); } } else { MessageBox.Show("no se ha podido cargar la factura"); } } else { MessageBox.Show("No se ha encontrado el registro pro factura"); } } }
void btnChonHocVien_Click(object sender, EventArgs e) { gvMain = (data.FrmMain.Controls.Find("gcMain", true)[0] as GridControl).MainView as GridView; if (!gvMain.Editable) { XtraMessageBox.Show("Để chọn học viên vui lòng chuyển sang chế độ sửa hoặc thêm phiếu.", Config.GetValue("PackageName").ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); return; } drCur = (data.BsMain.Current as DataRowView).Row; if (drCur["MaCD"] == DBNull.Value) //bắt buộc chọn cấp độ trước để lọc danh sách học viên { XtraMessageBox.Show("Vui lòng chọn cấp độ để lấy danh sách!", Config.GetValue("PackageName").ToString()); return; } Config.NewKeyValue("@MaCD", drCur["MaCD"]); // nếu đã duyệt thì không cho chọn học viên if (drCur["TinhTrang"].ToString() == "Đã duyệt") { XtraMessageBox.Show("Danh sách học viên đã được duyệt, không thể chọn thêm học viên !", Config.GetValue("PackageName").ToString()); return; } rpDSHV = FormFactory.FormFactory.Create(FormType.Report, "1687") as ReportPreview; if (rpDSHV == null) { return; } gvDSHV = (rpDSHV.Controls.Find("gridControlReport", true)[0] as GridControl).MainView as GridView; SimpleButton btnXuLy = rpDSHV.Controls.Find("btnXuLy", true)[0] as SimpleButton; btnXuLy.Click += new EventHandler(btnXuLy_Click); rpDSHV.WindowState = FormWindowState.Maximized; rpDSHV.ShowDialog(); }
private void SetupSecondaryView () { Console.WriteLine("SetupSecondaryView ()"); xmlView = new XmlView(generator,this); SecondaryViewContents.Add(xmlView); reportPreview = new ReportPreview(loader,this); SecondaryViewContents.Add(reportPreview); reportViewer = new ReportViewerSecondaryView(loader,this); SecondaryViewContents.Add(reportViewer); // var wpfViewer = new WPFReportPreview(loader,this); // SecondaryViewContents.Add(wpfViewer); // testView = new TestWPFReportPreview(loader,this); // SecondaryViewContents.Add(testView); }
private void SetupSecondaryView () { xmlView = new XmlView(generator,this); SecondaryViewContents.Add(xmlView); preview = new ReportPreview(loader,this); SecondaryViewContents.Add(preview); reportViewer = new ReportViewerSecondaryView(loader,this); SecondaryViewContents.Add(reportViewer); var p = new WPFReportPreview(loader,this); SecondaryViewContents.Add(p); }
public IActionResult ConsumptionFolio(long id) { var folio = _farm.GetFolio().FirstOrDefault(x => x.Id == id); var model = new ReportPreview { ToConsumptionDate = folio.InitialDate.DateTime, WarehouseName = "", FromConsumptionDate = folio.FinalDate.DateTime, }; var report = _farm.ConsumptionReport(model.FromConsumptionDate, model.ToConsumptionDate, model.WarehouseName, false, folio.Id).ToList(); model.WarehouseName = report.Select(x => x.Warehouse).FirstOrDefault(); //report.Select(x => x.Warehouse).Distinct().ToString(); model.ReportTable = report; var excel = _excel.GenerateExcelName("SalidaSoftland" + model.WarehouseName, model.ToConsumptionDate, model.WarehouseName); var excelPath = excel[0]; var excelName = excel[1]; if (excel[0] == null) { _toastNotification.AddInfoToastMessage( "There is no consumption report between date " + model.FromConsumptionDate.ToString("MM-dd-yyyy") + " and " + model.ToConsumptionDate.ToString("MM-dd-yyyy"), new ToastrOptions { PositionClass = ToastPositions.TopCenter }); var list2 = _farm.GetWarehouseListNames(); ViewBag.WarehouseList = list2; ViewBag.Url = ""; return(View(model)); } //var file = new FileInfo(excel); using (var fs = new FileStream(excelPath, FileMode.Create, FileAccess.ReadWrite)) { var workbook = new XSSFWorkbook(); var format = workbook.CreateDataFormat(); var style = workbook.CreateCellStyle(); style.DataFormat = format.GetFormat("text"); var numberFormat = workbook.CreateDataFormat(); var numberStyle = workbook.CreateCellStyle(); numberStyle.DataFormat = numberFormat.GetFormat("#.###"); var cellCount = 9; var i = 1; ISheet excelSheet = workbook.CreateSheet("Entrada"); var rowHeader = excelSheet.CreateRow(0); rowHeader.CreateCell(0).SetCellValue("Código Bodega"); rowHeader.CreateCell(1).SetCellValue("Número de Folio Guía de Salida"); rowHeader.CreateCell(2).SetCellValue("Fecha de generación Guía de Salida"); rowHeader.CreateCell(3).SetCellValue("Concepto de Salida a Bodega"); rowHeader.CreateCell(4).SetCellValue("Descripción"); rowHeader.CreateCell(5).SetCellValue("Código Centro de Costo"); rowHeader.CreateCell(6).SetCellValue("Código de Producto"); rowHeader.CreateCell(7).SetCellValue("Código Unidad de Medida"); rowHeader.CreateCell(8).SetCellValue("Cantidad Despachada"); foreach (var item in report) { var row = excelSheet.CreateRow(i); for (var j = 0; j < cellCount; j++) { switch (j) { case 0: row.CreateCell(j).SetCellValue(item.Warehouse); break; case 1: row.CreateCell(j).SetCellValue(string.Empty); break; case 2: var cell = row.CreateCell(j, CellType.String); cell.SetCellValue(item.GeneratedDate); cell.CellStyle = style; break; case 3: row.CreateCell(j).SetCellValue(item.WarehouseOut); break; case 4: row.CreateCell(j).SetCellValue(item.Description); break; case 5: row.CreateCell(j).SetCellValue(item.CenterCostCode); break; case 6: row.CreateCell(j).SetCellValue(item.ProductCode); break; case 7: row.CreateCell(j).SetCellValue(item.BaseUnit); break; case 8: var celln = row.CreateCell(j, CellType.Numeric); celln.SetCellValue((double)item.Amount); celln.CellStyle = numberStyle; //row.CreateCell(j).SetCellValue((double) item.Amount); break; } } i++; } workbook.Write(fs); } ViewBag.Url = "/Temp/" + excelName; ViewBag.HeaderText = "Information for Folio: " + folio.Id; return(View(model)); }