购物网第一阶段总结笔记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>";                }            }                      }    }}

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