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));
}
