private void cargarGridQuery()
{
//if (txtQueryIDCaja.TextLength > 0)
//{
filtro = " CAST(fecha AS DATE) BETWEEN '" + txtFecha1.Text + "' AND '" + txtFecha2.Text + "'";
//String filtro = " CAST(fecha AS DATE)>='" + txtFecha1.Text + "' and CAST(fecha AS DATE) <='" + txtFecha2.Text+"'";
DBM.CLS.QUERY objQuery = new DBM.CLS.QUERY();
//DBM.CLS.Funciones.FillGridView(dgQuery, objQuery.GetRecordsFilters("egreso", "1", filtro));
DBM.CLS.Funciones.FillGridView(dgQuery, objQuery.GetRecordsFromTwoTableLEFTJOIN("egreso", "egreso_tipo", "idEgresoTipo", "idEgresoTipo", filtro, "a.fecha"));
//}
}
private void cargarProductos()
{
DBM.CLS.QUERY Query = new DBM.CLS.QUERY();
DBM.CLS.Funciones.FillGridView(dgProducto, Query.GetRecordsFromTwoTableLEFTJOIN("producto", "familia", "idFamilia", "idFamilia", "", "familia"));
}
private void filtrarProductoByCboFamilia()
{
DBM.CLS.QUERY Query = new DBM.CLS.QUERY();
dgProducto.AutoGenerateColumns = false;
DBM.CLS.Funciones.FillGridView(dgProducto, Query.GetRecordsFromTwoTableLEFTJOIN("producto", "familia", "idFamilia", "idFamilia", "b.idFamilia=" + cboFamilia_Query.SelectedValue.ToString(), "familia"));
}
private void filtrarProducto()
{
DBM.CLS.QUERY Query = new DBM.CLS.QUERY();
DBM.CLS.Funciones.FillGridView(dgProducto, Query.GetRecordsFromTwoTableLEFTJOIN("producto", "familia", "idFamilia", "idFamilia", "nombre like '%" + txtnombreQuery.Text + "%'", "familia"));
}
private void cargarGrid()
{
DBM.CLS.QUERY objQuery = new DBM.CLS.QUERY();
//DBM.CLS.Funciones.FillGridView(dgEgreso, objQuery.GetRecordsFilters("egreso", "idCaja", idCajaAbierta));
DBM.CLS.Funciones.FillGridView(dgEgreso, objQuery.GetRecordsFromTwoTableLEFTJOIN("egreso", "egreso_tipo", "idEgresoTipo", "idEgresoTipo", "a.idCaja =" + idCajaAbierta, "a.idEgreso"));
}
