/// <summary> /// Initializes a new instance of the JqGridColumnSearchOptions class. /// </summary> public JqGridColumnSearchOptions() { BuildSelect = null; DataEvents = null; DataInit = null; DataUrl = null; DefaultValue = null; HtmlAttributes = null; SearchHidden = false; SearchOperators = (JqGridSearchOperators)32768; }
private static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (!string.IsNullOrEmpty(searchingOperatorString)) return String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue); switch (searchingOperator) { case JqGridSearchOperators.Bw: return String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue); case JqGridSearchOperators.Bn: return String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue); case JqGridSearchOperators.Ew: return String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue); case JqGridSearchOperators.En: return String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue); case JqGridSearchOperators.Cn: return String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue); case JqGridSearchOperators.Nc: return String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue); default: return String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue); } }
public string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_DoprinosDohodak") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_DoprinosDohodakVr") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_KnjigaOS") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_PoslovniSubjekt") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } return(String.Empty); }
private Func <Character, bool> GetCharacterNamePredicate(JqGridSearchOperators searchingOperator, string searchingValue) { Func <Character, bool> namePredicate = null; switch (searchingOperator) { case JqGridSearchOperators.Eq: namePredicate = (character => String.Compare(character.Name, searchingValue, StringComparison.OrdinalIgnoreCase) == 0); break; case JqGridSearchOperators.Ne: namePredicate = (character => String.Compare(character.Name, searchingValue, StringComparison.OrdinalIgnoreCase) != 0); break; case JqGridSearchOperators.Bw: namePredicate = (character => character.Name.StartsWith(searchingValue, StringComparison.OrdinalIgnoreCase)); break; case JqGridSearchOperators.Bn: namePredicate = (character => !character.Name.StartsWith(searchingValue, StringComparison.OrdinalIgnoreCase)); break; case JqGridSearchOperators.Ew: namePredicate = (character => character.Name.EndsWith(searchingValue, StringComparison.OrdinalIgnoreCase)); break; case JqGridSearchOperators.En: namePredicate = (character => !character.Name.EndsWith(searchingValue, StringComparison.OrdinalIgnoreCase)); break; case JqGridSearchOperators.Cn: namePredicate = (character => character.Name.IndexOf(searchingValue, StringComparison.OrdinalIgnoreCase) >= 0); break; case JqGridSearchOperators.Nc: namePredicate = (character => character.Name.IndexOf(searchingValue, StringComparison.OrdinalIgnoreCase) == -1); break; } return(namePredicate); }
public string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_HUB2013A") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_HUB") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "IDValutaPlacanje") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IDValutaPokrice") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IDDrzavaPrimatelj") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IDDrzavaBanka") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PlatiteljNaziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PlatiteljAdresa") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PlatiteljSjediste") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PlatiteljRacun") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PlatiteljPozivNaBroj") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PrimateljNaziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PrimateljAdresa") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PrimateljSjediste") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PrimateljRacun") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PrimateljPozivNaBroj") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OpisPlacanje") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "SWIFT") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "BankaNaziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "BankaAdresa") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "BankaSjediste") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OpisPlacanjePlatitelj") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_ObveznicaJavnogDugaIspravak") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_ObveznicaJavnogDuga") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "RedniBroj") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Iznos") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosValuta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Aktivno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "GodinaIzvod") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "RacunIzvod") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "RacunVrIzvod") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "BrojIzvod") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "BrojIzvodSt") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IDValuta") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_MjestoGrMjestoDatum") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_MjestoGrMjesto") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Oznaka") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Naziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "NazivKr") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Kratica") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Opis") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_Izvod2012A") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "IDIzvodVerzija") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IzvadakVr") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "RedniBrojIzvadak") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "PodbrojIzvadak") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "RedniBrojGrupa") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "VrstaIzvadak") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosDuguje") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosPotrazuje") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "SaldoStaro") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "SaldoNovo") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BankaVBDI") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "BankaNaziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "BankaOIB") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "BankaBIC") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Racun") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IDValuta") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Naziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Sjediste") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "MaticniBroj") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OIB") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_Temeljnica") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_TemeljnicaVr") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Tecaj") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "SumIznosDuguje") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "SumIznosPotrazuje") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "SumIznosDugujeValuta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "SumIznosPotrazujeValuta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Saldo") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "SaldoValuta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Knjizeno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Storno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "PocetnoStanje") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ZavrsnoKnjizenje") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Naziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IDValuta") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Oznaka") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_PDV") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_PDVVr") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Stopa") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_TecajListaSt") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_TecajLista") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "BrojJedinica") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TecajSD") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TecajKD") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TecajPD") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TecajKE") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TecajPE") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IDDrzavaIz") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IDDrzavaU") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IDValutaIz") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IDValutaU") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_HUBImport") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Godina") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Mjesec") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "RBImport") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "RBDokumentUpload") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "RBPdf") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "ErrorNumber") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "ErrorSeverity") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "ErrorState") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "ErrorLine") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "DokumentUpload") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Pdf") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ImportStatus") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ErrorProcedure") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ErrorMessage") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_ObrazacIPMjesec2011A") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_ObrazacIP") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_Opcina") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Mjesec") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosIsplata") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosUplataDoprinosIz") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosDohodak") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosOsobniOdbitak") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosPorezOsnova") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosUplataPorezPrirez") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosIsplataNeto") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "SifraOpcina") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_UgovorStanOtkupObrok") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "BrojUgovor") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojAneks") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojStorno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojObrok") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Godina") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Mjesec") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "GodinaGeneriranja") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "MjesecGeneriranja") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TemeljnicaGodina") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TemeljnicaVrsta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TemeljnicaBroj") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojMoratorij") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosJednokratno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosUcesce") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosPopust") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKredit") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKreditRevalorizacija") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKamata") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKamataRevalorizacija") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKreditOstatakRevalorizacija") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKamataOstatakRevalorizacija") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosMoratorij") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosValuta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TecajObrok") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TecajUgovor") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosZateznaKamata") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosObveza") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosPlaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Placen") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "IzPreplate") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "IDValuta") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OsobaInsert") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OsobaUpdate") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_DoprinosDohodak") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_DoprinosDohodakVr") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "IDMirovinskiStup") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IDPoticanjeZaposljavanja") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Stopa") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IzBruto") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "PrvoZaposlenje") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_UgovorStanOtkupObrokPreplata") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "BrojUgovor") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Broj") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojAneks") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojStorno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojObrok") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojPreplata") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TemeljnicaGodina") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TemeljnicaBroj") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TemeljnicaVrsta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "GodinaObrokFormiranje") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "MjesecObrokFormiranje") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojObveznica") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosPreplata") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosPreplataValuta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Aktivno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "NeZateznaKamata") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "IDValuta") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OsobaInsert") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OsobaUpdate") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "IDObrazacRSmObveznikVr2005A") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IDObrazacRSmObracunVr2005A") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IDObrazacRSmOsiguranjeOsnova2005A") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_ObrazacRSmA2005A") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_ObrazacRSm") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "BrojOsiguranika") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosObracunDohodak") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosDoprinosOsnova") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosDoprinosMIO1") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosDoprinosMIO2") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosIsplataDohodak") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Identifikator") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Mjesec") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Godina") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ObveznikNaziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ObveznikAdresa") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ObveznikIdentifikacijskiBroj") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ObveznikVrsta") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "GodinaIsplataDohodak") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "MjesecIsplataDohodak") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Hash") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_Izvod2012ASt") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "IDIzvod2012ATransakcijaVr") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IDHUBNamjena2013A") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Tecaj") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosValuta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Iznos") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosDuguje") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosPotrazuje") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosDugujeValuta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosPotrazujeValuta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Racun") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Naziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Adresa") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Sjediste") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IDValuta") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PlatiteljPozivNaBroj") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PrimateljPozivNaBroj") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OpisPlacanje") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IdentifikatorTransakcijeFINA") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "IdentifikatorTransakcije") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_UgovorStanOtkupAneks") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "BrojUgovor") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojAneks") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojStorno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Godina") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Mjesec") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojObrok") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojObrokDospjelo") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TemeljnicaGodina") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TemeljnicaVrsta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TemeljnicaBroj") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "DokumentGrupa") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "DokumentVrsta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "BrojObrokOd") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosUcesce") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosUcescePlaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosUcesceNeplaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKredit") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKreditPlaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKreditNeplaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKreditRevalorizacija") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKreditRevalorizacijaPlaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKreditRevalorizacijaNeplaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKamata") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKamataPlaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKamataNeplaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKamataRevalorizacija") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKamataRevalorizacijaPlaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKamataRevalorizacijaNeplaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosJednokratno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosJednokratnoPlaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosJednokratnoNeplaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosJednokratnoValuta") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosJednokratnoValutaPlaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosJednokratnoValutaNeplaceno") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKreditObrok") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosKamataObrok") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosUkupnoObrok") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosTrosakSud") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "IznosPovrat") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "TecajDM") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "NadstojnickiAdaptiran") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "IDValuta") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OsobaInsert") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OsobaUpdate") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_UgovorStanOtkupObrokUplata") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "IDValuta") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OsobaInsert") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OsobaUpdate") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PlacanjeVrOznaka") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PlacanjeVrNaziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_DokumentVr") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "IDDokumentGr") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Obrocni") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Jednokratni") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Kupac") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Partner") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Ugovor") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Faktura") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Nalog") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Oznaka") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Naziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "NazivKr") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Kratica") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Opis") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_ObrazacRSmA2005A") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_ObrazacRSm") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Identifikator") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Mjesec") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Godina") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ObveznikNaziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ObveznikAdresa") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ObveznikIdentifikacijskiBroj") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ObveznikVrsta") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "GodinaIsplataDohodak") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "MjesecIsplataDohodak") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Hash") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_Kupac") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_UgovorStanOtkupKupac") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_UgovorStanOtkup") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Nositelj") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Oznaka") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Naziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "JMBG") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Ulica") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "KucniBroj") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "KucniBrojDodatak") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "PostanskiBroj") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OIB") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Posta") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_HUBImport") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ImportStatus") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ErrorProcedure") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "ErrorMessage") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_KontniPlanSt") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_KontniPlan") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "SaldoKonti") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ZapisDopusteno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ZapisObavezno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "SubjektDopusteno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "SubjektObavezno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ObjektDopusteno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ObjektObavezno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "DavanjeDopusteno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "DavanjeObavezno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "DugujeDopusteno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "DugujeObavezno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "PotrazujeDopusteno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "PotrazujeObavezno") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "Konto") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Naziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "NazivKr") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Kratica") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_ObrazacID1") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_Zapis") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_DohodakIsplatitelj") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "DatotekaNaziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Datoteka") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public static string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "TjedanDan") { String Vrijednost = ProvjeraDecimalFiltera(searchingValue); if (!String.IsNullOrEmpty(Vrijednost)) { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, Vrijednost)); } else { return(String.Empty); } } if (searchingName == "Oznaka") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Naziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_ObrazacIPMjesec2011A") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_ObrazacIP") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_Opcina") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "SifraOpcina") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_DatotekaIzvod2012A") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_DatotekaIzvod") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "VBDI") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "Naziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "OIB") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }
public string GetFilter(string searchingName, JqGridSearchOperators searchingOperator, string searchingValue) { string searchingOperatorString = String.Empty; switch (searchingOperator) { case JqGridSearchOperators.Eq: searchingOperatorString = "="; break; case JqGridSearchOperators.Ne: searchingOperatorString = "!="; break; case JqGridSearchOperators.Lt: searchingOperatorString = "<"; break; case JqGridSearchOperators.Le: searchingOperatorString = "<="; break; case JqGridSearchOperators.Gt: searchingOperatorString = ">"; break; case JqGridSearchOperators.Ge: searchingOperatorString = ">="; break; } if (searchingName == "ID_ShemaStPolje") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "ID_ShemaSt") { return(String.Format("{0} {1} {2}", searchingName, searchingOperatorString, searchingValue)); } if (searchingName == "TablicaShema") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "TablicaNaziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "TablicaPoljeNaziv") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } if (searchingName == "AritmetickiOperator") { switch (searchingOperator) { case JqGridSearchOperators.Bw: return(String.Format("{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Bn: return(String.Format("!{0}.StartsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Ew: return(String.Format("{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.En: return(String.Format("!{0}.EndsWith(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Cn: return(String.Format("{0}.Contains(\"{1}\")", searchingName, searchingValue)); case JqGridSearchOperators.Nc: return(String.Format("!{0}.Contains(\"{1}\")", searchingName, searchingValue)); default: return(String.Format("{0} {1} \"{2}\"", searchingName, searchingOperatorString, searchingValue)); } } return(String.Empty); }