private void Fill() { Act.ProjectList(project); btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?tb=ISC064_MARKETINGJUAL..REF_JENISPROPERTI_LOG&Pk=" + NoJenis + "'"; btndel.Attributes["onclick"] = "location.href='JenisPropertiDel.aspx?NoJenis=" + NoJenis + "'"; string strSql = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_JENISPROPERTI WHERE SN = '" + NoJenis + "'"; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString())) { Response.Redirect("/CustomError/SecLevel.html"); } else { nojenis.Text = rs.Rows[0]["SN"].ToString(); jenis.Text = rs.Rows[0]["JenisProperti"].ToString(); namajenis.Text = rs.Rows[0]["Nama"].ToString(); Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString()); } }
private void Fill() { btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=" + Mi.DbPrefix + "FINANCEAR..REF_ACC_LOG&Pk=" + Acc + "'"; btndel.Attributes["onclick"] = "location.href='AccDel.aspx?Acc=" + Acc + "'"; string[] x = Cf.SplitByString(Acc, ";"); DataTable rs = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "FINANCEAR..REF_ACC WHERE Acc = '" + x[0] + "' AND SubID='" + x[1] + "'"); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString())) { Response.Redirect("/CustomError/SecLevel.html"); } else { acc.Text = rs.Rows[0]["Acc"].ToString(); rekening.Text = rs.Rows[0]["Rekening"].ToString(); subid.Text = rs.Rows[0]["SubID"].ToString(); bank.Text = rs.Rows[0]["Bank"].ToString(); cabang1.Text = rs.Rows[0]["Cabang"].ToString(); atasnama.Text = rs.Rows[0]["AtasNama"].ToString(); saldoawal.Text = Cf.Num(rs.Rows[0]["SaldoAwal"]); Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString()); } }
private void Fill() { btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?tb=ISC064_MARKETINGJUAL..REF_AGENT_LEVEL_LOG&Pk=" + NoLevel + "'"; btndel.Attributes["onclick"] = "location.href='LevelSalesDel.aspx?NoLevel=" + NoLevel + "'"; string strSql = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_LEVEL WHERE LevelID = '" + NoLevel + "'"; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString())) { Response.Redirect("/CustomError/SecLevel.html"); } else { nolevel.Text = rs.Rows[0]["LevelID"].ToString(); nama.Text = rs.Rows[0]["Nama"].ToString(); Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString()); string Tipe = Db.SingleString("SELECT Tipe FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_TIPE WHERE ID = '" + rs.Rows[0]["Tipe"].ToString() + "'"); tipe.Items.Add(new ListItem("Sekarang : " + Tipe, rs.Rows[0]["Tipe"].ToString())); string Parent = Db.SingleString("SELECT Nama FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_LEVEL WHERE LevelID = '" + rs.Rows[0]["ParentID"].ToString() + "'"); Cf.SelectedValue(parent, Parent); } //string Tipe = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_TIPE WHERE ID = '" + rs.Rows[0]["Tipe"].ToString() + "'"; //DataTable rs2 = Db.Rs(Tipe); //Cf.SelectedValue(tipe, rs2.Rows[0]["Tipe"].ToString()); //Cf.SelectedValue(parent, rs.Rows[0]["Nama"].ToString()); }
private void Fill() { Act.ProjectList(project); btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?tb=ISC064_MARKETINGJUAL..REF_JENIS_LOG&Pk=" + NoTipe + "'"; btndel.Attributes["onclick"] = "location.href='TipeSalesDel.aspx?NoTipe=" + NoTipe + "'"; string strSql = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_AGENT_TIPE WHERE ID = '" + NoTipe + "'"; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString())) { Response.Redirect("/CustomError/SecLevel.html"); } else { notipe.Text = rs.Rows[0]["ID"].ToString(); tipe.Text = rs.Rows[0]["Tipe"].ToString(); Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString()); } }
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"]; } }
private void Fill() { btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=REF_EMAIL_LOG&Pk=" + ID + "'"; btndel.Attributes["onclick"] = "location.href='AlamatEmailDel.aspx?ID=" + ID + "'"; string[] x = Cf.SplitByString(ID, ";"); DataTable rs = Db.Rs("SELECT * FROM REF_EMAIL WHERE ID = '" + x[0] + "'"); if (rs.Rows.Count == 0) Response.Redirect("/CustomError/Deleted.html"); else if (!Act.AksesProject(rs.Rows[0]["Project"].ToString())) Response.Redirect("/CustomError/SecLevel.html"); else { id.Text = rs.Rows[0]["ID"].ToString(); email.Text = rs.Rows[0]["Email"].ToString(); Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString()); } }
private void Fill() { btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?tb=ISC064_MARKETINGJUAL..REF_FOLLOWUP_LOG&Pk=" + No + "'"; btndel.Attributes["onclick"] = "location.href='FollowUpDel.aspx?No=" + No + "'"; string strSql = "SELECT * FROM " + Mi.DbPrefix + "MARKETINGJUAL..REF_FOLLOWUP WHERE No = '" + No + "'"; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else { nolokasi.Text = rs.Rows[0]["No"].ToString(); lokasi.Text = rs.Rows[0]["NamaGrouping"].ToString(); Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString()); } }
private void Fill() { btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=MS_CUSTOMER_LOG&Pk=" + NoCustomer.PadLeft(5, '0') + "'"; btndel.Attributes["onclick"] = "location.href='CustomerDel.aspx?NoCustomer=" + NoCustomer + "'"; string strSql = "SELECT * FROM MS_CUSTOMER WHERE NoCustomer = " + NoCustomer; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else { nocustomer.Text = rs.Rows[0]["NoCustomer"].ToString().PadLeft(5, '0'); if ((string)rs.Rows[0]["TipeCs"] == "PERORANGAN") { perorangan.Checked = true; } if ((string)rs.Rows[0]["TipeCs"] == "BADAN HUKUM") { badanhukum.Checked = true; } if (Convert.ToSByte(rs.Rows[0]["Refferator"]) == 1) { reff.Checked = true; DataTable a = Db.Rs("SELECT * FROM MS_KONTRAK WHERE NoRefferatorAgent='" + rs.Rows[0]["NoCustomer"].ToString() + "' or NoRefferatorCustomer='" + rs.Rows[0]["NoCustomer"].ToString() + "' and Status='A'"); if (a.Rows.Count == 0) { reff.Enabled = true; } else { reff.Enabled = false; } } else { reff.Checked = false; } nama.Text = rs.Rows[0]["Nama"].ToString(); nama2.Text = rs.Rows[0]["Nama2"].ToString(); salutation.Text = rs.Rows[0]["Salutation"].ToString(); namabisnis.Text = rs.Rows[0]["NamaBisnis"].ToString(); jenisbisnis.Text = rs.Rows[0]["JenisBisnis"].ToString(); merekbisnis.Text = rs.Rows[0]["MerekBisnis"].ToString(); namanpwp.Text = rs.Rows[0]["NamaNPWP"].ToString(); npwp.Text = rs.Rows[0]["NPWP"].ToString(); pekerjaan.Text = rs.Rows[0]["Pekerjaan"].ToString(); npwp1.Text = rs.Rows[0]["NPWPAlamat1"].ToString(); npwp2.Text = rs.Rows[0]["NPWPAlamat2"].ToString(); npwp3.Text = rs.Rows[0]["NPWPAlamat3"].ToString(); npwp4.Text = rs.Rows[0]["NPWPAlamat4"].ToString(); npwp5.Text = rs.Rows[0]["NPWPAlamat5"].ToString(); if ((string)rs.Rows[0]["Status"] == "A") { aktif.Checked = true; } else { inaktif.Checked = true; } notelp.Text = rs.Rows[0]["NoTelp"].ToString(); nohp.Text = rs.Rows[0]["NoHp"].ToString().Length > 2 ? rs.Rows[0]["NoHp"].ToString().Substring(0, 3) != "+62" ? rs.Rows[0]["NoHp"].ToString().Substring(1) : rs.Rows[0]["NoHp"].ToString().Substring(3) : ""; nohp2.Text = rs.Rows[0]["NoHP2"].ToString(); nokantor.Text = rs.Rows[0]["NoKantor"].ToString(); nofax.Text = rs.Rows[0]["NoFax"].ToString(); email.Text = rs.Rows[0]["Email"].ToString(); noktp.Text = rs.Rows[0]["NoKTP"].ToString(); ktp1.Text = rs.Rows[0]["KTP1"].ToString(); ktp2.Text = rs.Rows[0]["KTP2"].ToString(); ktp3.Text = rs.Rows[0]["KTP3"].ToString(); ktp4.Text = rs.Rows[0]["KTP4"].ToString(); ktp5.Text = rs.Rows[0]["KTP5"].ToString(); kodepos1.Text = rs.Rows[0]["Kodepos"].ToString(); alamat1.Text = rs.Rows[0]["Alamat1"].ToString(); alamat2.Text = rs.Rows[0]["Alamat2"].ToString(); alamat3.Text = rs.Rows[0]["Alamat3"].ToString(); alamat4.Text = rs.Rows[0]["Alamat4"].ToString(); alamat5.Text = rs.Rows[0]["Alamat5"].ToString(); kantor1.Text = rs.Rows[0]["Kantor1"].ToString(); kantor2.Text = rs.Rows[0]["Kantor2"].ToString(); kantor3.Text = rs.Rows[0]["Kantor3"].ToString(); kantor4.Text = rs.Rows[0]["Kantor4"].ToString(); kantor5.Text = rs.Rows[0]["Kantor5"].ToString(); nmorghub.Text = rs.Rows[0]["NamaKerabat"].ToString(); hubungan.SelectedValue = rs.Rows[0]["Hubungan"].ToString(); hphub.Text = rs.Rows[0]["NoHPKerabat"].ToString(); emailhub.Text = rs.Rows[0]["EmailKerabat"].ToString(); try { agama.SelectedValue = rs.Rows[0]["Agama"].ToString(); } catch { agama.SelectedIndex = agama.Items.Count - 1; } tgllahir.Text = Cf.Day(rs.Rows[0]["TglLahir"]); tglktp.Text = Cf.Day(rs.Rows[0]["TglKTP"]); if (Convert.ToBoolean(rs.Rows[0]["KTPSeumurHidup"]) == true) { sedup.Checked = true; tglktp.Text = ""; } unitlama.Text = rs.Rows[0]["UnitLama"].ToString(); luaslama.Text = Cf.Num(rs.Rows[0]["LuasLama"]); tokolama.Text = rs.Rows[0]["TokoLama"].ToString(); zoninglama.Text = rs.Rows[0]["ZoningLama"].ToString(); gedunglama.Text = rs.Rows[0]["GedungLama"].ToString(); teleponlama.Text = rs.Rows[0]["TeleponLama"].ToString(); aktelama.Text = rs.Rows[0]["AkteLama"].ToString(); tgltransaksi.Text = Cf.Day(rs.Rows[0]["TglTransaksi"]); tglInput.Text = Cf.Date(rs.Rows[0]["TglInput"]); tglEdit.Text = Cf.Date(rs.Rows[0]["TglEdit"]); sumberdata.Items.Add(new ListItem(rs.Rows[0]["SumberData"].ToString())); sumberdata.SelectedValue = rs.Rows[0]["SumberData"].ToString(); Cf.SelectedValue(project, rs.Rows[0]["Project"].ToString()); int c1 = Db.SingleInteger("SELECT COUNT(*) FROM MS_KONTRAK WHERE NoCustomer = " + NoCustomer); if (c1 > 0) { sifat.Text = "Sudah Beli"; } else { sifat.Text = "Belum Beli"; } tempatlahir.Text = rs.Rows[0]["TempatLahir"].ToString(); marital.SelectedValue = rs.Rows[0]["Marital"].ToString(); switch (rs.Rows[0]["Kewarganegaraan"].ToString()) { case "WNI": wni.Checked = true; break; case "WNA": wna.Checked = true; break; case "KORPORASI INDONESIA": kori.Checked = true; break; case "KORPORASI ASING": kora.Checked = true; break; } penanggungjawab.Text = rs.Rows[0]["PenanggungjawabKorp"].ToString(); jabatan.Text = rs.Rows[0]["JabatanKorp"].ToString(); nosk.Text = rs.Rows[0]["NoSKKorp"].ToString(); bentuk.Text = rs.Rows[0]["BentukKorp"].ToString(); if (kori.Checked || kora.Checked) { korp1.Visible = korp2.Visible = korp3.Visible = korp4.Visible = true; } else { korp1.Visible = korp2.Visible = korp3.Visible = korp4.Visible = false; } kori.Visible = false; kora.Visible = false; wni.Visible = true; wni.Checked = true; wna.Visible = true; korp1.Visible = korp2.Visible = korp3.Visible = korp4.Visible = false; } }