public CLayer.StaticPage GetPage(long pageId)
{
string sql = "Select * From staticpage Where PageId=" + pageId.ToString();
DataTable dt = Connection.GetSQLTable(sql);
CLayer.StaticPage result = null;
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
result = new CLayer.StaticPage();
result.PageId = Connection.ToLong(dr["PageId"]);
result.City = Connection.ToString(dr["City"]);
result.Location = Connection.ToString(dr["Location"]);
result.PageTitle = Connection.ToString(dr["PageTitle"]);
result.Description = Connection.ToString(dr["Description"]);
result.FileName = Connection.ToString(dr["FileName"]);
result.Image = Connection.ToString(dr["Image"]);
result.ShowInWidget = Connection.ToBoolean(dr["ShowInWidget"]);
result.RootFolder = Connection.ToString(dr["RootFolder"]);
}
return(result);
}