bloglist.aspx.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 WebPage_BlogList : System.Web.UI.Page
{
    public string VirtualPath = "";
    private string strWhere = ""; //显示文章sql

    protected void Page_Load(object sender, EventArgs e)
    {

        //验证用户功能-------------------------------------------------
        this.ValidUserStation();
        //-------------------------------------------------------------

        makeScriptAndSelItemID();														//添加客户端脚本及隐藏的选定行ID控件

        if (!IsPostBack)
        {
            if (this.hidWhere.Value != "")
            {
                strWhere = this.hidWhere.Value;
            }
            else
            {
                strWhere = "";
            }
            this.OpenDatebase(strWhere);
        }
    }
    protected void btnDel_Click(object sender, EventArgs e)
    {
        string m_strIDList = "";
        HtmlInputHidden oHtmlHid = (HtmlInputHidden)this.FindControl("hidSelectedID");
        m_strIDList = oHtmlHid.Value;
        if (m_strIDList != "")
        {
            m_strIDList = m_strIDList.Substring(0, m_strIDList.Length - 1);
            this.DeleteData(m_strIDList);
        }
        oHtmlHid.Value = "";
    }

       


    #region	删除文章
    /// <summy>
    /// 删除文章
    /// </summary>
    private void DeleteData(string strIDList)
    {
        if (strIDList.Trim() != "")
        {
            string sqlDel = "";

            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数据库连接


            bool blnSaveState = true;
            string strErrMsg = "";
            try
            {

                sqlDel = "Delete MessageBoard Where ID IN(" + strIDList.Trim() + ")";
                //-------------------------------------------------------------------------------------------------------
                Conn.MakeConnectionMethod(sqlDel, ConnKey, DAL.executeMethod.execute_NoneQuery, DAL.EnumDBType.Sql, VirtualPath);

                //当前页
                string[] strIDColl = strIDList.Split(",".ToCharArray());
                if (strIDColl.Length == this.GridView1.Rows.Count)
                {
                    if (this.GridView1.PageIndex > 0)
                    {
                        this.GridView1.PageIndex = this.GridView1.PageIndex - 1;
                    }
                }


            }
            catch (Exception es)
            {
                strErrMsg = es.Message;
                blnSaveState = false;
            }
            finally
            {
                if (blnSaveState)
                {
                    Response.Write("<script language='javascript'>window.setTimeout(\" alert('删除文章成功！')\",100)</script>");
                }
                else
                {
                    Response.Write("<script language='javascript'>window.setTimeout(\"alert('删除文章失败！')\",100)</script>");
                }

            }

            if (blnSaveState)
            {
                if (this.hidWhere.Value != "")
                {
                    strWhere = this.hidWhere.Value;
                }
                else
                {
                    strWhere = "";
                }
                OpenDatebase(strWhere);
            }
        }
    }
    #endregion
    


    /// <summary>
    /// 添加表格的选择框列(表格列表必须)
    /// </summary>
    /// <param name="oDT">要添加选择框的表对象</param>
    /// <returns></returns>
    private DataTable makeSelectItem(DataTable oDT)
    {
        DataTable o_DT = oDT;
        if (oDT != null)
        {
            if (oDT.Columns.Count > 0)
            {
                string strItemValue = "";
                oDT.Columns.Add(new DataColumn("CheckSelected", typeof(string)));

                HtmlInputHidden o_hidAllID = (HtmlInputHidden)this.FindControl("hidAllID");
                o_hidAllID.Value = "";

                int m_Index = 0;
                int m_StartIndex = this.GridView1.PageIndex * this.GridView1.PageSize;
                int m_Count = m_StartIndex + this.GridView1.PageSize;

                foreach (DataRow oDR in oDT.Rows)
                {
                    if (m_Index >= m_StartIndex && m_Index < m_Count)
                    {
                        if (m_Index > m_StartIndex) { o_hidAllID.Value += ","; }
                        o_hidAllID.Value += oDR["ID"].ToString();//记录当前页所有的ID
                    }
                    strItemValue = "<INPUT id=\"chkBox" + oDR["ID"].ToString() + "\" style=\"CURSOR: hand\" onclick=\"SelCheckBox('" + oDR["ID"].ToString() + "');\" type=\"checkbox\" value=\""
                        + oDR["ID"].ToString() + "\">";
                    oDR["CheckSelected"] = strItemValue;
                    m_Index += 1;
                }
            }
        }

        return o_DT;
    }

    #region	验证用户可使用的功能
    /// <summary>
    /// 验证用户身份
    /// </summary>
    /// <returns></returns>
    private void ValidUserStation()
    {
        string userid = "";
        HttpCookie Cookie = CheckLogin();

        if (Cookie != null)
        {
            userid = Cookie["User_ID"].ToString();

        }
        else
        {
            Response.Write("<script language='javascript'>window.setTimeout(\" alert('您必须登陆才可以文章！')\",100);</script>");
            return;

        }

        if (userid != "")
        {
            this.hidIsModify.Value = "modify";
            //this.hidIsNew.Value = "new";
        }
        else
        {
            ShowPrompt();
        }
    }

    private void ShowPrompt()
    {
        string strUrl = "<script language='javascript'>"
            + "window.setTimeout(\"alert('系统检查到[会话已过期]或[您尚未登录],将自动转到登录页面！')\", 100);"
            + "</script>";
        Response.Write(strUrl);

        strUrl = "<script language='javascript'>"
            + "window.open("
            + "\"../ManageMain.aspx\","
            + "\"_top\","
            + "\"\""
            + ",true);"
            + "</script>";
        Response.Write(strUrl);
        Response.End();
        return; ;
    }
    #endregion


    /// <summary>
    /// 添加客户端脚本及隐藏的选定行ID控件(表格列表必须)
    /// </summary>
    private void makeScriptAndSelItemID()
    {
        //添加一个隐藏控件用于记录选取的行ID
        HtmlInputHidden oHtmlHid = new HtmlInputHidden();
        oHtmlHid.ID = "hidSelectedID";

        this.divParent.Controls.Add(oHtmlHid);

        oHtmlHid = new HtmlInputHidden();
        oHtmlHid.ID = "hidAllID";

        this.divParent.Controls.Add(oHtmlHid);

        string strScript = "<script language=javascript>\n"
            + "//选择单个选项\n"
            + "\tfunction SelCheckBox(strID)\n"
            + "\t{\n"
            + "\t\tvar o_checkBox = event.srcElement;\n"
            + "\t\tvar strIDColl = new String();\n"
            + "\t\tvar strNameColl = new String();\n"
            + "\t\tstrIDColl = document.all(\"hidSelectedID\").value;\n"
            + "\t\tif (o_checkBox.checked)\n"
            + "\t\t{\n"
            + "\t\t\tstrIDColl += strID + \",\";\n"
            + "\t\t}\n"
            + "\t\telse\n"
            + "\t\t{\n"
            + "\t\t\tstrIDColl = strIDColl.replace(strID + \",\",\"\");\n"
            + "\t\t}\n"
            + "\t\tdocument.all(\"hidSelectedID\").value = strIDColl;\n"
            + "\t}\n\n"
            + "//选择全部选项\n"
            + "\tfunction SelectAllcheckBox()"
            + "\t{"
            + "\t\tvar strAllID = document.all(\"hidAllID\").value;"
            + "\t\tif (strAllID != \"\")"
            + "\t\t{"
            + "\t\t\tvar strAllIDColl = strAllID.split(\",\");"
            + "\t\t\tvar blnChecked = window.event.srcElement.checked;"
            + "\t\t\tfor (i=0;i<strAllIDColl.length;i++)"
            + "\t\t\t{"
            + "\t\t\t\tdocument.all(\"chkBox\"+strAllIDColl[i]).checked = blnChecked;"
            + "\t\t\t\tSelCheckBox(strAllIDColl[i]);"
            + "\t\t\t}"
            + "\t\t}"
            + "\t}"
            + "</script>\n";
        Response.Write(strScript);
    }



    public void OpenDatebase(string strwhere)
    {
        string sql = "Select ID,Title,CreateTime "
                + ",ReadTotal "
                + ",CASE WHEN IsNominate IS NULL THEN '' WHEN IsNominate = 0 THEN '<font style=\"FONT-SIZE:14pt;COLOR:#0000c0\">×</font>' WHEN IsNominate = 1 THEN '<font style=\"FONT-SIZE:14pt;COLOR:#0000c0\">√</font>' END IsNominate"
            //  + ",CASE WHEN IsRevert IS NULL THEN '' WHEN IsRevert = 0 THEN '<font style=\"FONT-SIZE:14pt;COLOR:#0000c0\">×</font>' WHEN IsRevert = 1 THEN '<font style=\"FONT-SIZE:14pt;COLOR:#0000c0\">√</font>' END IsRevert"
            //  + ",CASE WHEN Type IS NULL THEN '表扬' WHEN Type=0 THEN '表扬' WHEN Type=1 THEN '表扬' WHEN Type=2 THEN '咨询' WHEN Type=3 THEN '建议' WHEN Type=4 THEN '批评' END Type"
                + " from Article ";
        if (strwhere != "")
        {
            sql += strwhere;
        }
        else
        {
            sql += " order by CreateTime desc";
        }

        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数据库连接	

        ds = (DataSet)Conn.MakeConnectionMethod(sql, ConnKey, DAL.executeMethod.execute_DataSet, DAL.
            EnumDBType.Sql, VirtualPath);

        if (ds.Tables[0].Rows.Count > 0)
        {
            DataTable myTable = ds.Tables[0];
            //myTable.Columns.Add(new DataColumn("Type2",typeof(string)));

            for (int i = 0; i < myTable.Rows.Count; i++)
            {
                if (myTable.Rows[i]["Title"].ToString().Length > 30)
                {
                    myTable.Rows[i]["Title"] = myTable.Rows[i]["Title"].ToString().Substring(0, 30) + "...";
                }

            }

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

            this.GridView1.DataSource = makeSelectItem(myTable);
            this.GridView1.DataBind();
        }
        else
        {
            DataTable myTable = ds.Tables[0];
            if (myTable == null) { this.GridView1.PageIndex = 0; }
            if (this.GridView1.PageIndex > 0)
            {
                int intPageCount = (myTable.Rows.Count / this.GridView1.PageSize) + (myTable.Rows.Count % this.GridView1.PageSize != 0 ? 1 : 0);
                if (intPageCount <= this.GridView1.PageIndex)
                { this.GridView1.PageIndex = 0; }
            }

            this.GridView1.DataSource = makeSelectItem(myTable);
            this.GridView1.DataBind();
        }

    }


    #region CheckLogin()//个人用户是否登录<返回一个HttpCookie>
    /// <summary>
    /// 是否登录
    /// </summary>
    /// <returns></returns>
    private HttpCookie CheckLogin()
    {

        HttpCookie Cookie = Request.Cookies["Message"];
        HttpCookie retCookie = null;
        if (Cookie == null || Cookie.ToString() == "")
        {
            return retCookie;
        }
        else
        {
            retCookie = Request.Cookies["Message"];
            return retCookie;
        }

    }
    #endregion


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

        if (e.NewPageIndex >= 0)
        {
            this.GridView1.PageIndex = e.NewPageIndex;
            if (this.hidWhere.Value != "")
            {
                strWhere = this.hidWhere.Value;
            }
            else
            {
                strWhere = "";
            }
            this.OpenDatebase(strWhere);

        }
    }
    protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e)
    {
        if (this.hidIsModify.Value.ToLower() == "modify")
        {
            int intSelIndex = this.GridView1.SelectedIndex;

            if (intSelIndex >= 0)
            {
                string strUrl = "AddBlog.aspx?FunID=1&ID=" + this.GridView1.Rows[intSelIndex].Cells[0].Text.Trim();
                //+"&FunID=1";0             

                Response.Redirect(strUrl, true);
            }
        }
        else
        {
            string strUrl = "<script language='javascript'>"
                + "window.setTimeout(\"alert('您没有[修改]权限,如有需要请与系统管理员联系！')\", 100);"
                + "</script>";
            Response.Write(strUrl);
        }
    }


    protected void btnAdd_Click(object sender, EventArgs e)
    {
        string strUrl = "AddBlog.aspx?ID=2&FunID=2";
        Response.Redirect(strUrl, true);
    }
}