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);
}
}
}
