/// <summary>
/// 执行查询的sql语句[带输入参数]
/// </summary>
/// <param name="sql"></param>
/// <param name="prams"></param>
/// <returns></returns>
public static DataSet Select(this StringBuilder sql, ParCollection prams = null)
{
using (DBDalOperate dal = new DBDalOperate())
{
return(dal.ExecSqlQuery(sql, prams));
}
}
/// <summary>
/// 执行查询的sql语句[带输入参数]
/// </summary>
/// <param name="sql"></param>
/// <param name="prams"></param>
/// <returns></returns>
public static DataSet Select(this AutoPar auto)
{
using (DBDalOperate dal = new DBDalOperate())
{
auto.End();
return(dal.ExecSqlQuery(auto.strSql, auto.pars));
}
}