public void ValidaRubroIngreso()
{
var zhallado = false;
var xcodartic = string.Empty;
xcodartic = examinarrubros.Rows[examinarrubros.CurrentRow.Index].Cells["rubroid"].Value.ToString();
var xcodplanilla = "...";
if (object.ReferenceEquals(examinaranexos.Rows[examinaranexos.CurrentRow.Index].Cells["tipoplla"].Value, DBNull.Value))
{
}
else
{
xcodplanilla = examinaranexos.Rows[examinaranexos.CurrentRow.Index].Cells["tipoplla"].Value.ToString();
}
if (xcodartic.Trim().Length == 0)
{
examinarrubros.Rows[examinarrubros.CurrentRow.Index].Cells["rubroid"].Value = string.Empty;
examinarrubros.Rows[examinarrubros.CurrentRow.Index].Cells["rubroname"].Value = string.Empty;
zhallado = true;
}
else
{
var BL = new tb_plla_rubrosingresoBL();
var BE = new tb_plla_rubrosingreso();
BE.tipoplla = xcodplanilla;
BE.rubroid = xcodartic;
tmptabla = BL.GetAll_CONSULTA_PLLA(VariablesPublicas.EmpresaID, BE).Tables[0];
if (BL.Sql_Error.Length == 0)
{
if (tmptabla.Rows.Count > 0)
{
zhallado = true;
examinarrubros.Rows[examinarrubros.CurrentRow.Index].Cells["rubroid"].Value = tmptabla.Rows[0]["rubroid"].ToString().Trim();
examinarrubros.Rows[examinarrubros.CurrentRow.Index].Cells["rubroname"].Value = tmptabla.Rows[0]["rubroname"].ToString().Trim();
}
}
}
if (!zhallado)
{
examinarrubros.Rows[examinarrubros.CurrentRow.Index].Cells["rubroid"].Value = j_rubro;
}
examinarrubros.Refresh();
}
private void Filtrar()
{
var sorted = default(SortOrder);
var xnomcolumna = string.Empty;
if ((dgProveedor.SortedColumn != null))
{
xnomcolumna = dgProveedor.Columns[dgProveedor.SortedColumn.Index].Name;
sorted = dgProveedor.SortOrder;
}
var xpalabra1 = string.Empty;
var xpalabra2 = string.Empty;
var xpalabra3 = string.Empty;
if (txtdescripcion.Enabled)
{
xpalabra1 = VariablesPublicas.Palabras(txtdescripcion.Text, 1);
xpalabra2 = VariablesPublicas.Palabras(txtdescripcion.Text, 2);
xpalabra3 = VariablesPublicas.Palabras(txtdescripcion.Text, 3);
}
var xtipoplla = string.Empty;
if (_Planilla.Trim().Length == 0)
{
if (cmbtipoplanilla.Enabled)
{
xtipoplla = cmbtipoplanilla.SelectedValue.ToString();
}
}
else
{
xtipoplla = _Planilla;
}
var xvmccia = "..";
if (cmbempresa.Enabled)
{
if (cmbempresa.SelectedValue != null)
{
xvmccia = cmbempresa.SelectedValue.ToString();
}
}
dgProveedor.DataSource = null;
dgProveedor.AutoGenerateColumns = false;
var BL = new tb_plla_rubrosingresoBL();
var BE = new tb_plla_rubrosingreso();
BE.tipoplla = xtipoplla;
BE.descriplike1 = xpalabra1;
BE.descriplike2 = xpalabra2;
BE.descriplike3 = xpalabra3;
dgProveedor.DataSource = BL.GetAll_CONSULTA_PLLA(VariablesPublicas.EmpresaID, BE).Tables[0];
if (xnomcolumna.Trim().Length > 0)
{
if (sorted == SortOrder.Ascending)
{
dgProveedor.Sort(dgProveedor.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Ascending);
}
else
{
dgProveedor.Sort(dgProveedor.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Descending);
}
}
else
{
dgProveedor.Sort(dgProveedor.Columns["rubroid"], System.ComponentModel.ListSortDirection.Ascending);
}
VariablesPublicas.PintaEncabezados(dgProveedor);
}
