/// <summary> /// 记录sql /// </summary> /// <param name="customerTraceInfo"></param> private static void OnCustomerTraceConnection(CustomerTraceInfo customerTraceInfo) { try { string sql = Environment.NewLine + "#####################################################" + Environment.NewLine + customerTraceInfo.SqlText; try { sql = customerTraceInfo.CustomerParams.Aggregate(customerTraceInfo.SqlText, (current, item) => current.Replace(item.Key, item.Value.Value.ToString())); } catch (Exception) { //ignore } sql += Environment.NewLine; foreach (var detail in customerTraceInfo.RunTimeList) { var sencond = (int)detail.Duration.TotalSeconds; var time = sencond + "秒"; if (sencond < 1) { time = detail.Duration.TotalMilliseconds + "豪秒"; } sql += $"Server:{detail.Server},DB名称:{detail.DbName}, 执行时间:{time}" + Environment.NewLine + "#####################################################" + Environment.NewLine; LogHelper.Info("SQL:", sql); } } catch (Exception) { //ignore } }
private static void OnCustomerTraceConnection(CustomerTraceInfo customerTraceInfo) { try { string sql = customerTraceInfo.CustomerParams.Aggregate(customerTraceInfo.SqlText, (current, item) => current.Replace(item.Key, item.Value.Value.ToString())); Debug.Write(sql + Environment.NewLine); } catch (Exception) { //ignore } }
/// <summary> /// 显示sql /// </summary> /// <param name="customerTraceInfo"></param> protected void OnCustomerTraceConnection(CustomerTraceInfo customerTraceInfo) { try { string sql = customerTraceInfo.CustomerParams.Aggregate(customerTraceInfo.SqlText, (current, item) => current.Replace(item.Key, item.Value.Value.ToString())); Trace.Write(sql); } catch (Exception) { //ignore } }
private static void OnCustomerTraceConnection(CustomerTraceInfo customerTraceInfo) { try { string sql = customerTraceInfo.CustomerParams.Aggregate(customerTraceInfo.SqlText, (current, item) => current.Replace(item.Key, item.Value.Value.ToString())); Debug.Write(sql + Environment.NewLine); foreach (var detail in customerTraceInfo.RunTimeList) { Debug.Write($"Server:{detail.Server},DB名称:{detail.DbName}, 执行时间:{detail.Duration.TotalSeconds}秒"); Debug.Write(Environment.NewLine); } } catch (Exception) { //ignore } }
private static void OnLogTrace(CustomerTraceInfo obj) { }