private DataTable Lista_tomainventario()
{
var TablaProductostock = new DataTable("Productostock");
try
{
var BL = new tb_me_local_stockBL();
var BE = new tb_me_local_stock();
BE.moduloid = moduloid.Trim();
BE.local = local.Trim();
BE.lineaid = lineaid;
BE.status = status;
TablaProductostock = BL.GetAll_productostock(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (TablaProductostock != null)
{
return TablaProductostock;
}
else
{
return null;
}
}
catch (Exception ex)
{
return null;
}
}
private DataTable Movimiento_productostock(bool porlocal)
{
var TablaProductostock = new DataTable("Productostock");
try
{
var BL = new tb_me_local_stockBL();
var BE = new tb_me_local_stock();
BE.moduloid = moduloid.Trim();
BE.local = local.Trim();
BE.lineaid = lineaid;
BE.grupoid = grupoid;
BE.subgrupoid = subgrupoid;
BE.productid = productid;
BE.colorid = colorid;
BE.status = status;
BE.productidold = productidold;
if (porlocal)
{
TablaProductostock = BL.GetAll_productostockxlocal(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
}
else
{
TablaProductostock = BL.GetAll_productostock(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
}
if (TablaProductostock != null)
{
return TablaProductostock;
}
else
{
return TablaProductostock;
}
}
catch (Exception ex)
{
throw ex;
}
}
private void btn_busqueda_Click(object sender, EventArgs e)
{
var TablaProductostock = new DataTable("Productostock");
try
{
var BL = new tb_me_local_stockBL();
var BE = new tb_me_local_stock();
BE.moduloid = modulo.Trim();
BE.local = local.Trim();
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.status = chkTodos.Checked ? "1" : "0";
TablaProductostock = BL.GetAll_productostock(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0];
if (TablaProductostock != null)
{
Examinar3.DataSource = TablaProductostock;
Examinar3.RefreshDataSource();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
