private void btn_excel_Click(object sender, EventArgs e)
{
var BL = new tb_60movimientosdetBL();
var BE = new tb_60movimientosdet();
var TablaMov_ordprod = new DataTable();
BE.moduloid = modulo.Trim();
BE.local = local.Trim();
BE.fechdocini = Convert.ToDateTime(fechdocini.Text.Trim().Substring(0, 10));
BE.fechdocfin = Convert.ToDateTime(fechdocfin.Text.Trim().Substring(0, 10));
BE.ser_opi = serop_ini.Text.Trim();
BE.num_opi = numop_ini.Text.Trim();
BE.ser_opf = serop_fin.Text.Trim();
BE.num_opf = numop_fin.Text.Trim();
if (almacaccionid.SelectedIndex != -1 && almacaccionid.SelectedItem.ToString().Trim().Length > 0)
{
BE.almacaccionid = almacaccionid.SelectedValue.ToString();
}
BE.filtro = "1";
TablaMov_ordprod = BL.GetAll_ConsumoxOP(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (TablaMov_ordprod.Rows.Count > 0)
{
ExportarExcel(TablaMov_ordprod);
}
}
private DataTable Movimiento_mov_ordprod()
{
DtReporte = new DataTable("Productostock");
try
{
var BL = new tb_60movimientosdetBL();
var BE = new tb_60movimientosdet();
BE.moduloid = moduloid.Trim();
BE.local = local.Trim();
BE.fechdocini = Convert.ToDateTime(fechdocini.Trim().Substring(0, 10));
BE.fechdocfin = Convert.ToDateTime(fechdocfin.Trim().Substring(0, 10));
if (serop_ini.Trim().Length > 0)
{
BE.ser_opi = serop_ini.Trim().PadLeft(4, '0');
}
if (numop_ini.Trim().Length > 0)
{
BE.num_opi = numop_ini.Trim().PadLeft(10, '0');
}
if (serop_fin.Trim().Length > 0)
{
BE.ser_opf = serop_fin.Trim().PadLeft(4, '0');
}
if (numop_fin.Trim().Length > 0)
{
BE.num_opf = numop_fin.Trim().PadLeft(10, '0');
}
if (almacaccionid.Trim().Length > 0)
{
BE.almacaccionid = almacaccionid;
}
DtReporte = BL.GetAll_ConsumoxOP(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (DtReporte != null)
{
return DtReporte;
}
else
{
return DtReporte;
}
}
catch (Exception ex)
{
return null;
}
}