browsemessage.ascx.cs

内容管理 内容管理 内容管理 内容管理 内容管理

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class WebUserControl_BrowseMessage : System.Web.UI.UserControl
{
    string VirtualPath = "";
    

    protected void Page_Load(object sender, EventArgs e)
    {
        if (this.VirtualPath == "")  //得到相对于首页Index.aspx的路径
        {
            this.VirtualPath = GetVirtualPath.getVirtualPath("Index.aspx");
        }


        if (!IsPostBack)
        {
            
            if (Request["ID"] != null)
            {
       
                ViewState["ArticleID"] = Request["ID"].ToString();
            }          
        }

        openDataBase_and_BindToDataGrid(Convert.ToInt32(ViewState["ArticleID"]));
    }


    //翻页
    protected void changepage(object sender, System.Web.UI.WebControls.GridViewPageEventArgs e)
    {

        if (e.NewPageIndex >= 0)
        {
            this.GridView1.PageIndex = e.NewPageIndex;
            int articleID = 1;
            if (ViewState["ArticleID"] != null)
            {
                articleID = Convert.ToInt32(ViewState["ArticleID"].ToString());
            }
            openDataBase_and_BindToDataGrid(articleID);

        }
    }



    private void openDataBase_and_BindToDataGrid(int ArticleID)
    {

        DataSet ds = new DataSet();
        DAL.boBusiness bo = new DAL.boBusiness();
        DAL.MakeConnection Conn = new DAL.MakeConnection();
        DAL.clsDBConnkey ConnKey = new DAL.clsDBConnkey();
        ConnKey = bo.loadkey();//得到config数据库连接
        string sql = "";

        if (ArticleID >= 0)
        {
             sql = "Select ID,Title,LeavewordTime,Content,RevertContent,RevertTime,WebUser,IP,Email,IsRevert,IsNominate "
                            + " from MessageBoard  where  ArticleID=" + ArticleID + " order by leavewordtime desc";
        }
        else
        {
            sql="Select ID,Title,LeavewordTime,Content,RevertContent,RevertTime,WebUser,IP,Email,IsRevert,IsNominate "
                    + " from MessageBoard   order by leavewordtime desc";
        }


        try
        {
            if (sql != "")
            {
                ds = (DataSet)Conn.MakeConnectionMethod(sql, ConnKey, DAL.executeMethod.execute_DataSet, DAL.
                    EnumDBType.Sql, VirtualPath);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    DataTable dt = ds.Tables[0];
                    dt.Columns.Add(new DataColumn("HTML", typeof(string)));
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        for (int j = 0; j < dt.Columns.Count; j++)
                        {
                            if (dt.Rows[i][j] == null || dt.Rows[i][j].ToString() == "")
                            {
                                dt.Rows[i][j] = DBNull.Value;

                            }
                        }
                        dt.Rows[i]["HTML"] = IndexBusiness.MakeHTML(dt.Rows[i], VirtualPath);
                    }

                    if (this.GridView1.PageIndex > 0)
                    {
                        int intPageCount = (dt.Rows.Count / this.GridView1.PageSize) + (dt.Rows.Count % this.GridView1.PageSize != 0 ? 1 : 0);
                        if (intPageCount <= this.GridView1.PageIndex)
                        { this.GridView1.PageIndex = 0; }
                    }

                    this.GridView1.DataSource = dt.DefaultView;
                    this.GridView1.DataBind();
                }
            }
        }
        catch (System.Exception ex)
        {
            throw ex;
        }
    }

}