protected void Page_Load(object sender, System.EventArgs e) { Act.Pass(); Act.NoCache(); Act.CekInt("NoCustomer"); Func.CustomerPassword(NoCustomer); //Custom SECURITY if (!Act.Sec("ED:" + Request.PhysicalPath)) { ok.Enabled = false; save.Enabled = false; } if (!Page.IsPostBack) { //kalkulator Js.NumberFormat(luaslama); Act.ProjectList(project); Fill(); } FeedBack(); }
protected void tambah(int index) { TableRow r = new TableRow(); r.ID = "baris_" + index; TableCell c; DropDownList ddl; TextBox tb; Label l; ddl = new DropDownList(); ddl.ID = "lvlsales_" + index; if (tipe.SelectedIndex == 0) { LibMkt.ListLvlSales(ddl, 0, project.SelectedValue); } else { LibMkt.ListLvlSales(ddl, Convert.ToInt32(tipe.SelectedValue), project.SelectedValue); } c = new TableCell(); c.Controls.Add(ddl); r.Cells.Add(c); tb = new TextBox(); tb.ID = "penjualan_" + index; Js.NumberFormat(tb); c = new TableCell(); c.Controls.Add(tb); r.Cells.Add(c); tb = new TextBox(); tb.ID = "reward_" + index; c = new TableCell(); c.Controls.Add(tb); r.Cells.Add(c); c = new TableCell(); l = new Label(); l.Text = "<i class='fa fa-trash'></i>"; l.CssClass = "btn btn-cal"; StringBuilder x = new StringBuilder(); x.Append("ClearSkema3('penjualan_" + index + "','reward_" + index + "');"); l.Attributes["onclick"] = x.ToString(); c.Controls.Add(l); r.Cells.Add(c); list.Controls.Add(r); }
protected void fill() { Js.NumberFormat(persenlunas); string value = Db.SingleString("SELECT ISNULL(VALUE, '0') FROM REF_PARAM WHERE ParamID = '" + ParamID + "'"); if (!String.IsNullOrEmpty(value)) { persenlunas.Text = Cf.Num(value); } else { persenlunas.Text = "0"; } }
private void Bind() { Js.Focus(this, nama); //Js.NumberFormat(bfjumlah); //Js.NumberFormat(dpjumlah); //Js.NumberFormat(angjumlah); Js.NumberFormat(diskon); diskon.Attributes["onblur"] = "if(this.value!=tempdisc){" + "recaldisc(document.getElementById('diskon'));" + "}"; diskon.Attributes["style"] = "display: none;"; }
protected void fill() { Js.NumberFormat(bayar); string value = Db.SingleString("SELECT ISNULL(VALUE, '0') FROM " + Mi.DbPrefix + "SECURITY..REF_PARAM WHERE ParamID = '" + ParamID + "'"); if (!String.IsNullOrEmpty(value)) { bayar.Text = Cf.Num(value); } else { bayar.Text = "0"; } }
protected void Page_Load(object sender, System.EventArgs e) { Act.Pass(); Act.NoCache(); if (!Page.IsPostBack) { Act.ProjectList(project); FillTable(); Js.Focus(this, acc); Js.NumberFormat(saldoawal); } FeedBack(); }
private void FillHeader() { Js.NumberFormat(barunominal); Act.ProjectList(project); UnitList(lokasi); diskon.Attributes["onfocus"] = "tempnum=CalcFocus(this);tempdisc=this.value;"; diskon.Attributes["onblur"] = "if(this.value!=tempdisc){" + "recaldisc(document.getElementById('diskon'));" + "}"; btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=" + Mi.DbPrefix + "MARKETINGJUAL..REF_SKEMA_LOG&Pk=" + Nomor.PadLeft(3, '0') + "'"; btndel.Attributes["onclick"] = "location.href='SkemaDel.aspx?Nomor=" + Nomor + "'"; DataTable rsHeader = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_SKEMA WHERE Nomor = " + Nomor); if (rsHeader.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else if (!Act.AksesProject(rsHeader.Rows[0]["Project"].ToString())) { Response.Redirect("/CustomError/SecLevel.html"); } else { nama.Text = rsHeader.Rows[0]["Nama"].ToString(); diskon.Text = rsHeader.Rows[0]["Diskon"].ToString(); diskonket.Text = rsHeader.Rows[0]["DiskonKet"].ToString(); bunga2.Text = rsHeader.Rows[0]["Bunga"].ToString(); bungaket.Text = rsHeader.Rows[0]["BungaKet"].ToString(); jenis.SelectedValue = rsHeader.Rows[0]["Jenis"].ToString(); Cf.SelectedValue(project, rsHeader.Rows[0]["Project"].ToString()); Cf.SelectedValue(lokasi, rsHeader.Rows[0]["TipeUnit"].ToString()); if (rsHeader.Rows[0]["Status"].ToString() == "A") { aktif.Checked = true; inaktif.Checked = false; } else { aktif.Checked = false; inaktif.Checked = true; } round.Checked = (bool)rsHeader.Rows[0]["RThousand"]; } }
protected void Page_Load(object sender, System.EventArgs e) { Act.Pass(); Act.NoCache(); if (!Page.IsPostBack) { nobg.Attributes["ondblclick"] = "popDaftarBG();"; InitForm(); Js.Focus(this, ket); nilaitr.Visible = false; Js.NumberFormat(nilai); Js.NumberFormat(admBank); Js.NumberFormat(lebihBayar); Js.NumberFormat(lb); Js.NumberFormat(biayaadmin); biayaadmin.Attributes["onblur"] += "javascript:hitungbiayaadmin();"; lb.Attributes["onblur"] += "javascript:hitungbiayaadmin();"; lebihBayar.Attributes["onblur"] += "javascript:hitungbiayaadmin();"; admBank.Attributes["onblur"] += "javascript:hitungbiayaadmin();"; gt.Attributes.Add("readonly", "readonly"); grandtotal.Attributes.Add("readonly", "readonly"); fillAcc(); } ClientScript.RegisterOnSubmitStatement( GetType(), "hitungulang", "hitunggt();" ); ClientScript.RegisterStartupScript( GetType(), "hitungulang2", "hitunggt();", true ); if (detildiv.Visible) { Js.Confirm(this, "Lanjutkan proses registrasi tanda terima sementara?"); } FillTb(); }
protected void Page_Load(object sender, EventArgs e) { Act.Pass(); Act.NoCache(); if (!Page.IsPostBack) { init(); Js.Focus(this, save); Fill(); } FeedBack(); Js.NumberFormat(hrst); }
private void Bind() { //NumberFormat.js Js.NumberFormat(luas); DataTable rs; string strSql; strSql = "SELECT * FROM REF_JENIS WHERE Project = '" + project.SelectedValue + "' ORDER BY SN"; rs = Db.Rs(strSql); for (int i = 0; i < rs.Rows.Count; i++) { string v = rs.Rows[i]["Jenis"].ToString(); string t = v + " - " + rs.Rows[i]["Nama"].ToString(); ListItem li = new ListItem(); li.Text = t; li.Value = v; li.Attributes.Add("class", "radio"); jenis.Items.Add(li); } strSql = "SELECT * FROM REF_LOKASI WHERE Project = '" + project.SelectedValue + "' ORDER BY SN"; rs = Db.Rs(strSql); for (int i = 0; i < rs.Rows.Count; i++) { string v = rs.Rows[i]["Lokasi"].ToString(); string t = v + " - " + rs.Rows[i]["Nama"].ToString(); lokasi.Items.Add(new ListItem(" " + t, v)); } //strSql = "SELECT * FROM REF_JENISPROPERTI WHERE Project = '" + project.SelectedValue + "' ORDER BY SN"; //rs = Db.Rs(strSql); //for (int i = 0; i < rs.Rows.Count; i++) //{ // string v = rs.Rows[i]["JenisProperti"].ToString(); // string t = v + " - " + rs.Rows[i]["Nama"].ToString(); // ListItem li = new ListItem(); // li.Text = t; // li.Value = v; // li.Attributes.Add("class", "radio"); // tipe.Items.Add(li); //} var hub = GlobalHost.ConnectionManager.GetHubContext <UnitHub>(); hub.Clients.All.broadcastStatus(NoStock); }
protected void Page_Load(object sender, System.EventArgs e) { Act.Pass(); Act.NoCache(); if (!Page.IsPostBack) { InitForm(); detildiv.Visible = false; Js.NumberFormat(nilai); Js.NumberFormat(admBank); } if (detildiv.Visible) { Js.Confirm(this, "Lanjutkan proses registrasi memo pelunasan?"); } FillTb(); }
protected void fill() { Js.NumberFormat(grace); if (Param.Exist(RumusDenda1)) { rumus1.Text = Param.GetParam(RumusDenda1); } if (Param.Exist(RumusDenda2)) { rumus2.Text = Param.GetParam(RumusDenda2); } if (Param.Exist(GracePeriod)) { grace.Text = Cf.Num(Convert.ToDecimal(Param.GetParam(GracePeriod))); } if (Param.Exist(BerlakuDenda)) { berlaku.Text = Param.GetParam(BerlakuDenda); } }
protected void Page_Load(object sender, System.EventArgs e) { Act.Pass(); Act.NoCache(); Act.CekInt("Nocb"); if (!Page.IsPostBack) { Js.Focus(this, tgl); fillAcc(); Fill(); Js.NumberFormat(sisa); Js.NumberFormat(lb); Js.NumberFormat(bk); } FeedBack(); }
protected void Page_Load(object sender, System.EventArgs e) { Act.Pass(); Act.NoCache(); if (!Page.IsPostBack) { rBankKeluar.Visible = false; rRek.Visible = false; rTglKembali.Visible = false; backbtn.Visible = false; btnAct.Visible = false; nokontrak.Attributes["ondblclick"] = "popDaftarKontrak('a&ppjb=1');"; fillAcc(); if (Request.QueryString["NoKontrak"] != null) { nokontrak.Text = Request.QueryString["NoKontrak"]; LoadKontrak(); cancel.Attributes["onclick"] = "location.href='CBRegistrasi1.aspx'"; } else { Js.Focus(this, nokontrak); frm.Visible = false; } Js.NumberFormat(bk); } FeedBack(); if (frm.Visible) { Js.Confirm(this, "Lanjutkan proses pencatatan Cashback?"); } }
protected void tambah(int index) { TableRow r = new TableRow(); r.ID = "baris_" + index; TableCell c; DropDownList ddl; RadioButtonList rbl; TextBox tb; ddl = new DropDownList(); ddl.ID = "lvlsales_" + index; LibMkt.ListLvlSales(ddl, Convert.ToInt32(tipe.SelectedValue), project.SelectedValue); c = new TableCell(); c.Controls.Add(ddl); r.Cells.Add(c); tb = new TextBox(); tb.ID = "penjualan_" + index; Js.NumberFormat(tb); c = new TableCell(); c.Controls.Add(tb); r.Cells.Add(c); tb = new TextBox(); tb.ID = "reward_" + index; c = new TableCell(); c.Controls.Add(tb); r.Cells.Add(c); list.Controls.Add(r); }
private void FillTb() { string strSql = "SELECT * " + ",(NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM " + Tb + "..MS_PELUNASAN WHERE NoTagihan = MS_TAGIHAN.NoUrut AND NoKontrak = '" + Ref + "') ) AS SisaTagihan" + " FROM " + Tb + "..MS_TAGIHAN AS MS_TAGIHAN WHERE NoKontrak = '" + Ref + "'" + " AND KPR != '1' AND Tipe != 'ADM'" + " AND (NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM " + Tb + "..MS_PELUNASAN WHERE NoTagihan = MS_TAGIHAN.NoUrut AND NoKontrak = '" + Ref + "') ) > 0" + " ORDER BY TglJT, NoUrut"; rsTagihan = Db.Rs(strSql); decimal Ano = Db.SingleDecimal("SELECT ISNULL(Nilai, 0) FROM MS_ANONIM WHERE NoAnonim = '" + anonim.SelectedValue + "'"); decimal sisatotal = 0; decimal sisatotal2 = 0; int b = 0; for (int i = 0; i < rsTagihan.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } b++; Label l; TextBox t; CheckBox cb; l = new Label(); l.Text = "<tr valign=top>" + "<td>" + rsTagihan.Rows[i]["NoKontrak"] + "." + rsTagihan.Rows[i]["NoUrut"] + "</td>" + "<td>" + rsTagihan.Rows[i]["NamaTagihan"] + "</td>" + "<td>" + rsTagihan.Rows[i]["Tipe"] + "</td>" + "<td style='white-space:nowrap'>" + Cf.Day(rsTagihan.Rows[i]["TglJT"]) + "</td>" + "<td align=right>" + Cf.Num(rsTagihan.Rows[i]["SisaTagihan"]) + "</td>" + "<td>" ; list.Controls.Add(l); t = new TextBox(); t.ID = "lunas_" + i; t.Width = 100; t.CssClass = "txt_num"; Js.NumberFormat(t); t.Attributes["onblur"] += "hitunggt();"; list.Controls.Add(t); l = new Label(); l.Text = "</td><td>"; list.Controls.Add(l); cb = new CheckBox(); cb.Attributes.Add("onclick", "tagihan('" + i + "','" + Cf.Num(rsTagihan.Rows[i]["SisaTagihan"]) + "',this)"); list.Controls.Add(cb); l = new Label(); l.Text = "</td>"; list.Controls.Add(l); sisatotal += Convert.ToDecimal(rsTagihan.Rows[i]["SisaTagihan"]); //Response.Write(sisatotal + "<Br>"); } string strSql2 = "SELECT * " + ",(NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM " + Tb + "..MS_PELUNASAN WHERE NoTagihan = MS_TAGIHAN.NoUrut AND NoKontrak = '" + Ref + "') ) AS SisaTagihan" + " FROM " + Tb + "..MS_TAGIHAN AS MS_TAGIHAN WHERE NoKontrak = '" + Ref + "'" + " AND KPR != '1' AND Tipe = 'ADM'" + " AND (NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM " + Tb + "..MS_PELUNASAN WHERE NoTagihan = MS_TAGIHAN.NoUrut AND NoKontrak = '" + Ref + "') ) > 0" + " ORDER BY TglJT, NoUrut"; rsTagihan2 = Db.Rs(strSql2); for (int a = 0; a < rsTagihan2.Rows.Count; a++) { if (!Response.IsClientConnected) { break; } Label l; TextBox t; CheckBox cb; l = new Label(); l.Text = "<tr valign=top>" + "<td>" + rsTagihan2.Rows[a]["NoKontrak"] + "." + rsTagihan2.Rows[a]["NoUrut"] + "</td>" + "<td>" + rsTagihan2.Rows[a]["NamaTagihan"] + "</td>" + "<td>" + rsTagihan2.Rows[a]["Tipe"] + "</td>" + "<td style='white-space:nowrap'>" + Cf.Day(rsTagihan2.Rows[a]["TglJT"]) + "</td>" + "<td align=right>" + Cf.Num(rsTagihan2.Rows[a]["SisaTagihan"]) + "</td>" + "<td>" ; list.Controls.Add(l); t = new TextBox(); t.ID = "lunas_" + (a + b); t.Width = 100; t.CssClass = "txt_num"; Js.NumberFormat(t); t.Attributes["onblur"] += "hitunggt();"; list.Controls.Add(t); l = new Label(); l.Text = "</td><td>"; list.Controls.Add(l); cb = new CheckBox(); cb.Attributes.Add("onclick", "tagihan('" + (a + b) + "','" + Cf.Num(rsTagihan2.Rows[a]["SisaTagihan"]) + "',this)"); list.Controls.Add(cb); l = new Label(); l.Text = "</td>"; list.Controls.Add(l); sisatotal2 += Convert.ToDecimal(rsTagihan2.Rows[a]["SisaTagihan"]); } if (Ano > (sisatotal + sisatotal2)) { gt.Text = Cf.Num(Ano); lb.Text = Cf.Num(Ano - (sisatotal + sisatotal2)); } }
protected void init() { Act.ProjectList(project); Js.NumberFormat(batas); }
private void FillTb() { string strSql = "SELECT * " + ",(NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM " + Tb + "..MS_PELUNASAN WHERE NoTagihan = MS_TAGIHAN.NoUrut AND NoKontrak = '" + Ref + "') ) AS SisaTagihan" + " FROM " + Tb + "..MS_TAGIHAN AS MS_TAGIHAN WHERE NoKontrak = '" + Ref + "'" + " AND (NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM " + Tb + "..MS_PELUNASAN WHERE NoTagihan = MS_TAGIHAN.NoUrut AND NoKontrak = '" + Ref + "') ) > 0" + " ORDER BY NoUrut"; rsTagihan = Db.Rs(strSql); for (int i = 0; i < rsTagihan.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } Label l; TextBox t; TextBox tgl; HtmlInputButton btn; HtmlGenericControl div; HtmlGenericControl span; HtmlGenericControl label; HtmlGenericControl italic; l = new Label(); l.Text = "<tr valign=top>" + "<td>" + rsTagihan.Rows[i]["NoKontrak"] + "." + rsTagihan.Rows[i]["NoUrut"] + "</td>" + "<td>" + rsTagihan.Rows[i]["NamaTagihan"] + "</td>" + "<td>" + rsTagihan.Rows[i]["Tipe"] + "</td>" + "<td style='white-space:nowrap'>" + Cf.Day(rsTagihan.Rows[i]["TglJT"]) + "</td>" + "<td align=right>" + Cf.Num(rsTagihan.Rows[i]["SisaTagihan"]) + "</td>"; list.Controls.Add(l); l = new Label(); l.Text = "<td>"; list.Controls.Add(l); t = new TextBox(); t.ID = "lunas_" + i; t.Width = 100; t.CssClass = "txt_num"; Js.NumberFormat(t); t.Attributes["onblur"] += "hitunggt();"; list.Controls.Add(t); l = new Label(); l.Text = "</td><td>"; list.Controls.Add(l); //Tanggal div = new HtmlGenericControl("div"); div.Attributes.Add("class", "input-group input-small"); div.Attributes.Add("style", "margin-top: 0px; margin-left: 0px;"); tgl = new TextBox(); tgl.ID = "tgl_" + i; tgl.CssClass = "tgl form-control form-control-small"; tgl.Text = Cf.Day(Convert.ToDateTime(DateTime.Today)); tgl.Attributes["style"] = "font:8pt; width:65%"; div.Controls.Add(tgl); span = new HtmlGenericControl("span"); span.Attributes.Add("style", "height: 34px; display: block;"); span.Attributes.Add("class", "input-group-btn"); label = new HtmlGenericControl("label"); label.Attributes.Add("for", tgl.ID); label.Attributes.Add("class", "btn-a default btn-cal"); italic = new HtmlGenericControl("i"); italic.Attributes.Add("class", "fa fa-calendar"); label.Controls.Add(italic); span.Controls.Add(label); div.Controls.Add(span); list.Controls.Add(div); l = new Label(); l.Text = "</td><td><input type='checkbox' onclick=\"tagihan('" + i + "','" + Cf.Num(rsTagihan.Rows[i]["SisaTagihan"]) + "',this)\"></td></tr>"; list.Controls.Add(l); } }
protected void tambahbaris(short i) { HtmlTableRow tr; HtmlTableCell c; TextBox tb; TextBox tb2; TextBox tb4; TextBox tb5; TextBox tb6; TextBox tb7; TextBox tb8; HtmlInputButton btn; Label l; tr = new HtmlTableRow(); tr.VAlign = "top"; list.Controls.Add(tr); c = new HtmlTableCell(); c.InnerHtml = i.ToString() + "."; tr.Cells.Add(c); tb = new TextBox(); tb.ID = "kodebr_" + i; tb.Width = 120; tb8 = new TextBox(); tb8.ID = "kodebr2_" + i; tb8.Attributes["style"] = "display:none"; btn = new HtmlInputButton(); btn.ID = "btnacc_" + i; btn.Value = "..."; btn.Attributes["class"] = "search"; tb2 = new TextBox(); tb2.ID = "namabr_" + i; tb2.Width = 200; tb2.ReadOnly = true; tb4 = new TextBox(); tb4.ID = "satuanbr_" + i; tb4.Width = 70; tb4.ReadOnly = true; tb5 = new TextBox(); tb5.ID = "hrgabr_" + i; Js.NumberFormat(tb5); tb5.Width = 140; tb5.ReadOnly = true; tb6 = new TextBox(); tb6.ID = "qtybr_" + i; tb6.Text = "0"; tb6.Attributes["onfocus"] = "tempnum=CalcFocus(this);"; tb6.Attributes["onkeyup"] = "CalcType(this,tempnum);"; tb6.Attributes["onblur"] = "CalcBlur(this);hitungaja('" + i + "');"; tb6.Width = 50; tb7 = new TextBox(); tb7.ID = "totalbr_" + i; tb7.Width = 140; tb7.ReadOnly = true; string Project = Db.SingleString("SELECT Project FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'"); tb.Attributes["ondblclick"] = btn.Attributes["onclick"] = "callgimmick('" + tb.ID + "','" + tb2.ID + "','" + tb4.ID + "','" + tb5.ID + "','" + tb8.ID + "','" + Project + "')"; c = new HtmlTableCell(); c.Controls.Add(tb); c.Controls.Add(tb8); c.Controls.Add(btn); tr.Cells.Add(c); c = new HtmlTableCell(); c.Controls.Add(tb2); tr.Cells.Add(c); c = new HtmlTableCell(); c.Controls.Add(tb4); tr.Cells.Add(c); c = new HtmlTableCell(); c.Controls.Add(tb5); tr.Cells.Add(c); c = new HtmlTableCell(); c.Controls.Add(tb6); tr.Cells.Add(c); c = new HtmlTableCell(); c.Controls.Add(tb7); tr.Cells.Add(c); c = new HtmlTableCell(); l = new Label(); l.Text = "<i class='fa fa-trash'></i>"; l.CssClass = "btn btn-cal"; StringBuilder x = new StringBuilder(); x.Append("ClearGimmick('kodebr_" + i + "','kodebr2_" + i + "','namabr_" + i + "','satuanbr_" + i + "','hrgabr_" + i + "','qtybr_" + i + "','totalbr_" + i + "');"); l.Attributes["onclick"] = x.ToString(); c.Controls.Add(l); tr.Cells.Add(c); }
private void Fill() { Js.NumberFormat(sisa); Js.NumberFormat(lb); Func.KontrakHeader(NoKontrak, nokontrakl, unit, customer, agent); string strSql = "SELECT * FROM ISC064_MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'"; DataTable rs = Db.Rs(strSql); unit.Text = Db.SingleString("SELECT NoUnit " + " FROM ISC064_MARKETINGJUAL..MS_KONTRAK " + " WHERE NoKontrak = '" + NoKontrak + "'"); customer.Text = Db.SingleString("SELECT Nama " + " FROM ISC064_MARKETINGJUAL..MS_KONTRAK AS MS_KONTRAK " + " INNER JOIN ISC064_MARKETINGJUAL..MS_CUSTOMER AS MS_CUSTOMER " + " ON MS_KONTRAK.NoCustomer = MS_CUSTOMER.NoCustomer" + " WHERE NoKontrak = '" + NoKontrak + "'"); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else { decimal nilaitagihan = 0; decimal nilaipelunasan1 = 0; decimal nilaipelunasan2 = 0; decimal sisatagihan = 0; decimal lebihbayar = 0; decimal bankkeluar = 0; DataTable rs1 = Db.Rs("SELECT * " + " FROM ISC064_MARKETINGJUAL..MS_TAGIHAN " + " WHERE NoKontrak = '" + NoKontrak + "'"); for (int i = 0; i < rs1.Rows.Count; i++) { decimal x = Db.SingleDecimal("SELECT ISNULL(SUM(NilaiPelunasan),0) FROM ISC064_MARKETINGJUAL..MS_PELUNASAN WHERE NoKontrak = '" + NoKontrak + "' AND NoTagihan = '" + rs1.Rows[i]["Nourut"] + "'");// AND CaraBayar!='AL' nilaitagihan += Convert.ToDecimal(rs1.Rows[i]["NilaiTagihan"]); if (x > Convert.ToDecimal(rs1.Rows[i]["NilaiTagihan"])) { nilaipelunasan1 += Convert.ToDecimal(rs1.Rows[i]["NilaiTagihan"]); } else { nilaipelunasan1 += x; } nilaipelunasan2 += x; } decimal sumAlokasi = Db.SingleDecimal("SELECT ISNULL(SUM(NilaiPelunasan),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE NoKontrak = '" + NoKontrak + "' AND CaraBayar='AL'"); decimal MemoCB = 0;// Db.SingleDecimal("SELECT ISNULL(SUM(LebihBayar),0) FROM MS_CASHBACK_MEMO where nokontrak='" + NoKontrak + "'"); sisatagihan = nilaitagihan - nilaipelunasan1; bankkeluar = nilaitagihan - nilaipelunasan2; lebihbayar = Db.SingleDecimal("SELECT ISNULL(SUM(LB),0) FROM MS_TTS WHERE Ref = '" + NoKontrak + "' AND Status <> 'VOID'"); decimal BK = Db.SingleDecimal("SELECT ISNULL(SUM(BankKeluar),0) FROM MS_CASHBACK WHERE NoKontrak = '" + NoKontrak + "'"); sisa.Text = Cf.Num(sisatagihan); lb.Text = Cf.Num(lebihbayar - BK - sumAlokasi - MemoCB); LebihBayar1 = lebihbayar - BK; } }
void fillTagihan() { decimal LB = Convert.ToDecimal(lb.Text);; decimal total = 0; string query = "SELECT (a.Nokontrak + '.' + Cast(a.NoUrut AS VARCHAR)) AS NoTagihan, " + " a.NamaTagihan, " + " a.Tipe, " + " a.TglJT, " + " a.NoUrut, " + " (a.NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE NoKontrak = a.NoKontrak and NoTagihan = a.NoUrut)) AS SisaTagihan " + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_TAGIHAN A " + " WHERE 1=1 " + " AND A.Nokontrak = '" + NoKontrak + "'" + " AND (A.NilaiTagihan - (SELECT ISNULL(SUM(NilaiPelunasan),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE NoKontrak = a.NoKontrak AND NoTagihan = a.NoUrut)) >0 "; rs = Db.Rs(query); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } HtmlTableRow r = new HtmlTableRow(); HtmlTableCell c = new HtmlTableCell(); TextBox t; HtmlButton bt; Label l; c.InnerHtml = rs.Rows[i]["NoTagihan"].ToString(); r.Cells.Add(c); c = new HtmlTableCell(); c.InnerHtml = rs.Rows[i]["NamaTagihan"].ToString(); r.Cells.Add(c); c = new HtmlTableCell(); c.InnerHtml = rs.Rows[i]["Tipe"].ToString(); r.Cells.Add(c); c = new HtmlTableCell(); c.InnerHtml = Cf.Day(rs.Rows[i]["TglJT"]); r.Cells.Add(c); c = new HtmlTableCell(); c.InnerHtml = Cf.Num(Convert.ToDecimal(rs.Rows[i]["SisaTagihan"])); c.Align = "Right"; r.Cells.Add(c); c = new HtmlTableCell(); t = new TextBox(); t.ID = "bayar_" + i; t.Attributes.Add("style", "text-align:right;"); if (Convert.ToDecimal(rs.Rows[i]["SisaTagihan"]) <= LB) { t.Text = Cf.Num(rs.Rows[i]["SisaTagihan"]); total += Convert.ToDecimal(rs.Rows[i]["SisaTagihan"]); totalBayar.Text = Cf.Num(total); } else { if (LB > 0) { t.Text = Cf.Num(LB); total += LB; LB -= Convert.ToDecimal(rs.Rows[i]["SisaTagihan"]); totalBayar.Text = Cf.Num(total); } } Js.NumberFormat(t); t.Attributes["onblur"] += "hitunggt();"; c.Controls.Add(t); r.Cells.Add(c); // Tanggal c = new HtmlTableCell(); t = new TextBox(); t.ID = "tgl_" + Convert.ToString(i); t.Width = 75; t.CssClass = "txt_center"; t.Text = Cf.Day(rs.Rows[i]["TglJT"]); t.Attributes["style"] = "font:8pt"; c.Controls.Add(t); l = new Label(); l.Text = " "; c.Controls.Add(l); bt = new HtmlButton(); bt.InnerHtml = ""; bt.Attributes["onclick"] = "openCalendar('" + t.ID + "')"; bt.Attributes["class"] = "btn"; bt.Attributes["style"] = "font-family: 'fontawesome'"; c.Controls.Add(bt); r.Cells.Add(c); c = new HtmlTableCell(); CheckBox cb = new CheckBox(); cb.Attributes.Add("onclick", "tagihan('bayar_" + i + "','" + Cf.Num(rs.Rows[i]["SisaTagihan"]) + "',this)"); c.Controls.Add(cb); r.Cells.Add(c); c = new HtmlTableCell(); c.Attributes.Add("style", "display:none;"); c.InnerHtml = rs.Rows[i]["NoUrut"].ToString(); c.ID = "NoTagihan_" + i; r.Cells.Add(c); list.Controls.Add(r); } //HtmlTableRow tr = new HtmlTableRow(); //HtmlTableCell td = new HtmlTableCell(); //td.InnerHtml = "<b>Grand Total</b>"; //td.ColSpan = 5; //tr.Cells.Add(td); //td = new HtmlTableCell(); //TextBox te = new TextBox(); //te.ID = "totalBayar"; //te.Attributes.Add("style", "text-align:right;"); //te.Text = Cf.Num(total); //td.Controls.Add(te); //tr.Cells.Add(td); //td = new HtmlTableCell(); //td.ColSpan = 2; //tr.Cells.Add(td); //list.Controls.Add(tr); }
protected void Fill() { kode.Text = Request.QueryString["id"]; //tgl.Text = Cf.Day(DateTime.Today); list.Controls.Clear(); string strSql = "SELECT a.NoCF, a.SN, a.SN_NoCF, a.Nilai, b.NoKontrak, b.NoUnit, b.NamaCust, b.NoAgent, b.NamaSkema" + " FROM MS_KOMISI_CFP_DETAIL a" + " INNER JOIN MS_KOMISI_CF b ON a.NoCF = b.NoCF" + " WHERE 1=1 " + " AND (SELECT COUNT(*) FROM MS_KOMISI_CFR_DETAIL WHERE NoCF = a.NoCF AND SN_NoCF = a.SN_NoCF) = 0" + " AND b.Project = '" + Project + "'" + " AND NoCFP = '" + Request.QueryString["id"] + "'"; DataTable rs = Db.Rs(strSql); Rpt.NoData(list, rs, "Tidak terdapat data dengan kriteria seperti tersebut diatas."); int index = 0; for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } HtmlTableRow r = new HtmlTableRow(); HtmlTableCell c; CheckBox cb; TextBox tb6; string NamaPenerima = Db.SingleString("SELECT ISNULL(NamaAgent,'') FROM MS_KOMISI_CF_DETAIL WHERE NoCF = '" + rs.Rows[i]["NoCF"].ToString() + "' AND SN = " + Convert.ToInt32(rs.Rows[i]["SN_NoCF"])); int NoAgent = Db.SingleInteger("SELECT ISNULL(NoAgent,0) FROM MS_KOMISI_CF_DETAIL WHERE NoCF = '" + rs.Rows[i]["NoCF"].ToString() + "' AND SN = " + Convert.ToInt32(rs.Rows[i]["SN_NoCF"])); cb = new CheckBox(); cb.ID = "cb_" + index; cb.Attributes["title"] = rs.Rows[i]["NoCF"] + ";" + rs.Rows[i]["SN_NoCF"] + ";" + NoAgent; c = new HtmlTableCell(); c.Controls.Add(cb); r.Cells.Add(c); c = new HtmlTableCell(); c.InnerHtml = NamaPenerima; r.Cells.Add(c); c = new HtmlTableCell(); c.InnerHtml = rs.Rows[i]["NoKontrak"].ToString(); r.Cells.Add(c); c = new HtmlTableCell(); c.InnerHtml = rs.Rows[i]["NoUnit"].ToString(); r.Cells.Add(c); c = new HtmlTableCell(); c.InnerHtml = Db.SingleString("SELECT ISNULL(Nama,'') FROM MS_AGENT WHERE NoAgent = '" + NoAgent + "'"); r.Cells.Add(c); c = new HtmlTableCell(); c.InnerHtml = rs.Rows[i]["NamaSkema"].ToString(); r.Cells.Add(c); c = new HtmlTableCell(); c.InnerHtml = Cf.Num(Convert.ToDecimal(rs.Rows[i]["Nilai"])); c.Attributes["class"] = "right"; r.Cells.Add(c); tb6 = new TextBox(); tb6.ID = "pph_" + i; tb6.Text = "0"; tb6.Attributes["onfocus"] = "tempnum=CalcFocus(this);"; tb6.Attributes["onkeyup"] = "CalcType(this,tempnum);"; //tb6.Attributes["onblur"] = "CalcBlur(this);hitungaja('" + i + "');"; tb6.Width = 100; tb6.CssClass = "txt_num"; Js.NumberFormat(tb6); c = new HtmlTableCell(); c.Controls.Add(tb6); c.Attributes["class"] = "right"; r.Cells.Add(c); list.Controls.Add(r); index++; } }