Admin/orderlist.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

public partial class Admin_orderlist : System.Web.UI.Page
{
    private static string sql;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            sql = "SELECT dbo.tb_Order.OrderID, dbo.tb_Order.TotalMoney, dbo.tb_Order.OrderDate, dbo.tb_Order.OrderState, dbo.tb_Order.PayType,dbo.tb_Order.IsPayed, dbo.tb_Order.ReceiverName, dbo.tb_Order.ReceiverTel, dbo.tb_Order.Address, dbo.tb_Order.Code, dbo.tb_Order.Email,dbo.tb_Member.MemberName, dbo.tb_Order.MemberID FROM dbo.tb_Order INNER JOIN dbo.tb_Member ON dbo.tb_Order.MemberID = dbo.tb_Member.MemberID ORDER BY dbo.tb_Order.OrderDate DESC";
            BindData(sql);
        } 
    } 
    private void BindData(string sql)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connstr"]);
        SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        this.gvOrderList.DataSource = ds.Tables[0].DefaultView;
        gvOrderList.DataBind();
    } 

    protected void btnSearch_Click(object sender, EventArgs e)
    {
        //按照不同的方式查询订单
        sql = "SELECT dbo.tb_Order.OrderID, dbo.tb_Order.TotalMoney, dbo.tb_Order.OrderDate, dbo.tb_Order.OrderState, dbo.tb_Order.PayType,dbo.tb_Order.IsPayed, dbo.tb_Order.ReceiverName, dbo.tb_Order.ReceiverTel, dbo.tb_Order.Address, dbo.tb_Order.Code, dbo.tb_Order.Email,dbo.tb_Member.MemberName, dbo.tb_Order.MemberID FROM dbo.tb_Order INNER JOIN dbo.tb_Member ON dbo.tb_Order.MemberID = dbo.tb_Member.MemberID  where 1=1 ";
        if (txtKeyword.Text != "")
        {
            sql += " and OrderID=" + Int32.Parse(txtKeyword.Text.Trim());
        } 
        if (ddlPayed.SelectedValue == "已付款")
        {
            sql += " and  IsPayed='是' ";
        } 
        if (this.ddlShipped.SelectedValue == "未付款")
        {
            sql += " and  IsPayed ='否' ";
        } 
        if (this.ddlShipped.SelectedValue == "未发货")
        {
            sql += " and  OrderState='未处理' ";
        } 
        if (ddlShipped.SelectedValue == "已发货")
        {
            sql += " and  OrderState='已处理' ";
        } 

        BindData(sql);
    }