/// <summary>
/// ExecuteScalar执行SQL语句,返回执行结果的第一行第一列；
/// </summary>
/// <param name="con">数据库连接对象</param>
/// <param name="sqlStr">sql语句</param>
/// <param name="parameterNameValueDic">参数名名称及对应的值字典集合[key:参数名称,含参数符号;value:参数值]</param>
/// <returns>返回执行结果</returns>
protected object PrimitiveExecuteScalar(IDbConnection con, string sqlStr, Dictionary <string, object> parameterNameValueDic = null)
{
using (var cmd = DBAccessEx.CreateCommand(this._dbAccess, con, sqlStr, parameterNameValueDic))
{
return(cmd.ExecuteScalar());
}
}
/// <summary>
/// 执行SQL语句,返回查询结果
/// </summary>
/// <param name="con">数据库连接对象</param>
/// <param name="sqlStr">sql语句</param>
/// <param name="parameterNameValueDic">参数名名称及对应的值字典集合[key:参数名称,含参数符号;value:参数值]</param>
/// <returns>返回执行结果</returns>
protected DataTable PrimitiveQueryDataToDataTable(IDbConnection con, string sqlStr, Dictionary <string, object> parameterNameValueDic = null)
{
using (var cmd = DBAccessEx.CreateCommand(this._dbAccess, con, sqlStr, parameterNameValueDic))
{
var da = this._dbAccess.CreateDbDataAdapter();
da.SelectCommand = cmd;
using (DataSet ds = new DataSet())
{
da.Fill(ds);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
dt.Dispose();
return(dt);
}
}
}
return(null);
}