private void Fill()
{
string strSql = "SELECT DISTINCT"
+ " NoUnit"
+ ",Koordinat"
+ " FROM MS_UNIT"
+ " WHERE Peta = '" + f + "'"
+ " ORDER BY NoUnit";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rpt, rs, "Floor plan ini belum memiliki koordinat.");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = rs.Rows[i]["NoUnit"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Cut(rs.Rows[i]["Koordinat"], 100);
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
}
private void Fill()
{
var d = Db.Rs("Select * from ms_siteplan where id='" + IDx + "'");
if (d.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
var r = d.Rows[0];
nama.Text = r["Nama"].ToString();
if (File.Exists(Server.MapPath(".").ToLower().Replace("adminjual", "") + r["PathGambarDasar"].ToString()))
{
imgdasar.ImageUrl = Path.Combine(Request.PhysicalApplicationPath.ToLower(), r["PathGambarDasar"].ToString());// r["PathGambarDasar"].ToString();
}
//if (File.Exists(Server.MapPath(".").ToLower().Replace("adminjual", "") + r["PathGambarTransparent"].ToString()))
//{
// imgtransparent.ImageUrl =r["PathGambarTransparent"].ToString();
//}
if ((bool)r["isParent"])
{
tr1.Visible = tr2.Visible = rpt.Visible = false;
}
string strSql = "SELECT DISTINCT"
+ " NoUnit"
+ ",Koordinat"
+ " FROM MS_UNIT"
+ " WHERE Peta = '" + r["Nama"] + "'"
+ " ORDER BY NoUnit";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rpt, rs, "Floor plan ini belum memiliki koordinat.");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow tr = new TableRow();
TableCell c;
c = new TableCell();
c.Text = rs.Rows[i]["NoUnit"].ToString();
tr.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Cut(rs.Rows[i]["Koordinat"], 100);
tr.Cells.Add(c);
Rpt.Border(tr);
rpt.Rows.Add(tr);
}
}
