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