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