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