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