Example #1
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT pemb_id as 'PEMBIAYAAN ID',pemb_kd_bidang as 'KODE BIDANG',pemb_keterangan as 'KETERANGAN' FROM dim_pembiayaan");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatadimensi.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing
Example #2
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT fpan_tahun as 'TAHUN',fpan_id as 'KERJASAMA ID',fpan_bidang as 'KODE BIDANG',fpan_no as 'NOMOR KERJASAMA',fpan_usulan as 'NILAI USULAN (Rp.)',fpan_realisasi as 'NILAI REALISASI (Rp.)' FROM fakta_kerjasama");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatafakta.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing
Example #3
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT fcap_tahun as 'TAHUN',fcap_id as 'CAPAIAN ID',fcap_kd_bidang as 'KODE BIDANG',fcap_kd_prog as 'KODE PROGRAM',fcap_target as 'TARGET ANGKA',fcap_satuan as 'SATUAN' FROM fakta_capaian");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatafakta.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing
Example #4
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT wkt_id as 'ID WAKTU', wkt_detail as 'TAHUN' FROM dim_waktu");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatadimensi.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing
Example #5
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT fpaj_tahun as 'TAHUN',fpaj_id as 'PAJAK ID', fpaj_kd_keg as 'KODE KEGIATAN', fpaj_nilai as 'NILAI PAJAK' FROM fakta_pajak");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatafakta.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing
Example #6
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT panj_id as 'PANJAR ID',panj_no_bukt as 'NOMOR BUKTI', panj_penerima as 'PENERIMA',panj_kd_bidang as 'KODE BIDANG',panj_kd_prog as 'KODE PROGRAM',panj_kd_keg as 'KODE KEGIATAN',panj_keterangan as 'KETERANGAN PANJAR' FROM dim_panjar");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatadimensi.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing
Example #7
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT keg_id as 'KEGIATAN ID',keg_kd_keg as 'KODE KEGIATAN', keg_kd_bidang as 'KODE BIDANG',keg_kd_prog as 'KODE PROGRAM', keg_uraian as 'URAIAN KEGIATAN' FROM dim_kegiatan");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatadimensi.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing
Example #8
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT kont_id as 'KONTRAK ID',kont_spp as 'KODE SPP',kont_nomor as 'NOMOR KONTRAK',kont_nama as 'NAMA PERUSAHAAN',kont_bentuk as 'BENTUK PERUSAHAAN',kont_alamat as 'ALAMAT',kont_pimpinan as 'NAMA PIMPINAN PERUSAHAAN',kont_keperlian as 'KEPERLUAN KERJASAMA' FROM dim_kontrak");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatadimensi.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing
Example #9
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT fper_id_unit as 'UNIT ID',fper_id_subunit as 'SUB UNIT ID',fper_nama as 'NAMA',fper_angg as 'PENGGUNAAN ANGGARAN (Rp.)' FROM fakta_perangkat");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatafakta.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing
Example #10
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT subu_id as 'SUB UNIT ID',subu_kd_unit as 'KODE UNIT', subu_nama as 'NAMA',subu_nip as 'NIP',subu_jabatan as 'JABATAN' FROM dim_subunit");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatadimensi.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing
Example #11
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT log_id as 'NOMOR ID',username as 'USERNAME',keterangan as 'LEVEL USER',tingkat as 'JABATAN PENGGUNA' FROM logon");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatauser.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing
Example #12
0
        private void ListData()
        {
            DataTable dt = new DataTable();


            Koneksi koneksi = new Koneksi();
            dt = koneksi.tampil_data_dw("SELECT fang_tahun as 'TAHUN',fang_kd_bidang as 'KODE BIDANG',fang_pend_id as 'PENDAPATAN ID',fang_pend_satuan as 'BANYAK SATUAN',fang_pend_nilai as 'NILAI PENDAPATAN',fang_pend_total as 'TOTAL PENDAPATAN',fang_pemb_id as 'PEMBIAYAAN ID',fang_pemb_satuan as 'BANYAK SATUAN',fang_nilai as 'NILAI PEMBIAYAAN',fang_pemb_total as 'TOTAL PEMBIAYAAN' FROM fakta_anggaran");
            try
            {
                paging_PageIndex = 1;

                if (dt.Rows.Count > 0)
                {
                    DataTable tmpTable = new DataTable();

                    tmpTable = dt.Clone();

                    if (dt.Rows.Count >= paging_NoOfRecPerPage)
                    {
                        for (int i = 0; i < paging_NoOfRecPerPage; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }
                    else
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            tmpTable.ImportRow(dt.Rows[i]);
                        }
                    }

                    listDatafakta.DataContext = tmpTable.DefaultView;
                    tmpTable.Dispose();
                    dt_TempData = dt;
                }
                else
                {
                    // MessageBox.Show("Message");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Message" + ex);
            }
        } //void closing