private void dgvDatos_AfterRowFilterChanged(object sender, AfterRowFilterChangedEventArgs e)
{
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 :
Convert.ToDecimal(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;
}
}
private void gridViewWaste_AfterRowFilterChanged(object sender, AfterRowFilterChangedEventArgs e)
{
if (sender != null)
{
filterChanged(this, e);
}
}
private void OnRowFilterChanged(object sender, AfterRowFilterChangedEventArgs e)
{
try {
if (this.cboView.Text == "Current Issues")
{
this.grdIssues.DisplayLayout.Save(this.mColumnFilters, PropertyCategories.ColumnFilters);
}
}
catch { }
}
private void OnRowFilterChanged(object sender, AfterRowFilterChangedEventArgs e)
{
try {
this.tslFilters.Text = "Filters Off";
this.tslFilters.Enabled = false;
for (int i = 0; i < this.grdIssues.DisplayLayout.Bands[0].ColumnFilters.Count; i++)
{
if (this.grdIssues.DisplayLayout.Bands[0].ColumnFilters[i].ToString().Trim().Length > 0)
{
this.tslFilters.Text = "Filters On";
this.tslFilters.Enabled = true;
break;
}
}
}
catch { }
}
private void dgvDatos1_AfterRowFilterChanged(object sender, AfterRowFilterChangedEventArgs e)
{
try
{
int Filtrados = 0; int notFil = 0;
DataTable dt = Datos1.Copy();
//dt.Rows.Clear();
DataTable filt = Datos1.Copy();
filt.Rows.Clear();
foreach (UltraGridRow row in this.dgvDatos1.Rows)
{
if (row.IsFilteredOut)
{
Filtrados++;
}
else
{
string Consulta = "Artículo='" + row.Cells["Artículo"].Value.ToString() + "'";
DataRow[] dr = dt.Select(Consulta);
if (dr.Count() > 0)
{
foreach (DataRow item in dr)
{
DataRow dr0 = filt.NewRow();
for (int i = 0; i < filt.Columns.Count; i++)
{
dr0[i] = item[i];
}
filt.Rows.Add(dr0);
}
}
notFil++;
}
}
Filtra(filt);
}
catch (Exception ex)
{
}
}
private void ugResults_AfterRowFilterChanged(object sender, AfterRowFilterChangedEventArgs e)
{
UpdateGridRowCounts(ugResults);
}
private void ugDestination_AfterRowFilterChanged(object sender, AfterRowFilterChangedEventArgs e)
{
UpdateGridRowCounts(ugDestination);
}
private void ugSource_AfterRowFilterChanged(object sender, AfterRowFilterChangedEventArgs e)
{
UpdateGridRowCounts(ugSource);
}
private void dgvDatos_AfterRowFilterChanged(object sender, AfterRowFilterChangedEventArgs e)
{
this.Total();
}