public static string Collection(SqlCollectionType type, params string[] sqls)
{
switch (type)
{
case SqlCollectionType.None:
case SqlCollectionType.Union:
default:
return(Union(sqls));
case SqlCollectionType.UnionAll:
return(UnionAll(sqls));
case SqlCollectionType.Except:
return(Except(sqls));
case SqlCollectionType.Intersect:
return(Intersect(sqls));
}
}
public static string Collection(SqlCollectionType type, string source_table, string source_sql, params string[] tables)
{
switch (type)
{
case SqlCollectionType.Union:
return(TableUnion(source_table, source_sql, tables));
case SqlCollectionType.UnionAll:
return(TableUnionAll(source_table, source_sql, tables));
case SqlCollectionType.Except:
return(TableExcept(source_table, source_sql, tables));
case SqlCollectionType.Intersect:
return(TableIntersect(source_table, source_sql, tables));
case SqlCollectionType.None:
default:
return(source_sql);
}
}
public override void AddInputParameter(string parameterName, object parameterValue, SqlCollectionType collectionType = SqlCollectionType.None, DbType type = DbType.AnsiString)
{
SqlParameter parameter = new SqlParameter();
parameter.ParameterName = FormatForSql(parameterName);
parameter.Value = parameterValue;
if (collectionType != SqlCollectionType.None)
{
parameter.TypeName = collectionType.ToString();
parameter.SqlDbType = SqlDbType.Structured;
}
Cmd.Parameters.Add(parameter);
}
public abstract void AddInputParameter(string parameterName, object parameterValue, SqlCollectionType collectionType = SqlCollectionType.None, DbType type = DbType.AnsiString);
public override void AddInputParameter(string parameterName, object parameterValue, SqlCollectionType collectionType = SqlCollectionType.None, DbType dbType = DbType.AnsiString)
{
throw new NotImplementedException();
}
public override void AddInputParameter(string parameterName, object parameterValue, SqlCollectionType collectionType = SqlCollectionType.None, DbType type = DbType.AnsiString)
{
currentInputParameters.Add(parameterName, parameterValue);
}
