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); } }