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 btnPrintStock_Click(object sender, EventArgs e) { 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.pvcTypeName"); 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, true); // soalnya blanknya nutupin stock } else { MessageBox.Show("DATA TIDAK ADA (LAPORAN HARIAN DI CLOSING FORM PVC)"); } } }