private void Window_Loaded(object sender, RoutedEventArgs e)
{
var reportData = new ReportDataSource();
var dsStatement = new PrintAccountDetailsDataSet();
dsStatement.BeginInit();
reportData.Name = "dsStatement";
reportData.Value = dsStatement.up_PrintAccountDetails;
ReportStatement.ProcessingMode = ProcessingMode.Local;
ReportStatement.LocalReport.DataSources.Clear();
ReportStatement.LocalReport.DataSources.Add(reportData);
ReportStatement.LocalReport.ReportEmbeddedResource = "StudioAdvanced.rptAccountDetails.rdlc";
ReportStatement.LocalReport.ReportPath = @"../../Reports/rptAccountDetails.rdlc";
var printAccountDetailsTableAdapter = new up_PrintAccountDetailsTableAdapter {
ClearBeforeFill = true
};
if (Data.Instance.Connection.State == ConnectionState.Open)
{
Data.Instance.Connection.Close();
}
printAccountDetailsTableAdapter.Fill(dsStatement.up_PrintAccountDetails, FamilyID);
dsStatement.EndInit();
ReportStatement.RefreshReport();
txtEmail.Text = Data.Instance.GetFamilyEmail(FamilyID);
}
/// <summary>
/// Генерация Выписки в docx
/// </summary>
/// <param name="model">Модель для генерации выписки</param>
/// <returns></returns>
public async Task <Stream> GenerateStatement(ModelSelect model)
{
return(await Task.Factory.StartNew(() =>
{
try
{
SerializeJson serializeJson = new SerializeJson();
model = (ModelSelect)typeof(SqlSelect).GetMethod("ParameterSelect")?.Invoke(new SqlSelect(), new object[] { model });
var type = Type.GetType($"{model.ParameterProcedureWeb.ModelClassFind}, EfDatabaseAutomation");
model = (ModelSelect)typeof(SqlSelect).GetMethod("ResultSelectProcedureString")?.MakeGenericMethod(type).Invoke(new SqlSelect(), new object[] { model });
EfDatabaseAutomation.Automation.BaseLogica.SqlSelect.XsdDTOSheme.Statement statement = (EfDatabaseAutomation.Automation.BaseLogica.SqlSelect.XsdDTOSheme.Statement)serializeJson.JsonDeserializeObjectClass <EfDatabaseAutomation.Automation.BaseLogica.SqlSelect.XsdDTOSheme.Statement>(model.ResultSelectProcedureWeb);
if (statement != null)
{
ReportStatement reportStatement = new ReportStatement();
reportStatement.CreateDocument(_parameterConfig.PathSaveTemplate, statement);
return reportStatement.FileArray();
}
}
catch (Exception ex)
{
Loggers.Log4NetLogger.Error(ex);
}
return null;
}));
}
protected override void visitReportStatement(ReportStatement statement)
{
appendLabel(statement);
writer.Append(KeywordEnum.REPORT.ToString()).Append(' ');
output.writeExpression(statement.ReportExpression);
if (statement.Severity != null)
{
writer.Append(' ').Append(KeywordEnum.SEVERITY.ToString()).Append(' ');
output.writeExpression(statement.Severity);
}
writer.Append(';').NewLine();
}
public ReportStatement Get(string userLogin)
{
//search DB for user's name and surname
var reports = _context.ProjectSheets.Where(r => r.UserLogin == userLogin).ToList();
var reportStatement = new ReportStatement()
{
UserLogin = userLogin,
Name = "name",
Surname = "surname",
ProjectSheets = reports
};
return(reportStatement);
}
public IEnumerable <ReportStatement> GetReportsList()
{
var reportList = _context.ProjectSheets.ToList();
var userLogins = reportList.Select(r => r.UserLogin).Distinct();
var reportsByPeople = new List <ReportStatement>();
foreach (var login in userLogins)
{
//search DB for user's name and surname
var reportStatement = new ReportStatement()
{
UserLogin = login,
Name = "name",
Surname = "surname",
ProjectSheets = reportList.Where(r => r.UserLogin == login).OrderBy(r => r.ProjectName).ToList()
};
reportsByPeople.Add(reportStatement);
}
return(reportsByPeople);
}
public void ObserveReportStatement(VHDLCompilerInterface compiler, ReportStatement report)
{
string op = VHDLOperandGenerator.GetOperand(report.ReportExpression, compiler);
code = GenReportStatement(op);
}
