protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Load DataSource buat combo Kelompok Anggaran ViewKelAnggaranCodeCombineNameCollection vkaccnc = new ViewKelAnggaranCodeCombineNameCollection(); vkaccnc.LoadAll(); cmbTransCode.DataSource = vkaccnc; cmbTransCode.DataTextField = "KaCodeName"; cmbTransCode.DataValueField = "KaCode"; cmbTransCode.DataBind(); //Load DataSource buat combo Kas KasCollection kasCollection = new KasCollection(); kasCollection.LoadAll(); cmbKasID.DataSource = kasCollection; cmbKasID.DataTextField = "KaName"; cmbKasID.DataValueField = "KaCode"; cmbKasID.DataBind(); if (Request.QueryString["BKU_ID"] != null) { long BkuID = 0; if (long.TryParse(Request.QueryString["BKU_ID"], out BkuID)) { Trans trans = new Trans(); if (trans.LoadByPrimaryKey(BkuID)) { txtTransID.Text = trans.BkuId.ToString(); txtTransNumber.Text = trans.TransNumber; dtpTransDate.SelectedDate = (DateTime)trans.TransDate; cmbTransCode.SelectedValue = trans.KaCode; cmbKasID.SelectedValue = trans.KasId; txtDescription.Text = trans.Descript; txtCekBG.Text = trans.CekBgNumber; txtDebitAmount.Text = trans.DebitAmount.ToString(); txtCreditAmount.Text = trans.CreditAmount.ToString(); } } } else txtTransNumber.Text = "{AUTO}"; } }
protected void btnPreview_Click(object sender, EventArgs e) { if (dtpStartDate.SelectedDate > dtpEndDate.SelectedDate || dtpStartDate.SelectedDate > DateTime.Now) return; if (dtpEndDate.SelectedDate.ToString().Trim() == string.Empty) return; if ((dtpStartDate.SelectedDate.ToString().Trim() == string.Empty)) dtpStartDate.SelectedDate = dtpStartDate.MinDate; //Load All Valid Kas KasQuery kasQ = new KasQuery("a"); PeriodeAnggaranQuery paQ = new PeriodeAnggaranQuery("b"); kasQ.InnerJoin(paQ).On(kasQ.PeriodeId == paQ.Id); kasQ.Select(kasQ.KaCode, kasQ.KaName); paQ.Where(paQ.IsClosed == false); KasCollection kasC = new KasCollection(); kasC.Load(kasQ); ReportBook rb = new ReportBook(); foreach (Kas k in kasC) { TransQuery tQ = new TransQuery("c"); tQ.Select(tQ.TransNumber, tQ.TransDate, tQ.Descript, tQ.DebitAmount, tQ.CreditAmount); tQ.Where(tQ.TransDate >= dtpStartDate.SelectedDate, tQ.TransDate <= dtpEndDate.SelectedDate,tQ.KasId == k.KaCode); TransCollection tColl = new TransCollection(); tColl.Load(tQ); if (tColl.Count > 0) { RSCM_BKU_web.Report.LaporanKasBank report1 = new RSCM_BKU_web.Report.LaporanKasBank(); report1.ReportParameters[0].Value = k.KaName; report1.ReportParameters[1].Value = dtpStartDate.SelectedDate; report1.ReportParameters[2].Value = dtpEndDate.SelectedDate; report1.DataSource = tColl; rb.Reports.Add(report1); } } //ReportViewer1.Report = rb; //ReportViewer1.RefreshReport(); }
protected void cmdPreview_Click(object sender, EventArgs e) { if (dtfStartDate.IsEmpty) dtfStartDate.SelectedDate = new DateTime(2011, 01, 01); if (dtfEndDate.IsEmpty) dtfEndDate.SelectedDate = DateTime.Now; if (dtfStartDate.SelectedDate > dtfEndDate.SelectedDate) return; if (string.IsNullOrEmpty(cmbJenisKasBank.SelectedItem.Value)) { cmbJenisKasBank.SelectedIndex = 0; } //ini untuk saldo awal KasCollection saldoKas = new KasCollection(); saldoKas.Query.Select(saldoKas.Query.SaldoAwal); saldoKas.Query.Where(saldoKas.Query.KaCode == cmbJenisKasBank.SelectedItem.Value); saldoKas.Query.Load(); //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.KasId == cmbJenisKasBank.SelectedItem.Value); //transtotalCreditCollection.Query.OrderBy(transtotalCreditCollection.Query.TransNumber.Ascending, transtotalCreditCollection.Query.BkuId.Ascending); 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.KasId == cmbJenisKasBank.SelectedItem.Value); transtotalDebitCollection.Query.Load(); decimal totalDebit = 0; if (transtotalDebitCollection[0].DebitAmount.HasValue == false) { totalDebit = 0; } else { totalDebit = (decimal)transtotalDebitCollection[0].DebitAmount.Value; } //so, Saldo Awal adalah ... decimal SaldoAwal = 0; foreach(Kas kkkk in saldoKas) { SaldoAwal = (decimal)kkkk.SaldoAwal + totalDebit - totalCredit; } //TransQuery transQ = new TransQuery(); string zero = "0"; string zeros = "0.0"; string sawal = "SALDO AWAL"; decimal nol = 0; DateTime skrg = DateTime.Now; DateTime startdate = dtfStartDate.SelectedDate; startdate = startdate.AddDays(-1); var trans = from t in db.Trans join k in db.KAs on t.KAS_ID equals k.KA_CODE where t.TRANS_DATE >= dtfStartDate.SelectedDate && t.TRANS_DATE <= dtfEndDate.SelectedDate && t.KAS_ID == cmbJenisKasBank.SelectedItem.Value select new { NUMBER = (string)t.TRANS_NUMBER, DATES = (DateTime)t.TRANS_DATE, DESCRIPTS = t.DESCRIPT, CREDIT = (decimal)t.CREDIT_AMOUNT, DEBIT = (decimal)t.DEBIT_AMOUNT, CODES = (String)k.KA_CODE, NAMES = (string)k.KA_NAME }; var Cash = from kas in db.KAs where kas.KA_CODE == cmbJenisKasBank.SelectedItem.Value select new { NUMBER = zero, DATES = startdate, DESCRIPTS = sawal, CREDIT = nol, DEBIT = SaldoAwal, CODES = zeros, NAMES = (string)kas.KA_NAME }; var Gab = trans.Union(Cash); DataTable Gabungan = AnonymousToDataTable.ToDataTable(Gab); Gabungan.Columns.Add("SALDO", typeof(decimal)); foreach (DataRow dr in Gabungan.Rows) { if (dr["DESCRIPTS"].ToString() == sawal) { dr["SALDO"] = SaldoAwal; continue; } SaldoAwal = SaldoAwal + (Convert.ToDecimal(dr["DEBIT"])) - (Convert.ToDecimal(dr["CREDIT"])); dr["SALDO"] = SaldoAwal; Gabungan.AcceptChanges(); } RSCM_BKU_web.Report.LaporanKasBank report1 = new RSCM_BKU_web.Report.LaporanKasBank(); report1.DataSource = Gabungan; ReportViewer1.Report = report1; ReportViewer1.RefreshReport(); }
virtual public void Combine(KasCollection collection) { base.Combine(collection); }