search.aspx.cs

ASP.NET2.0开发一个类似BtoC、CtoC的企业产品信息发布系统。

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;

public partial class Search : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //  string a = Request.QueryString["a"];//晕，这里定义来接收的参数没想到没用，划掉先！
        int a1 = Convert.ToInt32(Request.QueryString["a1"]);//用几个repeatr控件来绑定，这个控件比较灵活撒~
        if (a1 == 0)
        {
            aa();

        }
        else if (a1 == 1)
        {
            bb();
        }
        else if (a1 == 2)
        {
            cc();
        }


    }
    private void aa()
    {
        string a = Request.QueryString["a"];
        int a1 = Convert.ToInt32(Request.QueryString["a1"]);
        string que = "select * from Cs where c4 like '%" + a + "%'";
        this.Repeater1.DataSource = db.ds(que);
        this.Repeater1.DataBind();


    }
    private void bb()
    {
        string a = Request.QueryString["a"];
        int a1 = Convert.ToInt32(Request.QueryString["a1"]);
        string que = "select * from Ns where n2 like '%" + a + "%'";
        this.Repeater2.DataSource = db.ds(que);
        this.Repeater2.DataBind();


    }
    private void cc()//有Ps.ascx好像代码一样啊，直接复制Datalist算了，呵~~~~
    {
        string a = Request.QueryString["a"];
        string que = "select * from Ps where p1 like '%"+a+"%'";
        this.DataList1.DataSource = db.ds(que);
        this.DataList1.DataBind();


    }
}