/// <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); }