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);
     }
 }
Пример #2
0
    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);
        }
    }
Пример #3
0
    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 = "******";
        }
    }