private void FgFix_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode.ToString() == "Delete")
{
FgFix.SetData(FgFix.Row, FgFix.Col, null);
}
}
private void FgFix_CellChanged(object sender, C1.Win.C1FlexGrid.RowColEventArgs e)
{
DataTable dtResult = new DataTable();
if (b_agregando == true)
{
return;
}
//if ((funfun.NulosC(FgFix.GetData(FgFix.Row, FgFix.Col)).ToString() == "") || (funfun.NulosN(FgFix.GetData(FgFix.Row, FgFix.Col)).ToString() == "0") )
//{
// dtResult = dtConsulta;
// FgFix.SetData(FgFix.Row, FgFix.Col, null);
// funFlex.FlexMostrarDatos(FgFiltro, arrCabeceraFlex, dtResult, 0, true);
// return;
//}
int n_col = FgFix.Col - 1; // RESTAMOS 1 PARA IGUALARLO AL INDICE DEL ARRAY DEL FILTRO
string c_cadenafiltro = "";
string c_condicion = funfun.NulosC(FgFix.GetData(FgFix.Row, FgFix.Col));
//if (arrCabeceraFlex[n_col, 2].ToString() == "C")
//{
// c_cadenafiltro = arrCabeceraFlex[n_col, 4].ToString() + " LIKE '*" + c_condicion + "*'";
//}
//if ((arrCabeceraFlex[n_col, 2].ToString() == "N") || (arrCabeceraFlex[n_col, 2].ToString() == "D"))
//{
// c_cadenafiltro = arrCabeceraFlex[n_col, 4].ToString() + " = " + c_condicion + "";
//}
string c_nomcol = "";
int n_fil = 0;
int n_numcon = 0;
c_cadenafiltro = "";
//Helper.Comunes.Funciones funFunciones = new Helper.Comunes.Funciones();
for (n_col = 1; n_col <= FgFix.Cols.Count - 1; n_col++)
{
c_nomcol = FgFix.GetData(0, n_col).ToString();
c_condicion = funfun.NulosC(FgFix.GetData(2, n_col));
if (c_condicion != "")
{
n_numcon = n_numcon + 1;
if (n_numcon > 1)
{
c_cadenafiltro = c_cadenafiltro + " AND";
}
for (n_fil = 1; n_fil <= FgFix.Cols.Count - 1; n_fil++)
{
if (arrCabeceraFlex[n_fil - 1, 0] == c_nomcol)
{
if (arrCabeceraFlex[n_fil - 1, 2].ToString() == "C")
{
c_cadenafiltro = c_cadenafiltro + " " + arrCabeceraFlex[n_fil - 1, 4].ToString() + " LIKE '*" + c_condicion + "*'";
}
if ((arrCabeceraFlex[n_fil - 1, 2].ToString() == "N") || (arrCabeceraFlex[n_fil, 2].ToString() == "D"))
{
c_cadenafiltro = c_cadenafiltro + " " + arrCabeceraFlex[n_col, 4].ToString() + " = " + c_condicion + "";
}
break;
}
}
}
}
if (c_cadenafiltro == "")
{
dtResult = dtConsulta;
FgFix.SetData(FgFix.Row, FgFix.Col, null);
funFlex.FlexMostrarDatos(FgFiltro, arrCabeceraFlex, dtResult, 0, true);
}
else
{
dtResult = fungen.DataTableFiltrar(dtConsulta, c_cadenafiltro);
funFlex.FlexMostrarDatos(FgFiltro, arrCabeceraFlex, dtResult, 0, true);
}
}
