public bool Query(string tableName, SQLField field) { if (string.IsNullOrEmpty(tableName) || field == null) { return(false); } SQLStatement statement = new SQLStatement(tableName); statement.SelectFields("*").AddConditions(SQLOperation.EQUAL, SQLUnion.NONE, field); SqliteDataReader reader = Query(statement); bool hasRows = reader.HasRows; CloseReader(reader); return(hasRows); }
/// <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)); }