private void btnRekapAkhir_Click(object sender, EventArgs e)
{
Rahayu_Program.Report.ReportForm reportForm = new Rahayu_Program.Report.ReportForm(main);
reportForm.MdiParent = main;
reportForm.WindowState = FormWindowState.Maximized;
DataTable dt = main.ExecuteQuery("SELECT pvcTypeName, mp.pvcID, pvcName, pvcPerPack, pvcTypeUnit, sellPrice, homeStock, rahayuStock FROM MsPVC mp JOIN MsPVCType mpt ON mp.pvcTypeID = mpt.pvcTypeID WHERE NOT mp.pvcTypeID = 8 AND NOT mp.pvcTypeID = 9 ORDER BY mpt.pvcTypeID");
if (dt == null)
{
MessageBox.Show("ERROR PRINT REPORT (LAPORAN HARIAN DI CLOSING FORM PVC)");
this.Dispose();
}
else
{
if (dt.Rows.Count > 0)
{
Rahayu_Program.Report.PVC.LaporanStockManual laporan = new Rahayu_Program.Report.PVC.LaporanStockManual();
laporan.SetDataSource(dt);
laporan.SummaryInfo.ReportTitle = "PVC Laporan Stock Manual";
buatLaporanByQueryStock(laporan, false); //false soalnya ga mau di tutupin
}
else
{
MessageBox.Show("DATA TIDAK ADA (LAPORAN HARIAN DI CLOSING FORM PVC)");
}
}
}
private void btnBedaRekap_Click(object sender, EventArgs e)
{
Rahayu_Program.Report.ReportForm reportForm = new Rahayu_Program.Report.ReportForm(main);
reportForm.MdiParent = main;
reportForm.WindowState = FormWindowState.Maximized;
DataTable dt = main.ExecuteQuery("SELECT DISTINCT srsh.nomorRak, srsd.barangID, mb.namaBarang, srsd.stockAsli AS stockKomputer, srsd.selisih, srsd.stockHitung FROM MsBarang mb JOIN StationeryRekapStockHeader srsh ON mb.barangID = srsd.barangID JOIN StationeryRekapStockDetail srsd ON srsh.rekapStockID = srsd.rekapStockID JOIN MsPVCType mpt WHERE NOT srsd.selisih = 0 AND srsh.rekapTime > '" + awal.ToString("yyyy-MM-dd HH:mm:ss") + "' AND srsh.rekapTime < '" + akhir.ToString("yyyy-MM-dd HH:mm:ss") + "' AND NOT mp.pvcTypeID = 8 AND NOT mp.pvcTypeID = 9 ORDER BY mpt.pvcTypeID");
if (dt == null)
{
MessageBox.Show("OPEN REPORT ERROR (PRINT REKAP STOCK INPUT STATIONERY)");
this.Dispose();
}
else
{
if (dt.Rows.Count > 0)
{
Rahayu_Program.Report.Stationery.LaporanBedaStock laporan = new Rahayu_Program.Report.Stationery.LaporanBedaStock();
laporan.SetDataSource(dt);
reportForm.GetCrystalReportViewer().ReportSource = laporan;
reportForm.GetCrystalReportViewer().Refresh();
reportForm.Show();
}
else
{
MessageBox.Show("DATA TIDAK ADA");
}
}
}