protected void cmdProceed_Click(object sender, EventArgs e) { if (dtpStartDate.SelectedDate > dtpEndDate.SelectedDate) return; //RadGrid1.Rebind(); LaporanTransBKUPerMA report1 = new LaporanTransBKUPerMA(); OfficerCollection ofc = new OfficerCollection(); ofc.LoadAll(); foreach (Officer o in ofc) { if (o.Jabatan == "kaunit") { report1.ReportParameters[2].Value = o.NamaLengkap; report1.ReportParameters[4].Value = o.Nip; } else { report1.ReportParameters[3].Value = o.NamaLengkap; report1.ReportParameters[5].Value = o.Nip; } } report1.ReportParameters[0].Value = ((DateTime)dtpStartDate.SelectedDate).ToShortDateString(); report1.ReportParameters[1].Value = ((DateTime)dtpEndDate.SelectedDate).ToShortDateString(); report1.DataSource = dt; ReportViewer1.Report = report1; ReportViewer1.RefreshReport(); }
protected void preview_report(object sender, EventArgs e) { DateTime startDate = new DateTime(1990, 1, 1); DateTime endDate = DateTime.Now; TransaksiBKUQuery transBkuQ = new TransaksiBKUQuery(); SaldoAwalCollection saCol = new SaldoAwalCollection(); saCol.LoadAll(); transBkuQ.SelectAll(); transBkuQ.OrderBy(transBkuQ.TransNumber.ToString()); transBkuQ.Where(transBkuQ.TransDate >= startDate, transBkuQ.TransDate <= endDate); TransaksiBKUCollection transBkuCol = new TransaksiBKUCollection(); transBkuCol.Load(transBkuQ); if (transBkuCol.Count > 0) { dt = transBkuQ.LoadDataTable(); dt.Columns.Add("Saldo", typeof(decimal)); DataTable dtCopy = dt.Clone(); foreach (RSCM_BKU_Web.BusinessObjects.SaldoAwal sa in saCol) { //dt.Rows.Add("", null, "", "", "", "", 0, 0, false, false, true, sa.SaldoAwal); dtCopy.Rows.Add("0", null, "SALDO AWAL TOTAL", "0", "Saldo Awal Total", "", sa.SaldoAwal, 0, false, false, true, "", sa.SaldoAwal); SaldoAwal = Convert.ToDecimal((sa.SaldoAwal)); } foreach (DataColumn dc in dt.Columns) { titles += dc.ColumnName; this.Title = titles; } foreach (DataRow dr in dt.Rows) { SaldoAwal = SaldoAwal + (Convert.ToDecimal(dr["DEBIT_AMOUNT"]) - Convert.ToDecimal(dr["CREDIT_AMOUNT"])); dr["Saldo"] = SaldoAwal; dt.AcceptChanges(); dtCopy.Rows.Add(dr["TRANS_NUMBER"], dr["TRANS_DATE"], dr["DESCRIPT"], dr["KA_CODE"], dr["KA_NAME"], dr["GT_CODE"], dr["DEBIT_AMOUNT"], dr["CREDIT_AMOUNT"], dr["IS_CLOSED"], dr["ISVERIFIED"], dr["IS_ACTIVE"], dr["CEK_BG_NUMBER"], dr["Saldo"]); } RSCM_BKU_web.Report.LaporanBKU report1 = new LaporanBKU(); OfficerCollection ofc = new OfficerCollection(); ofc.LoadAll(); foreach (Officer o in ofc) { if (o.Jabatan == "kaunit") { report1.ReportParameters[2].Value = o.NamaLengkap; report1.ReportParameters[4].Value = o.Nip; } else { report1.ReportParameters[3].Value = o.NamaLengkap; report1.ReportParameters[5].Value = o.Nip; } } report1.ReportParameters[0].Value = startDate; report1.ReportParameters[1].Value = endDate; report1.ReportParameters[6].Value = SaldoAwal.ToString(); report1.ReportParameters[6].Value = string.Format("{0:N2}", SaldoAwal); report1.DataSource = dtCopy; ReportViewer1.Report = report1; ReportViewer1.Update(); } else return; }
protected void cmdPeview_Click(object sender, EventArgs e) { if (dtfStartDate.IsEmpty) dtfStartDate.SelectedDate = new DateTime(2010, 01, 01); if (dtfEndDate.IsEmpty) dtfEndDate.SelectedDate = DateTime.Now; if (dtfStartDate.SelectedDate > dtfEndDate.SelectedDate) return; TransaksiBKUQuery transBkuQ = new TransaksiBKUQuery(); //KelAnggaranQuery kelAnggaranQuery = new KelAnggaranQuery(); SaldoAwalCollection saCol = new SaldoAwalCollection(); saCol.LoadAll(); //hitung total kredit untuk semua transaksi sebelum tanggal awal TransCollection transtotalCreditCollection = new TransCollection(); transtotalCreditCollection.Query.Select(transtotalCreditCollection.Query.CreditAmount.Sum().Coalesce("0")); transtotalCreditCollection.Query.Where(transtotalCreditCollection.Query.TransDate < dtfStartDate.SelectedDate); transtotalCreditCollection.Query.Load(); decimal totalCredit = 0; if (!transtotalCreditCollection[0].CreditAmount.HasValue) { totalCredit = 0; } else { totalCredit = (decimal)transtotalCreditCollection[0].CreditAmount.Value; } //hitung total debit untuk semua transaksi sebelum tanggal awal TransCollection transtotalDebitCollection = new TransCollection(); transtotalDebitCollection.Query.Select(transtotalDebitCollection.Query.DebitAmount.Sum().Coalesce("0")); transtotalDebitCollection.Query.Where(transtotalDebitCollection.Query.TransDate < dtfStartDate.SelectedDate); transtotalDebitCollection.Query.Load(); decimal totalDebit = 0; if (transtotalDebitCollection[0].DebitAmount.HasValue == false) { totalDebit = 0; } else { totalDebit = (decimal)transtotalDebitCollection[0].DebitAmount.Value; } transBkuQ.SelectAll(); //transBkuQ.Select(transBkuQ.TransNumber,transBkuQ.TransDate,kelAnggaranQuery.GtCode,transBkuQ.Descript,transBkuQ.KaName,transBkuQ.CekBgNumber); transBkuQ.OrderBy(transBkuQ.TransNumber.Ascending); transBkuQ.Where(transBkuQ.TransDate >= dtfStartDate.SelectedDate & transBkuQ.TransDate <= dtfEndDate.SelectedDate); //transBkuQ.InnerJoin(kelAnggaranQuery).On(transBkuQ.KaCode == kelAnggaranQuery.KaCode); TransaksiBKUCollection transBkuCol = new TransaksiBKUCollection(); transBkuCol.Load(transBkuQ); if (transBkuCol.Count > 0) { dt = transBkuQ.LoadDataTable(); dt.Columns.Add("Saldo", typeof(decimal)); DataTable dtCopy = dt.Clone(); foreach (RSCM_BKU_Web.BusinessObjects.SaldoAwal sa in saCol) { dtCopy.Rows.Add("0", null, "SALDO AWAL TOTAL", "0", "Saldo Awal Total", "", (sa.SaldoAwal + totalDebit - totalCredit), 0, false, false, true, "", (sa.SaldoAwal + totalDebit - totalCredit)); SaldoAwal = Convert.ToDecimal((sa.SaldoAwal + totalDebit - totalCredit)); } foreach (DataColumn dc in dt.Columns) { titles += dc.ColumnName; this.Title = titles; } foreach (DataRow dr in dt.Rows) { SaldoAwal = SaldoAwal + (Convert.ToDecimal(dr["DEBIT_AMOUNT"]) - Convert.ToDecimal(dr["CREDIT_AMOUNT"])); dr["Saldo"] = SaldoAwal; dt.AcceptChanges(); dtCopy.Rows.Add(dr["TRANS_NUMBER"], dr["TRANS_DATE"], dr["DESCRIPT"], dr["KA_CODE"], dr["KA_NAME"], dr["GT_CODE"], dr["DEBIT_AMOUNT"], dr["CREDIT_AMOUNT"], dr["IS_CLOSED"], dr["ISVERIFIED"], dr["IS_ACTIVE"], dr["CEK_BG_NUMBER"], dr["Saldo"]); } RSCM_BKU_web.Report.LaporanBKU report1 = new LaporanBKU(); OfficerCollection ofc = new OfficerCollection(); ofc.LoadAll(); foreach (Officer o in ofc) { if (o.Jabatan == "kaunit") { report1.ReportParameters[2].Value = o.NamaLengkap; report1.ReportParameters[4].Value = o.Nip; } else { report1.ReportParameters[3].Value = o.NamaLengkap; report1.ReportParameters[5].Value = o.Nip; } } CultureInfo ci = new CultureInfo("id-ID"); report1.ReportParameters[0].Value = dtfStartDate.SelectedDate.ToString("d",ci); report1.ReportParameters[1].Value = dtfEndDate.SelectedDate.ToString("d",ci); report1.ReportParameters[6].Value = SaldoAwal.ToString(); report1.ReportParameters[6].Value = string.Format("{0:N2}", SaldoAwal); report1.DataSource = dtCopy; ReportViewer1.Report = report1; ReportViewer1.RefreshReport(); ReportViewer1.RefreshReport(); } else return; }