public DbTerm(string tableName, string columnName, DbSymbol dbSymbol, object value)
{
TableName = tableName;
ColumnName = columnName;
DbSymbol = dbSymbol;
Value = value;
}
public DbTerm2(string tableName, string columnName, DbSymbol dbSymbol, string tableName2, string columnName2)
{
TableName = tableName;
TableName2 = tableName2;
ColumnName = columnName;
DbSymbol = dbSymbol;
ColumnName2 = columnName2;
}
/// <summary>
/// 创建条件
/// </summary>
/// <param name="obProperty">属性</param>
/// <param name="dbSymbol">条件符号</param>
/// <param name="obProperty2">属性2</param>
/// <returns></returns>
public static ObParameterBase Create(ObProperty obProperty, DbSymbol dbSymbol, ObProperty obProperty2)
{
Type t = Assembly.Load(ASSEMBLY_STRING).GetType(CLASS_NAME);
var parameters = new object[]
{
obProperty,
dbSymbol,
obProperty2
};
return((ObParameterBase)Activator.CreateInstance(t, parameters));
}
/// <summary>
/// 创建带符号参数
/// </summary>
/// <param name="tableName">对象类型名(表名)</param>
/// <param name="columnName">属性名(字段名)</param>
/// <param name="dbSymbol">符号</param>
/// <param name="tableName2">对象类型名(表名)</param>
/// <param name="columnName2">属性名(字段名)</param>
public ObParameter(string tableName, string columnName, DbSymbol dbSymbol, string tableName2, string columnName2)
{
var dbTrem = new DbTerm2(tableName, columnName, dbSymbol, tableName2, columnName2);
Value = dbTrem;
}
/// <summary>
/// 创建带符号参数
/// </summary>
/// <param name="tableName">对象类型名(表名)</param>
/// <param name="columnName">属性名(字段名)</param>
/// <param name="dbSymbol">符号</param>
/// <param name="value">值</param>
public ObParameter(string tableName, string columnName, DbSymbol dbSymbol, object value)
{
var dbTrem = new DbTerm(tableName, columnName, dbSymbol, value);
Value = dbTrem;
}
/// <summary>
/// 创建带符号参数
/// </summary>
/// <param name="srcValue"></param>
/// <param name="dbSymbol"></param>
/// <param name="dstValue"></param>
public ObParameter(IObProperty srcValue, DbSymbol dbSymbol, object dstValue)
{
var dbTrem = new DbTerm3(srcValue, dbSymbol, dstValue);
Value = dbTrem;
}
public DbTerm3(IObProperty srcValue, DbSymbol dbSymbol, object dstValue)
{
SrcValue = srcValue;
DbSymbol = dbSymbol;
DstValue = dstValue;
}
/// <summary>
///
/// </summary>
/// <param name="symbolString"></param>
/// <param name="value"></param>
/// <param name="symbol"></param>
/// <param name="dbValue"></param>
/// <returns>0失败 1正常 2is null或is not null</returns>
private static int SymbolTryParse(string symbolString, object value, out DbSymbol symbol, out DbValue dbValue)
{
var ret = 1;
dbValue = DbValue.IsNull;
switch (symbolString)
{
case "==":
symbol = DbSymbol.Equal;
if (value == null)
{
ret = 2;
dbValue = DbValue.IsNull;
}
break;
case ">":
symbol = DbSymbol.Than;
break;
case "<":
symbol = DbSymbol.Less;
break;
case ">=":
symbol = DbSymbol.ThanEqual;
break;
case "<=":
symbol = DbSymbol.LessEqual;
break;
case "!=":
symbol = DbSymbol.NotEqual;
if (value == null)
{
ret = 2;
dbValue = DbValue.IsNotNull;
}
break;
default:
if (Enum.TryParse(symbolString, true, out symbol))
{
switch (symbol)
{
case DbSymbol.Equal:
if (value == null)
{
ret = 2;
dbValue = DbValue.IsNull;
}
break;
case DbSymbol.NotEqual:
if (value == null)
{
ret = 2;
dbValue = DbValue.IsNotNull;
}
break;
case DbSymbol.Like:
case DbSymbol.LikeLeft:
case DbSymbol.LikeRight:
if (value == null || value.ToString() == "")
{
ret = 0;
}
break;
}
}
else
{
ret = 0;
}
break;
}
return(ret);
}
