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