Exemplo n.º 1
0
    void init()
    {
        Bll.newsBll nb = new Bll.newsBll();
        string      s;

        if (Session["language"] != null && Session["language"].ToString() == "en-us")
        {
            s = "select title_eng as title, msg_eng as msg,link_eng as link,time  from tab_news where discription=N'福利计划" + Session["Company"] + "'";
        }
        else
        {
            s = "select *  from tab_news where discription=N'福利计划" + Session["Company"] + "'";
        }

        DataTable dt = nb.NewsSelect(s);

        this.Label1.Text            = DateTime.Parse(dt.Rows[0]["time"].ToString()).ToShortDateString();
        this.HyperLink1.NavigateUrl = this.HyperLink2.NavigateUrl += dt.Rows[0]["link"].ToString();
        this.HyperLink1.Text        = dt.Rows[0]["title"].ToString();
        content = dt.Rows[0]["msg"].ToString();
    }