public string ParseValue(string value, string dataType)
{
int gmtDateMinLen = 24;
value = FilterSql.FilterValue(value);
switch (dataType)
{
case "datetime":
//Mon Sep 01 2014 00:00:00 GMT+0800 (China Standard Time)
if (value.Length > gmtDateMinLen)
{
DateTime newDate;
if (DateTime.TryParseExact(value.Substring(0, 24), "ddd MMM dd yyyy HH:mm:ss", new CultureInfo("en-US"), DateTimeStyles.None, out newDate))
{
value = newDate.ToString("yyyy-MM-dd HH:mm:ss");
}
else if (DateTime.TryParse(value, out newDate))
{
value = newDate.ToString("yyyy-MM-dd");
}
}
break;
case "date":
//Mon Sep 01 2014 00:00:00 GMT+0800 (China Standard Time)
//Fri Jun 5 00:00:00 UTC+0800 2015
if (value.Length > gmtDateMinLen)
{
DateTime newDate;
if (DateTime.TryParseExact(value.Substring(0, 24), "ddd MMM dd yyyy HH:mm:ss", new CultureInfo("en-US"), DateTimeStyles.None, out newDate))
{
value = newDate.ToString("yyyy-MM-dd");
}
else if (DateTime.TryParse(value, out newDate))
{
value = newDate.ToString("yyyy-MM-dd");
}
}
break;
case "int":
int iVal;
if (int.TryParse(value, out iVal))
{
value = iVal + "";
}
else
{
value = "";
}
break;
case "decimal":
decimal dVal;
if (decimal.TryParse(value, out dVal))
{
value = dVal + "";
}
else
{
value = "";
}
break;
}
return(value);
}
public string Smaller(string fieldName, string value, string OrAnd = "And")
{
return(string.Format(" {2} {0} <= '{1}'", fieldName, FilterSql.FilterValue(value), OrAnd));
}
public string Like(string fieldName, string value, string OrAnd = "And")
{
return(string.Format(" {2} {0} like '%{1}%'", fieldName, FilterSql.FilterValue(value), OrAnd));
}
public string NotEqual(string fieldName, string value, string OrAnd = "And")
{
return(string.Format(" {2} {0} <> '{1}'", fieldName, FilterSql.FilterValue(value), OrAnd));
}
public string In(string fieldName, string value, string orAnd = "And")
{
return(string.Format(" {2} {0} in ('{1}')", fieldName, FilterSql.FilterValue(value).Replace(",", "','"), orAnd));
}
