简单留言管理

//简易留言管理，使用repeater控件绑定
<table align="center" border="1" cellpadding="0px" cellspacing="0px" width="751px">
                    <tr>
                        <td colspan="6" style="text-align: right; padding-right: 20px;">
                        </td>
                    </tr>
                    <tr>
                        <td align="center" height="20px" width="75px">
                            编号
                        </td>
                        <td align="center" width="150px">
                            标题
                        </td>
                        <td align="center" width="75px">
                            留言时间
                        </td>
                        <td align="center">
                            留言内容
                        </td>
                        <td align="center" width="75px">
                            回复内容
                        </td>
                        <td align="center" width="95px">
                            操作
                        </td>
                    </tr>
                    <asp:Repeater ID="Repeater1" runat="server">
                        <ItemTemplate>
                            <tr>
                                <td align="center" height="30px">
                                    <%#Eval("id")%>
                                </td>
                                <td align="left">
                                    <%#Eval("title")%>
                                </td>
                                <td align="center">
                                    <%#Eval("sendTime")%>
                                </td>
                                <td align="left">
                                        <%#Eval("titleContent") %>
                                </td>
                                <td align="left">
                                    <%#Eval("reply")%>
                                </td>
                                <td align="center" width="110px">
                                    <a href='update.aspx?id=<%#Eval("id")%>'>审核</a>&nbsp;<asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%#Eval("id")%>'
                                            OnClick="LinkButton1_Click" OnClientClick="return confirm('是否真的要删除？')">删除</asp:LinkButton>
                                </td>
                            </tr>
                        </ItemTemplate>
                    </asp:Repeater>
                </table>
//删除留言
protected void LinkButton1_Click(object sender, EventArgs e)
    {
        // 当前点击的按钮

        LinkButton lb = (LinkButton)sender;
        // 
        string id = lb.CommandArgument;
        // 删除该留言
        bool b = new MessageDAL().Delete("id="+id);
        if (b)
        {
            // 重新绑定
            bind();
            showPage();
            Lib.Common.MessBox("删除成功！");
        }
        else
        {
           HttpContext rq = null;
            Lib.Common.MessBox("删除失败！", "Administrator.aspx", rq);
        }
//添加、更新回复
protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            show(); 
        }
    }
    //取出相应的值
    public void show()
    {
        //初始化MessageDAL
        MessageDAL msd = new MessageDAL();
        int id = int.Parse(Request.QueryString["id"].ToString());
        //将id赋值给变量strWhere
        string strWhere = "id=" + id;
        //使用GetDataSet()方法返回DataSet
        DataTable dt = msd.GetDataSet(strWhere).Tables[0];
        //用TextBox将取的值显示出来
        TextBox1.Text = dt.Rows[0]["title"].ToString();
        TextBox2.Text = dt.Rows[0]["sendTime"].ToString();
        TextBox3.Text = dt.Rows[0]["titleContent"].ToString();
        TextBox4.Text = dt.Rows[0]["reply"].ToString();
    }
    //修改提交
    public void submitUpdate()
    {
        MessageDAL msd = new MessageDAL();
        MessageModel msm = new MessageModel();
        //使用Request.QueryString获取id的值
        msm.id = int.Parse(Request.QueryString["id"].ToString());
        //将修改后的值传给变量
        msm.title = TextBox1.Text;
        msm.titleContent = TextBox3.Text;
        msm.sendTime = Convert.ToDateTime(TextBox2.Text);
        msm.reply = TextBox4.Text;
        bool b = msd.Update(msm, "id="+msm.id);
        if (b)
        {
            Common.MessBox("修改成功！");
        }
        else
        {
            Common.MessBox("修改失败！");
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //提交修改
        submitUpdate();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        //重置时reply清空
        TextBox4.Text = "";
    }