private void BindDataProvince() { log4net.Config.XmlConfigurator.Configure(); log.Info("BindDataProvince() Started.."); try { lbxProvince.Items.Clear(); SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA(); DataTable dt = ws.GetProvince(); lbxProvince.DataSource = dt; lbxProvince.DataTextField = "Nama"; lbxProvince.DataValueField = "Id"; lbxProvince.DataBind(); } catch (Exception ex) { log.Info("BindDataProvince() Error. " + ex.Message); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "err_msg", "bootbox.alert({message:'<strong>There is an error:</strong> " + ex.Message.Replace("'", "\\'") + "', title:'Oops!'});", true); } log.Info("BindDataProvince() Finished.."); }
protected void btnView_Click(object sender, EventArgs e) { SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA(); string id = ws.InsertReportParameter(GetListBoxItem(lbxCompany), GetListBoxItem(lbxProvince), "", Constants.sessionUsername); Response.Redirect(Page.ResolveUrl("~/Lookup/Preview/ViewAssetSummaryByComp.aspx?id=" + id + "&usr=" + Constants.sessionUsername)); }
protected void btnView_Click(object sender, EventArgs e) { SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA(); string id = ws.InsertReportParameter(GetListBoxItem(lbxStatus), "", "", Constants.sessionUsername); Response.Redirect(Page.ResolveUrl("~/Lookup/Preview/ViewAssetDocumentChecklist.aspx?id=" + id + "&usr="******"&ty=v")); }
protected void btnDownload_Click(object sender, EventArgs e) { try { //after publish need to change it string rooturl = Constants.rootURL; SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA(); string id = ws.InsertReportParameter(GetListBoxItem(lbxCompany), GetListBoxItem(lbxProvince), "", Constants.sessionUsername); string url = rooturl + "Lookup/Preview/ViewAssetSummaryByComp.aspx?id=" + id + "&usr="******"AssetSummaryByCompany_" + DateTime.Now.ToString("yyyyMMdd") + ".pdf"; string filename = "\"" + Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig) + "\""; if (File.Exists(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig))) { File.Delete(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig)); } Process proc = new Process(); proc.StartInfo.FileName = Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "exe\\") + "wkhtmltopdf.exe"; proc.StartInfo.Arguments = "--print-media-type --page-width 250mm --page-height 323mm --margin-top 0 --margin-right 0 --margin-bottom 0 --margin-left 0 --dpi 200 --header-spacing 0 --footer-spacing 0 --disable-smart-shrinking --zoom 1.33 " + url + " " + filename; proc.StartInfo.UseShellExecute = false; proc.StartInfo.CreateNoWindow = true; proc.Start(); proc.WaitForExit(); byte[] bytes = System.IO.File.ReadAllBytes(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig)); Page.Response.ContentType = "application/pdf"; Page.Response.AddHeader("content-disposition", "attachment;filename=" + fileConfig); Page.Response.Cache.SetCacheability(HttpCacheability.NoCache); Page.Response.BinaryWrite(bytes); if (File.Exists(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig))) { File.Delete(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "PDF\\" + fileConfig)); } log.Info("Download " + fileConfig + " finished."); Page.Response.End(); } catch (Exception ex) { log.Info("Download error. " + ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { log.Info("ViewSertipikatSudahJatuhTempo Page_Load."); string username = Request.QueryString["usr"]; SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA(); DataTable dtSertipikat = new DataTable(); log.DebugFormat("Call GetSertipikatSudahJatuhTempo() Started."); dtSertipikat = ws.GetSertipikatSudahJatuhTempo(); log.DebugFormat("Call GetSertipikatSudahJatuhTempo() Finished. Result {0} rows.", dtSertipikat.Rows.Count); string html = System.IO.File.ReadAllText(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Template/HTML/SertipikatSudahJatuhTempo.html")); if (dtSertipikat.Rows.Count > 0) { string HTMLContentReport = ""; for (int i = 0; i < dtSertipikat.Rows.Count; i++) { HTMLContentReport += string.Format(@"<tr> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{2}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{3}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{4}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{5}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{6}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{7}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{8}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{9}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{10}</td> </tr>", dtSertipikat.Rows[i]["Kode"].ToString(), dtSertipikat.Rows[i]["Nama Aset"].ToString(), dtSertipikat.Rows[i]["Nomor Sertipikat"].ToString(), dtSertipikat.Rows[i]["Tanggal Penerbitan"].ToString(), dtSertipikat.Rows[i]["Tanggal Berakhir Hak"].ToString(), string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Lewat Hari"].ToString())), dtSertipikat.Rows[i]["Alamat Sertipikat"].ToString(), string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Luas Tanah Fisik"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Luas Tanah Sertipikat"].ToString())), dtSertipikat.Rows[i]["Jenis Hak Atas Tanah"].ToString(), dtSertipikat.Rows[i]["Nama Pemegang Hak"].ToString()); } html = html.Replace("@ContentReport", HTMLContentReport); } else { html = html.Replace("@ContentReport", ""); } html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss")) .Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy")); ltView.Text = html; } catch (Exception ex) { log.Error(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { log.Info("ViewAkuisisiSummaryByComp Page_Load."); try { int id = Convert.ToInt32(Request.QueryString["id"]); string username = Request.QueryString["usr"]; string company = ""; decimal totalPerencanaan = 0; decimal totalAreaPerencanaan = 0; decimal totalPemeriksaan = 0; decimal totalAreaPemeriksaan = 0; decimal totalProses = 0; decimal totalAreaProses = 0; decimal totalSudahBayarProses = 0; decimal totalJatuhTempoProses = 0; decimal totalBelumJatuhTempoProses = 0; decimal totalNilaiProses = 0; decimal totalSelesai = 0; decimal totalAreaSelesai = 0; decimal totalSudahBayarSelesai = 0; decimal totalJatuhTempoSelesai = 0; decimal totalBelumJatuhTempoSelesai = 0; decimal totalNilaiSelesai = 0; decimal totalSeluruhAkuisisi = 0; decimal totalSeluruhArea = 0; decimal totalSeluruhNilai = 0; SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA(); DataTable dtParameter = new DataTable(); log.DebugFormat("Call GetReportParameter() Started. Parameters : id = {0}", id); dtParameter = ws.GetReportParameter(id); if (dtParameter.Rows.Count > 0) { company = dtParameter.Rows[0]["Parameter1"].ToString(); } log.DebugFormat("Call GetReportParameter() Finished. Result {0} rows.", dtParameter.Rows.Count); DataTable dtAkuisisi = new DataTable(); log.DebugFormat("Call GetAkuisisiSummaryByComp() Started. Parameters : Company = {0}", company); dtAkuisisi = ws.GetAkuisisiSummaryByComp(company); log.DebugFormat("Call GetAkuisisiSummaryByComp() Finished. Result {0} rows.", dtAkuisisi.Rows.Count); string html = System.IO.File.ReadAllText(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Template/HTML/AkuisisiSummaryByComp.html")); if (dtAkuisisi.Rows.Count > 0) { string HTMLContentReport = ""; int no = 1; for (int i = 0; i < dtAkuisisi.Rows.Count; i++) { HTMLContentReport += string.Format(@"<tr> <td style='text-align: center; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{0}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{1}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{2}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{3}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{4}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{5}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{6}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{7}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{8}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{9}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{10}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{11}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{12}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{13}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{14}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{15}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{16}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{17}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{18}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{19}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'>{20}</td> </tr>", string.Format("{0:n0}", Convert.ToDecimal(no.ToString())), dtAkuisisi.Rows[i]["CompanyName"].ToString(), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalPerencanaan"].ToString())), string.Format("{0:n2}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaPerencanaan"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalPemeriksaan"].ToString())), string.Format("{0:n2}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaPemeriksaan"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalProses"].ToString())), string.Format("{0:n2}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaProses"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBayarProses"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalJatuhTempoProses"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBelumJatuhTempoProses"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilaiProses"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalSelesai"].ToString())), string.Format("{0:n2}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaSelesai"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBayarSelesai"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalJatuhTempoSelesai"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBelumJatuhTempoSelesai"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilaiSelesai"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAkuisisi"].ToString())), string.Format("{0:n2}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalArea"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilai"].ToString()))); totalPerencanaan += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalPerencanaan"].ToString()); totalAreaPerencanaan += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaPerencanaan"].ToString()); totalPemeriksaan += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalPemeriksaan"].ToString()); totalAreaPemeriksaan += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaPemeriksaan"].ToString()); totalProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalProses"].ToString()); totalAreaProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaProses"].ToString()); totalSudahBayarProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBayarProses"].ToString()); totalJatuhTempoProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalJatuhTempoProses"].ToString()); totalBelumJatuhTempoProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBelumJatuhTempoProses"].ToString()); totalNilaiProses += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilaiProses"].ToString()); totalSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalSelesai"].ToString()); totalAreaSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAreaSelesai"].ToString()); totalSudahBayarSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBayarSelesai"].ToString()); totalJatuhTempoSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalJatuhTempoSelesai"].ToString()); totalBelumJatuhTempoSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalBelumJatuhTempoSelesai"].ToString()); totalNilaiSelesai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilaiSelesai"].ToString()); totalSeluruhAkuisisi += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalAkuisisi"].ToString()); totalSeluruhArea += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalArea"].ToString()); totalSeluruhNilai += Convert.ToDecimal(dtAkuisisi.Rows[i]["TotalNilai"].ToString()); no += 1; } //Total HTMLContentReport += string.Format(@"<tr> <td colspan='2' style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{0}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{1}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{2}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{3}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{4}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{5}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{6}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{7}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{8}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{9}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{10}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{11}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{12}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{13}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{14}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{15}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{16}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{17}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{18}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px;'><b>{19}</b></td> </tr>", "Total", string.Format("{0:n0}", totalPerencanaan), string.Format("{0:n2}", totalAreaPerencanaan), string.Format("{0:n0}", totalPemeriksaan), string.Format("{0:n2}", totalAreaPemeriksaan), string.Format("{0:n0}", totalProses), string.Format("{0:n2}", totalAreaProses), string.Format("{0:n0}", totalSudahBayarProses), string.Format("{0:n0}", totalJatuhTempoProses), string.Format("{0:n0}", totalBelumJatuhTempoProses), string.Format("{0:n0}", totalNilaiProses), string.Format("{0:n0}", totalSelesai), string.Format("{0:n2}", totalAreaSelesai), string.Format("{0:n0}", totalSudahBayarSelesai), string.Format("{0:n0}", totalJatuhTempoSelesai), string.Format("{0:n0}", totalBelumJatuhTempoSelesai), string.Format("{0:n0}", totalNilaiSelesai), string.Format("{0:n0}", totalSeluruhAkuisisi), string.Format("{0:n2}", totalSeluruhArea), string.Format("{0:n0}", totalSeluruhNilai)); html = html.Replace("@ContentReport", HTMLContentReport); } else { html = html.Replace("@ContentReport", ""); } html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss")) .Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy")); ltView.Text = html; } catch (Exception ex) { log.Error(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { log.Info("ViewAssetSummaryByComp Page_Load."); string company = ""; string province = ""; string username = Request.QueryString["usr"]; int id = Convert.ToInt32(Request.QueryString["id"]); decimal totalAsset = 0; decimal totalSertipikat = 0; decimal totalGirik = 0; decimal totalLainnya = 0; decimal totalArea = 0; SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA(); DataTable dtParameter = new DataTable(); log.DebugFormat("Call GetReportParameter() Started. Parameters : id = {0}", id); dtParameter = ws.GetReportParameter(id); if (dtParameter.Rows.Count > 0) { company = dtParameter.Rows[0]["Parameter1"].ToString(); province = dtParameter.Rows[0]["Parameter2"].ToString(); } log.DebugFormat("Call GetReportParameter() Finished. Result {0} rows.", dtParameter.Rows.Count); DataTable dtAsset = new DataTable(); log.DebugFormat("Call GetAssetSummaryByComp() Started. Parameters : Company = {0}, Province = {0}", company, province); dtAsset = ws.GetAssetSummaryByComp(company, province); log.DebugFormat("Call GetAssetSummaryByComp() Finished. Result {0} rows.", dtAsset.Rows.Count); string html = System.IO.File.ReadAllText(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Template/HTML/AssetSummaryByComp.html")); if (dtAsset.Rows.Count > 0) { string HTMLContentReport = ""; for (int i = 0; i < dtAsset.Rows.Count; i++) { HTMLContentReport += string.Format(@"<tr> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{2}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{3}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{4}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{5}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{6}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{7}</td> </tr>", dtAsset.Rows[i]["CompanyName"].ToString(), dtAsset.Rows[i]["ProvinsiName"].ToString(), dtAsset.Rows[i]["AsetTypeName"].ToString(), string.Format("{0:n0}", Convert.ToDecimal(dtAsset.Rows[i]["hasAsset"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAsset.Rows[i]["hasSertipikat"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAsset.Rows[i]["hasGirik"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAsset.Rows[i]["Lainnya"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtAsset.Rows[i]["LuasTanah"].ToString()))); totalAsset += Convert.ToDecimal(dtAsset.Rows[i]["hasAsset"].ToString()); totalSertipikat += Convert.ToDecimal(dtAsset.Rows[i]["hasSertipikat"].ToString()); totalGirik += Convert.ToDecimal(dtAsset.Rows[i]["hasGirik"].ToString()); totalLainnya += Convert.ToDecimal(dtAsset.Rows[i]["Lainnya"].ToString()); totalArea += Convert.ToDecimal(dtAsset.Rows[i]["LuasTanah"].ToString()); } //Total HTMLContentReport += string.Format(@"<tr> <td colspan='3' style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{0}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{1}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{2}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{3}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{4}</b></td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>{5}</b></td> </tr>", "Total", string.Format("{0:n0}", totalAsset), string.Format("{0:n0}", totalSertipikat), string.Format("{0:n0}", totalGirik), string.Format("{0:n0}", totalLainnya), string.Format("{0:n0}", totalArea)); html = html.Replace("@ContentReport", HTMLContentReport); } else { html = html.Replace("@ContentReport", ""); } html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss")) .Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy")); ltView.Text = html; } catch (Exception ex) { log.Error(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { log.Info("ViewAssetDocumentChecklist Page_Load."); int id = Convert.ToInt32(Request.QueryString["id"]); string username = Request.QueryString["usr"]; string type = Request.QueryString["ty"]; string namaAset = ""; string kodeAset = ""; string status = ""; SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA(); DataTable dtParameter = new DataTable(); log.DebugFormat("Call GetReportParameter() Started. Parameters : id = {0}", id); dtParameter = ws.GetReportParameter(id); if (dtParameter.Rows.Count > 0) { status = dtParameter.Rows[0]["Parameter1"].ToString(); } log.DebugFormat("Call GetReportParameter() Finished. Result {0} rows.", dtParameter.Rows.Count); DataTable dtAsset = new DataTable(); log.DebugFormat("Call GetAssetDocumentChecklist() Started."); dtAsset = ws.GetAssetDocumentChecklist(status); log.DebugFormat("Call GetAssetDocumentChecklist() Finished. Result {0} rows.", dtAsset.Rows.Count); string html = System.IO.File.ReadAllText(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Template/HTML/AssetDocumentChecklist.html")); string HTMLDokumen = ""; if (dtAsset.Rows.Count > 0) { if (type == "d") { string HTMLContent = ""; HTMLContent += @"<div style='page-break-after: always;'> <table style='width:100%; font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'> <tr style='font-family: Calibri; font-size: 16px; color: black; text-align: center'> <td colspan='2'><b>Asset Document Checklist</b></td> </tr> <tr style='font-family: Calibri; font-size: 12px; color: black; text-align: center'> <td colspan='2'><b>@AsOf</b></td> </tr> <tr style='height:20px'> <td colspan='2'></td> </tr> <tr> <td style='width:500px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Aset</td> <td style='width:900px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Kekurangan</td> </tr>"; var DTAkuisisi = (from DataRow dRow in dtAsset.Rows select new { akuisisiID = dRow["AkuisisiID"], kodeAkuisisi = dRow["KodeAkuisisi"], statusAkuisisi = dRow["StatusAkuisisi"] }).Distinct().ToList(); int idx = 1; int idxOri = 1; bool pageBreak = false; foreach (var akuisisi in DTAkuisisi) { var DTAssetID = (from DataRow dRow in dtAsset.Rows where dRow["AkuisisiID"].ToString() == akuisisi.akuisisiID.ToString() select new { asetID = dRow["AsetID"], akuisisiID = dRow["AkuisisiID"] }).Distinct().ToList(); foreach (var asetid in DTAssetID) { var DTAsset = (from DataRow dRow in dtAsset.Rows where dRow["AsetID"].ToString() == asetid.asetID.ToString() && dRow["AkuisisiID"].ToString() == asetid.akuisisiID.ToString() select new { akuisisiID = dRow["AkuisisiID"], kodeAkuisisi = dRow["KodeAkuisisi"], kodeAset = dRow["KodeAset"], namaAset = dRow["NamaAset"], jenisDokumen = dRow["JenisDokumen"], keterangan = dRow["Keterangan"] }).ToList(); idx++; if (idx > 115 || (idxOri + DTAsset.Count()) > 115) { pageBreak = true; idx = 1; idxOri = 1; } foreach (var asset in DTAsset) { if (idx > 115) { pageBreak = true; } namaAset = asset.namaAset.ToString(); kodeAset = asset.kodeAset.ToString(); if (asset.keterangan.ToString() == "") { HTMLDokumen += asset.jenisDokumen.ToString().Trim() + "<br/>"; } else { HTMLDokumen += asset.jenisDokumen.ToString().Trim() + " - <i>" + asset.keterangan.ToString().Trim() + "</i><br/>"; } idx++; } idxOri = idx; if (pageBreak) { HTMLContent += @" </table> </div> <div style='page-break-after: always;'> <table style='width:100%; font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'> <tr style='font-family: Calibri; font-size: 16px; color: black; text-align: center'> <td colspan='11'><b>Asset Document Checklist</b></td> </tr> <tr style='font-family: Calibri; font-size: 12px; color: black; text-align: center'> <td colspan='21'><b>@AsOf</b></td> </tr> <tr style='height:20px'> <td colspan='11'></td> </tr> <tr> <td style='width:500px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Aset</td> <td style='width:900px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Kekurangan</td> </tr>"; pageBreak = false; } HTMLContent += @"<tr bgcolor=#F7F7F7><td colspan=2 style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>Kode Akuisisi : " + akuisisi.kodeAkuisisi.ToString() + " - " + akuisisi.statusAkuisisi.ToString() + "</b></td></tr>"; HTMLContent += string.Format(@"<tr> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td> </tr>", namaAset, HTMLDokumen); HTMLDokumen = ""; } } HTMLContent += @"<table style='width:100%; font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'> <tr style='height:20px'> <td></td> </tr> <tr style='font-family: Calibri; font-size: 10px; color: black; text-align: center'> <td>-- End of Report --</td> </tr> <tr style='font-family: Calibri; font-size: 10px; color: black; text-align: left'> <td>Printed by : @PrintedBy</td> </tr> </table>"; html = html.Replace("@ContentReport", HTMLContent); } else if (type == "v") { string HTMLContent = ""; HTMLContent += @"<div style='page-break-after: always;'> <table style='width:100%; font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'> <tr style='font-family: Calibri; font-size: 16px; color: black; text-align: center'> <td colspan='2'><b>Asset Document Checklist</b></td> </tr> <tr style='font-family: Calibri; font-size: 12px; color: black; text-align: center'> <td colspan='2'><b>@AsOf</b></td> </tr> <tr style='height:20px'> <td colspan='2'></td> </tr> <tr> <td style='width:500px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Aset</td> <td style='width:900px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Kekurangan</td> </tr>"; var DTAkuisisi = (from DataRow dRow in dtAsset.Rows select new { akuisisiID = dRow["AkuisisiID"], kodeAkuisisi = dRow["KodeAkuisisi"], statusAkuisisi = dRow["StatusAkuisisi"] }).Distinct().ToList(); foreach (var akuisisi in DTAkuisisi) { var DTAssetID = (from DataRow dRow in dtAsset.Rows where dRow["AkuisisiID"].ToString() == akuisisi.akuisisiID.ToString() select new { asetID = dRow["AsetID"], akuisisiID = dRow["AkuisisiID"] }).Distinct().ToList(); foreach (var asetid in DTAssetID) { var DTAsset = (from DataRow dRow in dtAsset.Rows where dRow["AsetID"].ToString() == asetid.asetID.ToString() && dRow["AkuisisiID"].ToString() == asetid.akuisisiID.ToString() select new { akuisisiID = dRow["AkuisisiID"], kodeAkuisisi = dRow["KodeAkuisisi"], kodeAset = dRow["KodeAset"], namaAset = dRow["NamaAset"], jenisDokumen = dRow["JenisDokumen"], keterangan = dRow["Keterangan"] }).ToList(); foreach (var asset in DTAsset) { namaAset = asset.namaAset.ToString(); kodeAset = asset.kodeAset.ToString(); if (asset.keterangan.ToString() == "") { HTMLDokumen += asset.jenisDokumen.ToString().Trim() + "<br/>"; } else { HTMLDokumen += asset.jenisDokumen.ToString().Trim() + " - <i>" + asset.keterangan.ToString().Trim() + "</i><br/>"; } } HTMLContent += @"<tr bgcolor=#F7F7F7><td colspan=2 style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'><b>Kode Akuisisi : " + akuisisi.kodeAkuisisi.ToString() + " - " + akuisisi.statusAkuisisi.ToString() + "</b></td></tr>"; HTMLContent += string.Format(@"<tr> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td> </tr>", namaAset, HTMLDokumen); HTMLDokumen = ""; } } HTMLContent += @"</table> </div> <table style='width:100%; font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'> <tr style='height:20px'> <td></td> </tr> <tr style='font-family: Calibri; font-size: 10px; color: black; text-align: center'> <td>-- End of Report --</td> </tr> <tr style='font-family: Calibri; font-size: 10px; color: black; text-align: left'> <td>Printed by : @PrintedBy</td> </tr> </table>"; html = html.Replace("@ContentReport", HTMLContent); } } else { html = html.Replace("@ContentReport", ""); } html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss")) .Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy")); ltView.Text = html; } catch (Exception ex) { log.Error(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { log.Info("ViewSertipikatAkanJatuhTempo Page_Load."); string username = Request.QueryString["usr"]; SIMAWS.WS_SIMA ws = new SIMAWS.WS_SIMA(); DataTable dtSertipikat = new DataTable(); log.DebugFormat("Call GetSertipikatAkanJatuhTempo() Started."); dtSertipikat = ws.GetSertipikatAkanJatuhTempo(); log.DebugFormat("Call GetSertipikatAkanJatuhTempo() Finished. Result {0} rows.", dtSertipikat.Rows.Count); string html = System.IO.File.ReadAllText(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "Template/HTML/SertipikatAkanJatuhTempo.html")); if (dtSertipikat.Rows.Count > 0) { string HTMLContent = ""; HTMLContent += @"<div style='page-break-after: always;'> <table style='font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'> <tr style='font-family: Calibri; font-size: 16px; color: black; text-align: center'> <td colspan='11'><b>Sertipikat Akan Jatuh Tempo</b></td> </tr> <tr style='font-family: Calibri; font-size: 12px; color: black; text-align: center'> <td colspan='21'><b>@AsOf</b></td> </tr> <tr style='height:20px'> <td colspan='11'></td> </tr> <tr> <td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Kode</td> <td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Aset</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nomor Sertipikat</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Tanggal Penerbitan</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Tanggal Berakhir Hak</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Sisa Hari Berlaku</td> <td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Alamat Sertipikat</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Luas Tanah Fisik</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Luas Tanah Sertipikat</td> <td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Jenis Hak Atas Tanah</td> <td style='width:200px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Pemegang Hak</td> </tr>"; for (int i = 1; i < dtSertipikat.Rows.Count; i++) { HTMLContent += string.Format(@"<tr> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{2}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{3}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{4}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{5}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{6}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{7}</td> <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{8}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{9}</td> <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{10}</td> </tr>", dtSertipikat.Rows[i - 1]["Kode"].ToString(), dtSertipikat.Rows[i - 1]["Nama Aset"].ToString(), dtSertipikat.Rows[i - 1]["Nomor Sertipikat"].ToString(), dtSertipikat.Rows[i - 1]["Tanggal Penerbitan"].ToString(), dtSertipikat.Rows[i - 1]["Tanggal Berakhir Hak"].ToString(), string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i - 1]["Sisa Hari Berlaku"].ToString())), dtSertipikat.Rows[i - 1]["Alamat Sertipikat"].ToString(), string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i - 1]["Luas Tanah Fisik"].ToString())), string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i - 1]["Luas Tanah Sertipikat"].ToString())), dtSertipikat.Rows[i - 1]["Jenis Hak Atas Tanah"].ToString(), dtSertipikat.Rows[i - 1]["Nama Pemegang Hak"].ToString()); if (i % 50 == 0) { HTMLContent += @" </table> </div> <div style='page-break-after: always;'> <table style='font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'> <tr style='font-family: Calibri; font-size: 16px; color: black; text-align: center'> <td colspan='11'><b>Sertipikat Akan Jatuh Tempo</b></td> </tr> <tr style='font-family: Calibri; font-size: 12px; color: black; text-align: center'> <td colspan='21'><b>@AsOf</b></td> </tr> <tr style='height:20px'> <td colspan='11'></td> </tr> <tr> <td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Kode</td> <td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Aset</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nomor Sertipikat</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Tanggal Penerbitan</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Tanggal Berakhir Hak</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Sisa Hari Berlaku</td> <td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Alamat Sertipikat</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Luas Tanah Fisik</td> <td style='width:100px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Luas Tanah Sertipikat</td> <td style='width:150px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Jenis Hak Atas Tanah</td> <td style='width:200px; text-align:center; background-color:#E0E0E0; font-weight:bold; padding:5px 15px 5px 15px; height:20px; border:.5pt solid black;'>Nama Pemegang Hak</td> </tr>"; } } HTMLContent += @"<table style='font-family: Arial; font-size: 11px; border-spacing: 0; border-collapse: collapse;'> <tr style='height:20px'> <td colspan='11'></td> </tr> <tr style='font-family: Calibri; font-size: 10px; color: black; text-align: center'> <td colspan='11'>-- End of Report --</td> </tr> <tr style='font-family: Calibri; font-size: 10px; color: black; text-align: left'> <td colspan='11'>Printed by : @PrintedBy</td> </tr> </table>"; html = html.Replace("@ContentReport", HTMLContent); } else { html = html.Replace("@ContentReport", ""); } html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss")) .Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy")); // if (dtSertipikat.Rows.Count > 0) // { // string HTMLContentReport = ""; // for (int i = 0; i < dtSertipikat.Rows.Count; i++) // { // HTMLContentReport += string.Format(@"<tr> // <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{0}</td> // <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{1}</td> // <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{2}</td> // <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{3}</td> // <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{4}</td> // <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{5}</td> // <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{6}</td> // <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{7}</td> // <td style='text-align: right; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{8}</td> // <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{9}</td> // <td style='text-align: left; padding: 5px 15px 5px 15px; border: 0.5pt solid black; height: 20px; min-width: 50px'>{10}</td> // // </tr>", dtSertipikat.Rows[i]["Kode"].ToString(), // dtSertipikat.Rows[i]["Nama Aset"].ToString(), // dtSertipikat.Rows[i]["Nomor Sertipikat"].ToString(), // dtSertipikat.Rows[i]["Tanggal Penerbitan"].ToString(), // dtSertipikat.Rows[i]["Tanggal Berakhir Hak"].ToString(), // string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Sisa Hari Berlaku"].ToString())), // dtSertipikat.Rows[i]["Alamat Sertipikat"].ToString(), // string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Luas Tanah Fisik"].ToString())), // string.Format("{0:n0}", Convert.ToDecimal(dtSertipikat.Rows[i]["Luas Tanah Sertipikat"].ToString())), // dtSertipikat.Rows[i]["Jenis Hak Atas Tanah"].ToString(), // dtSertipikat.Rows[i]["Nama Pemegang Hak"].ToString()); // } // html = html.Replace("@ContentReport", HTMLContentReport); // } // else // { // html = html.Replace("@ContentReport", ""); // } // html = html.Replace("@PrintedBy", username + " " + DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss")) // .Replace("@AsOf", "As of " + DateTime.Now.ToString("dd/MM/yyyy")); ltView.Text = html; } catch (Exception ex) { log.Error(ex.Message); } }