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

4.友情链接Aspx页面绑定代码

    <table class="style1" border="1">
        <tr>
            <th>
                链接标题
            </th>
            <th>
                链接地址
            </th>
            <th>
                创建时间
            </th>
            <th>
                操作
            </th>
        </tr>
        <asp:Repeater ID="rep" runat="server">
            <ItemTemplate>
                <tr>
                    <td>
                        <%#Eval("linkname") %>
                    </td>
                    <td>
                        <%#Eval("url") %>
                    </td>
                    <td>
                        <%#Eval("createdate","{0:yyyy年MM月dd日 HH时mm分ss秒}") %>
                    </td>
                    <td>
                           //传入链接名称的id来进行修改
                        <a href='link_add.aspx?id=<%#Eval("id") %>'>修改</a>
                       //用LinkButton控件来做删除
                        <asp:LinkButton ID="lbtnDel" OnClick="Del" CommandArgument='<%#Eval("id") %>' runat="server"
                            OnClientClick="return confirm('是否确认删除？')">
                            删除
                        </asp:LinkButton>
                    </td>
                </tr>
            </ItemTemplate>
        </asp:Repeater>

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

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>";  
                }  
            }                
        }  
    }  
}  

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