private void frmLog_Load(object sender, EventArgs e) { try { Setup(); txtLog.ConfigurationManager.Language = "mssql"; txtLog.ConfigurationManager.Configure(); //txtLog.Text = string.Empty; //var filePath = @"C:\Temp\DB Tool\"; //var fileName = DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + ".txt"; //if (!Directory.Exists(filePath)) //{ // Directory.CreateDirectory(filePath); //} //if (File.Exists(filePath + fileName)) //{ // txtLog.Text = File.ReadAllText(filePath + fileName); //} var data = new QueryLog.Data(); data.ConnectionId = ConnectionId; data.FromDate = DateTime.Today; var logList = QueryLog.Search(data); if (logList != null && logList.Rows.Count > 0) { foreach (DataRow dr in logList.Rows) { var dt = Convert.ToDateTime(dr["CreatedDate"]); txtLog.AppendText("--------Executed on: " + dt.ToString("MM-dd-yyyy") + " " + dt.Hour + ":" + dt.Minute + ":" + dt.Second + "-------\n"); txtLog.AppendText(Convert.ToString(dr["QueryText"]) + "\n"); txtLog.AppendText("\n"); } } } catch (Exception) { throw; } }
private void LoadSQLLog() { txtLog.ResetText(); var data = new QueryLog.Data(); data.ConnectionId = ConnectionId; data.FromDate = DateTime.Today; var logList = QueryLog.Search(data); if (logList != null && logList.Rows.Count > 0) { foreach (DataRow dr in logList.Rows) { var dt = Convert.ToDateTime(dr["CreatedDate"]); txtLog.AppendText("--------Executed on: " + dt.ToString("MM-dd-yyyy") + " " + dt.Hour + ":" + dt.Minute + ":" + dt.Second + "-------\n"); txtLog.AppendText(Convert.ToString(dr["QueryText"]) + "\n"); txtLog.AppendText("\n"); } } }
public override void Log(string expression, object value) { string log = null; if (value != null && value.GetType() != typeof(string)) { var enumerable = value as IEnumerable; if (enumerable != null) { var sb = new StringBuilder(); foreach (var item in enumerable) { if (item == null) { sb.AppendLine("(null)"); } else { sb.AppendLine(item.ToString()); } } value = sb.ToString(); } } if (value == null) { value = "(null)"; } if (value == DBNull.Value) { value = "(DBNull)"; } if (!string.IsNullOrEmpty(expression) && value != null) { log = ">> " + expression + Environment.NewLine + value.ToString(); } else { if (!string.IsNullOrEmpty(expression)) { log = ">> " + expression; } else { log = value.ToString(); } } _box.AppendText(log + Environment.NewLine + Environment.NewLine); }