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