Exemple #1
0
        private void Header()
        {
            System.Text.StringBuilder x = new System.Text.StringBuilder();

            Rpt.Judul(x, comp, judul);

            DateTime Dari   = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
            DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");


            Rpt.SubJudul(x
                         , Tanggal2 + " : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai)
                         );

            Rpt.SubJudul(
                x, "Status SP3K : " + StatusSPK.Replace("-", " ")
                );

            Rpt.SubJudul(
                x, "Hasil SP3K : " + HasilSPK.Replace("-", " ")
                );

            Rpt.SubJudul(
                x, "Project : " + Project
                );

            Rpt.SubJudul(
                x, "Perusahaan : " + Perusahaan
                );

            if (Rekening == "SEMUA")
            {
                Rpt.SubJudul(x, "Rekening Bank: SEMUA");
            }
            else
            {
                Rpt.SubJudul(x, "Rekening Bank: " + Rekening);
            }

            //Rpt.Header(rpt, x);
            Rpt.HeaderReport(headReport, "", x);
        }
Exemple #2
0
        private void Fill()
        {
            //string w = "";
            string nLokasi = "";

            if (Lokasi != "SEMUA")
            {
                nLokasi += " AND a.Lokasi = '" + Lokasi + "'";
            }

            string tgl = "";

            if (Tanggal2 == "TargetSP3K")
            {
                tgl = "TargetSP3K";
            }
            else if (Tanggal2 == "TglPengajuanSP3K")
            {
                tgl = "TglPengajuanSP3K";
            }
            else if (Tanggal2 == "TglHasilSP3K")
            {
                tgl = "TglHasilSP3K";
            }

            DateTime Dari   = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
            DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");


            string Status = "";

            if (StatusSPK != "SEMUA")
            {
                if (StatusSPK == "BELUM DITENTUKAN")
                {
                    Status = " AND StatusSP3K = ''";
                }
                else
                {
                    Status = " AND StatusSP3K = '" + StatusSPK.Replace("-", " ") + "'";
                }
            }

            string Hasil = "";

            if (HasilSPK != "SEMUA")
            {
                Hasil = " AND HasilSP3K = '" + HasilSPK.Replace("-", " ") + "'";
            }

            string Tanggal = "";

            Tanggal = " AND CONVERT(varchar," + tgl + ",112) >= '" + Cf.Tgl112(Dari) + "'"
                      + " AND CONVERT(varchar," + tgl + ",112) <= '" + Cf.Tgl112(Sampai) + "'";


            string BankKPR = "";

            if (Rekening != "SEMUA")
            {
                BankKPR = " AND BankKPR = '" + Rekening + "'";
            }

            string nProject = "";

            if (Project != "SEMUA")
            {
                nProject = " AND a.Project IN ('" + Project.Replace(",", "','") + "')";
            }

            string nPerusahaan = "";

            if (Perusahaan != "SEMUA")
            {
                nPerusahaan = " AND a.Pers = '" + Perusahaan + "'";
            }

            string aa = "";

            if (UserAgent() > 0)
            {
                aa = " AND a.NoAgent = " + UserAgent();
            }


            string strSql = "SELECT a.*, b.Nama AS NamaCustomer, d.LuasSG"
                            + " FROM MS_KONTRAK a"
                            + " INNER JOIN MS_CUSTOMER b ON a.NoCustomer = b.NoCustomer"
                            + " INNER JOIN MS_UNIT d ON a.NoUnit = d.NoUnit "
                            + " WHERE a.Status = 'A'"
                            + nPerusahaan
                            + nProject
                            + nLokasi
                            + Tanggal
                            + Status
                            + Hasil
                            + BankKPR
                            + aa
            ;
            DataTable rs = Db.Rs(strSql);

            decimal t = 0, PotensiKPR = 0;

            for (int i = 0; i < rs.Rows.Count; i++)
            {
                if (!Response.IsClientConnected)
                {
                    break;
                }

                TableRow r = new TableRow();
                r.Attributes["ondblclick"] = "popEditProsesKPR('" + Cf.Pk(rs.Rows[i]["NoKontrak"]) + "');";
                TableCell c;

                c                 = new TableCell();
                c.Text            = (i + 1).ToString();
                c.HorizontalAlign = HorizontalAlign.Center;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = rs.Rows[i]["NoKontrak"].ToString();
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = rs.Rows[i]["NamaCustomer"].ToString();
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = rs.Rows[i]["NoUnit"].ToString();
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = Cf.Num(rs.Rows[i]["LuasSG"]);
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = rs.Rows[i]["BankKPR"].ToString();
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = rs.Rows[i]["StatusSP3K"].ToString();
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = Cf.Day(rs.Rows[i]["TargetSP3K"]);
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = Cf.Day(rs.Rows[i]["TglPengajuanSP3K"]);
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = Cf.Day(rs.Rows[i]["TglHasilSP3K"]);
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = rs.Rows[i]["NoSP3K"].ToString();
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = rs.Rows[i]["HasilSP3K"].ToString();
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);

                c                 = new TableCell();
                c.Text            = Db.SingleString("SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..REF_PROJECT WHERE Project = '" + rs.Rows[i]["Project"].ToString() + "'");
                c.HorizontalAlign = HorizontalAlign.Left;
                c.VerticalAlign   = VerticalAlign.Top;
                r.Cells.Add(c);
                c                 = new TableCell();
                PotensiKPR        = Convert.ToDecimal(rs.Rows[i]["ApprovalKPR"]);
                c.Text            = Cf.Num(PotensiKPR);
                c.HorizontalAlign = HorizontalAlign.Left;
                r.Cells.Add(c);


                //c = new TableCell();
                //PotensiKPR = Db.SingleDecimal("SELECT ISNULL(SUM(NilaiTagihan), 0) FROM MS_TAGIHAN WHERE NoKontrak = '" + rs.Rows[i]["NoKontrak"] + "' AND Tipe = 'ANG' AND (NamaTagihan LIKE '%KPR%' OR NamaTagihan LIKE '%AKAD%')");
                //c.Text = Cf.Num(PotensiKPR);
                //c.HorizontalAlign = HorizontalAlign.Right;
                //r.Cells.Add(c);

                rpt.Rows.Add(r);

                t += PotensiKPR;

                if (i == (rs.Rows.Count - 1))
                {
                    SubTotal(t);
                }
            }
        }