private void Fill() { string strSql = "SELECT * FROM MS_UNIT WHERE NoStock = '" + NoStock + "'"; DataTable rs = Db.Rs(strSql); priority.Text = NoPriority; nomorunit.Text = rs.Rows[0]["NoUnit"].ToString(); namacust.Text = Db.SingleString("SELECT Nama FROM MS_NUP INNER JOIN MS_CUSTOMER ON MS_NUP.NoCustomer=MS_CUSTOMER.NoCustomer WHERE NoNUP ='" + NoPriority + "'"); tipe.Text = rs.Rows[0]["Tipe"].ToString(); luas.Text = Cf.Num(rs.Rows[0]["LuasSG"]); harga.Text = Cf.NumBulat(rs.Rows[0]["Pricelist"]); unitpilih.Text = rs.Rows[0]["NoUnit"].ToString(); }
protected void fill() { //var d = db.SmsFormats.SingleOrDefault(p => p.Project == dept.SelectedValue && p.Tipe == Tipe); //if (d != null) //{ // waktu.Text = Cf.NumBulat(d.NilaiWaktu); // satuan.SelectedValue = d.SatuanWaktu; // format.Text = d.Format; // inaktif.SelectedIndex = d.Inaktif ? 1 : 0; //} DataTable rsHeader = Db.Rs("SELECT * FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='" + Tipe + "'"); if (rsHeader.Rows.Count == 0) { tipe.Text = Tipe; waktu.Text = ""; satuan.SelectedIndex = 0; format.Text = ""; inaktif.SelectedIndex = 0; } else { tipe.Text = rsHeader.Rows[0]["Tipe"].ToString(); waktu.Text = Cf.NumBulat(rsHeader.Rows[0]["NilaiWaktu"]); satuan.SelectedValue = (rsHeader.Rows[0]["SatuanWaktu"].ToString()); format.Text = rsHeader.Rows[0]["Format"].ToString(); inaktif.SelectedIndex = Convert.ToBoolean(rsHeader.Rows[0]["Inaktif"]) ? 1 : 0; project.SelectedValue = (rsHeader.Rows[0]["Project"].ToString()); //decimal waktu2 = Db.SingleDecimal("SELECT ISNULL(NilaiWaktu, '0') FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='"+Tipe+ "'"); //string satuan2 = Db.SingleString("SELECT ISNULL(SatuanWaktu, '0') FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='" + Tipe + "'"); //string format2 = Db.SingleString("SELECT ISNULL(Format, '0') FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='" + Tipe + "'"); //string inaktif2 = Db.SingleString("SELECT ISNULL(Inaktif, '0') FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='" + Tipe + "'"); //string project2 = Db.SingleString("SELECT ISNULL(Project, '0') FROM SmsFormat WHERE Project = '" + project.SelectedValue + "' AND Tipe ='" + Tipe + "'"); //waktu.Text = Convert.ToString(waktu2); //satuan.Text = satuan2; //format.Text = format2; //inaktif.SelectedIndex = Convert.ToBoolean(inaktif2) ? 1:0 ; //project.Text = project2; } if (Tipe != "UlangTahun") { divwaktu.Visible = true; } }
private void Fill() { btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=MS_RESERVASI_LOG&Pk=" + NoReservasi.ToString().PadLeft(5, '0') + "'"; btndel.Attributes["onclick"] = "location.href='ReservasiDel.aspx?NoReservasi=" + NoReservasi + "'"; DataTable rs = Db.Rs("SELECT a.*, b.NoCustomer, b.Nama, DateDiff(Day,a.Tgl,a.TglExpire) as SisaWaktu " + " FROM MS_RESERVASI a" + " INNER JOIN MS_CUSTOMER b" + " ON a.NoCustomer = b.NoCustomer" + " WHERE a.NoReservasi = " + NoReservasi ); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else { wl.Attributes["onclick"] = "location.href='UnitWL.aspx?NoStock=" + rs.Rows[0]["NoStock"] + "'"; if (rs.Rows[0]["Status"].ToString() == "A") { status.ForeColor = Color.Green; status.Text = "Aktif"; } else { status.ForeColor = Color.Red; status.Text = "Expire"; } noreservasi.Text = rs.Rows[0]["NoReservasi"].ToString(); noreservasifull.Text = rs.Rows[0]["NoReservasi2"].ToString(); int totalwl = Db.SingleInteger( "SELECT COUNT(*) FROM MS_RESERVASI WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'"); nourut.Text = rs.Rows[0]["NoUrut"] + "/" + totalwl; tgl.Text = Cf.Day(rs.Rows[0]["Tgl"]); batas.Text = Cf.Date(rs.Rows[0]["TglExpire"]); sisawaktu.Text = Cf.NumBulat(rs.Rows[0]["SisaWaktu"]); noqueue.Text = rs.Rows[0]["NoQueue"].ToString(); nilai.Text = Cf.Num(rs.Rows[0]["Netto"]); skema.SelectedValue = rs.Rows[0]["Skema"].ToString(); skema.Enabled = false; agent.Items.Add(new ListItem( "Tidak Berubah : " + rs.Rows[0]["NoAgent"].ToString().PadLeft(5, '0') , rs.Rows[0]["NoAgent"].ToString())); agent.SelectedValue = rs.Rows[0]["NoAgent"].ToString(); agent.Enabled = false; supervisor.Text = rs.Rows[0]["Supervisor"].ToString(); manager.Text = rs.Rows[0]["Manager"].ToString(); //tanggal input, edit dan follow-up tglInput.Text = Cf.Date(rs.Rows[0]["TglInput"]); tglEdit.Text = Cf.Date(rs.Rows[0]["TglEdit"]); printWL.InnerHtml = printWL.InnerHtml + " (" + rs.Rows[0]["PrintWL"] + ")"; printJadwalTagihan.InnerHtml = printJadwalTagihan.InnerHtml + " (" + rs.Rows[0]["PrintJadwalTagihan"] + ")"; printbform.InnerHtml = printbform.InnerHtml + " (" + rs.Rows[0]["printbform"] + ")"; string Project = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_UNIT WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'"); printWL.HRef = "PrintWL.aspx?NoReservasi=" + NoReservasi + "&project=" + Project; printJadwalTagihan.HRef = "PrintJadwalTagihanReservasi.aspx?NoReservasi=" + NoReservasi + "&project=" + Project; printbform.HRef = "PrintBForm.aspx?NoReservasi=" + NoReservasi + "&project=" + Project; //req panahome int countTTS = Db.SingleInteger("select Count(*) from " + Mi.DbPrefix + "FINANCEAR..MS_TTS where NoReservasi = '" + NoReservasi + "' and Project = '" + Project + "'"); if (countTTS != 0) { int NoTTS = Db.SingleInteger("select ISNULL(NoTTS, 0) from " + Mi.DbPrefix + "FINANCEAR..MS_TTS where NoReservasi = '" + NoReservasi + "' and Project = '" + Project + "'"); int PrintTTS = Db.SingleInteger("select ISNULL(PrintTTS, 0) from " + Mi.DbPrefix + "FINANCEAR..MS_TTS where NoReservasi = '" + NoReservasi + "' and Project = '" + Project + "'"); printtts.HRef = "PrintTTS.aspx?NoTTS=" + NoTTS + "&project=" + Project; printtts.InnerHtml = printtts.InnerHtml + " (" + PrintTTS + ")"; } else { printtts.Visible = true; } } }
private void Fill() { string strSql = "SELECT *" + ",CASE CaraBayar" + " WHEN 'TN' THEN 'TUNAI'" + " WHEN 'KK' THEN 'KARTU KREDIT'" + " WHEN 'KD' THEN 'KARTU DEBIT'" + " WHEN 'TR' THEN 'TRANSFER BANK'" + " WHEN 'BG' THEN 'CEK GIRO'" + " WHEN 'UJ' THEN 'UANG JAMINAN'" + " WHEN 'DN' THEN 'DISKON'" + " END AS CaraBayar2" + " FROM " + Mi.DbPrefix + "FINANCEAR..MS_TTS WHERE NoTTS = " + nomor; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count != 0) { namacs.Text = Cf.Str(rs.Rows[0]["Customer"]); Customer.Text = Cf.Str(rs.Rows[0]["Customer"]); noAcc.Text = Cf.Str(rs.Rows[0]["Acc"]); //req nomor panahome (reset perbulan) nobkm.Text = rs.Rows[0]["NoTTS2"].ToString(); tglbkm.Text = Cf.DayIndo(rs.Rows[0]["Tgltts"]); nosp.Text = rs.Rows[0]["Ref"].ToString(); nilainup.Text = nominal.Text = Cf.Num(rs.Rows[0]["Total"]); //int temp = Convert.ToInt16(Cf.Num(rs.Rows[0]["Total"])); jumlahUnit.Text = rs.Rows[0]["Unit"].ToString(); terbilangnilainup.Text = Money.Str(Convert.ToDecimal(rs.Rows[0]["Total"])) + " RUPIAH"; if (rs.Rows[0]["Acc"].ToString() != "-") { bankacc.Text = Db.SingleString("select ISNULL(Bank, '') from REF_ACC where Acc = '" + rs.Rows[0]["Acc"].ToString() + "'") + " (" + rs.Rows[0]["CaraBayar2"].ToString() + ")"; } else { bankacc.Text = "Cash"; } tglttd.Text = Cf.DayIndo(rs.Rows[0]["TglTTS"]); tglbankacc.Text = Cf.DayIndo(rs.Rows[0]["TglTTS"]); decimal PpnNUP = Convert.ToDecimal(rs.Rows[0]["Total"]) / (decimal)1.1; decimal DppNUP = Convert.ToDecimal(rs.Rows[0]["Total"]) - PpnNUP; dppnup.Text = Cf.NumBulat(PpnNUP); ppnnup.Text = Cf.NumBulat(DppNUP); baya.Text = rs.Rows[0]["ket"].ToString(); //fill data customer int CountNUP = Db.SingleInteger("select count(*) from " + Mi.DbPrefix + "MARKETINGJUAL..MS_NUP where NoNUP = '" + rs.Rows[0]["NoNUP"] + "'"); if (CountNUP != 0) { string strSqlNUP = ""; strSqlNUP = "SELECT " + " b.KTP1" + " ,b.KTP2" + " ,b.KTP3" + " ,b.KTP4" + " ,b.KTP5" + " ,b.Kodepos" + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_NUP a INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER b ON a.NoCustomer = b.NoCustomer WHERE a.NoNUP = '" + rs.Rows[0]["NoNUP"] + "'"; DataTable rsNUP = Db.Rs(strSqlNUP); for (int j = 0; j < rsNUP.Rows.Count; j++) { alamat1.Text = rsNUP.Rows[j]["KTP1"].ToString(); alamat2.Text = rsNUP.Rows[j]["KTP2"].ToString() + " " + rsNUP.Rows[j]["KTP3"].ToString(); alamat3.Text = rsNUP.Rows[j]["KTP4"].ToString() + " " + rsNUP.Rows[j]["KTP5"].ToString() + " " + rsNUP.Rows[j]["Kodepos"].ToString(); } } else { string strSqlKontrak = "SELECT " + " b.KTP1" + " ,b.KTP2" + " ,b.KTP3" + " ,b.KTP4" + " ,b.KTP5" + " ,b.Kodepos" + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK a INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER b ON a.NoCustomer = b.NoCustomer WHERE a.NoKontrak = '" + rs.Rows[0]["Ref"] + "'"; DataTable rsKon = Db.Rs(strSqlKontrak); for (int j = 0; j < rsKon.Rows.Count; j++) { alamat1.Text = rsKon.Rows[j]["KTP1"].ToString(); alamat2.Text = rsKon.Rows[j]["KTP2"].ToString() + " " + rsKon.Rows[j]["KTP3"].ToString(); alamat3.Text = rsKon.Rows[j]["KTP4"].ToString() + " " + rsKon.Rows[j]["KTP5"].ToString() + " " + rsKon.Rows[j]["Kodepos"].ToString(); } } //fill data unit int CountUnit = Db.SingleInteger("select count(*) from " + Mi.DbPrefix + "MARKETINGJUAL..MS_UNIT where NoUnit = '" + rs.Rows[0]["Unit"] + "'"); if (CountUnit != 0) { string strSqlUnit = ""; strSqlUnit = "SELECT * " + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_UNIT WHERE NoUnit = '" + rs.Rows[0]["Unit"] + "'"; DataTable rsUnit = Db.Rs(strSqlUnit); for (int k = 0; k < rsUnit.Rows.Count; k++) { nounit.Text = rsUnit.Rows[k]["Nomor"].ToString(); jalan.Text = rsUnit.Rows[k]["NamaJalan"].ToString(); cluster.Text = rsUnit.Rows[k]["Lokasi"].ToString(); } } else { hide1.Visible = false; hide2.Visible = false; hide3.Visible = false; } } }
private void Fill() { string strSql = "SELECT * FROM MS_KONTRAK " + " WHERE NoKontrak = '" + nomor + "' and Project = '" + proj + "'" ; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count > 0) { NoKontrak1.Text = rs.Rows[0]["NoKontrak"].ToString(); hargajual1.Text = Cf.NumBulat(rs.Rows[0]["Gross"]); hargapengikat1.Text = Cf.NumBulat(rs.Rows[0]["NilaiKontrak"]); ppn1.Text = Cf.NumBulat(rs.Rows[0]["NilaiPPN"]); terbilang.Text = Money.Str(Convert.ToDecimal(rs.Rows[0]["NilaiKontrak"])) + " RUPIAH"; skema.Text = Db.SingleString("select ISNULL(Nama, '') from REF_SKEMA where Nomor = '" + rs.Rows[0]["Refskema"] + "'"); sales.Text = Db.SingleString("SELECT NAMA FROM MS_AGENT WHERE NoAgent = " + rs.Rows[0]["NoAgent"].ToString()); //vabca.Text = rs.Rows[0]["NoVA"].ToString(); string Nova = rs.Rows[0]["NoVA"].ToString(); string KodeProVA = Nova.Substring(0, 5); string TahunBulanVA = Nova.Substring(5, 4); string TipeVA = Nova.Substring(9, 3); string NomorVA = Nova.Substring(12, 4); vabca.Text = KodeProVA + "-" + TahunBulanVA + "-" + TipeVA + "-" + NomorVA; tglsp.Text = Cf.Day(Convert.ToDateTime(rs.Rows[0]["TglKontrak"])); DataTable rs1 = Db.Rs("SELECT * FROM MS_UNIT WHERE NoUnit='" + rs.Rows[0]["NoUnit"].ToString() + "'"); string Lokasi = ""; if (rs1.Rows.Count > 0) { string tipe1 = Db.SingleString("select jenis from ms_unit where nounit = '" + rs.Rows[0]["NoUnit"].ToString() + "'"); string tipe2 = Db.SingleString("select Nama from Ref_jenis where jenis = '" + tipe1 + "'"); tipeunit.Text = tipe2; luassg.Text = Cf.Num(rs1.Rows[0]["LuasSG"]) + " M<sup>2</sup>"; luasnett.Text = Cf.Num(rs1.Rows[0]["LuasNett"]) + " M<sup>2</sup>"; lantai.Text = rs1.Rows[0]["Lantai"].ToString(); nounit.Text = rs1.Rows[0]["Nomor"].ToString(); } tower.Text = "Paul Marc";// rs.Rows[0]["Lokasi"].ToString(); ////fill data customer int CountCus = Db.SingleInteger("select count(*) from MS_CUSTOMER where NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'"); if (CountCus != 0) { string strSqlCus = ""; strSqlCus = "SELECT * FROM MS_CUSTOMER WHERE NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'"; DataTable rsCus = Db.Rs(strSqlCus); for (int j = 0; j < rsCus.Rows.Count; j++) { namacs.Text = cs2.Text = rsCus.Rows[j]["Nama"].ToString(); noktp.Text = rsCus.Rows[j]["NoKTP"].ToString(); nonpwp.Text = rsCus.Rows[j]["NPWP"].ToString(); Almt.Text = rsCus.Rows[j]["KTP1"].ToString(); Almt2.Text = rsCus.Rows[j]["KTP2"].ToString(); Almt3.Text = rsCus.Rows[j]["KTP3"].ToString(); Almt4.Text = rsCus.Rows[j]["KTP4"].ToString() + "," + rsCus.Rows[j]["KTP5"].ToString(); AlmtSrt.Text = rsCus.Rows[j]["Alamat1"].ToString(); AlmtSrt2.Text = rsCus.Rows[j]["Alamat2"].ToString(); AlmtSrt3.Text = rsCus.Rows[j]["Alamat3"].ToString(); AlmtSrt4.Text = rsCus.Rows[j]["Alamat4"].ToString() + " " + rsCus.Rows[j]["Alamat5"].ToString(); hp.Text = rsCus.Rows[j]["NoHP"].ToString(); hpkerabat.Text = rsCus.Rows[j]["NoHPKerabat"].ToString(); email.Text = rsCus.Rows[j]["Email"].ToString(); telp.Text = rsCus.Rows[j]["NoTelp"].ToString(); NoKantor1.Text = rsCus.Rows[j]["NoKantor"].ToString(); } } ////fill data unit //int CountUnit = Db.SingleInteger("select count(*) from MS_UNIT where NoStock = '" + rs.Rows[0]["NoStock"] + "'"); //if (CountUnit != 0) //{ // string strSqlUnit = ""; // strSqlUnit = "SELECT * FROM MS_UNIT WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'"; // DataTable rsUnit = Db.Rs(strSqlUnit); // for (int k = 0; k < rsUnit.Rows.Count; k++) // { // jenisproperti.Text = rsUnit.Rows[k]["JenisProperti"].ToString(); // namajalan.Text = rsUnit.Rows[k]["NamaJalan"].ToString(); // nounit.Text = rsUnit.Rows[k]["Nomor"].ToString().PadLeft(2, '0'); // jenis.Text = rsUnit.Rows[k]["Jenis"].ToString(); // luasnett.Text = Cf.Num(rsUnit.Rows[k]["LuasNett"]); // luassg.Text = Cf.Num(rsUnit.Rows[k]["LuasSG"]); // lokasi.Text = rsUnit.Rows[k]["Lokasi"].ToString(); // } //} ////gimmick //int CountGimmick = Db.SingleInteger("select count(*) from MS_KONTRAK_GIMMICK where NoKontrak = '" + nomor + "'"); //if (CountGimmick != 0) //{ // gimmicktr.Visible = true; // FillTb(); //} //else //{ // gimmicktr.Visible = false; //} } }
private void Fill() { string strSql = "SELECT * FROM MS_KONTRAK " + " WHERE NoKontrak = '" + nomor + "' and Project = '" + proj + "'" ; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count > 0) { nokontrak.Text = rs.Rows[0]["NoKontrak"].ToString(); tglkontrak.Text = Cf.DayIndo(rs.Rows[0]["TglKontrak"]); // namaproject.Text = rs.Rows[0]["NamaProject"].ToString(); namapers.Text = rs.Rows[0]["NamaPers"].ToString(); nilaikontrak.Text = Cf.NumBulat(rs.Rows[0]["NilaiKontrak"]); skema.Text = Db.SingleString("select ISNULL(Nama, '') from REF_SKEMA where Nomor = '" + rs.Rows[0]["Refskema"] + "'"); //ag.Text = Db.SingleString("SELECT NAMA FROM MS_AGENT WHERE NoAgent = " + rs.Rows[0]["NoAgent"].ToString()); //fill data customer int CountCus = Db.SingleInteger("select count(*) from MS_CUSTOMER where NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'"); if (CountCus != 0) { string strSqlCus = ""; strSqlCus = "SELECT * FROM MS_CUSTOMER WHERE NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'"; DataTable rsCus = Db.Rs(strSqlCus); for (int j = 0; j < rsCus.Rows.Count; j++) { namacs.Text = namacs2.Text = rsCus.Rows[j]["Nama"].ToString(); noktp.Text = rsCus.Rows[j]["NoKTP"].ToString(); npwp.Text = rsCus.Rows[j]["NPWP"].ToString(); alamatktp1.Text = rsCus.Rows[j]["KTP1"].ToString() + " " + rsCus.Rows[j]["KTP2"].ToString() + " " + rsCus.Rows[j]["KTP3"].ToString(); alamatktp2.Text = rsCus.Rows[j]["KTP4"].ToString() + " " + rsCus.Rows[j]["KTP5"].ToString(); alamatsekarang1.Text = rsCus.Rows[j]["Alamat1"].ToString() + " " + rsCus.Rows[j]["Alamat2"].ToString() + " " + rsCus.Rows[j]["Alamat3"].ToString(); alamatsekarang2.Text = rsCus.Rows[j]["Alamat4"].ToString() + " " + rsCus.Rows[j]["Alamat5"].ToString(); hp1.Text = rsCus.Rows[j]["NoHP"].ToString(); hp2.Text = rsCus.Rows[j]["NoHP2"].ToString(); // email.Text = rsCus.Rows[j]["Email"].ToString(); } } //fill data unit int CountUnit = Db.SingleInteger("select count(*) from MS_UNIT where NoStock = '" + rs.Rows[0]["NoStock"] + "'"); if (CountUnit != 0) { string strSqlUnit = ""; strSqlUnit = "SELECT * FROM MS_UNIT WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'"; DataTable rsUnit = Db.Rs(strSqlUnit); for (int k = 0; k < rsUnit.Rows.Count; k++) { // jenisproperti.Text = rsUnit.Rows[k]["JenisProperti"].ToString(); namajalan.Text = rsUnit.Rows[k]["NamaJalan"].ToString(); nounit.Text = rsUnit.Rows[k]["Nomor"].ToString().PadLeft(2, '0'); jenis.Text = rsUnit.Rows[k]["Jenis"].ToString(); luasnett.Text = Cf.Num(rsUnit.Rows[k]["LuasNett"]); luassg.Text = Cf.Num(rsUnit.Rows[k]["LuasSG"]); lokasi.Text = rsUnit.Rows[k]["Lokasi"].ToString(); } } //gimmick int CountGimmick = Db.SingleInteger("select count(*) from MS_KONTRAK_GIMMICK where NoKontrak = '" + nomor + "'"); if (CountGimmick != 0) { // gimmicktr.Visible = true; FillTb(); } else { //gimmicktr.Visible = false; } } }
private void Fill() { aKey.HRef = "javascript:openModal('KontrakEditKey.aspx?NoKontrak=" + NoKontrak + "','350','220')"; aStatus.HRef = "javascript:openModal('KontrakStatus.aspx?NoKontrak=" + NoKontrak + "','500','500')"; //printSuratLunas.HRef = "PrintSuratLunas.aspx?NoKontrak=" + NoKontrak; btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=MS_KONTRAK_LOG&Pk=" + NoKontrak + "'"; btndel.Attributes["onclick"] = "location.href='KontrakDel.aspx?NoKontrak=" + NoKontrak + "&NoStock=" + NoStock + "'"; refresh.Attributes["onclick"] = "if(confirm('" + "Apakah anda ingin mengambil ulang data unit ?\\n" + "Perhatian bahwa nilai GROSS dan DISKON bisa berubah." + "'))" + "{location.href='KontrakRefresh.aspx?NoKontrak=" + NoKontrak + "'}"; string strSql = "SELECT *" + " FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'"; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count == 0) { Response.Redirect("/CustomError/Deleted.html"); } else { nokontrak.Text = rs.Rows[0]["NoKontrak"].ToString(); nkm.Text = rs.Rows[0]["NoKontrakManual"].ToString(); if (Convert.ToInt16(rs.Rows[0]["FlagProsesBatal"]) == 1) { prosesbatal.Checked = true; } else { prosesbatal.Checked = false; } string stat = rs.Rows[0]["Status"].ToString(); if (stat == "A") { status.ForeColor = Color.RoyalBlue; status.Text = "Aktif"; } else if (stat == "B") { status.ForeColor = Color.Red; status.Text = "Batal"; } else if (stat == "E") { status.ForeColor = Color.Gray; status.Text = "Proses Batal"; } tglkontrak.Text = Cf.Day(rs.Rows[0]["TglKontrak"]); targetst.Text = Cf.Day(rs.Rows[0]["TargetST"]); nokused.SelectedValue = rs.Rows[0]["nokused"].ToString(); lokpen.SelectedValue = rs.Rows[0]["LokasiPenjualan"].ToString(); //tanggal input, edit dan follow-up tglInput.Text = Cf.Date(rs.Rows[0]["TglInput"]); tglEdit.Text = Cf.Date(rs.Rows[0]["TglEdit"]); decimal Luas = Convert.ToDecimal(rs.Rows[0]["Luas"]); luas.Text = Cf.Num(Luas); string ket = ""; switch ((int)rs.Rows[0]["FlagGross"]) { case 1: ket = "Edit Kontrak"; break; case 2: ket = "Refresh Unit"; break; case 3: ket = "Pindah Unit"; break; case 4: ket = "Serah Terima"; break; } decimal t = 0; decimal bungaNominal = Db.SingleDecimal("SELECT ISNULL(BungaNominal,0) FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'");//checkNull(rs.Rows[0]["BungaNominal"]); gross.Text = Cf.Num(rs.Rows[0]["Gross"]); //biayalainlain.Text = Cf.Num(rs.Rows[0]["HargaLainLain"]); //biayagimmick.Text = Cf.Num(rs.Rows[0]["HargaGimmick"]); diskon.Text = Cf.Num(Convert.ToDecimal(rs.Rows[0]["DiskonRupiah"])); diskontambahan.Text = Cf.Num(Convert.ToDecimal(rs.Rows[0]["DiskonTambahan"])); afterdisc.Text = Cf.Num(Convert.ToDecimal(rs.Rows[0]["Gross"]) - Convert.ToDecimal(rs.Rows[0]["DiskonRupiah"]) - Convert.ToDecimal(rs.Rows[0]["DiskonTambahan"])); hargaSD.Text = Cf.Num(Convert.ToDecimal(rs.Rows[0]["Gross"]) + Convert.ToDecimal(rs.Rows[0]["HargaLainLain"]) + Convert.ToDecimal(rs.Rows[0]["HargaGimmick"])); lblBunga.Text = Cf.Num(bungaNominal); decimal nilaiKontrak = Convert.ToDecimal(rs.Rows[0]["NilaiKontrak"]) + Convert.ToDecimal(rs.Rows[0]["NilaiPPN"]); nilai.Text = Cf.Num(rs.Rows[0]["NilaiKontrak"]); hargatanah.Text = Cf.NumBulat(rs.Rows[0]["HargaTanah"]); note.Text = rs.Rows[0]["Note"].ToString(); titipjual.SelectedValue = rs.Rows[0]["TitipJual"].ToString(); if (rs.Rows[0]["PaketInvestasi"].ToString() == "1") { paketinvest.Checked = true; tglinv.Text = Cf.Day(rs.Rows[0]["TglPaketInvestasi"]); } lblDPP.Text = Cf.Num(Math.Round(Db.SingleDecimal("SELECT ISNULL(NilaiDPP,0) FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "' "))); lblPPN.Text = ppn.Text = Cf.Num(Math.Round(Convert.ToDecimal(rs.Rows[0]["NilaiPPN"]))); if (Convert.ToDecimal(rs.Rows[0]["NilaiPPN"]) == 0) { DPP2.Text = Cf.Num(rs.Rows[0]["NilaiKontrak"]); PPN2.Text = "0"; } else { DPP2.Text = Cf.Num(Math.Round(Convert.ToDecimal(nilai.Text) / (decimal)1.1)); PPN2.Text = Cf.Num(Math.Round(Convert.ToDecimal(DPP2.Text) * (decimal)0.1)); } //refresh info DataTable rsunit = Db.Rs("SELECT NoUnit, Luas, PriceList " + " FROM MS_UNIT WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'"); if (rsunit.Rows.Count != 0) { if (rsunit.Rows[0]["NoUnit"].ToString() != rs.Rows[0]["NoUnit"].ToString() || Convert.ToDecimal(rsunit.Rows[0]["Luas"]) != Convert.ToDecimal(rs.Rows[0]["Luas"]) || Convert.ToDecimal(rsunit.Rows[0]["PriceList"]) != Convert.ToDecimal(rs.Rows[0]["Gross"]) ) { refreshinfo.Text = "DATA ADMINISTRASI BERBEDA"; } else { refresh.Disabled = true; } } //agent agent.Items.Add(new ListItem( "Tidak Berubah : " + rs.Rows[0]["NoAgent"].ToString().PadLeft(5, '0') , rs.Rows[0]["NoAgent"].ToString())); agent.SelectedValue = rs.Rows[0]["NoAgent"].ToString(); string TipeAgent = Db.SingleString("SELECT Tipe FROM MS_AGENT WHERE NoAgent = '" + rs.Rows[0]["NoAgent"] + "'"); if (TipeAgent == "INHOUSE") { reff.Visible = true; } else { reff.Visible = false; } //refferator if (rs.Rows[0]["NoRefferatorAgent"].ToString() != "") { agentreff.Items.Add(new ListItem( "Tidak Berubah : " + rs.Rows[0]["NoRefferatorAgent"].ToString().PadLeft(5, '0') , rs.Rows[0]["NoRefferatorAgent"].ToString())); agentreff.SelectedValue = rs.Rows[0]["NoRefferatorAgent"].ToString() + ";EMPLOYEE"; } else { agentreff.Items.Add(new ListItem( "Tidak Berubah : " + rs.Rows[0]["NoRefferatorCustomer"].ToString().PadLeft(5, '0') , rs.Rows[0]["NoRefferatorCustomer"].ToString())); agentreff.SelectedValue = rs.Rows[0]["NoRefferatorCustomer"].ToString() + ";BUYER"; } skema.Text = rs.Rows[0]["Skema"].ToString(); batal.Text = rs.Rows[0]["AlasanBatal"].ToString(); if (batal.Text == "") { bataltr.Visible = false; } ppjb.Text = Cf.Day(rs.Rows[0]["TglPPJB"]) + " " + "<u>" + rs.Rows[0]["NoPPJB"] + "</u>"; ppjbused.SelectedValue = rs.Rows[0]["PPJBu"].ToString(); if (rs.Rows[0]["NoPPJB"] == "") { ppjbm.ReadOnly = true; jbm.Visible = false; } else { ppjbm.Text = rs.Rows[0]["NoPPJBm"].ToString(); } ajb.Text = Cf.Day(rs.Rows[0]["TglAJB"]) + " " + "<u>" + rs.Rows[0]["NoAJB"] + "</u>"; //serah terima if ((string)rs.Rows[0]["ST"] == "T") { st.Text = "<b>Terlambat</b>"; } else if ((string)rs.Rows[0]["ST"] == "D") { st.Text = Cf.Day(rs.Rows[0]["TglST"]) + " " + "<u>" + rs.Rows[0]["NoST"] + "</u>"; } printSP.InnerHtml = printSP.InnerHtml + " (" + rs.Rows[0]["PrintSP"] + ")"; printPPJB.InnerHtml = printPPJB.InnerHtml + " (" + rs.Rows[0]["PrintPPJB"] + ")"; printAJB.InnerHtml = printAJB.InnerHtml + " (" + rs.Rows[0]["PrintAJB"] + ")"; printBAST.InnerHtml = printBAST.InnerHtml + " (" + rs.Rows[0]["PrintBAST"] + ")"; printRKOM.InnerHtml = printRKOM.InnerHtml + " (" + rs.Rows[0]["PrintRKOM"] + ")"; printFPS.InnerHtml = printFPS.InnerHtml + " (" + rs.Rows[0]["PrintFPS"] + ")"; JenisPPN.SelectedValue = rs.Rows[0]["JenisPPN"].ToString(); if (Convert.ToBoolean(rs.Rows[0]["JenisKPR"])) { jeniskpr.Items[1].Selected = true; } else { jeniskpr.Items[0].Selected = true; } if (rs.Rows[0]["CaraBayar"].ToString() == "KPR") { carabayar2.Items[0].Selected = true; } else if (rs.Rows[0]["CaraBayar"].ToString() == "CASH BERTAHAP") { carabayar2.Items[1].Selected = true; } else if (rs.Rows[0]["CaraBayar"].ToString() == "CASH KERAS") { carabayar2.Items[2].Selected = true; } else if (rs.Rows[0]["CaraBayar"].ToString() == "") { carabayar2.ClearSelection(); } nilaikpa.Text = Cf.Num(rs.Rows[0]["NilaiRealisasiKPR"]); rekcair.Items.Add(new ListItem("Sekarang : " + rs.Rows[0]["RekeningCairKPR"], rs.Rows[0]["RekeningCairKPR"].ToString())); rekcair.Items[rekcair.Items.Count - 1].Selected = true; if (rs.Rows[0]["PPJB"].ToString() == "D") { tra.Visible = true; trb.Visible = true; } else { tra.Visible = false; trb.Visible = false; } //Faktur Pajak Standar if (rs.Rows[0]["AJB"].ToString() == "D") { printFPS.Visible = true; kdPajak.Enabled = true; //noFPS.ReadOnly = true; } else { printFPS.Visible = false; kdPajak.SelectedValue = ""; kdPajak.Enabled = false; //noFPS.ReadOnly = true; } if (rs.Rows[0]["Status"].ToString() == "B") { trc.Visible = trd.Visible = tre.Visible = trf.Visible = trk.Visible = true; printFBatal.Visible = true; } else { trc.Visible = trd.Visible = tre.Visible = trf.Visible = trk.Visible = false; printFBatal.Visible = false; } //Fill No Faktur Pajak string kp = Db.SingleString("SELECT NoFPS FROM MS_KONTRAK WHERE NoKontrak = '" + NoKontrak + "'"); if (kp == "") { kdPajak.SelectedValue = ""; noFPS.Text = ""; } else { string kp2 = kp.Substring(0, 3); if (kp2 == "010") { kdPajak.SelectedValue = "010"; noFPS.Text = Cf.Str(rs.Rows[0]["NoFPS"]).ToString().Substring(3, 16); } else { kdPajak.SelectedValue = "011"; noFPS.Text = Cf.Str(rs.Rows[0]["NoFPS"]).ToString().Substring(3, 16); } } nilaiklaim.Text = Cf.Num(rs.Rows[0]["NilaiKlaim"]); totallunas.Text = Cf.Num(rs.Rows[0]["TotalLunasBatal"]); nilaipulang.Text = Cf.Num(rs.Rows[0]["NilaiPulang"]); tglkembali.Text = Cf.Day(rs.Rows[0]["TglKembali"]); reffcust.Text = rs.Rows[0]["reffcust"].ToString(); anreff.Text = rs.Rows[0]["anreff"].ToString(); bankreff.Text = rs.Rows[0]["bankreff"].ToString(); npwpreff.Text = rs.Rows[0]["npwpreff"].ToString(); norekreff.Text = rs.Rows[0]["norekreff"].ToString(); acc.Items.Add(new ListItem("Tidak berubah: " + rs.Rows[0]["AccBatal"], rs.Rows[0]["AccBatal"].ToString())); acc.SelectedIndex = acc.Items.Count - 1; if (Convert.ToBoolean(rs.Rows[0]["FOBO"]) || Convert.ToBoolean(rs.Rows[0]["FOBOBatal"])) { btndel.Attributes["disabled"] = "true"; } focounter.Text = (Db.SingleInteger("SELECT ISNULL(COUNT(*),0) FROM MS_TAGIHAN WHERE NoKontrak = '" + NoKontrak + "' AND NamaTagihan LIKE 'FITTING OUT%'")).ToString(); decimal fitting = Db.SingleDecimal("SELECT ISNULL(SUM(NilaiTagihan), 0) FROM MS_TAGIHAN WHERE NoKontrak = '" + NoKontrak + "' AND NamaTagihan LIKE 'FITTING OUT%'"); fo.Text = Cf.Num(Math.Round(fitting)); //nilai ini berguna untuk mengecek nilai focounter dan fo //apabila focounter dan fo berubah maka data berubah foCheck = focounter.Text; focounterCheck = fo.Text; //status PPN if ((bool)rs.Rows[0]["PPN"]) { statusPPN.Text = "<b>(INCLUDE)</b>"; } else if (!(bool)rs.Rows[0]["PPN"]) { statusPPN.Text = "<b>(EXCLUDE)</b>"; } /*Sumber Dana*/ ddlSumberDana.SelectedValue = rs.Rows[0]["SumberDana"].ToString(); if ((int)rs.Rows[0]["SumberDana"] == 3) { trLainnya.Visible = true; } else { trLainnya.Visible = false; } lainnya.Text = rs.Rows[0]["SumberDanaLainnya"].ToString(); ddlTujuan.SelectedValue = rs.Rows[0]["TujuanKontrak"].ToString(); if (rs.Rows[0]["TujuanKontrak"].ToString() == "3") { trTujuanLain.Visible = true; } else { trTujuanLain.Visible = false; } tujuanlain.Text = rs.Rows[0]["TujuanLainnya"].ToString(); noqueue.Text = rs.Rows[0]["NUP"].ToString(); nova.Text = rs.Rows[0]["NoVA"].ToString(); if (nova.Text != "") { btnpop.Disabled = true; } } printSP.HRef = "PrintSP.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"] + "&Priview=0"; printSP2.HRef = "PrintSP.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"] + "&Priview=1"; printPPJB.HRef = "PrintPPJB.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"]; printAJB.HRef = "PrintAJB.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"]; printBAST.HRef = "PrintBAST.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"]; printRKOM.HRef = "PrintRKOM.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"]; printFPS.HRef = "PrintFPS.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"]; printFBatal.HRef = "PrintFBatal.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"]; printJadwalTagihan.HRef = "PrintJadwalTagihan.aspx?NoKontrak=" + NoKontrak + "&project=" + rs.Rows[0]["Project"]; }
private void Fill() { string strSql = "SELECT * FROM MS_KONTRAK " + " WHERE NoKontrak = '" + nomor + "' and Project = '" + proj + "'" ; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count > 0) { nokontrak.Text = rs.Rows[0]["NoKontrak"].ToString(); //tglkontrak.Text = Cf.DayIndo(rs.Rows[0]["TglKontrak"]); //namaproject.Text = rs.Rows[0]["NamaProject"].ToString(); //namapers.Text = rs.Rows[0]["NamaPers"].ToString(); hargapengikatan.Text = nilaikontrak1.Text = Cf.NumBulat(rs.Rows[0]["NilaiKontrak"]); carabayar.Text = cara_bayar.Text = cara_bayar1.Text = Db.SingleString("select ISNULL(Nama, '') from REF_SKEMA where Nomor = '" + rs.Rows[0]["Refskema"] + "'"); marketing.Text = marketing2.Text = Db.SingleString("SELECT NAMA FROM MS_AGENT WHERE NoAgent = " + rs.Rows[0]["NoAgent"].ToString()); //fill data customer int CountCus = Db.SingleInteger("select count(*) from MS_CUSTOMER where NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'"); if (CountCus != 0) { string strSqlCus = ""; strSqlCus = "SELECT * FROM MS_CUSTOMER WHERE NoCustomer = '" + rs.Rows[0]["NoCustomer"] + "'"; DataTable rsCus = Db.Rs(strSqlCus); for (int j = 0; j < rsCus.Rows.Count; j++) { namacs.Text = namacs2.Text = pemesan.Text = pemesan2.Text = rsCus.Rows[j]["Nama"].ToString(); noktp.Text = rsCus.Rows[j]["NoKTP"].ToString(); npwp.Text = rsCus.Rows[j]["NPWP"].ToString(); alamatktp1.Text = rsCus.Rows[j]["KTP1"].ToString() + " " + rsCus.Rows[j]["KTP2"].ToString() + " " + rsCus.Rows[j]["KTP3"].ToString(); alamatktp2.Text = rsCus.Rows[j]["KTP4"].ToString() + " " + rsCus.Rows[j]["KTP5"].ToString(); // alamatsekarang1.Text = rsCus.Rows[j]["Alamat1"].ToString() + " " + rsCus.Rows[j]["Alamat2"].ToString() + " " + rsCus.Rows[j]["Alamat3"].ToString(); // alamatsekarang2.Text = rsCus.Rows[j]["Alamat4"].ToString() + " " + rsCus.Rows[j]["Alamat5"].ToString(); telpon.Text = rsCus.Rows[j]["NoTelp"].ToString(); noHp.Text = rsCus.Rows[j]["NoHP"].ToString(); // email.Text = rsCus.Rows[j]["Email"].ToString(); // } } //fill data unit int CountUnit = Db.SingleInteger("select count(*) from MS_UNIT where NoStock = '" + rs.Rows[0]["NoStock"] + "'"); if (CountUnit != 0) { string strSqlUnit = ""; string strSqlBooking = "SELECT " + "NilaiTagihan" + " FROM MS_TAGIHAN" + " WHERE NoKontrak = '" + nomor + "'" + " AND TIPE = 'BF'"; booking_fee.Text = Cf.Num(Db.SingleDecimal(strSqlBooking)); strSqlUnit = "SELECT * FROM MS_UNIT WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'"; DataTable rsUnit = Db.Rs(strSqlUnit); for (int k = 0; k < rsUnit.Rows.Count; k++) { jenisproperti.Text = jenispro2.Text = rsUnit.Rows[k]["JenisProperti"].ToString(); //namajalan.Text = rsUnit.Rows[k]["NamaJalan"].ToString(); lantai_blok_unit.Text = lantai1.Text = rsUnit.Rows[k]["Lantai"].ToString(); lantai_blok_unit2.Text = unit1.Text = rsUnit.Rows[k]["Nomor"].ToString().PadLeft(2, '0'); //jenis.Text = rsUnit.Rows[k]["Jenis"].ToString(); luasbgn.Text = luas_bangun.Text = Cf.Num(rsUnit.Rows[k]["LuasNett"]); //luassg.Text = Cf.Num(rsUnit.Rows[k]["LuasSG"]); //lokasi.Text = rsUnit.Rows[k]["Lokasi"].ToString(); } } //gimmick //int CountGimmick = Db.SingleInteger("select count(*) from MS_KONTRAK_GIMMICK where NoKontrak = '" + nomor + "'"); //if (CountGimmick != 0) //{ // gimmicktr.Visible = true; // FillTb(); //} //else //{ // gimmicktr.Visible = false; //} } }