private static String BuildSql(String leftPart, object rightPart, CommonEnumerators.FilterOperate operate)
{
String format = " [{0}] {1} {2} ";
String str2 = CommonEnumerators.GetOperate(operate);
switch (rightPart.GetType().FullName)
{
case "System.String":
{
String str3 = rightPart.ToString().Replace("'", "").Replace("%", "").Trim();
if (operate == CommonEnumerators.FilterOperate.StartWith)
{
return(String.Format(format, leftPart, str2, String.Format("'{0}%'", str3)));
}
if (operate == CommonEnumerators.FilterOperate.EndWith)
{
return(String.Format(format, leftPart, str2, String.Format("'%{0}'", str3)));
}
if ((operate == CommonEnumerators.FilterOperate.Contains) || (operate == CommonEnumerators.FilterOperate.NotContains))
{
return(String.Format(format, leftPart, str2, String.Format("'%{0}%'", str3)));
}
if ((operate == CommonEnumerators.FilterOperate.GtIndicator) || (operate == CommonEnumerators.FilterOperate.LtIndicator))
{
return(String.Format(format, leftPart, str2, String.Format("[{0}]", rightPart)));
}
return(String.Format(format, leftPart, str2, String.Format("'{0}'", str3)));
}
case "System.DateTime":
{
DateTime time = Convert.ToDateTime(rightPart);
return(String.Format(format, leftPart, str2, String.Format("'{0}'", time.ToString("yyyy-MM-dd"))));
}
}
return(String.Format(format, leftPart, str2, rightPart));
}
public FilterEntity(object leftPart, object rightPart, CommonEnumerators.FilterOperate operate)
{
this.LeftPart = leftPart;
this.RightPart = rightPart;
this.Operate = operate;
}
