protected void Page_Load(object sender, EventArgs e) { log = new Log(this); try { forumTopicId = RequestUtils.GetForumTopicId(this); userId = Utils.GetUserId(Context); if (!base.IsPostBack) { if (userId != 0) { using (GmConnection conn = Global.CreateConnection()) { string s = conn.ExecuteScalar("select Name from UserInfo where Id=" + userId) as string; if (s != null) { tbName.Text = s; } } } } } catch (Exception ex) { log.Exception(ex); } }
protected void Page_Load(object sender, EventArgs e) { log = MainMasterPage.InitPage(this); int forumTopicId = RequestUtils.GetForumTopicId(this); this.SqlDataSource1.SelectParameters["ForumTopicId"].DefaultValue = forumTopicId.ToString(); try { string cmdText = "SELECT Forums.Id AS ForumId, Forums.Name AS ForumName, ForumTopics.Name AS ForumTopicName FROM Forums INNER JOIN ForumTopics ON Forums.Id = ForumTopics.ForumId WHERE (ForumTopics.Id = @ForumTopicId)"; using (GmConnection conn = Global.CreateConnection()) { GmCommand cmd = conn.CreateCommand(cmdText); cmd.AddInt("ForumTopicId", forumTopicId); using (GmDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { forumId = dr.GetInt(); forumName = dr.GetString(); forumTopicName = dr.GetString(); } else { return; } } } } catch (Exception ex) { log.Exception(ex); } }
private void LoadData() { int forumTopicId = RequestUtils.GetForumTopicId(this); hlAdd.NavigateUrl += "?ft=" + forumTopicId; gridHelper.ClearDataTable(); string query = "select ForumMessages.Id,Date,UserName,SUBSTRING(Text,0,50) as Text, Symbol from ForumMessages left join Statuses on Statuses.Id=Status where ForumTopicId=" + forumTopicId; using (GmConnection conn = Global.CreateConnection()) { conn.Fill(gridHelper.DataTable, query); } gridHelper.DataTable.DefaultView.Sort = "Id desc"; }
void LoadData() { int id = RequestUtils.GetForumTopicId(this); if (id != 0) { using (GmConnection conn = Global.CreateConnection()) { forumTopic = ForumTopic.GetForumTopic(conn, id); } } if (forumTopic == null) { forumTopic = new ForumTopic(); int fr = RequestUtils.GetForumId(this); if (fr != 0) { forumTopic.forumId = fr; } } }
void LoadData() { int id = RequestUtils.GetForumMessageId(this); if (id != 0) { using (GmConnection conn = Global.CreateConnection()) { forumMessage = ForumMessage.GetForumMessage(conn, id); } } if (forumMessage == null) { forumMessage = new ForumMessage(); int ft = RequestUtils.GetForumTopicId(this); if (ft != 0) { forumMessage.forumTopicId = ft; } forumMessage.userName = "******"; } }