public IDataReader ExecuteReader(WhereBuilder wb)
{
return(ExecuteReader(wb.SQLString, wb.Parameters, CommandType.Text));
}
public DataSet FillSQLDataSet(WhereBuilder wb)
{
return(FillSQLDataSet(wb.SQLString, wb.Parameters));
}
public int ExecuteNonQuery(WhereBuilder wb)
{
return(ExecuteNonQuery(wb.SQLString, wb.Parameters, CommandType.Text));
}
public object ExecuteScalar(WhereBuilder wb)
{
return(ExecuteScalar(wb.SQLString, wb.Parameters, CommandType.Text));
}
/// <summary>
/// 跟根据查询参数查询
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static DataTable QueryDataSet(IQuery query)
{
WhereBuilder wb = query.ParseSQL();
return(SelectDataSet(wb).Tables[0]);
}
public static DataSet SelectDataSet(EntityBase entity)
{
WhereBuilder wb = new WhereBuilder(entity);
return(SelectDataSet(wb));
}
public static DataSet SelectDataSet(WhereBuilder wb)
{
return(Select(wb.SQLString, wb.Parameters));
}
public static EntityCollection <T> SelectByBroker <T>(WhereBuilder wb, DataAccessBroker broker)
where T : EntityBase, new()
{
return(SelectByBroker <T>(wb.SQLString, wb.Parameters, broker));
}
/// <summary>
/// 根据WhereBuilder查询
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="wb"></param>
/// <returns></returns>
public static EntityCollection <T> Select <T>(WhereBuilder wb)
where T : EntityBase, new()
{
return(Select <T>(wb.SQLString, wb.Parameters));
}