/// <summary> /// /// </summary> /// <param name="sql"></param> /// <param name="parameterValues"></param> /// <param name="pagination"></param> /// <returns></returns> public override DataTable ExecutePaginationTable(SqlWrap sql, IDictionary <string, object> parameterValues, Pagination pagination) { ArgumentAssertion.IsNotNull(sql, "sql"); ArgumentAssertion.IsNotNull(pagination, "pagination"); Stopwatch stopwatch = null; var sqlProcessor = ObjectIOCFactory.GetSingleton <DataSettings>().SqlProcessor; if (sqlProcessor.EnableTrace) { stopwatch = Stopwatch.StartNew(); } var sqlText = GetPaginationSql(sql, pagination); sqlText = this.TransformSql(sqlText, parameterValues); var dataSet = MySqlHelper.ExecuteDataSet(this.ConnectionString, sqlText, sql.CommandTimeout, ConvertToDbParams(parameterValues)); var totalCount = dataSet.Tables[0].Rows[0][0].Convert <int>(); pagination.TotalCount = totalCount; if (sqlProcessor.EnableTrace) { stopwatch.Stop(); sqlProcessor.Log(LogLevel.Trace, string.Format("[{0}]ExecuteSql({1})\r\n\t{2}", stopwatch.Elapsed, sql.FullName, sqlText), null); } return(dataSet.Tables[1]); }
/// <summary> /// /// </summary> /// <param name="sql"></param> /// <param name="parameterValues"></param> /// <returns></returns> public override DataSet ExecuteDataSet(SqlWrap sql, IDictionary <string, object> parameterValues) { ArgumentAssertion.IsNotNull(sql, "sql"); Stopwatch stopwatch = null; var sqlProcessor = ObjectIOCFactory.GetSingleton <DataSettings>().SqlProcessor; if (sqlProcessor.EnableTrace) { stopwatch = Stopwatch.StartNew(); } var sqlText = this.TransformSql(sql.SqlText, parameterValues); var result = MySqlHelper.ExecuteDataSet(this.ConnectionString, sqlText, sql.CommandTimeout, ConvertToDbParams(parameterValues)); if (sqlProcessor.EnableTrace) { stopwatch.Stop(); sqlProcessor.Log(LogLevel.Trace, string.Format("[{0}]ExecuteSql({1})\r\n\t{2}", stopwatch.Elapsed, sql.FullName, sqlText), null); } return(result); }