private void ImpresionFormato131() { var TablaMov_balancestock = new DataTable("mov_balancestock"); var BL = new tb_60movimientosdetBL(); var BE = new tb_60movimientosdet(); var mes1 = Convert.ToInt32(cboPerimesini.SelectedValue.ToString()); var mes2 = Convert.ToInt32(cboPerimesfin.SelectedValue.ToString()); BE.moduloid = modulo; BE.local = local; BE.perianio = ((MERCADERIA.MainMercaderia)MdiParent).perianio; if (mes1 < 10) { BE.perimesini = "0" + Convert.ToString(cboPerimesini.SelectedValue.ToString()); } else { BE.perimesini = Convert.ToString(cboPerimesini.SelectedValue.ToString()); } if (mes2 < 10) { BE.perimesfin = "0" + Convert.ToString(cboPerimesfin.SelectedValue.ToString()); } else { BE.perimesfin = Convert.ToString(cboPerimesfin.SelectedValue.ToString()); } BE.lineaid = lineaid.Text.Trim(); BE.grupoid = grupoid.Text.Trim(); BE.subgrupoid = subgrupoid.Text.Trim(); BE.productidini = productid.Text.Trim(); var dt = new DataTable(); dt = BL.GetAll_Balance(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; TablaMov_balancestock = dt; if (TablaMov_balancestock.Rows.Count == 0) { MessageBox.Show("No existe Información Procesada", "Mensaje del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { var miForma = new Frm_Reportes(); var reporteBalanceStock = new REPORTES.CR_mov_balancestock(); miForma.Text = "Reporte Balance de Stock"; Fech_impresion(); reporteBalanceStock.DataDefinition.FormulaFields["empresaestable"].Text = "': " + VariablesPublicas.EmpresaEstablec.Trim() + "'"; reporteBalanceStock.DataDefinition.FormulaFields["empresatipo"].Text = "': " + ((MERCADERIA.MainMercaderia)MdiParent).moduloname + "'"; reporteBalanceStock.DataDefinition.FormulaFields["empresaperiodo"].Text = "': " + VariablesPublicas.N_PrimerMes1.Trim() + " " + VariablesPublicas.perianio.Trim() + "'"; if (VariablesPublicas.N_FinMes1 == string.Empty) { reporteBalanceStock.DataDefinition.FormulaFields["mesperifin"].Text = string.Empty; } else { reporteBalanceStock.DataDefinition.FormulaFields["mesperifin"].Text = "'- " + VariablesPublicas.N_FinMes1.Trim() + " " + VariablesPublicas.perianio.Trim() + "'"; } reporteBalanceStock.DataDefinition.FormulaFields["fechaimpresion"].Text = "': " + VariablesPublicas.FechImpresion + "'"; miForma.Table = TablaMov_balancestock; miForma.Reporte = reporteBalanceStock; miForma.Show(); } }
private DataTable Movimiento_mov_balancestock() { DtReporte = new DataTable("mov_balancestock"); try { var BL = new tb_60movimientosdetBL(); var BE = new tb_60movimientosdet(); BE.moduloid = moduloid.ToString(); BE.local = local.ToString(); BE.perianio = Peranio.ToString(); BE.perimesini = Mesdoini.ToString(); BE.perimesfin = Mesdofin.ToString(); BE.lineaid = lineaid.Trim(); BE.grupoid = grupoid.Trim(); BE.subgrupoid = subgrupoid.Trim(); BE.productidini = productidini.Trim(); if (accion) { BE.accion = "0"; } else { BE.accion = "1"; } DtReporte = BL.GetAll_Balance(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; if (DtReporte != null) { return DtReporte; } else { return DtReporte; } } catch (Exception ex) { return null; } }