public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
PrintingSalesInvoice rpt = new PrintingSalesInvoice();
rpt.Site = this.Site;
return(rpt);
}
private void btnPrintInvoice_Click(object sender, EventArgs e)
{
DataTable dt = main.ExecuteQuery("SELECT psh.printingSalesID, salesTime, "
+ "parentCompanyName, companyName, customerName, "
+ "tempo, purchaseOrderID as noPO, psd.printingType, psd.printingTitle, "
+ "jobType, CONCAT(quantity, ' ', quantityType) as quantity, "
+ "CONCAT(material, '; ', imageSize, '; ', sidePrint, '; ', psd.description) as description, "
+ "hargaMaterial, hargaOngkosCetak "
+ "FROM PrintingSalesHeader psh "
+ "LEFT JOIN PrintingSalesDetail psd ON psh.printingSalesID = psd.printingSalesID "
+ "LEFT JOIN MsCustomer cu ON cu.customerID = psh.customerID "
+ "LEFT JOIN MsCompany co ON co.companyID = cu.companyID "
+ "LEFT JOIN MsParentCompany pc ON co.parentCompanyID = pc.parentCompanyID "
+ "WHERE psh.printingSalesID = '" + salesID + "'");
DataTable dtSub = main.ExecuteQuery("SELECT * FROM PrintingSalesPayment WHERE printingSalesID = '" + salesID + "'");
DataTable dtSub2 = main.ExecuteQuery("SELECT printingSalesID, printingType, printingTitle, finishingType, detail as descriptionFinishing FROM PrintingSalesDetailFinishing WHERE printingSalesID = '" + salesID + "'");
if (dt == null)
{
MessageBox.Show("ERROR PRINT REPORT (LAPORAN HARIAN DI CLOSING FORM STATIONERY)");
this.Dispose();
}
else
{
if (dt.Rows.Count > 0)
{
Rahayu_Program.Report.PrintingSales.PrintingSalesInvoice laporan = new Rahayu_Program.Report.PrintingSales.PrintingSalesInvoice();
laporan.SetDataSource(dt);
laporan.SetParameterValue("SubjekPPH", rbPPh21.Checked ? "Subjek PPh 21" : "Subjek PPh 23");
laporan.Subreports["PrintingSalesSubReportPayment.rpt"].DataSourceConnections.Clear();
if (dtSub.Rows.Count > 0)
{
laporan.Subreports["PrintingSalesSubReportPayment.rpt"].SetDataSource(dtSub);
}
laporan.Subreports["PrintingSalesSubReportFinishing.rpt"].DataSourceConnections.Clear();
if (dtSub2.Rows.Count > 0)
{
laporan.Subreports["PrintingSalesSubReportFinishing.rpt"].SetDataSource(dtSub2);
}
buatLaporanByQuery(laporan, rbPPh21.Checked ? "Subjek PPh 21" : "Subjek PPh 23");
//direct print
/*laporan.PrintOptions.PrinterName = System.IO.File.ReadAllText(Application.StartupPath + @"\config\printer\printing-sales-notasetengah.is");
* laporan.PrintToPrinter(1, false, 0, 0);*/
}
else
{
MessageBox.Show("DATA TIDAK ADA (LAPORAN HARIAN DI CLOSING FORM STATIONERY)");
}
}
}
