private DataTable Movimiento_productokardex_tela()
{
var TablaProductokardex_tela = new DataTable("Productokardex_tela");
try
{
var BL = new tb_me_movimientosdetBL();
var BE = new tb_me_movimientosdet();
BE.moduloid = moduloid.Trim();
BE.local = local.Trim();
BE.lineaid = lineaid;
BE.grupoid = grupoid;
BE.subgrupoid = subgrupoid;
BE.productid = productid;
BE.colorid = colorid;
BE.rollo = rollo;
BE.mottrasladointid = mottrasladointid;
BE.Ubicacion = Produbic;
BE.ctacte = ctacte;
BE.direcnume = direcnume;
BE.fechdocini = Convert.ToDateTime(fechdocini.Trim().Substring(0, 10));
BE.fechdocfin = Convert.ToDateTime(fechdocfin.Trim().Substring(0, 10));
if (almacaccionid.Trim().Length > 0)
{
BE.almacaccionid = almacaccionid;
}
TablaProductokardex_tela = BL.GetAll_productokardex(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (TablaProductokardex_tela != null)
{
return TablaProductokardex_tela;
}
else
{
return null;
}
}
catch (Exception ex)
{
return null;
}
}
private void ImpresionKardexArticulo()
{
var TablaProductokardex_tela = new DataTable();
var BL = new tb_me_movimientosdetBL();
var BE = new tb_me_movimientosdet();
BE.moduloid = modulo;
BE.local = local;
BE.lineaid = lineaid.Text.Trim();
BE.grupoid = grupoid.Text.Trim();
BE.subgrupoid = subgrupoid.Text.Trim();
BE.productid = productid.Text.Trim();
BE.colorid = colorid.Text.Trim();
BE.mottrasladointid = mottrasladointid.Text.Trim();
BE.Ubicacion = produbic.Text.Trim();
BE.ctacte = ctacte.Text.Trim();
BE.direcnume = direcnume.ToString();
BE.fechdocini = Convert.ToDateTime(fechdocini.Text.Substring(0, 10));
BE.fechdocfin = Convert.ToDateTime(fechdocfin.Text.Substring(0, 10));
BE.serref = serref.Text.Trim();
BE.numref = numdococ1.Text.Trim() + numdococ.Text.Trim();
if (almacaccionid.SelectedValue.ToString() != string.Empty)
{
BE.almacaccionid = almacaccionid.SelectedValue.ToString();
}
TablaProductokardex_tela = BL.GetAll_productokardex(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (TablaProductokardex_tela.Rows.Count == 0)
{
MessageBox.Show("No existe Información Procesada", "Mensaje del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
var miForma = new Frm_Reportes();
var reporteRollokardex = new REPORTES.CR_productokardex();
miForma.Text = "Reporte de Kardex x Articulo";
reporteRollokardex.DataDefinition.FormulaFields["fechdoc"].Text = "'DE: " + fechdocini.Text.Substring(0, 10) + " AL:" + fechdocfin.Text.Substring(0, 10) + "'";
reporteRollokardex.DataDefinition.FormulaFields["almacen"].Text = "'" + VariablesPublicas.EmpresaTipo + "'";
if (modulo.Trim() == "0810")
{
reporteRollokardex.DataDefinition.FormulaFields["name"].Text = "'TIENDA : " + VariablesPublicas.Local + " - " + VariablesPublicas.nombrelocal + "'";
}
else
{
reporteRollokardex.DataDefinition.FormulaFields["name"].Text = "'LOCAL : " + VariablesPublicas.Local + " - " + VariablesPublicas.nombrelocal + "'";
}
if (modulo == "0320")
{
reporteRollokardex.DataDefinition.FormulaFields["varitems"].Text = "'ROLLO'";
}
else
{
reporteRollokardex.DataDefinition.FormulaFields["varitems"].Text = "''";
}
miForma.Table = TablaProductokardex_tela;
miForma.Reporte = reporteRollokardex;
miForma.Show();
}
}
