private void button1_Click(object sender, EventArgs e)
{
if (button1.Text == "Filtrar errores")
{
button1.Text = "Mostrar todo";
Infragistics.Win.UltraWinGrid.FilterCondition myConditions = new Infragistics.Win.UltraWinGrid.FilterCondition();
myConditions.CompareValue = "Y";
myConditions.ComparisionOperator = Infragistics.Win.UltraWinGrid.FilterComparisionOperator.Equals;
dgvDatos.Rows.ColumnFilters["Error"].FilterConditions.Add(myConditions);
}
else
{
button1.Text = "Filtrar errores";
UltraGridBand band = this.dgvDatos.DisplayLayout.Bands[0];
band.ColumnFilters["Error"].FilterConditions.Clear();
}
}
private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
dgvDatos.DataSource = null;
dgvStocks.DataSource = null;
dgvVentas.DataSource = null;
dgvTotales.DataSource = null;
if (cbOrigen.SelectedIndex == 0)
{
this.SetMensaje("Seleccione un almacén origen", 5000, Color.Red, Color.White);
return;
}
if (cbDestino.SelectedIndex == 0)
{
this.SetMensaje("Seleccione un almacén destino", 5000, Color.Red, Color.White);
return;
}
using (SqlConnection connection = new SqlConnection(Datos.Clases.Constantes.conectionLog))
{
using (SqlCommand command = new SqlCommand("sp_Inventario", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@TipoConsulta", 13);
command.Parameters.AddWithValue("@Almacen_Origen", cbOrigen.SelectedValue);
command.Parameters.AddWithValue("@Almacen_Destino", cbDestino.SelectedValue);
command.Parameters.AddWithValue("@ItemCode", txtArticulo.Text);
command.Parameters.AddWithValue("@CardCode", cbLinea.SelectedValue);
command.Parameters.AddWithValue("@nameOrigen", cbOrigen.Text);
command.Parameters.AddWithValue("@nameDestino", cbDestino.Text);
command.Parameters.Add("@TipoReubicacion", SqlDbType.VarChar, 10).Direction = ParameterDirection.Output;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = command;
DataTable table = new DataTable();
da.Fill(table);
TipoFormato = Convert.ToString(command.Parameters["@TipoReubicacion"].Value.ToString());
dgvDatos.DataSource = table;
dgvDatos.Rows.ColumnFilters[(int)Columnas1.Linea].FilterConditions.Clear();
dgvDatos.Rows.ColumnFilters[(int)Columnas1.Articulo].FilterConditions.Clear();
if (Convert.ToInt32(cbLinea.SelectedValue) != 0)
{
Infragistics.Win.UltraWinGrid.FilterCondition myConditions = new Infragistics.Win.UltraWinGrid.FilterCondition();
myConditions.CompareValue = cbLinea.Text;
myConditions.ComparisionOperator = Infragistics.Win.UltraWinGrid.FilterComparisionOperator.Equals;
dgvDatos.Rows.ColumnFilters[(int)Columnas1.Linea].FilterConditions.Add(myConditions);
}
if (!string.IsNullOrEmpty(txtArticulo.Text))
{
Infragistics.Win.UltraWinGrid.FilterCondition myConditions = new Infragistics.Win.UltraWinGrid.FilterCondition();
myConditions.CompareValue = txtArticulo.Text;
myConditions.ComparisionOperator = Infragistics.Win.UltraWinGrid.FilterComparisionOperator.Equals;
dgvDatos.Rows.ColumnFilters[(int)Columnas1.Articulo].FilterConditions.Add(myConditions);
}
if (TipoFormato.Equals("TRA1"))
{
DataTable tbl = new DataTable();
tbl.Columns.Add("Total (PZ)", typeof(decimal));
tbl.Columns.Add("Total ($)", typeof(decimal));
tbl.Columns.Add("Peso (KG)", typeof(decimal));
tbl.Columns.Add("Volumen (ft3)", typeof(decimal));
DataRow row = tbl.NewRow();
decimal pz = decimal.Zero; decimal mm = decimal.Zero; decimal peso = decimal.Zero; decimal vol = decimal.Zero;
foreach (UltraGridRow item in dgvDatos.Rows)
{
if (!item.IsFilteredOut)
{
pz += Convert.ToDecimal(item.Cells[(int)Columnas1.Transferir].Value);
mm += Convert.ToDecimal(item.Cells[(int)Columnas1.Monto].Value);
peso += Convert.ToDecimal(item.Cells["TP"].Value == DBNull.Value ? decimal.Zero
: item.Cells["TP"].Value);
vol += Convert.ToDecimal(item.Cells["Volumen"].Value);
}
}
row[0] = pz;
row[1] = mm;
row[2] = peso;
row[3] = vol;
tbl.Rows.Add(row);
dgvTotales.DataSource = tbl;
Infragistics.Win.UltraWinCalcManager.UltraCalcManager calcManager;
calcManager = new Infragistics.Win.UltraWinCalcManager.UltraCalcManager(this.Container);
dgvDatos.CalcManager = calcManager;
calcManager.ReCalc();
}
}
}
}
catch (Exception ex)
{
this.SetMensaje(ex.Message, 5000, Color.Red, Color.White);
}
}