book.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;
//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

public partial class book : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Page.Title = odb.scr("select title from config");//设置页标题
        Server.Execute("pd.aspx");
        if (!IsPostBack)
        {
            fill();
        }  
    }
    private void fill()
    {//做的一个方法，因为页内将有多次的绑定
        //这里设置一个隐藏的Label，用与储存当前的页索引
        int cup = Convert.ToInt32(pagelbl.Text);

        PagedDataSource ps = new PagedDataSource();//NEW一个分页数据源
        ps.DataSource = odb.ds("select * from guest where vis=0 order by id desc").DefaultView;//送一个SQL语句进去，确定该数据源的数据源，有点绕吧，呵呵
        ps.AllowPaging = true;//允许分页
        ps.PageSize = odb.num("booknum");//设置页的数量
        ps.CurrentPageIndex = cup-1;
        if (!IsPostBack)
        {//判断页面是否第一次载入
            for (int i = 1; i <= ps.PageCount; i++)
            {//循环出页码
                pageddl.Items.Add(i.ToString());
            }
        }
        //下面主要是控制上下翻页按纽是否起用
        pageup.Enabled = true;
        pagedown.Enabled = true;
        if (ps.IsFirstPage)
        {//如果是最前页，上页按纽不可用
            pageup.Enabled = false;
        }
        if (ps.IsLastPage)
        {//如果是最后页，下页按纽不可用
            pagedown.Enabled = false;
        }
        //设置页码下拉菜单当前选中的值
        pageddl.SelectedItem.Text = cup.ToString();
        //终于可以绑定给DataList了
        DataList1.DataSource = ps;
        DataList1.DataKeyField = "id";
        DataList1.DataBind();
        }
    protected void pageddl_SelectedIndexChanged(object sender, EventArgs e)
    {//页码下拉菜单事件
        pagelbl.Text = pageddl.SelectedItem.Text.ToString();
        fill();
    }
    protected void pagedown_Click(object sender, EventArgs e)
    {//下页事件
        pagelbl.Text = Convert.ToString(Convert.ToInt32(pagelbl.Text)+1);
        pageddl.SelectedValue = pagelbl.Text;
        fill();
    }
    protected void pageup_Click(object sender, EventArgs e)
    {//上页事件
        pagelbl.Text = Convert.ToString(Convert.ToInt32(pagelbl.Text)-1);
        pageddl.SelectedValue = pagelbl.Text;
        fill();
    }
    protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
        {
            int id = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex]);
            //如果没有QQ就不显示QQ图标
            Image qq = (Image)e.Item.FindControl("Image2");
            qq.Visible = odb.img("select qq from guest where id=" + id + "");
            //email
            Image email = (Image)e.Item.FindControl("Image3");
            email.Visible = odb.img("select email from guest where id=" + id + "");
            //MSN
            Image msn = (Image)e.Item.FindControl("Image4");
            msn.Visible = odb.img("select msn from guest where id=" + id + "");
            //url
            Image url = (Image)e.Item.FindControl("Image5");
            url.Visible = odb.img("select url from guest where id=" + id + "");
            //如果有密码就不显示内容
            Label concent = (Label)e.Item.FindControl("Label4");
            Panel dengl = (Panel)e.Item.FindControl("dl");
            if (!odb.img("select pwd from guest where id=" + id + ""))
            {//如果没密码的话就直接显示内容以及需要的回复
                concent.Text = Server.HtmlDecode(odb.scr("select concent from guest where id=" + id + "")).ToString();
                if (Convert.ToInt32(odb.scr("select count(*) from [read] where lid=" + id + ""))>0)
                {//如果有回复的话就把回复panel以及下面的东西都找出来，然后绑上数据，显示出来
                        Panel re = (Panel)e.Item.FindControl("Panel1");
                        re.Visible = true;

                        DataList read = (DataList)e.Item.FindControl("DataList2");
                        read.DataSource = odb.ds("select * from [read] where lid=" + id + "");
                        read.DataBind();
                }
            }
            else
            {//如果有密码就把内容隐去，出现登陆项
                if (Session["fk"] != null || Session["qx"] != null)
                {
                    concent.Text = Server.HtmlDecode(odb.scr("select concent from guest where id=" + id + "")).ToString();
                    if (Convert.ToInt32(odb.scr("select count(*) from [read] where lid=" + id + "")) > 0)
                    {//如果有回复的话就把回复panel以及下面的东西都找出来，然后绑上数据，显示出来
                        Panel re = (Panel)e.Item.FindControl("Panel1");
                        re.Visible = true;

                        DataList read = (DataList)e.Item.FindControl("DataList2");
                        read.DataSource = odb.ds("select * from [read] where lid=" + id + "");
                        read.DataBind();
                    }
                }
                else
                { 
                    dengl.Visible = true;
                    concent.Visible = false;
                }
            }
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {//登陆查看信息
        for (int i = 0; i < DataList1.Items.Count; i++)
        {
            TextBox pwd = (TextBox)DataList1.Items[i].FindControl("dlpwd");
            Label id=(Label)DataList1.Items[i].FindControl("iidd");
            if (odb.scr("select [pwd] from [guest] where id=" + id.Text + "").ToString() == pwd.Text.ToString())
            {
                Session["fk"] = pwd.Text.ToString();

                Label concent = (Label)DataList1.Items[i].FindControl("Label4");
                Panel dengl = (Panel)DataList1.Items[i].FindControl("dl");

                dengl.Visible = false;
                concent.Visible = true;
                if (Convert.ToInt32(odb.scr("select count(*) from [read] where lid=" + id.Text + "")) > 0)
                {//如果有回复的话就把回复panel以及下面的东西都找出来，然后绑上数据，显示出来
                    Panel re = (Panel)DataList1.Items[i].FindControl("Panel1");
                    re.Visible = true;

                    DataList read = (DataList)DataList1.Items[i].FindControl("DataList2");
                    read.DataSource = odb.ds("select * from [read] where lid=" + id.Text + "");
                    read.DataBind();
                }
            }
        }
    }
}