/// <summary>
/// 执行SQL查询，返回记录集
/// </summary>
/// <param name="sql">SQL语句</param>
/// <param name="tableNames">所依赖的表的表名</param>
/// <returns></returns>
public DataSet Select(String sql, String[] tableNames)
{
String cacheKey = sql + "_" + ConnName;
if (EnableCache && XCache.Contain(cacheKey))
{
return(XCache.Item(cacheKey));
}
DataSet ds = DB.Query(sql);
if (EnableCache)
{
XCache.Add(cacheKey, ds, tableNames);
}
return(ds);
}
/// <summary>
/// 执行CMD，返回记录集
/// </summary>
/// <param name="cmd">CMD</param>
/// <param name="tableNames">所依赖的表的表名</param>
/// <returns></returns>
public DataSet Select(DbCommand cmd, String[] tableNames)
{
String cacheKey = cmd.CommandText + "_" + ConnName;
if (EnableCache && XCache.Contain(cacheKey))
{
return(XCache.Item(cacheKey));
}
DataSet ds = DB.Query(cmd);
if (EnableCache)
{
XCache.Add(cacheKey, ds, tableNames);
}
DB.AutoClose();
return(ds);
}
