private void GetData()
{
var mitraid = Session["proposal_number"].ToString();
DataTable kartu = new Pertamina.PKBL.BLL.Akuntansi.KartuPiutangDetailBll().getKartuPiutang(mitraid.ToString());
int currAngsuran = 0;
foreach (DataRow item in kartu.Rows)
{
if (Convert.ToInt32(item["AngsuranKe"]) == currAngsuran)
{
item["AngsuranKe"] = " ";
item["HutangPokok"] = " ";
item["Bunga"] = " ";
item["Total"] = " ";
item["TglJatuhTempo"] = " ";
}
else
{
currAngsuran = Convert.ToInt32(item["AngsuranKe"]);
}
}
gvDetailKartuPiutang.DataSource = kartu;
gvDetailKartuPiutang.DataBind();
}
public DataTable GetDataKartu(string no_proposal)
{
//Hashtable parameters = new Hashtable();
//parameters.Add("@proposal_number-varchar-99", no_proposal);
Pertamina.PKBL.BLL.Akuntansi.KartuPiutangDetailBll kpBll = new KartuPiutangDetailBll();
return(kpBll.getKartuPiutang(no_proposal));//dbHelper.GetData("[USP_KEMITRAAN_SELECT_KARTU_PIUTANG_DETAIL]", parameters);
}
protected void Page_Load(object sender, EventArgs e)
{
var proposal = Request.QueryString["proposal"].ToString();
var detail = (new Pertamina.PKBL.BLL.Akuntansi.KartuPiutangDetailBll()).getPrintKartuPiutang(proposal);
DataRow data = (DataRow)detail["data"];
if (!IsPostBack)
{
if (Request.QueryString["proposal"] != null)
{
lblKolektibilitas.Text = (new KartuPiutangDetailBll()).getKolektibilitas(Request.QueryString["proposal"].ToString().Trim());
}
}
if (data != null)
{
lblKodeMitra2.Text = data["mitraid"].ToString();
lblNama2.Text = data["requestor_name"].ToString();
lblAlamat2.Text = data["requestor_address"].ToString();
lblJtuhTempo2.Text = String.Format("per {0} bulan ", data["jatuhtempo_bulan"]);
lblPinjaman2.Text = String.Format("{0:#,##}.00", data["NilaiSetuju"]);
lblTanggalRealisasi2.Text = DateTime.Parse(data["TglRealisasi"].ToString()).ToString("dd/MM/yyyy");
lblTglJatuhTempo2.Text = data["maturityDate"].ToString();
lblJangkaWaktu2.Text = String.Format("{0} Bulan", data["JangkaWaktu"]);
lblGracePeriod2.Text = String.Format("{0} Bulan", data["grace_period"]);
lblPersentaseJasa2.Text = String.Format("{0}%", data["SukuBUnga"]);
}
DataTable kartu = new Pertamina.PKBL.BLL.Akuntansi.KartuPiutangDetailBll().getKartuPiutang(proposal.ToString());
int currAngsuran = 0;
foreach (DataRow item in kartu.Rows)
{
if (Convert.ToInt32(item["AngsuranKe"]) == currAngsuran)
{
item["AngsuranKe"] = " ";
item["HutangPokok"] = " ";
item["Bunga"] = " ";
item["Total"] = " ";
item["TglJatuhTempo"] = " ";
}
else
{
currAngsuran = Convert.ToInt32(item["AngsuranKe"]);
}
}
gvDetailKartuPiutang.DataSource = kartu;
gvDetailKartuPiutang.DataBind();
}
