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)
{
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("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);
}
}