public void Troubleshoot_general_report()
{
Debug.Listeners.Add(new ConsoleTraceListener());
QueryCatcher.Catch("Inforoom.ReportSystem.Helpers");
uint id = 144;
var cn = "server=sql.analit.net;user=;password=;default command timeout=0;Allow user variables=true;database=usersettings";
var dataAdapter = new MySqlDataAdapter("", cn);
dataAdapter.SelectCommand.CommandText = @"
select
*
from
reports.Reports r,
reports.reporttypes rt
where
r.GeneralReportCode = ?reportcode
and rt.ReportTypeCode = r.ReportTypeCode";
dataAdapter.SelectCommand.Parameters.AddWithValue("?reportcode", id);
var res = new DataTable();
dataAdapter.Fill(res);
using (var connection = new MySqlConnection(cn)) {
connection.Open();
foreach (DataRow drGReport in res.Rows)
{
if (Convert.ToBoolean(drGReport[BaseReportColumns.colEnabled]))
{
//Создаем отчеты и добавляем их в список отчетов
var reportcode = (ulong)drGReport[BaseReportColumns.colReportCode];
Console.WriteLine("Отчет {0}", reportcode);
var prop = GeneralReport.LoadProperties(connection, reportcode);
var bs = (BaseReport)Activator.CreateInstance(
GetReportTypeByName(drGReport[BaseReportColumns.colReportClassName].ToString()),
new object[] {
connection,
prop
});
bs.Session = session.SessionFactory.OpenSession(connection);
bs.ReportCaption = "rep";
bs.Write(Path.GetFullPath("test.xls"));
}
}
}
}
public Debug()
{
layout.ActivateOptions();
Error = "";
Stack = new NotifyValue <bool>();
Sql = new NotifyValue <string>("");
SqlCount = new NotifyValue <int>();
ErrorCount = new NotifyValue <int>();
HaveErrors = ErrorCount.Select(c => c > 0).ToValue();
PresentationTraceSources.DataBindingSource.Listeners.Add(new DelegateTraceListner(m => {
ErrorCount.Value++;
Error += m + "\r\n";
}));
var catcherSql = new QueryCatcher();
catcherSql.Appender = this;
catcherSql.Start();
var repository = (Hierarchy)log4net.LogManager.GetRepository();
var logger = (Logger)repository.GetLogger("AnalitF.Net.Client");
if (logger.Level > Level.Warn)
{
logger.Level = Level.Warn;
}
logger.AddAppender(this);
var caliburncatcher = new QueryCatcher("Caliburn.Micro");
caliburncatcher.Additivity = true;
caliburncatcher.Level = Level.Warn;
caliburncatcher.Appender = this;
caliburncatcher.Start();
}
public void Setup()
{
catcher = new QueryCatcher("AnalitF.Net");
catcher.Appender = new MemoryAppender();
catcher.Start();
}
