private void btDesignIEnumerable_Click(object sender, RoutedEventArgs e)
{
StiReport report = new StiReport();
report.RegData("EmployeeIEnumerable", CreateBusinessObjectsIEnumerable.GetEmployees());
report.Load("..\\BusinessObjects_IEnumerable.mrt");
report.DesignWithWpf();
}
private void btDesignITypedList_Click(object sender, RoutedEventArgs e)
{
StiReport report = new StiReport();
report.RegData("EmployeeITypedList", CreateBusinessObjectsITypedList.GetEmployees());
report.Load("..\\BusinessObjects_ITypedList.mrt");
report.DesignWithWpf();
}
private void btnrelPEPS_Click(object sender, RoutedEventArgs e)
{
MySqlCommand lerPEPS = new MySqlCommand("Select * from produto inner join venda on produto.ProNom = venda.VenPro" +
" inner join saldo on produto.ProNom = saldo.SalProd order by produto.ProDat", conexao.con);
conexao.abrir();
using (MySqlDataReader leitorPEPS = lerPEPS.ExecuteReader())
{
while (leitorPEPS.Read())
{
Saldo saldo = new Saldo();
saldo.dataVen = (DateTime)leitorPEPS["VenDat"];
saldo.VenDat = saldo.dataVen.ToShortDateString();
saldo.VenPro = leitorPEPS["VenPro"].ToString();
saldo.VenQtd = (Int32)leitorPEPS["VenQtd"];
saldo.VenVto = (Decimal)leitorPEPS["VenVto"];
saldo.VenVun = (Decimal)leitorPEPS["VenVun"];
saldo.SalQtd = Convert.ToInt32(leitorPEPS["SalQtd"]);
saldo.SalVun = (Decimal)leitorPEPS["SalVun"];
saldo.SalVto = (Decimal)leitorPEPS["SalVto"];
saldo.salProd = leitorPEPS["SalProd"].ToString();
saldo.dataSal = (DateTime)leitorPEPS["SalDat"];
saldo.SalDat = saldo.dataSal.ToShortDateString();
saldo.ProQtd = Convert.ToInt32(leitorPEPS["ProQtd"]);
saldo.dataPro = (DateTime)leitorPEPS["ProDat"];
saldo.ProDat = saldo.dataPro.ToShortDateString();
saldo.ProNom = leitorPEPS["ProNom"].ToString();
saldo.ProVun = (Decimal)leitorPEPS["ProPco"];
saldo.ProVto = (Decimal)leitorPEPS["ProPcoTot"];
saldo.ProFre = (Decimal)leitorPEPS["ProFre"];
saldo.ProIcms = (Decimal)leitorPEPS["ProIcms"];
lista.Add(saldo);
}
leitorPEPS.Close();
}
conexao.fechar();
StiReport relatorio = new StiReport();
relatorio.RegData("saldo", lista);
relatorio.DesignWithWpf();
}
internal static void ShowReport(StiReport report, bool wpf, bool design, DataSet dtSet,
string vrReportAutor, string vrReportDescricao, string vrEmpresa, string vrCnc,
string vrTitulo, string vrUsuario, string vrFiltros, string vrImage)
{
report.ReportAuthor = vrReportAutor;
report.ReportDescription = vrReportDescricao;
if (vrImage == null || vrImage == "")
report.Dictionary.Variables["vrEmpresa"].ValueObject = vrEmpresa;
else
{
if (System.IO.File.Exists(vrImage))
{
report.Dictionary.Variables["vrEmpresa"].ValueObject = sEspacos + vrEmpresa;
StiImage stiImage = report.GetComponents()["imgLogo"] as StiImage;
Image myImage = Image.FromFile(vrImage);
stiImage.Image = myImage;
}
}
report.Dictionary.Variables["vrCnc"].ValueObject = vrCnc;
report.Dictionary.Variables["vrTitulo"].ValueObject = vrTitulo;
report.Dictionary.Variables["vrUsuario"].ValueObject = vrUsuario;
report.Dictionary.Variables["vrFiltros"].ValueObject = vrFiltros;
report.RegData(dtSet);
report.Compile();
if (design)
{
if (wpf)
report.DesignWithWpf();
else
report.Design();
}
else
{
if (wpf)
report.ShowWithWpf();
else
report.Show();
}
}
private void buttonDesign_Click(object sender, RoutedEventArgs e)
{
stiReport1.Load("..\\Work with Components.mrt");
stiReport1.DesignWithWpf();
}
private void Design_Click(object sender, RoutedEventArgs e)
{
stiReport1.Load("..\\..\\Variaveis.mrt");
stiReport1.DesignWithWpf();
}
private void btDesign_Click(object sender, RoutedEventArgs e)
{
report.DesignWithWpf();
}
private void buttonRunDesigner_Click(object sender, RoutedEventArgs e)
{
StiReport report = new StiReport();
report.DesignWithWpf();
}
private void buttonDesign_Click(object sender, RoutedEventArgs e)
{
stiReport1.DesignWithWpf();
stiReport1.Compile();
}
