public ReportItem_M(IReportItem_M rep)
{
_isNew = false;
_idReport = rep.IdReport;
_type = rep.Type;
_idTable = rep.IdTable;
}
public void OpenReport(IReportItem_M report, IFilterTable filter)
{
var reportVM = new Report_VM((report as ReportItem_M), filter);
switch (report.Type)
{
case enTypeReport.Table:
case enTypeReport.Object:
{
var ti = Program.app.getTableInfo((int)report.IdTable);
var tm = new TableModel_M(ti, report.Type);
tm.Filter = filter;
reportVM.Reports.Add(tm);
} break;
case enTypeReport.All:
{
foreach (var item in Program.app.tables_info)
{
var tm = new TableModel_M(item, enTypeReport.All);
reportVM.Reports.Add(tm);
}
} break;
}
reportVM.OpenReport();
}
public bool FindNameMatch(IReportItem_M report)
{
return(_reports
.Any(f =>
f.Caption == report.Caption &&
f.IdReport != report.IdReport &&
f.Type == report.Type &&
(report.Type == enTypeReport.All ||
report.IdTable == null ||
report.IdTable == f.IdTable)));
}
public void Delete(IReportItem_M report)
{
using (var sqlCmd = new SqlWork())
{
sqlCmd.sql = @"
DELETE FROM
sys_scheme.report_templates
WHERE
id = :id;";
sqlCmd.AddParam(":id", report.IdReport, DbType.Int32);
sqlCmd.ExecuteNonQuery();
}
Reload();
}
public void OpenDesignTable(IReportItem_M report, IFilterTable filter)
{
if (report.Type != enTypeReport.Table)
{
throw new Exception(Resources.Report_M_ErrorDesign);
}
var reportVM = new Report_VM((report as ReportItem_M), filter);
var ti = Program.app.getTableInfo((int)report.IdTable);
var tm = new TableModel_M(ti, enTypeReport.Table);
tm.Filter = filter;
reportVM.Reports.Add(tm);
reportVM.OpenDesign();
}
