Example #1
0
        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)");
                }
            }
        }
Example #2
0
        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)");
                }
            }
        }