购物网第一阶段总结笔记4：友情链接模块之 友情链接的查询和修改

1：友情链接的查询
aspx代码：

    <asp:TextBox ID="txtkey" runat="server"></asp:TextBox>
    <asp:Button ID="btnSearch" runat="server" Text="查询" onclick="btnSearch_Click" />

cs代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Web.admin
{
    public partial class link_list : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                anp.RecordCount = new MyShop.DAL.LinkDAO().CalcCount(GetCond());
                BindRep();
            }
        }

        //sql中的where语句
        private string GetCond()
        {
            string cond = "";
            if (txtkey.Text.Trim().Length!=0)
            {
                string key = txtkey.Text.Trim();
                cond = "linkname like '%" + key + "%' or url like '%" + key + "%'";
            }
            return cond;
        }

        //数据控件绑定函数
        private void BindRep()
        {
            replist.DataSource = new MyShop.DAL.LinkDAO().GetList("*", "createDate", "desc", anp.PageSize, anp.CurrentPageIndex, GetCond());
            replist.DataBind();
        }

        //删除友情链接
        protected void Del(object sender, EventArgs e)
        {
            //利用linkButton的CommandArgument获取前台传入的参数
            string id = (sender as LinkButton).CommandArgument;
            new MyShop.DAL.LinkDAO().Delete(int.Parse(id));//删除

            //重新绑定数据
            BindRep();
        }

        //分页事件
        protected void anp_PageChanged(object sender, EventArgs e)
        {
            BindRep();
        }
        //查询
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            anp.RecordCount = new MyShop.DAL.LinkDAO().CalcCount(GetCond());//把cond参数传给CalcCount
            BindRep();
        }
    }
}

2：友情链接的修改
当点击修改按钮时候，链接到link_add.aspx ，然后传递给这个页面一个id，通过这个id，取得和此id相关的数据显示到页面的TextBox中。

 <a href='link_add.aspx?id=<%#Eval("id") %>'>修改</a>

然后再link_add.asp中处理修改事件：

当点击修改按钮，进入link_add.asp中的时候，如果id存在的话，就把数据加载到文本框中：

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string id=Request.QueryString["id"];
                int x;

                if (!string.IsNullOrEmpty(id)&&int.TryParse(id,out x))
                {
                    MyShop.Model.Link model = new MyShop.DAL.LinkDAO().GetModel(x);

                    if (model!=null)
                    {
                        txtlinkname.Text = model.linkname;
                        txturl.Text = model.url;
                        btnadd.Text = "修改";
                        litH1.Text = "修改友情链接";
                    }
                }
            }
        }

修改按钮的点击事件：

          if (btnadd.Text == "修改")
            { 
                 string id=Request.QueryString["id"];
                 int x;
                 if (!string.IsNullOrEmpty(id)&&int.TryParse(id,out x))
                 {
                     MyShop.Model.Link model = new MyShop.DAL.LinkDAO().GetModel(x);
                     if (model!=null)
                     {
                         model.linkname = txtlinkname.Text.Trim();
                         model.url = txturl.Text.Trim();
                         model.createDate = DateTime.Now;
                         new MyShop.DAL.LinkDAO().Update(model);
                         txtlinkname.Text = "";
                         txturl.Text = "";
                         litmsg.Text = "<span style='color:blue'>修改成功！</span>";
                         return;
                     }
                 }

            }

最终的link_add.asp的cs代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;


namespace Web.admin
{
    public partial class link_add : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string id=Request.QueryString["id"];
                int x;

                if (!string.IsNullOrEmpty(id)&&int.TryParse(id,out x))
                {
                    MyShop.Model.Link model = new MyShop.DAL.LinkDAO().GetModel(x);

                    if (model!=null)
                    {
                        txtlinkname.Text = model.linkname;
                        txturl.Text = model.url;
                        btnadd.Text = "修改";
                        litH1.Text = "修改友情链接";
                    }
                }
            }
        }

        protected void btnadd_Click(object sender, EventArgs e)
        {
            string name = txtlinkname.Text.Trim();
            string url = txturl.Text.Trim();

            //修改友情链接
            if (btnadd.Text == "修改")
            {
                string id = Request.QueryString["id"];
                int x;
                if (!string.IsNullOrEmpty(id) && int.TryParse(id, out x))
                {
                    MyShop.Model.Link model = new MyShop.DAL.LinkDAO().GetModel(x);
                    if (model != null)
                    {
                        model.linkname = txtlinkname.Text.Trim();
                        model.url = txturl.Text.Trim();
                        model.createDate = DateTime.Now;
                        new MyShop.DAL.LinkDAO().Update(model);
                        txtlinkname.Text = "";
                        txturl.Text = "";
                        litmsg.Text = "<span style='color:blue'>修改成功！</span>";
                        return;
                    }
                }

            }
            //增加友情链接
            else
            {
                MyShop.DAL.LinkDAO dao = new MyShop.DAL.LinkDAO();
                //验证输入框是否为空
                if (name.Length == 0 && url.Length == 0)
                {
                    litmsg.Text = "<span style='color:red'>请把信息填写完整！</span>";
                    return;//注意，要返回，没有这一句的话，下面的代码依然会执行！！
                }

                if (dao.Exists(name))
                {
                    litmsg.Text = "<span style='color:red'>此超链接已经存在！</span>";
                    return;
                }


                int res = dao.Add(new MyShop.Model.Link()
                {
                    linkname = name,
                    url = url,
                    createDate = DateTime.Now
                });


                if (res > 0)
                {
                    litmsg.Text = "<span style='color:blue'>增加成功！</span>";
                    txtlinkname.Text = "";
                    txturl.Text = "";
                }
                else
                {
                    litmsg.Text = "<span style='color:red'>增加失败，请联系管理员！</span>";
                }
            }              
        }
    }
}

至此，友情链接模块做好。