///<summary> /// 删除数据 ///</summary> ///<param name = "tableName">表名称</param> ///<param name = "query">查询组</param> public void DeleteFromTable(string tableName, QueryGroupCondition query) { var queryGroup = new QueryGroupConditionCollections { query }; //return DeleteFromTable(tableName, queryGroup); }
///<summary> /// 更新数据 ///</summary> ///<param name = "tableName">表名称</param> ///<param name = "updateFields">更新字段</param> ///<param name = "query">查询组</param> public void UpdateTable(string tableName, UpdateFieldConditionCollections updateFields, QueryGroupCondition query) { var queryGroup = new QueryGroupConditionCollections { query }; //return UpdateTable(tableName, updateFields, queryGroup); }
///<summary> /// 获取表数据 ///</summary> ///<param name = "tableName">表名称</param> ///<param name = "query">单组查询</param> ///<returns>DataTable</returns> public DataTable SelectFromTable(string tableName, QueryGroupCondition query) { return SelectFromTable(tableName, query, null, null); }
///<summary> /// 获取表数据 ///</summary> ///<param name = "tableName">表名称</param> ///<param name = "query">单组查询</param> ///<param name = "orderBy">排序</param> ///<returns>DataTable</returns> public DataTable SelectFromTable(string tableName, QueryGroupCondition query, OrderCollections orderBy) { return SelectFromTable(tableName, query, orderBy, null); }
/// <summary> /// 获取表数据 /// </summary> /// <param name="tableName">表名称</param> /// <param name="query">单组查询</param> /// <param name="pagination">分页结构</param> /// <returns> /// DataTable /// </returns> public DataTable SelectFromTable(string tableName, QueryGroupCondition query, Pagination pagination) { return SelectFromTable(tableName, query, null, pagination); }
/// <summary> /// 获取表数据 /// </summary> /// <param name="tableName">表名称</param> /// <param name="query">单组查询</param> /// <param name="orderBy">排序</param> /// <param name="pagination">分页结构</param> /// <returns> /// DataTable /// </returns> public DataTable SelectFromTable(string tableName, QueryGroupCondition query, OrderCollections orderBy, Pagination pagination) { var queryGroup = new QueryGroupConditionCollections { query }; return SelectFromTable(tableName, queryGroup, orderBy, pagination); }