?using System;
using System.Data;
using System.Data.SqlClient;
using System.Text;
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 controls_ViewUser : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //客戶名稱的模糊查詢
        ControlParameter cp = new ControlParameter("username", "txtusername", "Text");
        //獲取Select語句，并添加條件
        string str = SqlDataSource1.SelectCommand;
        str += " where username  like '%' + @username +'%'";
        //更新Select語句
        SqlDataSource1.SelectCommand = str;
        //添加參數(shù)-必須先清空參數(shù)
        SqlDataSource1.SelectParameters.Clear();
        SqlDataSource1.SelectParameters.Add(cp);
        //重新綁定數(shù)據(jù)
        GridView1.DataBind();
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        //通過軟件版本查詢
        //建立一個與控件相關聯(lián)的參數(shù)
        //構造函數(shù)中第一個參數(shù)表示SQL語句中的參數(shù)名
        //第二個參數(shù)表示控件的ID，第三個參數(shù)表示控件的取值屬性
        ControlParameter cp = new ControlParameter("softversion","txtsoftversion","Text");
        //獲取Select語句，并添加條件
        string str = SqlDataSource1.SelectCommand;
        str += " where softversion=@softversion";
        //更新Select語句
        SqlDataSource1.SelectCommand = str;
        //添加參數(shù)-必須先清空參數(shù)
        SqlDataSource1.SelectParameters.Clear();
        SqlDataSource1.SelectParameters.Add(cp);
        //重新綁定數(shù)據(jù)
        GridView1.DataBind();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        //通過城市查詢
        ControlParameter cp = new ControlParameter("cityname", "txtcity", "Text");
        //獲取Select語句，并添加條件
        string str = SqlDataSource1.SelectCommand;
        str += " where cityname=@cityname";
        //更新Select語句
        SqlDataSource1.SelectCommand = str;
        //添加參數(shù)-必須先清空參數(shù)
        SqlDataSource1.SelectParameters.Clear();
        SqlDataSource1.SelectParameters.Add(cp);
        //重新綁定數(shù)據(jù)
        GridView1.DataBind();
        
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        //分類查找
        //獲取Select語句
        string str = "";
        //定義控件參數(shù)
        ControlParameter cp = new ControlParameter("name", "txtseek","Text");
        switch (DropDownList1.SelectedValue)
        {
            case "等級":
                //定義查詢語句
                str =SqlDataSource1.SelectCommand + " where gradename=@name";
                break;
            case "狀態(tài)":
                str = SqlDataSource1.SelectCommand + " where statename=@name";
                break;
            case "業(yè)務類型":
                str = SqlDataSource1.SelectCommand + " where typename=@name";
                break;
        }
        //更新Select語句
        SqlDataSource1.SelectCommand = str;
        //添加參數(shù)-必須先清空參數(shù)
        SqlDataSource1.SelectParameters.Clear();
        SqlDataSource1.SelectParameters.Add(cp);
        //重新綁定數(shù)據(jù)
        GridView1.DataBind();
    }
}