private void Bind()
{
DataTable rs;
string strSql;
rs = Db.Rs("SELECT DISTINCT YEAR(TglKontrak), MONTH(TglKontrak) FROM MS_KONTRAK "
+ " WHERE Project = '" + project.SelectedValue + "' ORDER BY YEAR(TglKontrak), MONTH(TglKontrak)");
for (int i = 0; i < rs.Rows.Count; i++)
{
thnKontrak.Items.Add(new ListItem(
Cf.Monthname((int)rs.Rows[i][1]) + " " + rs.Rows[i][0].ToString()
, rs.Rows[i][0] + "," + rs.Rows[i][1]
));
}
thnKontrak.SelectedIndex = thnKontrak.Items.Count - 1;
strSql = "SELECT * FROM REF_JENIS WHERE Project = '" + project.SelectedValue + "' ORDER BY SN";
rs = Db.Rs(strSql);
for (int i = 0; i < rs.Rows.Count; i++)
{
string v = rs.Rows[i]["Jenis"].ToString();
string t = v + " - " + rs.Rows[i]["Nama"].ToString();
jenis.Items.Add(new ListItem(t, v));
}
strSql = "SELECT DISTINCT Lokasi FROM MS_KONTRAK WHERE Project = '" + project.SelectedValue + "' ORDER BY Lokasi";
rs = Db.Rs(strSql);
for (int i = 0; i < rs.Rows.Count; i++)
{
lokasi.Items.Add(new ListItem(rs.Rows[i][0].ToString()));
}
}
private void init()
{
DataTable rs;
rs = Db.Rs("SELECT DISTINCT YEAR(TglInput), MONTH(TglInput) FROM MS_UNIT "
+ " ORDER BY YEAR(TglInput), MONTH(TglInput)");
for (int i = 0; i < rs.Rows.Count; i++)
{
periode.Items.Add(new ListItem(
Cf.Monthname((int)rs.Rows[i][1]) + " " + rs.Rows[i][0].ToString()
, rs.Rows[i][0] + "," + rs.Rows[i][1]
));
}
rs = Db.Rs("SELECT * FROM REF_JENIS ORDER BY SN");
for (int i = 0; i < rs.Rows.Count; i++)
{
string v = rs.Rows[i]["Jenis"].ToString();
string t = v + " - " + rs.Rows[i]["Nama"].ToString();
jenis.Items.Add(new ListItem(t, v));
jenis.Items[i].Selected = true;
}
rs = Db.Rs("SELECT DISTINCT Lokasi FROM MS_UNIT ORDER BY Lokasi");
for (int i = 0; i < rs.Rows.Count; i++)
{
lokasi.Items.Add(new ListItem(rs.Rows[i][0].ToString()));
}
lokasi.SelectedIndex = 0;
periode.SelectedIndex = 0;
}
protected void Fill()
{
decimal t = 0, Total = 0;
for (int i = 1; i <= 12; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = Cf.Monthname(i);
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
t = Proyeksi(i);
c.Text = Cf.Num(t);
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
rpt.Rows.Add(r);
Total += t;
if (i == 12)
{
SubTotal(Total);
}
}
}
private void init()
{
string Project = project.SelectedIndex == 0 ? "Project IN (" + Act.ProjectListSql + ")" : "Project = '" + project.SelectedValue + "'";
DataTable rs;
lokasi.Items.Clear();
lokasi.Items.Add("SEMUA");
periode.Items.Clear();
periode.Items.Add("SEMUA");
rs = Db.Rs("SELECT DISTINCT YEAR(Periode), MONTH(Periode) FROM MS_PRICELIST_HISTORY "
+ " ORDER BY YEAR(Periode), MONTH(Periode)");
for (int i = 0; i < rs.Rows.Count; i++)
{
periode.Items.Add(new ListItem(
Cf.Monthname((int)rs.Rows[i][1]) + " " + rs.Rows[i][0].ToString()
, rs.Rows[i][0] + "," + rs.Rows[i][1]
));
}
rs = Db.Rs("SELECT * FROM REF_JENIS WHERE " + Project + " ORDER BY SN");
for (int i = 0; i < rs.Rows.Count; i++)
{
string v = rs.Rows[i]["Jenis"].ToString();
string t = v + " - " + rs.Rows[i]["Nama"].ToString();
jenis.Items.Add(new ListItem(t, v));
jenis.Items[i].Selected = true;
}
rs = Db.Rs("SELECT DISTINCT Lokasi FROM MS_UNIT WHERE " + Project + " ORDER BY Lokasi");
for (int i = 0; i < rs.Rows.Count; i++)
{
lokasi.Items.Add(new ListItem(rs.Rows[i][0].ToString()));
}
}
private void HeaderBayar()
{
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
if (Dari > Sampai)
{
DateTime x = Sampai;
Sampai = Dari;
Dari = x;
}
int m1 = Dari.Month;
int m2 = Sampai.Month;
int y1 = Dari.Year;
int y2 = Sampai.Year;
int th = y2 - y1;
int bln = (m2 - m1) + 1;
int jum = 0;
if (th > 0)
{
jum = (((th - 1) * 12) + (12 - m1) + m2) + 1;
}
else
{
jum = bln;
}
rpt.Rows[0].Cells[8].ColumnSpan = jum * 5;
TableRow r = new TableRow();
r.BackColor = Color.FromArgb(30, 144, 255);;
TableCell c;
//c = new TableHeaderCell();
//c.ColumnSpan = 8;
//c.RowSpan = 2;
//r.Cells.Add(c);
for (int j = 1; j <= jum; j++)
{
c = new TableHeaderCell();
c.Text = Cf.Monthname(Dari.AddMonths(j - 1).Month) + " " + Dari.AddMonths(j - 1).Year.ToString();
c.ForeColor = Color.White;
c.ColumnSpan = 5;
r.Cells.Add(c);
}
//c = new TableHeaderCell();
//c.ColumnSpan = 2;
//c.RowSpan = 2;
//r.Cells.Add(c);
rpt.Rows.Add(r);
}
protected void Fill()
{
string strSql = "SELECT a.*, b.*"
+ " FROM MS_KONTRAK a"
+ " INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER b ON a.NoCustomer = b.NoCustomer"
+ " WHERE NoKontrak = '" + 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]["NoKontrak"]) + "'");
//if (JenisPPN == "PEMERINTAH")
// HeaderPajak = (string)s.GetValue("NoFPSPemerintah", typeof(string));
//else if (JenisPPN == "KONSUMEN")
// HeaderPajak = (string)s.GetValue("NoFPSKonsumen", typeof(string));
nama.Text = rs.Rows[0]["Nama"].ToString();
nopajak.Text = rs.Rows[0]["NoFPS"].ToString();
strSql = "SELECT KTP1, KTP2, KTP3, KTP4"
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER"
+ " WHERE NoCustomer = " + Cf.Pk(rs.Rows[0]["NoCustomer"])
;
DataTable rsCs = Db.Rs(strSql);
alamat.Text = rsCs.Rows[0]["KTP1"]
+ "<br />"
+ rsCs.Rows[0]["KTP2"]
+ "<br />"
+ rsCs.Rows[0]["KTP3"]
+ "<br />"
+ rsCs.Rows[0]["KTP4"]
;
//Tanggal FPS
//DateTime dt = DateTime.Now;
//string tglFPS = Cf.Day(dt);
//tgl.Text = Convert.ToDateTime(dt).Day
// + " "
// + Cf.Monthname(Convert.ToDateTime(dt).Month)
// + " "
// + Convert.ToDateTime(dt).Year
// ;
tgl.Text = Convert.ToDateTime(rs.Rows[0]["TglAJB"]).Day
+ " "
+ Cf.Monthname(Convert.ToDateTime(rs.Rows[0]["TglAJB"]).Month)
+ " "
+ Convert.ToDateTime(rs.Rows[0]["TglAJB"]).Year
;
//Db.Execute("UPDATE MS_KONTRAK SET TglFPS='" + rs.Rows[0]["TglBKM"] + "' WHERE NoKontrak ='" + nomor + "'");
FillTable();
}
}
private void newHeader()
{
string header = "<p>" + Mi.Pt + "</p>";
header += "<h1 class='title'>LAPORAN COLLECTION</h1>";
header += "Periode : " + Cf.Monthname(Convert.ToInt32(Dari)) + " s/d " + Cf.Monthname(Convert.ToInt32(Sampai)) + " " + Tahun;
header += "Project : " + Project;
header += "Perusahaan : " + Perusahaan;
header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />";
headJudul.Text = header;
}
private void HeaderBayar()
{
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
int m1 = Dari.Month;
int m2 = Sampai.Month;
int y1 = Dari.Year;
int y2 = Sampai.Year;
int th = y2 - y1;
int bln = (m2 - m1) + 1;
int jum = 0;
if (th > 0)
{
jum = (((th - 1) * 12) + (12 - m1) + m2) + 1;
}
else
{
jum = bln;
}
rpt.Rows[0].Cells[8].ColumnSpan = jum * 5;
TableRow r = new TableRow();
r.BackColor = Color.LightGray;
TableCell c;
//c = new TableHeaderCell();
//c.ColumnSpan = 8;
//c.RowSpan = 2;
//r.Cells.Add(c);
for (int j = 1; j <= jum; j++)
{
c = new TableHeaderCell();
c.Text = Cf.Monthname(Dari.AddMonths(j - 1).Month) + " " + Dari.AddMonths(j - 1).Year.ToString();
c.ColumnSpan = 5;
r.Cells.Add(c);
}
//c = new TableHeaderCell();
//c.ColumnSpan = 2;
//c.RowSpan = 2;
//r.Cells.Add(c);
rpt.Rows.Add(r);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
lblHeader.Text = "<H3>" + Mi.Pt + "</H3>"
+ "<H1>LAPORAN REALISASI SALES & CASH IN</H1>"
+ "AS OF " + Cf.Monthname(Convert.ToInt32(bulansampai.SelectedValue)) + " " + Convert.ToInt32(tahunsampai.Text)
+ "<br />"
+ "<br />"
+ x
;
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
//DateTime Dari = Convert.ToDateTime(Dari);
//DateTime Sampai = Convert.ToDateTime(Sampai);
Rpt.SubJudul(x
, "Periode : " + Cf.Monthname(Convert.ToInt32(Dari)) + " s/d " + Cf.Monthname(Convert.ToInt32(Sampai)) + " " + Tahun
);
Rpt.Header(rpt, x);
}
private void init()
{
DataTable rs;
rs = Db.Rs("SELECT DISTINCT YEAR(TglKontrak), MONTH(TglKontrak) FROM MS_KOMISI INNER JOIN MS_KONTRAK ON MS_KOMISI.NoKontrak=MS_KONTRAK.NoKontrak"
+ " ORDER BY YEAR(TglKontrak), MONTH(TglKontrak)");
for (int i = 0; i < rs.Rows.Count; i++)
{
periodekomisi.Items.Add(new ListItem(
Cf.Monthname((int)rs.Rows[i][1]) + " " + rs.Rows[i][0].ToString()
, rs.Rows[i][0] + "," + rs.Rows[i][1]
));
}
periodekomisi.SelectedIndex = 0;
}
private void init()
{
DataTable rs;
string Project = project.SelectedIndex == 0 ? "Project IN (" + Act.ProjectListSql + ")" : "Project = '" + project.SelectedValue + "'";
rs = Db.Rs("SELECT DISTINCT YEAR(TglInput), MONTH(TglInput) FROM MS_AGENT "
+ " ORDER BY YEAR(TglInput), MONTH(TglInput)");
for (int i = 0; i < rs.Rows.Count; i++)
{
input.Items.Add(new ListItem(
Cf.Monthname((int)rs.Rows[i][1]) + " " + rs.Rows[i][0].ToString()
, rs.Rows[i][0] + "," + rs.Rows[i][1]
));
}
rs = Db.Rs("SELECT * FROM REF_AGENT_LEVEL WHERE " + Project + " ORDER BY LevelID");
for (int i = 0; i < rs.Rows.Count; i++)
{
string v = rs.Rows[i]["LevelID"].ToString();
string t = v + " - " + rs.Rows[i]["Nama"].ToString();
principal.Items.Add(new ListItem(t, v));
principal.Items[i].Selected = true;
}
rs = Db.Rs("SELECT * FROM REF_AGENT_TIPE WHERE " + Project + " ORDER BY ID");
for (int i = 0; i < rs.Rows.Count; i++)
{
string v = rs.Rows[i]["ID"].ToString();
string t = v + " - " + rs.Rows[i]["Tipe"].ToString();
tipe.Items.Add(new ListItem(t, v));
tipe.Items[i].Selected = true;
}
//rs = Db.Rs("SELECT DISTINCT SalesTipe FROM MS_AGENT ORDER BY SalesTipe");
//for (int i = 0; i < rs.Rows.Count; i++)
// tipe.Items.Add(new ListItem(rs.Rows[i][0].ToString()));
tipe.SelectedIndex = 0;
principal.SelectedIndex = 0;
input.SelectedIndex = 0;
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
x.Append("Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"<h3>" + Mi.Pt + "</h3>"
+ "<h1 class='title'>LAPORAN REALISASI SALES & CASH IN</h1>"
+ "Periode " + Cf.Monthname(Convert.ToInt32(BlnDari)) + " " + Convert.ToInt32(ThnDari)
+ " s/d " + Cf.Monthname(Convert.ToInt32(BlnSampai)) + " " + Convert.ToInt32(ThnSampai)
+ "<br />"
+ x
+ "<br />"
+ "<br />"
;
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
int Bln = Convert.ToInt32(bln.SelectedValue);
int Thn = Convert.ToInt32(thn.SelectedValue);
Rpt.SubJudul(x, "Periode: " + Cf.Monthname(Bln) + " " + Thn);
Rpt.SubJudul(
x, "Project : " + project.SelectedValue
);
Rpt.SubJudul(
x, "Perusahaan : " + pers.SelectedItem.Text
);
//Rpt.Header(rpt, x);
Rpt.HeaderReport(headReport, "", x);
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
DateTime Dari = Convert.ToDateTime(daribln.Text);
DateTime Sampai = Convert.ToDateTime(sampaibln.Text);
Rpt.SubJudul(x
, "Periode : " + Cf.Monthname(Convert.ToInt32(daribln.SelectedValue)) + " s/d " + Cf.Monthname(Convert.ToInt32(sampaibln.SelectedValue)) + " " + thn.SelectedValue
);
Rpt.SubJudul(x
, "Project : " + project.SelectedItem.Text
);
Rpt.SubJudul(x
, "Perusahaan : " + pers.SelectedItem.Text
);
Rpt.Header(rpt, x);
}
private void Fill()
{
string strSql = "SELECT * FROM MS_KASKELUAR WHERE NoVoucher = " + nomor;
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count != 0)
{
nomorl.Text = rs.Rows[0]["NoVoucher"].ToString().PadLeft(5, '0');
tgl.Text = Cf.Day(rs.Rows[0]["Tgl"]);
acc.Text = Db.SingleString("SELECT"
+ " Bank + ' ' + Rekening + ' ('+Acc+')' FROM REF_ACC "
+ " WHERE Acc = '" + rs.Rows[0]["Acc"] + "'");
keterangan.Text = rs.Rows[0]["Keterangan"].ToString();
dibayarkepada.Text = rs.Rows[0]["DibayarKepada"].ToString();
nilai.Text = Cf.Num(rs.Rows[0]["Nilai"]);
terbilang.Text = Money.Str((decimal)rs.Rows[0]["Nilai"]) + " RUPIAH";
carabayar.Text = rs.Rows[0]["CaraBayar"].ToString();
alatbayar.Text = rs.Rows[0]["AlatBayar"].ToString();
lblTgl.Text = DateTime.Today.Day.ToString() + " " + Cf.Monthname(DateTime.Today.Month);
lblThn.Text = DateTime.Today.Year.ToString().Substring(0, 2);
}
}
private void init()
{
DataTable rs;
Cf.BindBulan(lahir);
rs = Db.Rs("SELECT DISTINCT YEAR(TglInput), MONTH(TglInput) FROM MS_CUSTOMER "
+ " ORDER BY YEAR(TglInput), MONTH(TglInput)");
for (int i = 0; i < rs.Rows.Count; i++)
{
input.Items.Add(new ListItem(
Cf.Monthname((int)rs.Rows[i][1]) + " " + rs.Rows[i][0].ToString()
, rs.Rows[i][0] + "," + rs.Rows[i][1]
));
}
rs = Db.Rs("SELECT DISTINCT AgentInput FROM MS_CUSTOMER "
+ " ORDER BY AgentInput");
for (int i = 0; i < rs.Rows.Count; i++)
{
string v = rs.Rows[i][0].ToString();
string t = v;
string NamaAgent = Db.SingleString(
"SELECT ISNULL((SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..USERNAME WHERE UserID = '" + v + "'),'')");
if (NamaAgent != "")
{
t = t + " (" + NamaAgent + ")";
}
agentinput.Items.Add(new ListItem(t, v));
}
lahir.SelectedIndex = 0;
input.SelectedIndex = 0;
agentinput.SelectedIndex = 0;
}
private void Fill()
{
string strSql = "SELECT * FROM MS_RESERVASI WHERE NoReservasi = " + nomor;
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count != 0)
{
nama.Text = Db.SingleString("SELECT Nama FROM MS_CUSTOMER WHERE NoCustomer = " + Cf.Pk(rs.Rows[0]["NoCustomer"]));
alamat.Text = Db.SingleString("SELECT Alamat1 FROM MS_CUSTOMER WHERE NoCustomer = " + Cf.Pk(rs.Rows[0]["NoCustomer"]))
+ "<br />"
+ Db.SingleString("SELECT Alamat2 FROM MS_CUSTOMER WHERE NoCustomer = " + Cf.Pk(rs.Rows[0]["NoCustomer"]))
+ "<br />"
+ Db.SingleString("SELECT Alamat3 FROM MS_CUSTOMER WHERE NoCustomer = " + Cf.Pk(rs.Rows[0]["NoCustomer"]))
;
telp.Text = Db.SingleString("SELECT NoTelp FROM MS_CUSTOMER WHERE NoCustomer = " + Cf.Pk(rs.Rows[0]["NoCustomer"]));
nounit.Text = rs.Rows[0]["NoUnit"].ToString();
nourut.Text = rs.Rows[0]["NoUrut"].ToString();
harga.Text = "Rp. " + Cf.Num(rs.Rows[0]["NilaiReservasi"]);
terbilang.Text = Money.Str(Convert.ToDecimal(rs.Rows[0]["NilaiReservasi"]));
carabyr.Text = rs.Rows[0]["Skema"].ToString();
tgl.Text = Convert.ToDateTime(rs.Rows[0]["Tgl"]).ToString("dd")
+ " "
+ Cf.Monthname(Convert.ToDateTime(rs.Rows[0]["Tgl"]).Month)
+ " "
+ Convert.ToDateTime(rs.Rows[0]["Tgl"]).Year
;
namacust.Text = Db.SingleString("SELECT Nama FROM MS_CUSTOMER WHERE NoCustomer = " + Cf.Pk(rs.Rows[0]["NoCustomer"]));
namaagent.Text = Db.SingleString("SELECT Nama FROM MS_AGENT WHERE NoAgent = " + Cf.Pk(rs.Rows[0]["NoAgent"]));
nup.InnerHtml = rs.Rows[0]["NoQueue"].ToString();
batas.InnerHtml = Cf.Date(rs.Rows[0]["TglExpire"]);
masuk.InnerHtml = Cf.Date(rs.Rows[0]["TglInput"]);
}
}
private void Bind()
{
DataTable rs;
string strSql;
rs = Db.Rs("SELECT DISTINCT YEAR(a.TglKontrak), MONTH(a.TglKontrak) FROM MS_KONTRAK a WHERE a.Project = '" + project.SelectedValue + "'"
+ " ORDER BY YEAR(a.TglKontrak), MONTH(a.TglKontrak)");
for (int i = 0; i < rs.Rows.Count; i++)
{
thnKontrak.Items.Add(new ListItem(
Cf.Monthname((int)rs.Rows[i][1]) + " " + rs.Rows[i][0].ToString()
, rs.Rows[i][0] + "," + rs.Rows[i][1]
));
}
thnKontrak.SelectedIndex = thnKontrak.Items.Count - 1;
strSql = "SELECT DISTINCT a.Lokasi FROM MS_KONTRAK a WHERE a.Project = '" + project.SelectedValue + "' ORDER BY a.Lokasi";
rs = Db.Rs(strSql);
for (int i = 0; i < rs.Rows.Count; i++)
{
lokasi.Items.Add(new ListItem(rs.Rows[i][0].ToString()));
}
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
x.Append("<br>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"<h3>" + Mi.Pt + "</h3>"
+ "<h1 class='title'>LAPORAN REALISASI SALES & CASH IN</h1>"
+ "Periode " + Cf.Monthname(Convert.ToInt32(bulandari.SelectedValue)) + " " + Convert.ToInt32(tahundari.SelectedValue)
+ " s/d " + Cf.Monthname(Convert.ToInt32(bulansampai.SelectedValue)) + " " + Convert.ToInt32(tahunsampai.SelectedValue)
+ "<br />"
+ "Project : " + project.SelectedValue
+ "<br>Perusahaan : " + pers.SelectedItem.Text
+ "<br>Lokasi : " + tower.SelectedItem.Text
+ "<br>Lantai : " + lt.SelectedItem.Text
+ x
+ "<br />"
+ "<br />"
;
}
protected void Page_Load(object sender, System.EventArgs e)
{
string strsql = "SELECT * FROM MS_RESERVASI INNER JOIN MS_CUSTOMER ON MS_Reservasi.NoCustomer = MS_CUSTOMER.NoCustomer INNER JOIN MS_UNIT ON MS_RESERVASI.NoStock = MS_UNIT.NoStock WHERE NoReservasi='" + nomor + "'";
DataTable rs = Db.Rs(strsql);
if (rs.Rows.Count != 0)
{
pers.Text = Mi.Pt;
namacs.Text = rs.Rows[0]["Nama"].ToString();
string JenisProperti = rs.Rows[0]["JenisProperti"].ToString();
string CaraBayar = Db.SingleString("SELECT Jenis FROM REF_SKEMA WHERE Nomor='" + rs.Rows[0]["RefSkema"] + "'");
string ktp = "";
if (rs.Rows[0]["KTP1"].ToString() != "")
{
ktp += rs.Rows[0]["KTP1"];
if (rs.Rows[0]["KTP2"].ToString() != "")
{
ktp += ", ";
}
}
if (rs.Rows[0]["KTP2"].ToString() != "")
{
ktp += rs.Rows[0]["KTP2"];
if (rs.Rows[0]["KTP3"].ToString() != "")
{
ktp += ", ";
}
}
if (rs.Rows[0]["KTP3"].ToString() != "")
{
ktp += rs.Rows[0]["KTP3"];
if (rs.Rows[0]["KTP4"].ToString() != "")
{
ktp += ", ";
}
}
if (rs.Rows[0]["KTP4"].ToString() != "")
{
ktp += rs.Rows[0]["KTP4"];
}
alamatktp.Text = ktp != "" ? ktp : " ";
telphpfax.Text = rs.Rows[0]["NoTelp"].ToString() + "/" + rs.Rows[0]["NoHP"].ToString();
alasan1.Text = rs.Rows[0]["Alasan"].ToString();
string persendiskon = Db.SingleString("SELECT Diskon FROM REF_SKEMA WHERE Nomor='" + rs.Rows[0]["RefSkema"] + "'");
decimal Gross = Convert.ToDecimal(rs.Rows[0]["Gross"]);
decimal Diskon = 0;
decimal HargaSetelahDiskon = Gross - Diskon;
decimal PPN = HargaSetelahDiskon * (decimal)0.1;
harganett.Text = Cf.Num(HargaSetelahDiskon);
decimal BF = Db.SingleDecimal("SELECT ISNULL(SUM(NilaiTagihan),0) FROM MS_RESERVASI_TAGIHAN WHERE NoReservasi='" + nomor + "' AND Tipe='BF'");
tglres.Text = tgl.Text = Convert.ToDateTime(rs.Rows[0]["Tgl"]).ToString("dd") + " " + Cf.Monthname(Convert.ToDateTime(rs.Rows[0]["Tgl"]).Month) + " " + Convert.ToDateTime(rs.Rows[0]["Tgl"]).Year;
tgltarget.Text = Convert.ToDateTime(rs.Rows[0]["TglExpire"]).ToString("dd") + " " + Cf.Monthname(Convert.ToDateTime(rs.Rows[0]["TglExpire"]).Month) + " " + Convert.ToDateTime(rs.Rows[0]["TglExpire"]).Year;
if (rs.Rows[0]["Acc"].ToString() != "-")
{
bankacc.Text = Db.SingleString("select ISNULL(Bank, '') from " + Mi.DbPrefix + "FINANCEAR..REF_ACC where Acc = '" + rs.Rows[0]["Acc"].ToString() + "'");
}
else
{
bankacc.Text = "Cash";
}
jalan.Text = rs.Rows[0]["NamaJalan"].ToString();
nounit1.Text = rs.Rows[0]["Nomor"].ToString();
jenis.Text = rs.Rows[0]["Jenis"].ToString();
//string strSqlUnit = "";
//strSqlUnit = "SELECT * FROM MS_UNIT WHERE NoStock = '" + rs.Rows[0]["NoStock"] + "'";
//DataTable rsNUP = Db.Rs(strSqlUnit);
//for (int j = 0; j < rsNUP.Rows.Count; j++)
//{
// jalan.Text = "lt";//x[2];
// nounit1.Text = "un";//x[1];
// jenis.Text = "toew";//x[0];
//}
}
}
private void Fill()
{
decimal GrandTotal = 0;
for (int bln = 1; bln <= 12; bln++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
r.VerticalAlign = VerticalAlign.Top;
c = new TableCell();
c.Text = Cf.Monthname(bln);
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
int t = 0;
int gt = 0;
decimal rp = 0;
decimal grp = 0;
c = new TableCell();
c.HorizontalAlign = HorizontalAlign.Right;
c.Font.Bold = true;
r.Cells.Add(c);
for (int thn = Dari; thn <= Sampai; thn++)
{
c = new TableCell();
if (Perhitungan == "KUANTITAS")
{
t = sum1(thn, bln);
gt = gt + t;
if (t != 0)
{
c.Text = t.ToString();
}
}
if (Perhitungan == "RUPIAH")
{
rp = sum2(thn, bln);
grp = grp + rp;
if (rp != 0)
{
c.Text = Cf.Num(rp);
}
}
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
}
c = r.Cells[1];
if (Perhitungan == "KUANTITAS")
{
c.Text = gt.ToString();
}
if (Perhitungan == "RUPIAH")
{
c.Text = Cf.Num(grp);
}
rpt.Rows.Add(r);
if (Perhitungan == "KUANTITAS")
{
GrandTotal += Convert.ToInt32(gt);
}
else if (Perhitungan == "RUPIAH")
{
GrandTotal += grp;
}
if (bln == 12)
{
SubTotal(GrandTotal);
}
}
}
private void Fill()
{
decimal GrandTotal = 0;
for (int bln = 1; bln <= 12; bln++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
r.VerticalAlign = VerticalAlign.Top;
c = new TableCell();
c.Text = Cf.Monthname(bln);
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
int t = 0;
int gt = 0;
decimal rp = 0;
decimal grp = 0;
c = new TableCell();
c.HorizontalAlign = HorizontalAlign.Right;
c.Font.Bold = true;
r.Cells.Add(c);
int akhirbulan = DateTime.DaysInMonth(
Convert.ToInt32(tahun.SelectedValue)
, bln
);
for (int hari = 1; hari <= 31; hari++)
{
if (hari <= akhirbulan)
{
c = new TableCell();
if (kuantitas.Checked)
{
t = sum1(hari, bln);
gt = gt + t;
if (t != 0)
{
c.Text = t.ToString();
}
}
if (rupiah.Checked)
{
rp = sum2(hari, bln);
grp = grp + rp;
if (rp != 0)
{
c.Text = Cf.Num(rp);
}
}
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
}
}
c = r.Cells[1];
if (kuantitas.Checked)
{
c.Text = gt.ToString();
}
if (rupiah.Checked)
{
c.Text = Cf.Num(grp);
}
rpt.Rows.Add(r);
if (kuantitas.Checked)
{
GrandTotal += Convert.ToInt32(gt);
}
else if (rupiah.Checked)
{
GrandTotal += grp;
}
if (bln == 12)
{
SubTotal(GrandTotal);
}
}
}
private void Fill()
{
//DateTime Dari = Convert.ToDateTime(dari.Text);
decimal t1 = 0;
decimal t2 = 0;
decimal t3 = 0;
decimal t4 = 0;
decimal t5 = 0;
decimal t6 = 0;
string strSql = "SELECT a.*, a.Status, b.Nama AS Cust"
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK a"
+ " INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER b ON a.NoCustomer = b.NoCustomer"
+ " INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_UNIT c ON a.NoUnit = c.NoUnit"
+ " WHERE 1=1 "
+ " ORDER BY a.TGLKONTRAK";
DataTable rs = Db.Rs(strSql);
TableRow trow = new TableRow();
TableCell tc;
trow.BackColor = Color.Gray;
trow.HorizontalAlign = HorizontalAlign.Center;
tc = new TableCell();
tc.Text = "NO.";
tc.RowSpan = 2;
trow.Cells.Add(tc);
tc = new TableCell();
tc.Text = "CUSTOMER";
tc.RowSpan = 2;
trow.Cells.Add(tc);
tc = new TableCell();
tc.Text = "TGL BF";
tc.RowSpan = 2;
trow.Cells.Add(tc);
tc = new TableCell();
tc.Text = "TYPE";
tc.ColumnSpan = 4;
trow.Cells.Add(tc);
tc = new TableCell();
tc.Text = "HARGA";
tc.RowSpan = 2;
trow.Cells.Add(tc);
tc = new TableCell();
tc.Text = "PPN";
tc.RowSpan = 2;
trow.Cells.Add(tc);
tc = new TableCell();
tc.Text = "TOTAL HARGA";
tc.RowSpan = 2;
trow.Cells.Add(tc);
tc = new TableCell();
tc.Text = "TYPE OF PAYMENT";
tc.RowSpan = 2;
trow.Cells.Add(tc);
tc = new TableCell();
tc.Text = "Akumulasi Sebelum " + Cf.Monthname(Convert.ToInt32(bulandari.SelectedValue)) + " " + Convert.ToInt32(tahundari.Text);
tc.RowSpan = 2;
trow.Cells.Add(tc);
DateTime awal = new DateTime(Convert.ToInt32(tahundari.Text), Convert.ToInt32(bulandari.SelectedValue), 1);
DateTime akhir = Cf.AkhirBulan(Convert.ToInt32(bulansampai.SelectedValue), Convert.ToInt32(tahunsampai.Text));
var listOfMonths = new List <string>();
var list = new List <string>();
while (awal <= akhir)
{
listOfMonths.Add(Cf.Monthname(awal.ToString("MMMM")) + " " + awal.ToString("yyyy"));
list.Add(awal.ToString("MM-yyyy"));
awal = awal.AddMonths(1);
}
foreach (var r in listOfMonths)
{
tc = new TableCell();
tc.Text = r.ToString();
tc.ColumnSpan = 4;
trow.Cells.Add(tc);
}
tc = new TableCell();
tc.Text = "Total Penerimaan Hingga " + Cf.Monthname(Convert.ToInt32(bulansampai.SelectedValue)) + " " + Convert.ToInt32(tahunsampai.Text);
tc.RowSpan = 2;
trow.Cells.Add(tc);
tc = new TableCell();
tc.Text = "";
tc.RowSpan = 2;
trow.Cells.Add(tc);
tc = new TableCell();
tc.Text = "Persentase Pelunasan";
tc.RowSpan = 2;
trow.Cells.Add(tc);
tc = new TableCell();
tc.Text = "Sisa Angsuran";
tc.RowSpan = 2;
trow.Cells.Add(tc);
rpt.Rows.Add(trow);
TableRow trow1 = new TableRow();
TableCell tc1;
trow1.BackColor = Color.Gray;
trow1.HorizontalAlign = HorizontalAlign.Center;
tc1 = new TableCell();
tc1.Text = "NO UNIT";
trow1.Cells.Add(tc1);
tc1 = new TableCell();
tc1.Text = "TOWER";
trow1.Cells.Add(tc1);
tc1 = new TableCell();
tc1.Text = "LANTAI";
trow1.Cells.Add(tc1);
tc1 = new TableCell();
tc1.Text = "LUAS";
trow1.Cells.Add(tc1);
foreach (var r in listOfMonths)
{
tc1 = new TableCell();
tc1.Text = "1 - 7";
trow1.Cells.Add(tc1);
tc1 = new TableCell();
tc1.Text = "8 - 14";
trow1.Cells.Add(tc1);
tc1 = new TableCell();
tc1.Text = "15 - 21";
trow1.Cells.Add(tc1);
tc1 = new TableCell();
tc1.Text = " >= 22";
trow1.Cells.Add(tc1);
}
rpt.Rows.Add(trow1);
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = (i + 1).ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Cust"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["TglKontrak"]);
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NoUnit"].ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Lokasi"].ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
string[] x = Cf.SplitByString(rs.Rows[i]["NoUnit"].ToString(), "/");
c = new TableCell();
c.Text = x[1];
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(rs.Rows[i]["Luas"]);
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Math.Round(Convert.ToDecimal(rs.Rows[i]["NilaiDPP"])).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Math.Round(Convert.ToDecimal(rs.Rows[i]["NilaiPPN"])).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Math.Round(Convert.ToDecimal(rs.Rows[i]["NilaiKontrak"])).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Skema"].ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
DateTime awala = new DateTime(Convert.ToInt32(tahundari.Text), Convert.ToInt32(bulandari.SelectedValue), 1);
c = new TableCell();
c.Text = Math.Round(Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE TglPelunasan < '" + Cf.Tgl112(awala) + "' AND NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "'")).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
foreach (var u in list)
{
string[] a = Cf.SplitByString(u.ToString(), "-");
DateTime week1a = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 1);
DateTime week1b = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 7);
DateTime week2a = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 8);
DateTime week2b = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 14);
DateTime week3a = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 15);
DateTime week3b = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 21);
DateTime week4a = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 22);
DateTime week4b = Cf.AkhirBulan(Convert.ToInt32(a[0]), Convert.ToInt32(a[1]));
c = new TableCell();
c.Text = Math.Round(Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE TglPelunasan <= '" + Cf.Tgl112(week1b) + "' AND TglPelunasan >= '" + Cf.Tgl112(week1a) + "' AND NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "'")).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Math.Round(Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE TglPelunasan <= '" + Cf.Tgl112(week2b) + "' AND TglPelunasan >= '" + Cf.Tgl112(week2a) + "' AND NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "'")).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Math.Round(Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE TglPelunasan <= '" + Cf.Tgl112(week3b) + "' AND TglPelunasan >= '" + Cf.Tgl112(week3a) + "' AND NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "'")).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Math.Round(Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE TglPelunasan <= '" + Cf.Tgl112(week4b) + "' AND TglPelunasan >= '" + Cf.Tgl112(week4a) + "' AND NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "'")).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
}
c = new TableCell();
c.Text = Math.Round(Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE TglPelunasan < '" + Cf.Tgl112(akhir) + "' AND NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "'")).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = "";
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Math.Round(Convert.ToDecimal(rs.Rows[i]["PersenLunas"])).ToString() + "%";
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
decimal tagihan = Db.SingleDecimal("SELECT ISNULL(SUM(NILAITAGIHAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_TAGIHAN WHERE NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "'");
decimal pelunasan = Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "'");
decimal sisa = tagihan - pelunasan;
c = new TableCell();
c.Text = Math.Round(sisa).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
rpt.Rows.Add(r);
}
}
private void Fill()
{
decimal GrandTotal = 0;
int Dari = Convert.ToInt32(daric.SelectedValue);
int Sampai = Convert.ToInt32(sampaic.SelectedValue);
if (Dari > Sampai)
{
int x = Dari;
Dari = Sampai;
Sampai = x;
}
for (int bln = 1; bln <= 12; bln++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
r.VerticalAlign = VerticalAlign.Top;
c = new TableCell();
c.Text = Cf.Monthname(bln);
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
int t = 0;
int gt = 0;
decimal rp = 0;
decimal grp = 0;
c = new TableCell();
c.HorizontalAlign = HorizontalAlign.Right;
c.Font.Bold = true;
r.Cells.Add(c);
for (int thn = Dari; thn <= Sampai; thn++)
{
c = new TableCell();
if (kuantitas.Checked)
{
t = sum1(thn, bln);
gt += t;
if (t != 0)
{
c.Text = t.ToString();
}
}
if (rupiah.Checked)
{
rp = sum2(thn, bln);
grp += rp;
if (rp != 0)
{
c.Text = Cf.Num(rp);
}
}
c.HorizontalAlign = HorizontalAlign.Right;
r.Cells.Add(c);
}
c = r.Cells[1];
if (kuantitas.Checked)
{
c.Text = gt.ToString();
}
if (rupiah.Checked)
{
c.Text = Cf.Num(grp);
}
rpt.Rows.Add(r);
if (kuantitas.Checked)
{
GrandTotal += Convert.ToInt32(gt);
}
else if (rupiah.Checked)
{
GrandTotal += grp;
}
if (bln == 12)
{
SubTotal(GrandTotal);
}
}
}
protected void save_Click(object sender, EventArgs e)
{
//Generate komisi
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
decimal PersenKomisi = 0;
decimal komisiCF = 0;
decimal akumulasiKomisi = 0;
string strSql = "SELECT "
+ " NoKontrak"
+ ",NoUnit"
+ ",NilaiKontrak"
+ ",TglKontrak"
+ ",Jenis"
+ ",Nama AS Cs"
+ ",Gross"
+ ",CaraBayar"
+ ",DiskonRupiah"
+ ",CaraBayar"
+ ",BungaNominal"
+ " FROM MS_KONTRAK INNER JOIN MS_CUSTOMER ON MS_KONTRAK.NoCustomer = MS_CUSTOMER.NoCustomer"
+ " WHERE NoAgent = '" + NoAgent + "'"
+ " AND MS_KONTRAK.Status = 'A'"
+ " AND MS_KONTRAK.FlagKomisi = 0"
+ " AND MS_KONTRAK.TglKontrak >= '" + Dari + "'"
+ " AND MS_KONTRAK.TglKontrak <= '" + Sampai + "'"
+ " ORDER BY NoKontrak";
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count > 0)
{
//kontrak per agent
int jumUnit = rs.Rows.Count;
string tgl = null;
string periode = null;
decimal komisi40 = 0;
decimal komisi60 = 0;
decimal bunga = 0;
for (int i = 0; i < jumUnit; i++)
{
if (rs.Rows[i]["BungaNominal"] == null)
{
bunga = 0;
}
else
{
bunga = Convert.ToDecimal(rs.Rows[i]["BungaNominal"]);
}
decimal afterDiskon = Convert.ToDecimal(rs.Rows[i]["Gross"]) - Convert.ToDecimal(rs.Rows[i]["DiskonRupiah"]) + bunga;
DateTime tgl2 = Convert.ToDateTime(rs.Rows[i]["TglKontrak"]);
string month = Cf.Monthname(tgl2.Month);
tgl = Cf.Day(rs.Rows[i]["TglKontrak"].ToString());
periode = month + " " + tgl.Substring(7, 4);
if (jumUnit == 1)
{
PersenKomisi = (decimal)0.008;
decimal nilaiKomisi = PersenKomisi * afterDiskon;
if (rs.Rows[i]["CaraBayar"].ToString() == "CASH KERAS")
{
akumulasiKomisi = Math.Round(nilaiKomisi + ((decimal)0.015 * nilaiKomisi));
komisi40 = (decimal)0.4 * akumulasiKomisi;
komisi60 = (decimal)0.6 * akumulasiKomisi;
}
else
{
akumulasiKomisi = Math.Round(nilaiKomisi);
komisi40 = (decimal)0.4 * akumulasiKomisi;
komisi60 = (decimal)0.6 * akumulasiKomisi;
}
}
else if (jumUnit >= 2 && jumUnit <= 4)
{
PersenKomisi = (decimal)0.01;
decimal nilaiKomisi = PersenKomisi * afterDiskon;
if (rs.Rows[i]["CaraBayar"].ToString() == "CASH KERAS")
{
akumulasiKomisi = Math.Round(nilaiKomisi + ((decimal)0.015 * nilaiKomisi));
komisi40 = (decimal)0.4 * akumulasiKomisi;
komisi60 = (decimal)0.6 * akumulasiKomisi;
}
else
{
akumulasiKomisi = Math.Round(nilaiKomisi);
komisi40 = (decimal)0.4 * akumulasiKomisi;
komisi60 = (decimal)0.6 * akumulasiKomisi;
}
}
else if (jumUnit >= 5)
{
PersenKomisi = (decimal)0.015;
decimal nilaiKomisi = PersenKomisi * afterDiskon;
if (rs.Rows[i]["CaraBayar"].ToString() == "CASH KERAS")
{
akumulasiKomisi = Math.Round(nilaiKomisi + (decimal)0.015 * nilaiKomisi);
komisi40 = (decimal)0.4 * akumulasiKomisi;
komisi60 = (decimal)0.6 * akumulasiKomisi;
}
else
{
akumulasiKomisi = Math.Round(nilaiKomisi);
komisi40 = (decimal)0.4 * akumulasiKomisi;
komisi60 = (decimal)0.6 * akumulasiKomisi;
}
}
if (jumUnit >= 1 && jumUnit <= 4)
{
komisiCF = (decimal)200000;
}
else if (jumUnit >= 5)
{
komisiCF = (decimal)300000;
}
decimal NoUrut = Db.SingleDecimal("SELECT ISNULL(MAX(NoUrut),0) + 1 FROM MS_KOMISI WHERE NoAgent= '" + NoAgent + "' ");
Db.Execute("INSERT INTO MS_KOMISI (NoKontrak, NoUrut, NilaiKomisi, NamaKomisi, NoAgent, PeriodeKomisi, ClosingFee, Komisi40, Komisi60, CaraBayar)"
+ " VALUES('" + rs.Rows[i]["NoKontrak"] + "', '" + NoUrut + "', '" + akumulasiKomisi + "', 'Komisi Periode " + periode + "', '" + NoAgent + "', '" + periode + "', '" + komisiCF + "', '" + komisi40 + "', '" + komisi60 + "','" + rs.Rows[i]["CaraBayar"] + "')");
Db.Execute("UPDATE MS_KONTRAK"
+ " SET FlagKomisi = 1 WHERE NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "' AND NoAgent = '" + NoAgent + "'");
}
}
Response.Redirect("AgentKomisiGen.aspx?done=1&NoAgent=" + NoAgent);
}
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()
{
//DateTime Dari = Convert.ToDateTime(dari.Text);
string nProject = "";
if (Project != "SEMUA")
{
nProject = " AND a.Project IN('" + Project.Replace(",", "','") + "')";
}
string nPerusahaan = "";
if (Perusahaan != "SEMUA")
{
nPerusahaan = " AND a.Pers = '" + Perusahaan + "'";
}
decimal t1 = 0;
decimal t2 = 0;
decimal t3 = 0;
decimal t4 = 0;
decimal t5 = 0;
decimal t6 = 0;
string lantai = "";
string to = "";
if (Lt != "0")
{
lantai = " AND LEFT(c.NoUnit,7) like '%" + Lt + "%'";
}
if (Tower != "0")
{
to = " AND c.Lokasi ='" + Tower.Replace("%", " ") + "'";
}
string strSql = "SELECT a.*, a.Status, b.Nama AS Cust"
+ " FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_KONTRAK a"
+ " INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_CUSTOMER b ON a.NoCustomer = b.NoCustomer"
+ " INNER JOIN " + Mi.DbPrefix + "MARKETINGJUAL..MS_UNIT c ON a.NoUnit = c.NoUnit"
+ " WHERE 1=1 "
+ nProject
+ nPerusahaan
+ lantai
+ to
+ " ORDER BY a.Status, a.TglKontrak";
DataTable rs = Db.Rs(strSql);
TableHeaderRow trow = new TableHeaderRow();
TableHeaderCell tc;
//trow.BackColor = Color.LightGray;
trow.HorizontalAlign = HorizontalAlign.Center;
tc = new TableHeaderCell();
tc.Text = "NO.";
tc.RowSpan = 2;
tc.Wrap = false; tc.Attributes["style"] = "margin:1px;";
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "CUSTOMER";
tc.RowSpan = 2;
tc.Wrap = false;
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "STATUS";
tc.RowSpan = 2;
tc.Wrap = false;
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "TGL BF";
tc.RowSpan = 2;
tc.Wrap = false;
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "TYPE";
tc.ColumnSpan = 4;
tc.Wrap = false;
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "HARGA";
tc.RowSpan = 2;
tc.Wrap = false;
//tc.Attributes["style"] = "padding:100px; margin:100px";
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "PPN";
tc.RowSpan = 2;
tc.Wrap = false;
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "TOTAL HARGA";
tc.RowSpan = 2;
tc.Wrap = false;
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "TYPE OF PAYMENT";
tc.RowSpan = 2;
tc.Wrap = false;
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "Akumulasi Sebelum " + Cf.Monthname(Convert.ToInt32(BlnDari)) + " " + Convert.ToInt32(ThnDari);
tc.RowSpan = 2;
tc.Wrap = false;
trow.Cells.Add(tc);
DateTime awal = new DateTime(Convert.ToInt32(ThnDari), Convert.ToInt32(BlnDari), 1);
DateTime akhir = Cf.AkhirBulan(Convert.ToInt32(BlnSampai), Convert.ToInt32(ThnSampai));
var listOfMonths = new List <string>();
var list = new List <string>();
while (awal <= akhir)
{
listOfMonths.Add(Cf.Monthname(awal.ToString("MMMM")) + " " + awal.ToString("yyyy"));
list.Add(awal.ToString("MM-yyyy"));
awal = awal.AddMonths(1);
}
foreach (var r in listOfMonths)
{
tc = new TableHeaderCell();
tc.Text = r.ToString();
tc.ColumnSpan = 4;
tc.Wrap = false;
trow.Cells.Add(tc);
}
tc = new TableHeaderCell();
tc.Text = "Total Penerimaan Hingga " + Cf.Monthname(Convert.ToInt32(BlnSampai)) + " " + Convert.ToInt32(ThnSampai) + " (Angsuran dan Saldo Awal)";
tc.RowSpan = 2;
tc.Wrap = false;
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "Total Penerimaan Lain-Lain Hingga " + Cf.Monthname(Convert.ToInt32(BlnSampai)) + " " + Convert.ToInt32(ThnSampai) + " (Admin dan Memo Selain Saldo Awal)";
tc.RowSpan = 2;
tc.Wrap = false;
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "Persentase Penerimaan";
tc.RowSpan = 2;
tc.Wrap = false;
trow.Cells.Add(tc);
tc = new TableHeaderCell();
tc.Text = "Sisa Angsuran";
tc.RowSpan = 2;
tc.Wrap = false;
trow.Cells.Add(tc);
rpt.Rows.Add(trow);
TableHeaderRow trow1 = new TableHeaderRow();
TableHeaderCell tc1;
//trow1.BackColor = Color.LightGray;
trow1.HorizontalAlign = HorizontalAlign.Center;
tc1 = new TableHeaderCell();
tc1.Text = "NO UNIT";
trow1.Cells.Add(tc1);
tc1 = new TableHeaderCell();
tc1.Text = "TOWER";
trow1.Cells.Add(tc1);
tc1 = new TableHeaderCell();
tc1.Text = "LANTAI";
trow1.Cells.Add(tc1);
tc1 = new TableHeaderCell();
tc1.Text = "LUAS";
trow1.Cells.Add(tc1);
foreach (var r in list)
{
string[] a = Cf.SplitByString(r.ToString(), "-");
tc1 = new TableHeaderCell();
tc1.Text = "1 s/d 7 ";
trow1.Cells.Add(tc1);
tc1 = new TableHeaderCell();
tc1.Text = "8 s/d 14 ";
trow1.Cells.Add(tc1);
tc1 = new TableHeaderCell();
tc1.Text = "15 s/d 21 ";
trow1.Cells.Add(tc1);
tc1 = new TableHeaderCell();
tc1.Text = "22 s/d " + Cf.AkhirBulan(Convert.ToInt32(a[0]), Convert.ToInt32(a[1])).Day;
trow1.Cells.Add(tc1);
}
rpt.Rows.Add(trow1);
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = (i + 1).ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Cust"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
if (rs.Rows[i]["Status"].ToString() == "A")
{
c.Text = "<b>Aktif</b>";
}
else
{
c.Text = "Batal";
}
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["TglKontrak"]);
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NoUnit"].ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Lokasi"].ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
string mProject = Db.SingleString("SELECT Project FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_UNIT WHERE NoUnit = '" + rs.Rows[i]["NoUnit"] + "'");
string ParamID = "FormatUnit" + mProject;
string pemisah = Db.SingleString("SELECT Value FROM " + Mi.DbPrefix + "SECURITY..REF_PARAM WHERE ParamID = '" + ParamID + "'");
string[] x = Cf.SplitByString(rs.Rows[i]["NoUnit"].ToString(), pemisah);
c = new TableCell();
c.Text = x[1];
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(rs.Rows[i]["Luas"]) + "m<sup>2</sup>";
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(Convert.ToDecimal(rs.Rows[i]["NilaiDPP"])).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(Convert.ToDecimal(rs.Rows[i]["NilaiPPN"])).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(Convert.ToDecimal(rs.Rows[i]["NilaiKontrak"])).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Skema"].ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
DateTime awala = new DateTime(Convert.ToInt32(ThnDari), Convert.ToInt32(BlnDari), 1);
c = new TableCell();
c.Text = Cf.Num(Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE TglPelunasan < '" + Cf.Tgl112(awala) + "' AND NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "' AND CaraBayar!='PPA'")).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
foreach (var u in list)
{
string[] a = Cf.SplitByString(u.ToString(), "-");
DateTime week1a = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 1);
DateTime week1b = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 7);
DateTime week2a = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 8);
DateTime week2b = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 14);
DateTime week3a = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 15);
DateTime week3b = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 21);
DateTime week4a = new DateTime(Convert.ToInt32(a[1]), Convert.ToInt32(a[0]), 22);
DateTime week4b = Cf.AkhirBulan(Convert.ToInt32(a[0]), Convert.ToInt32(a[1]));
c = new TableCell();
c.Text = Cf.Num(Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE TglPelunasan <= '" + Cf.Tgl112(week1b) + "' AND TglPelunasan >= '" + Cf.Tgl112(week1a) + "' AND NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "' AND CaraBayar!='PPA'")).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE TglPelunasan <= '" + Cf.Tgl112(week2b) + "' AND TglPelunasan >= '" + Cf.Tgl112(week2a) + "' AND NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "' AND CaraBayar!='PPA'")).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE TglPelunasan <= '" + Cf.Tgl112(week3b) + "' AND TglPelunasan >= '" + Cf.Tgl112(week3a) + "' AND NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "' AND CaraBayar!='PPA'")).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE TglPelunasan <= '" + Cf.Tgl112(week4b) + "' AND TglPelunasan >= '" + Cf.Tgl112(week4a) + "' AND NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "'")).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
}
c = new TableCell();
c.Text = Cf.Num(Ang(rs.Rows[i]["NoKontrak"].ToString(), akhir));
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(LainLain(rs.Rows[i]["NoKontrak"].ToString(), akhir));
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Num(Convert.ToDecimal(rs.Rows[i]["PersenLunas"])).ToString() + "%";
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
decimal tagihan = Db.SingleDecimal("SELECT ISNULL(SUM(NILAITAGIHAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_TAGIHAN WHERE NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "'");
decimal pelunasan = Db.SingleDecimal("SELECT ISNULL(SUM(NILAIPELUNASAN),0) FROM " + Mi.DbPrefix + "MARKETINGJUAL..MS_PELUNASAN WHERE NoKontrak='" + rs.Rows[i]["NoKontrak"].ToString() + "' AND CaraBayar!='PPA'");
decimal sisa = tagihan - pelunasan;
c = new TableCell();
c.Text = Cf.Num(sisa).ToString();
c.Wrap = false;
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
rpt.Rows.Add(r);
}
}
protected void Header()
{
header.Text = Mi.Pt
+ "<br />"
+ "LAPORAN CASH FLOW"
;
System.Text.StringBuilder x = new System.Text.StringBuilder();
Dari = Convert.ToInt32(dari.SelectedValue);
// Sampai = Convert.ToInt32(sampai.SelectedValue);
// if(Dari > Sampai)
// {
int y = Dari;
// Dari = Sampai;
// Sampai = y;
// }
x.Append("Periode: " + thn.SelectedValue);
TableRow r;
TableCell c;
TableHeaderCell hc;
// r = new TableRow();
// c = new TableCell();
// c.ColumnSpan = Dari - 5;
// c.Attributes["style"] = "font-size: 8pt;";
// r.Cells.Add(c);
//
// rpt.Rows.Add(r);
r = new TableRow();
hc = new TableHeaderCell();
hc.Text = "No. Kontrak";
hc.Attributes["style"] = "background-color: gray; color: white;";
hc.RowSpan = 2;
hc.Width = 100;
r.Cells.Add(hc);
hc = new TableHeaderCell();
hc.Text = "Status";
hc.Attributes["style"] = "background-color: gray; color: white;";
hc.RowSpan = 2;
r.Cells.Add(hc);
hc = new TableHeaderCell();
hc.Text = "Customer";
hc.Attributes["style"] = "background-color: gray; color: white;";
hc.RowSpan = 2;
hc.Width = 200;
r.Cells.Add(hc);
hc = new TableHeaderCell();
hc.Text = "Unit";
hc.Attributes["style"] = "background-color: gray; color: white;";
hc.RowSpan = 2;
r.Cells.Add(hc);
int j = Dari;
// for(int i = Dari; i <= Sampai; i++)
// {
hc = new TableHeaderCell();
hc.Text = Cf.Monthname(j);
hc.Attributes["style"] = "background-color: gray; color: white;";
hc.ColumnSpan = 4;
r.Cells.Add(hc);
// }
rpt.Rows.Add(r);
r = new TableRow();
int roman = 1;
int temp = 1;
for (int i = 0; i < temp * 4; i++)
{
hc = new TableHeaderCell();
hc.Text = Cf.Roman(roman);
hc.Attributes["style"] = "background-color: gray; color: white;";
r.Cells.Add(hc);
roman++;
if (roman > 4)
{
roman = 1;
}
}
rpt.Rows.Add(r);
}
private void HeaderBayar()
{
DateTime nDari = Cf.AwalBulan(Convert.ToInt32(Dari), Convert.ToInt32(Tahun));
DateTime nSampai = Cf.AwalBulan(Convert.ToInt32(Sampai), Convert.ToInt32(Tahun));
if (nDari > nSampai)
{
DateTime x = nSampai;
nSampai = nDari;
nDari = x;
}
int m1 = nDari.Month;
int m2 = nSampai.Month;
int y1 = nDari.Year;
int y2 = nSampai.Year;
int th = y2 - y1;
int bln = (m2 - m1) + 1;
int jum = 0;
if (th > 0)
{
jum = (((th - 1) * 12) + (12 - m1) + m2) + 1;
}
else
{
jum = bln;
}
TableRow r = new TableRow();
r.BackColor = Color.LightGray;
TableCell c;
c = new TableHeaderCell();
c.Text = "NO";
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Sales";
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "UNIT";
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Luas";
c.ColumnSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Harga exc PPN";
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Harga Jual inc PPN";
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "CUSTOMER";
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "NPWP";
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Alamat NPWP";
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Project";
c.RowSpan = 2;
r.Cells.Add(c);
for (int j = 1; j <= jum; j++)
{
c = new TableHeaderCell();
c.Text = Cf.Monthname(nDari.AddMonths(j - 1).Month) + " " + nDari.AddMonths(j - 1).Year.ToString();
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Saldo Awal " + Cf.Monthname(nDari.AddMonths(j - 1).Month) + " " + nDari.AddMonths(j - 1).Year.ToString();
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Memo " + Cf.Monthname(nDari.AddMonths(j - 1).Month) + " " + nDari.AddMonths(j - 1).Year.ToString();
c.RowSpan = 2;
r.Cells.Add(c);
}
c = new TableHeaderCell();
c.Text = "TOTAL " + Tahun;
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "TOTAL SALDO AWAL " + Tahun;
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "TOTAL MEMO " + Tahun;
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Akumulasi<br/>Pembayaran";
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Akumulasi<br/>Pembayaran (Saldo Awal)";
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Akumulasi<br/>Pembayaran (Memo)";
c.RowSpan = 2;
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "%";
c.RowSpan = 2;
r.Cells.Add(c);
rpt.Rows.Add(r);
r = new TableRow();
r.BackColor = Color.LightGray;
c = new TableHeaderCell();
c.Text = "Nett";
r.Cells.Add(c);
c = new TableHeaderCell();
c.Text = "Gross";
r.Cells.Add(c);
rpt.Rows.Add(r);
}
