listorder.aspx.cs

天织在线购物网站完整源码及文档 本网站是一套基于Web2.0思想设计、采用asp.net2.0开发的社区门户产品。它同时也是一套Web2.0全面解决方案

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;
using System.Data.SqlClient;

public partial class Manage_listOrder : System.Web.UI.Page
{
    SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["CartConnectionString"].ConnectionString);
    static String connStirng = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        String info1 = Request.QueryString["type"].ToString();
        if (info1 == "notody")
        {
            connStirng = "Select Oid '订单号' ,CID '用户id', OTotalPrice '总价', OTotalNumber '总数', OData from OrderUser where datepart(year,Odata)=datepart(year,getDate()) and datepart(month,Odata)=datepart(month,getdate()) and datepart(day,Odata)=datepart(day,getdate()) and OState=1";
            conn();
        }
        else if (info1 == "nohistor")
        {
            connStirng = "Select Oid '订单号' ,CID '用户id', OTotalPrice '总价', OTotalNumber '总数', OData from OrderUser where OState=1";
            conn();
        }
        else if (info1 == "Sendtoday")
        {
            connStirng = "Select Oid '订单号' ,CID '用户id', OTotalPrice '总价', OTotalNumber '总数', OData from OrderUser where datepart(year,SendDate)=datepart(year,getDate()) and datepart(month,SendDate)=datepart(month,getdate()) and datepart(day,SendDate)=datepart(day,getdate()) and OState=2";
            conn();
        }
        else if (info1 == "Sendhistor")
        {
            connStirng = "Select Oid '订单号' ,CID '用户id', OTotalPrice '总价', OTotalNumber '总数', OData from OrderUser where OState=2";
            conn();
        }else if(info1 =="historOrder")
        {
            connStirng = "Select Oid '订单号' ,CID '用户id', OTotalPrice '总价', OTotalNumber '总数', OData from OrderUser where OState=3";
            conn();
        }


    }
    public void conn()
    {
        SqlDataAdapter mydapter = new SqlDataAdapter(connStirng, myConnection);
        myConnection.Open();
        DataSet myDataset = new DataSet();
        mydapter.Fill(myDataset);
        GridView1.DataSource = myDataset;
        GridView1.DataBind();
    }
}