/// <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>
/// 查询分页信息
/// </summary>
/// <param name="con">娄所谓中连接对象</param>
/// <param name="pageSize">页大小</param>
/// <param name="sqlStr">sql语句</param>
/// <param name="parameterNameValueDic">参数名名称及对应的值字典集合[key:参数名称,含参数符号;value:参数值]</param>
/// <returns>分页信息</returns>
public DBPageInfo QueryPageInfo(IDbConnection con, long pageSize, string sqlStr, Dictionary <string, object> parameterNameValueDic = null)
{
if (pageSize < 1)
{
throw new ArgumentOutOfRangeException("页大小不能小于1", nameof(pageSize));
}
object obj = this.PrimitiveExecuteScalar(con, sqlStr, parameterNameValueDic);
long totalCount = DBAccessEx.ConvertObject <Int64>(obj);
long pageCount = totalCount / pageSize;
if (totalCount % pageSize != 0)
{
pageCount++;
}
return(new DBPageInfo(pageCount, totalCount, pageSize));
}
/// <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);
}
