protected void Fill() { string strSql = "SELECT a.*, b.NoCustomer, c.NPWP" + " FROM MS_TTS a" + " INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK b ON a.Ref = b.NoKontrak" + " INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER c ON b.NoCustomer = c.NoCustomer" + " WHERE NoTTS = " + nomor ; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count != 0) { System.Configuration.AppSettingsReader s = new System.Configuration.AppSettingsReader(); string HeaderPajak = ""; string JenisPPN = Db.SingleString("SELECT JenisPPN FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = '" + Cf.Pk(rs.Rows[0]["Ref"]) + "'"); if (JenisPPN == "PEMERINTAH") { HeaderPajak = (string)s.GetValue("NoFPSPemerintah", typeof(string)); } else if (JenisPPN == "KONSUMEN") { HeaderPajak = (string)s.GetValue("NoFPSKonsumen", typeof(string)); } nopajak.Text = nopajak2.Text = nopajak3.Text = rs.Rows[0]["NoFPS"].ToString();// HeaderPajak + rs.Rows[0]["NoFPS"]; npwp.Text = npwp2.Text = npwp3.Text = rs.Rows[0]["NPWP"].ToString(); nama.Text = nama2.Text = nama3.Text = rs.Rows[0]["Customer"].ToString(); strSql = "SELECT NPWPAlamat1, NPWPAlamat2, NPWPAlamat3" + " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER" + " WHERE NoCustomer = " + Cf.Pk(rs.Rows[0]["NoCustomer"]) ; DataTable rsCs = Db.Rs(strSql); alamat.Text = alamat2.Text = alamat3.Text = rsCs.Rows[0]["NPWPAlamat1"] + "<br />" + rsCs.Rows[0]["NPWPAlamat2"] + "<br />" + rsCs.Rows[0]["NPWPALamat3"] ; tgl.Text = tgl2.Text = tgl3.Text = Convert.ToDateTime(rs.Rows[0]["TglBKM"]).Day + " " + Cf.Monthname(Convert.ToDateTime(rs.Rows[0]["TglBKM"]).Month) + " " + Convert.ToDateTime(rs.Rows[0]["TglBKM"]).Year ; ttd.Text = ttd2.Text = ttd3.Text = Db.SingleString("SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..REF_SIGN WHERE Dokumen = 'Faktur Pajak' AND SN = 1"); DataTable aa = Db.Rs("SELECT * FROM " + Mi.DbPrefix + "SECURITY..REF_DATA WHERE No = 1"); if (aa.Rows.Count > 0) { npwpnama.Text = npwpnama2.Text = npwpnama3.Text = aa.Rows[0]["NPWPNama"].ToString(); npwpno.Text = npwpno2.Text = npwpno3.Text = aa.Rows[0]["NPWP"].ToString(); npwpalamat.Text = npwpalamat2.Text = npwpalamat3.Text = Cf.StrKet(aa.Rows[0]["AlamatNPWP"]); } FillTable(); FillTable2(); FillTable3(); } }
private void Fill() { string Project = " AND c.Project In (" + Act.ProjectListSql + ")"; if (project.SelectedValue != "SEMUA") { Project = " AND c.Project = '" + project.SelectedValue + "'"; } string Perusahaan = ""; if (pers.SelectedValue != "SEMUA") { Perusahaan = " AND c.Pers = '" + pers.SelectedValue + "'"; } DateTime Dari = Convert.ToDateTime(dari.Text); DateTime Sampai = Convert.ToDateTime(sampai.Text); if (Dari > Sampai) { DateTime x = Sampai; Sampai = Dari; Dari = x; } decimal t1 = 0; decimal t2 = 0; decimal t3 = 0; string Rek = ""; if (rek.SelectedIndex != 0) { Rek = " AND a.Bank = '" + rek.SelectedValue + "'"; } string Status = ""; if (statusB.Checked) { Status = " AND a.Status = 'BARU'"; } if (statusID.Checked) { Status = " AND a.Status = 'ID'"; } if (statusS.Checked) { Status = " AND a.Status = 'S'"; } string tgl = ""; if (tglinput.Checked) { tgl = "Tgl"; } string strSql = "SELECT * " + " FROM MS_ANONIM a LEFT JOIN MS_TTS b ON a.NoAnonim = b.NoAnonim" + " LEFT JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK c ON b.Ref = c.NoKontrak" + " WHERE 1=1 " + " AND CONVERT(varchar," + tgl + ",112) >= '" + Cf.Tgl112(Dari) + "'" + " AND CONVERT(varchar," + tgl + ",112) <= '" + Cf.Tgl112(Sampai) + "'" + Project + Perusahaan + Rek + Status + " ORDER BY a.NoAnonim"; DataTable rs = Db.Rs(strSql); for (int i = 0; i < rs.Rows.Count; i++) { if (!Response.IsClientConnected) { break; } TableRow r = new TableRow(); TableCell c; r.VerticalAlign = VerticalAlign.Top; r.Attributes["ondblclick"] = "popEditTA('" + rs.Rows[i]["NoAnonim"] + "')"; c = new TableCell(); c.Text = (i + 1) + "."; c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); c = new TableCell(); c.Text = rs.Rows[i]["NoAnonim"].ToString().PadLeft(7, '0'); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Day(rs.Rows[i]["Tgl"]); c.Wrap = false; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); string NamaBank = Db.SingleString("SELECT Bank FROM REF_ACC WHERE Acc = '" + rs.Rows[i]["Bank"] + "'"); string RekBank = Db.SingleString("SELECT Rekening FROM REF_ACC WHERE Acc = '" + rs.Rows[i]["Bank"] + "'"); c = new TableCell(); c.Text = NamaBank;// +" " + RekBank; c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.StrKet(rs.Rows[i]["Ket"].ToString()); c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); c.Text = Cf.Num(rs.Rows[i]["Nilai"]); c.HorizontalAlign = HorizontalAlign.Right; r.Cells.Add(c); DataTable kw = Db.Rs("SELECT * FROM MS_TTS WHERE Status = 'POST' AND NoAnonim = '" + rs.Rows[i]["NoAnonim"].ToString() + "'"); c = new TableCell(); if (kw.Rows.Count > 0) { c.Text = Cf.Day(kw.Rows[0]["TglBKM"]); } c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); if (kw.Rows.Count > 0) { c.Text = kw.Rows[0]["ManualBKM"].ToString(); } c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); if (kw.Rows.Count > 0) { c.Text = kw.Rows[0]["Unit"].ToString(); } c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); if (kw.Rows.Count > 0) { c.Text = kw.Rows[0]["Customer"].ToString(); } c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); c = new TableCell(); if (kw.Rows.Count > 0) { c.Text = Cf.Num(kw.Rows[0]["Total"]); } c.HorizontalAlign = HorizontalAlign.Left; r.Cells.Add(c); rpt.Rows.Add(r); t1 += Convert.ToDecimal(rs.Rows[i]["Nilai"]); if (kw.Rows.Count > 0) { t2 += Convert.ToDecimal(kw.Rows[0]["Total"]); } if (i == rs.Rows.Count - 1) { SubTotal("GRAND TOTAL", t1, t2); } } }