/// <param name="union">条件语句中的unoin关键字 比如 OR 或 AND</param>
public void Delete(SQLField[] fields, SQLUnion union, SQLOperation operation = SQLOperation.EQUAL)
{
if (fields == null)
{
return;
}
SQLStatement statement = new SQLStatement(GetTableName());
statement.AddConditions(operation, union, fields);
Delete(statement);
}
/// <returns>返回多条查询结果 每条结果包含多个字段的值</returns>
/// <param name="fieldNames">要查询的字段名</param>
/// <param name="union">条件语句中的unoin关键字 比如 OR 或 AND</param>
/// <param name="operation">条件语句中的操作符 比如 = 或 like</param>
/// <param name="conditionFields">条件字段</param>
public List <SQLField[]> Query(string[] fieldNames, SQLUnion union, SQLOperation operation, params SQLField[] conditionFields)
{
if (fieldNames == null || fieldNames.Length <= 0)
{
return(null);
}
SQLStatement statement = new SQLStatement(GetTableName());
statement.SelectFields(fieldNames);
if (!IsCountAndValueEmpty(conditionFields))
{
statement.AddConditions(operation, union, conditionFields);
}
return(Query(statement));
}
