private void FillCsv()
{
string csv = string.Empty;
//FK KD_JENIS_TRANSAKSI FG_PENGGANTI NOMOR_FAKTUR MASA_PAJAK TAHUN_PAJAK TANGGAL_FAKTUR
//NPWP NAMA ALAMAT_LENGKAP JUMLAH_DPP JUMLAH_PPN JUMLAH_PPNBM
//ID_KETERANGAN_TAMBAHAN FG_UANG_MUKA UANG_MUKA_DPP UANG_MUKA_PPN
//UANG_MUKA_PPNBM REFERENSI
csv += "FK,";
csv += "KD_JENIS_TRANSAKSI,";
csv += "FG_PENGGANTI,";
csv += "NOMOR_FAKTUR,";
csv += "MASA_PAJAK,";
csv += "TAHUN_PAJAK,";
csv += "TANGGAL_FAKTUR,";
csv += "NPWP,";
csv += "NAMA,";
csv += "ALAMAT_LENGKAP,";
csv += "JUMLAH_DPP,";
csv += "JUMLAH_PPN,";
csv += "JUMLAH_PPNBM,";
csv += "ID_KETERANGAN_TAMBAHAN,";
csv += "FG_UANG_MUKA,";
csv += "UANG_MUKA_DPP,";
csv += "UANG_MUKA_PPN,";
csv += "UANG_MUKA_PPNBM,";
csv += "REFERENSI";
//Add new line.
csv += "\r\n";
//LT NPWP NAMA JALAN BLOK NOMOR RT RW KECAMATAN
//KELURAHAN KABUPATEN PROPINSI KODE_POS NOMOR_TELEPON
csv += "LT,";
csv += "NPWP,";
csv += "NAMA,";
csv += "JALAN,";
csv += "BLOK,";
csv += "RT,";
csv += "RW,";
csv += "KECAMATAN,";
csv += "KELURAHAN,";
csv += "KABUPATEN,";
csv += "PROPINSI,";
csv += "KODE_POS,";
csv += "NOMOR_TELEPON";
csv += "\r\n";
//OF KODE_OBJEK NAMA HARGA_SATUAN JUMLAH_BARANG HARGA_TOTAL DISKON DPP PPN TARIF_PPNBM PPNBM
csv += "OF,";
csv += "KODE_OBJEK,";
csv += "NAMA,";
csv += "HARGA_SATUAN,";
csv += "JUMLAH_BARANG,";
csv += "HARGA_TOTAL,";
csv += "DISKON,";
csv += "DPP,";
csv += "PPN,";
csv += "TARIF_PPNBM,";
csv += "PPNBM";
csv += "\r\n";
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
string UserID = "";
if (Kasir != "SEMUA")
{
UserID = " AND UserID = '" + Kasir + "'";
}
string Status = "";
if (StatusP != "")
{
Status = " AND a.Status = 'POST'";
}
if (StatusB != "")
{
Status = " AND a.Status = 'BARU'";
}
if (StatusV != "")
{
Status = " AND a.Status = 'VOID'";
}
string strAcc = "";
if (Rekening != "SEMUA")
{
strAcc = " AND Acc = '" + Cf.Str(Rekening) + "'";
}
string nLokasi = "";
if (Lokasi != "SEMUA")// ;
{
nLokasi = " AND b.Lokasi = '" + Cf.Str(Lokasi) + "'";
}
string agent = "";
if (UserAgent() > 0)
{
agent = " AND (SELECT NoAgent FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = a.Ref) = " + UserAgent();
}
decimal t1 = 0;
decimal t2 = 0;
decimal t3 = 0;
string tgl = "";
if (Tanggal == "tgltts")
{
tgl = "TglTTS";
}
if (Tanggal == "tglinput")
{
tgl = "a.TglInput";
}
if (Tanggal == "tglbkm")
{
tgl = "TglBKM";
}
if (Tanggal == "tglbg")
{
tgl = "TglBG";
}
//Tipe
string type = String.Empty;
type = Tipe.Replace("-", ",").TrimEnd(',');
type = type.Replace("+", " ");
type = type.Replace(",", "','");
type = "'" + type + "'";
//Cara Bayar
string akt = String.Empty;
akt = CaraBayar.Replace("-", ",").TrimEnd(',');
akt = akt.Replace("+", " ");
akt = akt.Replace(",", "','");
akt = "'" + akt + "'";
string strSql = "SELECT a.*, b.Lokasi, b.Jenis "
+ " FROM ISC064_FINANCEAR..MS_TTS a"
+ " INNER JOIN [ISC064_MARKETINGJUAL].[dbo].[MS_UNIT] b ON a.Unit = b.NoUnit "
+ " WHERE 1=1 "
+ " AND CONVERT(varchar," + tgl + ",112) >= '" + Cf.Tgl112(Dari) + "'"
+ " AND CONVERT(varchar," + tgl + ",112) <= '" + Cf.Tgl112(Sampai) + "'"
+ " AND a.Tipe IN (" + type + ")"
+ " AND CaraBayar IN (" + akt + ")"
+ UserID
+ Status
+ strAcc
+ nLokasi
+ agent
+ " ORDER BY NoTTS";
DataTable rs = Db.Rs(strSql);
string NPWPPT = Db.SingleString("SELECT ISNULL(NPWP,' ') FROM ISC064_SECURITY..REF_DATA");
string NamaNPWP = Db.SingleString("SELECT ISNULL(NPWPNama,' ') FROM ISC064_SECURITY..REF_DATA");
string AlamatNPWP = Db.SingleString("SELECT ISNULL(AlamatNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
string NomorNPWP = Db.SingleString("SELECT ISNULL(NomorNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
//string strSql2 = "";
//strSql2 = "SELECT DISTINCT NamaTagihan FROM ISC064_MARKETINGJUAL..MS_TAGIHAN"
// + " WHERE NOURUT in (SELECT NOTAGIHAN FROM ISC064_MARKETINGJUAL..MS_PELUNASAN WHERE NOTTS='" + rs.Rows[i]["NoTTS"].ToString() + "')"
// + " AND NoKontrak = '" + rs.Rows[i]["Ref"] + "'"
// ;
//DataTable rs12 = Db.Rs(strSql2);
//string w2 = "";
//if (rs12.Rows.Count > 1)
//{
// for (int j = 0; j < rs12.Rows.Count; j++)
// {
// w2 += rs12.Rows[j]["NamaTagihan"].ToString() + ";";
// }
//}
//else
//{
// for (int j = 0; j < rs12.Rows.Count; j++)
// {
// w2 += rs12.Rows[j]["NamaTagihan"].ToString();
// }
//}
string strSql2 = "";
strSql2 = "SELECT DISTINCT NoUnit FROM ISC064_MARKETINGJUAL..MS_KONTRAK"
+ " WHERE NoKontrak = '" + rs.Rows[i]["Ref"] + "'"
;
DataTable rs12 = Db.Rs(strSql2);
string w2 = "";
if (rs12.Rows.Count > 1)
{
for (int j = 0; j < rs12.Rows.Count; j++)
{
w2 += rs12.Rows[j]["NoUnit"].ToString() + ";";
}
}
else
{
for (int j = 0; j < rs12.Rows.Count; j++)
{
w2 += rs12.Rows[j]["NoUnit"].ToString();
}
}
string Kode_Objek = Db.SingleString("SELECT ISNULL(KODE,' ') FROM REF_EFAKTUR WHERE Uraian='" + w2 + "'");
//Baris 1
string NoFPS = rs.Rows[i]["NoFPS"].ToString();
string[] noFG = NoFPS.Split('.');
string printFG = "", printFP = "";
if (noFG.Length > 0)
{
//printFG = noFG.Length.ToString();
//printFP = noFG[1].ToString();
for (int count = 0; count <= noFG.Length - 1; count++)
{
if (count == 0)
{
printFG = noFG[count].ToString();
}
if (count > 0)
{
if (count == 1)
{
printFP += noFG[count].ToString();
}
else
{
printFP += "." + noFG[count].ToString();
}
}
}
}
DateTime TglKwitasi = Convert.ToDateTime(rs.Rows[i]["TglBKM"]);
int BulanKwitansi = TglKwitasi.Month;
int TahunKwitansi = TglKwitasi.Year;
string QueryNamaCS = "SELECT ISNULL(NPWP,' ') FROM ISC064_MARKETINGJUAL..MS_KONTRAK A"
+ " INNER JOIN ISC064_MARKETINGJUAL..MS_CUSTOMER B ON A.NoCustomer = B.NoCustomer"
+ " WHERE NoKontrak = '" + rs.Rows[i]["Ref"] + "'";
string NPWPCS = Db.SingleString(QueryNamaCS);
decimal NoCustomer = Db.SingleDecimal("SELECT NoCustomer FROM ISC064_MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak='" + rs.Rows[i]["Ref"] + "'");
DataTable dtCustomer = Db.Rs("SELECT * FROM ISC064_MARKETINGJUAL..MS_CUSTOMER WHERE NoCustomer = " + NoCustomer);
string Alm_NPWP1 = "", Alm_NPWP2 = "", Alm_NPWP3 = "";
string Alm_KTP1 = "", Alm_KTP2 = "", Alm_KTP3 = "", Alm_KTP4 = "";
string AlamatCS = " ";
if (dtCustomer.Rows.Count > 0)
{
Alm_NPWP1 = dtCustomer.Rows[0]["NPWPAlamat1"].ToString().Trim();
Alm_NPWP2 = dtCustomer.Rows[0]["NPWPAlamat2"].ToString().Trim();
Alm_NPWP3 = dtCustomer.Rows[0]["NPWPAlamat3"].ToString().Trim();
Alm_KTP1 = dtCustomer.Rows[0]["KTP1"].ToString().Trim();
Alm_KTP2 = dtCustomer.Rows[0]["KTP2"].ToString().Trim();
Alm_KTP3 = dtCustomer.Rows[0]["KTP3"].ToString().Trim();
Alm_KTP4 = dtCustomer.Rows[0]["KTP4"].ToString().Trim();
if (Alm_NPWP1 == " " || Alm_NPWP2 == " " || Alm_NPWP3 == " " || Alm_NPWP1 == "-" || Alm_NPWP2 == "-" || Alm_NPWP3 == "-")
{
if (Alm_KTP1 == " " || Alm_KTP2 == " " || Alm_KTP3 == " " || Alm_KTP4 == " " || Alm_KTP1 == "-" || Alm_KTP2 == "-" || Alm_KTP3 == "-" || Alm_KTP4 == "-")
{
AlamatCS = " ";
}
else
{
AlamatCS = Alm_KTP1 + " " + Alm_KTP2 + " " + Alm_KTP3 + " " + Alm_KTP4;
}
}
else
{
AlamatCS = Alm_NPWP1 + " " + Alm_NPWP2 + " " + Alm_NPWP3;
}
AlamatCS = AlamatCS.Trim();
if (AlamatCS == "")
{
AlamatCS = "";
}
}
decimal NilaiBayar = Convert.ToDecimal(rs.Rows[i]["Total"]);
decimal DPP = NilaiBayar / (decimal)1.1;
string sRef = w2 + " " + rs.Rows[0]["Jenis"].ToString() + " " + "SL-" + rs.Rows[0]["Unit"].ToString();
string KelurahanNPWP = Db.SingleString("SELECT ISNULL(KelurahanNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
string KabupatenNPWP = Db.SingleString("SELECT ISNULL(KabupatenNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
string KodePOS = Db.SingleString("SELECT ISNULL(KodePosNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
string NoTelp = Db.SingleString("SELECT ISNULL(NoTelp,' ') FROM ISC064_SECURITY..REF_DATA");
string PropinsiNPWP = Db.SingleString("SELECT ISNULL(PropinsiNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
string BlokNPWP = Db.SingleString("SELECT ISNULL(BlokNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
string RTNPWP = Db.SingleString("SELECT ISNULL(RTNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
string RWNPWP = Db.SingleString("SELECT ISNULL(RWNPWP,'') FROM ISC064_SECURITY..REF_DATA");
string KecamatanNPWP = Db.SingleString("SELECT ISNULL(KecamatanNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
csv += "FK".Replace(",", ";") + ',' + "01".Replace(",", ";") + ',' + "0".Replace(",", ";") + ',' + printFP.Replace(".", "").Replace(",", ";") + ',';
csv += BulanKwitansi.ToString().Replace(",", ";") + ',' + TahunKwitansi.ToString().Replace(",", ";") + ',' + Cf.DaySlash(TglKwitasi) + ',' + NPWPCS + ',';
csv += rs.Rows[i]["Customer"].ToString().Replace(",", ";") + ',' + AlamatCS.Replace(",", ";") + ',' + Math.Round(DPP).ToString().Replace(",", ";") + ',' + Math.Round(NilaiBayar - DPP).ToString().Replace(",", ";") + ',';
csv += "0".Replace(",", ";") + ',' + "".Replace(",", ";") + ',' + "0".Replace(",", ";") + ',' + "0".Replace(",", ";") + ',';
csv += "0".Replace(",", ";") + ',' + "0".Replace(",", ";") + ',' + sRef.Replace(",", ";");
csv += "\r\n";
//Baris 2
//csv += "FAPR".Replace(",", ";") + ',' + NPWPPT.Replace(",", ";") + ',' + NamaNPWP.Replace(",", ";") + ',' + AlamatNPWP.Replace(",", ";") + ',';
//csv += BlokNPWP.Replace(",", ";") + ',' + RTNPWP.Replace(",", ";") + ',' + RWNPWP.Replace(",", ";") + ',' + KecamatanNPWP.Replace(",", ";") + ',';
//csv += KelurahanNPWP.Replace(",", ";") + ',' + KabupatenNPWP.Replace(",", ";") + ',' + PropinsiNPWP.Replace(",", ";") + ',' + KodePOS.Replace(",", ";") + ',';
//csv += NoTelp.Replace(",", ";");
//csv += "\r\n";
//Baris 3
csv += "OF".ToString().Replace(",", ";") + ',' + Kode_Objek + ',' + w2.Replace(",", ";") + ',' + Math.Round(DPP).ToString().Replace(",", ";") + ',';
csv += "1".Replace(",", ";") + ',' + Math.Round(DPP).ToString().Replace(",", ";") + ',' + "0".ToString().Replace(",", ";") + ',' + Math.Round(DPP).ToString().Replace(",", ";") + ',' + Math.Round(NilaiBayar - DPP).ToString().Replace(",", ";") + ',' + "0".ToString().Replace(",", ";") + ',' + "0".ToString().Replace(",", ";");
csv += "\r\n";
}
string NamaFileCsv = "";
NamaFileCsv = "eFaktur" + DateTime.Now.Month + DateTime.Now.Year;
//Download the CSV file.
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + NamaFileCsv + ".csv");
Response.Charset = "";
Response.ContentType = "application/text";
Response.Output.Write(csv);
Response.Flush();
Response.End();
}
private void Fill()
{
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
string UserID = "";
if (Kasir != "SEMUA")
{
UserID = " AND UserID = '" + Kasir + "'";
}
string Status = "";
if (StatusP != "")
{
Status = " AND a.Status = 'POST'";
}
if (StatusB != "")
{
Status = " AND a.Status = 'BARU'";
}
if (StatusV != "")
{
Status = " AND a.Status = 'VOID'";
}
string nProject = "";
if (Project != "SEMUA")
{
nProject = " AND c.Project IN('" + Project.Replace(",", "','") + "')";
}
string nPerusahaan = "";
if (Perusahaan != "SEMUA")
{
nPerusahaan = " AND c.Pers = '" + Perusahaan + "'";
}
string strAcc = "";
if (Rekening != "SEMUA")
{
strAcc = " AND Acc = '" + Cf.Str(Rekening) + "'";
}
string nLokasi = "";
if (Lokasi != "SEMUA")// ;
{
nLokasi = " AND b.Lokasi = '" + Cf.Str(Lokasi) + "'";
}
string agent = "";
if (UserAgent() > 0)
{
agent = " AND (SELECT NoAgent FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak = a.Ref) = " + UserAgent();
}
decimal t1 = 0;
decimal t2 = 0;
decimal t3 = 0;
string tgl = "";
if (Tanggal == "tgltts")
{
tgl = "TglTTS";
}
if (Tanggal == "tglinput")
{
tgl = "a.TglInput";
}
if (Tanggal == "tglbkm")
{
tgl = "TglBKM";
}
if (Tanggal == "tglbg")
{
tgl = "TglBG";
}
//Tipe
string type = String.Empty;
type = Tipe.Replace("-", ",").TrimEnd(',');
type = type.Replace("+", " ");
type = type.Replace(",", "','");
type = "'" + type + "'";
//Cara Bayar
string akt = String.Empty;
akt = CaraBayar.Replace("-", ",").TrimEnd(',');
akt = akt.Replace("+", " ");
akt = akt.Replace(",", "','");
akt = "'" + akt + "'";
string strSql = "SELECT a.*, b.Lokasi, b.Jenis "
+ " FROM ISC064_FINANCEAR..MS_TTS a"
+ " INNER JOIN [ISC064_MARKETINGJUAL].[dbo].[MS_UNIT] b ON a.Unit = b.NoUnit "
+ " INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK c ON a.Ref = c.NoKontrak"
+ " WHERE 1=1 "
+ " AND CONVERT(varchar," + tgl + ",112) >= '" + Cf.Tgl112(Dari) + "'"
+ " AND CONVERT(varchar," + tgl + ",112) <= '" + Cf.Tgl112(Sampai) + "'"
+ " AND a.Tipe IN (" + type + ")"
+ " AND a.CaraBayar IN (" + akt + ")"
+ nProject
+ nPerusahaan
+ UserID
+ Status
+ strAcc
+ nLokasi
+ agent
+ " ORDER BY NoTTS";
DataTable rs = Db.Rs(strSql);
DataTable rsGiro = Db.Rs(
"SELECT a.*,b.Lokasi "
+ " FROM ISC064_FINANCEAR..MS_TTS a"
+ " INNER JOIN [ISC064_MARKETINGJUAL].[dbo].[MS_UNIT] b ON a.Unit = b.NoUnit "
+ " INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK c ON a.Ref = c.NoKontrak"
+ " WHERE 1=1"
+ " AND CONVERT(varchar," + tgl + ",112) >= '" + Cf.Tgl112(Dari) + "'"
+ " AND CONVERT(varchar," + tgl + ",112) <= '" + Cf.Tgl112(Sampai) + "'"
+ " AND a.Tipe IN (" + type + ")"
+ " AND a.CaraBayar IN (" + akt + ")"
+ nProject
+ nPerusahaan
+ UserID
+ Status
+ strAcc
+ nLokasi
+ " AND NoBG <> ''"
);
int LembarGiro = rsGiro.Rows.Count;
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"] = "popEditTTS('" + rs.Rows[i]["NoTTS"] + "')";
c = new TableCell();
c.Text = "FK" + "<br />" + "FAPR" + "<br />" + "OF";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
string strSql2 = "";
strSql2 = "SELECT DISTINCT NamaTagihan FROM ISC064_MARKETINGJUAL..MS_TAGIHAN"
+ " WHERE NOURUT in (SELECT NOTAGIHAN FROM ISC064_MARKETINGJUAL..MS_PELUNASAN WHERE NOTTS='" + rs.Rows[i]["NoTTS"].ToString() + "')"
+ " AND NoKontrak = '" + rs.Rows[i]["Ref"] + "'"
;
DataTable rs12 = Db.Rs(strSql2);
string w2 = "";
if (rs12.Rows.Count > 1)
{
for (int j = 0; j < rs12.Rows.Count; j++)
{
w2 += rs12.Rows[j]["NamaTagihan"].ToString() + ";";
}
}
else
{
for (int j = 0; j < rs12.Rows.Count; j++)
{
w2 += rs12.Rows[j]["NamaTagihan"].ToString();
}
}
string Kode_Objek = Db.SingleString("SELECT ISNULL(KODE,' ') FROM REF_EFAKTUR WHERE Uraian='" + w2 + "'");
string NamaNPWP = Db.SingleString("SELECT ISNULL(NPWPNama,' ') FROM ISC064_SECURITY..REF_DATA");
string AlamatNPWP = Db.SingleString("SELECT ISNULL(AlamatNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
string NomorNPWP = Db.SingleString("SELECT ISNULL(NomorNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
c = new TableCell();
c.Text = "01" + "<br />" + BersihKoma(NamaNPWP) + "<br />" + BersihKoma(Kode_Objek);
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
string NoFPS = rs.Rows[i]["NoFPS"].ToString();
string[] noFG = NoFPS.Split('.');
string printFG = "", printFP = "";
if (noFG.Length > 0)
{
//printFG = noFG.Length.ToString();
//printFP = noFG[1].ToString();
for (int count = 0; count <= noFG.Length - 1; count++)
{
if (count == 0)
{
printFG = noFG[count].ToString();
}
if (count > 0)
{
if (count == 1)
{
printFP += noFG[count].ToString();
}
else
{
printFP += "." + noFG[count].ToString();
}
}
}
}
c = new TableCell();
c.Text = BersihKoma(printFG) + "<br />" + BersihKoma(AlamatNPWP) + "<br />" + w2;
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
decimal NilaiBayar = Convert.ToDecimal(rs.Rows[i]["Total"]);
decimal DPP = NilaiBayar / (decimal)1.1;
c = new TableCell();
string Jalan = Db.SingleString("SELECT ISNULL(AlamatProject,' ') FROM ISC064_SECURITY..REF_DATA");
printFP = printFP.Replace(".", "");
c.Text = BersihKoma(printFP) + "<br />" + BersihKoma(Jalan) + "<br />" + Math.Round(DPP).ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
DateTime TglKwitasi = Convert.ToDateTime(rs.Rows[i]["TglBKM"]);
int BulanKwitansi = TglKwitasi.Month;
int TahunKwitansi = TglKwitasi.Year;
string BlokNPWP = Db.SingleString("SELECT ISNULL(BlokNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
c = new TableCell();
c.Text = BulanKwitansi + "<br />" + BersihKoma(BlokNPWP) + "<br />" + "1";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = TahunKwitansi + "<br />" + " " + "<br />" + Math.Round(DPP).ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
string RTNPWP = Db.SingleString("SELECT ISNULL(RTNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
c = new TableCell();
c.Text = Cf.DaySlash(TglKwitasi) + "<br />" + BersihKoma(RTNPWP) + "<br />" + "0";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
string QueryNamaCS = "SELECT ISNULL(NPWP,' ') FROM ISC064_MARKETINGJUAL..MS_KONTRAK A"
+ " INNER JOIN ISC064_MARKETINGJUAL..MS_CUSTOMER B ON A.NoCustomer = B.NoCustomer"
+ " WHERE NoKontrak = '" + rs.Rows[i]["Ref"] + "'";
string NPWPCS = Db.SingleString(QueryNamaCS);
string RWNPWP = Db.SingleString("SELECT ISNULL(RWNPWP,'') FROM ISC064_SECURITY..REF_DATA");
c = new TableCell();
c.Text = BersihKoma(NPWPCS) + "<br />" + BersihKoma(RWNPWP) + "<br />" + Math.Round(DPP).ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
string KecamatanNPWP = Db.SingleString("SELECT ISNULL(KecamatanNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
c = new TableCell();
c.Text = BersihKoma(rs.Rows[i]["Customer"].ToString()) + "<br />" + BersihKoma(KecamatanNPWP) + "<br />" + Math.Round(NilaiBayar - DPP).ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
// DATA CUSTOMER
decimal NoCustomer = Db.SingleDecimal("SELECT NoCustomer FROM ISC064_MARKETINGJUAL..MS_KONTRAK WHERE NoKontrak='" + rs.Rows[i]["Ref"] + "'");
DataTable dtCustomer = Db.Rs("SELECT * FROM ISC064_MARKETINGJUAL..MS_CUSTOMER WHERE NoCustomer =" + NoCustomer);
string Alm_NPWP1 = "", Alm_NPWP2 = "", Alm_NPWP3 = "";
string Alm_KTP1 = "", Alm_KTP2 = "", Alm_KTP3 = "", Alm_KTP4 = "";
string AlamatCS = " ";
if (dtCustomer.Rows.Count > 0)
{
Alm_NPWP1 = dtCustomer.Rows[0]["NPWPAlamat1"].ToString().Trim();
Alm_NPWP2 = dtCustomer.Rows[0]["NPWPAlamat2"].ToString().Trim();
Alm_NPWP3 = dtCustomer.Rows[0]["NPWPAlamat3"].ToString().Trim();
Alm_KTP1 = dtCustomer.Rows[0]["KTP1"].ToString().Trim();
Alm_KTP2 = dtCustomer.Rows[0]["KTP2"].ToString().Trim();
Alm_KTP3 = dtCustomer.Rows[0]["KTP3"].ToString().Trim();
Alm_KTP4 = dtCustomer.Rows[0]["KTP4"].ToString().Trim();
if (Alm_NPWP1 == " " || Alm_NPWP2 == " " || Alm_NPWP3 == " " || Alm_NPWP1 == "-" || Alm_NPWP2 == "-" || Alm_NPWP3 == "-")
{
if (Alm_KTP1 == " " || Alm_KTP2 == " " || Alm_KTP3 == " " || Alm_KTP4 == " " || Alm_KTP1 == "-" || Alm_KTP2 == "-" || Alm_KTP3 == "-" || Alm_KTP4 == "-")
{
AlamatCS = " ";
}
else
{
AlamatCS = Alm_KTP1 + " " + Alm_KTP2 + " " + Alm_KTP3 + " " + Alm_KTP4;
}
}
else
{
AlamatCS = Alm_NPWP1 + " " + Alm_NPWP2 + " " + Alm_NPWP3;
}
AlamatCS = AlamatCS.Trim();
if (AlamatCS == "")
{
AlamatCS = " ";
}
}
string KelurahanNPWP = Db.SingleString("SELECT ISNULL(KelurahanNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
c = new TableCell();
c.Text = BersihKoma(AlamatCS) + "<br />" + BersihKoma(KelurahanNPWP) + "<br />" + "0";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
string KabupatenNPWP = Db.SingleString("SELECT ISNULL(KabupatenNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
c = new TableCell();
c.Text = Math.Round(DPP).ToString() + "<br />" + BersihKoma(KabupatenNPWP) + "<br />" + "0";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
string PropinsiNPWP = Db.SingleString("SELECT ISNULL(PropinsiNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
c = new TableCell();
c.Text = Math.Round(NilaiBayar - DPP).ToString() + "<br />" + BersihKoma(PropinsiNPWP) + "<br />" + "0";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
//JUMLAH_PPNBM - KODE_POS
string KodePOS = Db.SingleString("SELECT ISNULL(KodePosNPWP,' ') FROM ISC064_SECURITY..REF_DATA");
c = new TableCell();
c.Text = "0" + "<br />" + BersihKoma(KodePOS) + "<br />" + " ";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
//ID_KETERANGAN_TAMBAHAN - NOMOR_TELEPON - <<KOSONG>>
string NoTelp = Db.SingleString("SELECT ISNULL(NoTelp,' ') FROM ISC064_SECURITY..REF_DATA");
c = new TableCell();
c.Text = " " + "<br />" + BersihKoma(NoTelp) + "<br />" + " ";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = "0" + "<br />" + " " + "<br />" + " ";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
//UANG_MUKA_DPP
c = new TableCell();
c.Text = "0" + "<br />" + " " + "<br />" + " ";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
//UANG_MUKA_PPN
c = new TableCell();
c.Text = "0" + "<br />" + " " + "<br />" + " ";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
//UANG_MUKA_PPNBM
c = new TableCell();
c.Text = "0" + "<br />" + " " + "<br />" + " ";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
//REFERENSI
string sRef = w2 + " " + rs.Rows[0]["Jenis"].ToString() + " " + "SL-" + rs.Rows[0]["Unit"].ToString();
c = new TableCell();
c.Text = BersihKoma(sRef) + "<br />" + " " + "<br />" + " ";
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
rpt.Rows.Add(r);
}
}
