/// <summary>
/// 获取标准字段SQL字符串
/// </summary>
/// <param name="tp"></param>
/// <param name="multiTable"></param>
/// <returns></returns>
public string ToSqlString(DatabaseTypes tp, bool multiTable = false)
{
string left = _left.IsComplicated ? $"({_left.ToSqlString(tp, multiTable)})" : _left.ToSqlString(tp, multiTable);
string right = _right.IsComplicated ? $"({_right.ToSqlString(tp, multiTable)})" : _right.ToSqlString(tp, multiTable);
return($"{left} {_operator} {right}");
}
/// <summary>
/// 获取标准字段SQL字符串
/// </summary>
/// <param name="tp"></param>
/// <param name="multiTable"></param>
/// <returns></returns>
public string ToSqlString(DatabaseTypes tp, bool multiTable = false)
{
string name = "";
switch (tp)
{
case DatabaseTypes.Microsoft_Office_Access:
case DatabaseTypes.Microsoft_Office_Access_v12:
case DatabaseTypes.Microsoft_SQL_Server:
case DatabaseTypes.SQLite:
case DatabaseTypes.SQLite_3:
name = $"[{_name}]";
break;
case DatabaseTypes.MySQL:
name = $"`{_name}`";
break;
case DatabaseTypes.PostgreSQL:
name = $"\"{_name}\"";
break;
default:
throw new Exception($"尚未支持 {tp.ToString()} 类型数据库");
}
return($"{_object.ToSqlString(tp, multiTable)} AS {name}");
}
/// <summary>
///
/// </summary>
/// <param name="tp"></param>
/// <param name="multiTable"></param>
/// <returns></returns>
public string ToSqlString(DatabaseTypes tp, bool multiTable = false)
{
return($"{this.Name}({_object.ToSqlString(tp, multiTable)})");
}
/// <summary>
/// 获取标准字段SQL字符串
/// </summary>
/// <param name="tp"></param>
/// <param name="multiTable"></param>
/// <returns></returns>
public string ToSqlString(DatabaseTypes tp, bool multiTable = false)
{
return($"{_object.ToSqlString(tp, multiTable)} {_sort}");
}
