Admin/Orders_List.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

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 Admin_Orders_List : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
        {
            this.DropDownList1.Items.Add("所有");
            this.DropDownList1.Items.Add("正在处理");
            this.DropDownList1.Items.Add("已取消");
            this.DropDownList1.Items.Add("已发货");
            this.DropDownList1.Items.Add("已完成");
            BindData();
        }
    }
    private void BindData()
    {
        string sql;
        sql = "select * from orders where 1=1";
        if (DropDownList1.Text.ToString().Trim() != "所有") { sql = sql + " and ostatus like '%" + DropDownList1.Text.ToString().Trim() + "%'"; }
        if (this.txtKey.Text.ToString().Trim() != "")
        {
            sql = sql + " and oreceiver like '%" + txtKey.Text.ToString().Trim() + "%'";
            sql = sql + " or musername like '%" + txtKey.Text.ToString().Trim() + "%'";
            sql = sql + " or uname like '%" + txtKey.Text.ToString().Trim() + "%'";
        }
        sql = sql + " order by oid desc";

        ClassDB.DGDataBind(DataGrid1, sql, "oid");
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        BindData();
    }
    protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        DataGrid1.CurrentPageIndex = e.NewPageIndex;
        BindData();
    }
}