orderlistaccess.cs

网上书店

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.Common;

/// <summary>
///OrderListAccess 的摘要说明
/// </summary>
public struct customerShippingInfo//订单配送信息
{
    public string realName;
    public string telPhone;
    public string Email;
    public string post;
    public string address;
}

public struct orderDateAndMoney//订单生成时间和总额
{
    public string dateCreated;
    public string subtotal;
}

public static class OrderListAccess
{
    //获取某个订单的配送信息
    public static customerShippingInfo GetOrderShippingInfo(string orderID)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetShippingDetails";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@orderID";
        param.DbType = DbType.Int32;
        param.Value = orderID;
        cmd.Parameters.Add(param);

        DataTable dt =CmdPart.ExcuteSelectCommand(cmd);
        customerShippingInfo cus = new customerShippingInfo();
        if (dt.Rows.Count > 0)
        {

            cus.address = dt.Rows[0][3].ToString();
            cus.telPhone = dt.Rows[0][0].ToString();
            cus.post = dt.Rows[0][2].ToString();
            cus.Email = dt.Rows[0][1].ToString();
            cus.realName = dt.Rows[0][4].ToString();
        }
        return cus;
    }

    //修改某一订单的具体配送方式
    public static bool ModefiyShippingDetails(string orderID, string customerPhone, string customerEmail, string post, string customerAddress, string customerName, string shipType)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "ModefiyShippingDetails";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@OrderID";
        param.DbType = DbType.Int32;
        param.Value = orderID;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@CustomerPhone";
        param.DbType = DbType.String;
        param.Value = customerPhone;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@CustomerEmail";
        param.DbType = DbType.String;
        param.Value = customerEmail;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@Post";
        param.DbType = DbType.String;
        param.Value = post;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@CustomerAddress";
        param.DbType = DbType.String;
        param.Value = customerAddress;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@CustomerName";
        param.DbType = DbType.String;
        param.Value = customerName;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@ShipType";
        param.DbType = DbType.String;
        param.Value = shipType;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }

    //取得订单生成时间和总金额
    public static orderDateAndMoney GetOrdersAmountAndDate(string orderID)
   
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "GetOrdersAmountAndDate";

        DbParameter param = cmd.CreateParameter();
        param.DbType = DbType.String;
        param.ParameterName = "@OrderID";
        param.Value = orderID;
        cmd.Parameters.Add(param);

        orderDateAndMoney order = new orderDateAndMoney();
        DataTable dt = CmdPart.ExcuteSelectCommand(cmd);
        if (dt.Rows.Count > 0)
        {
            order.dateCreated = dt.Rows[0][0].ToString();
            order.subtotal = dt.Rows[0][1].ToString();
        }

        return order;

    }


    //改变订单状态
    public static bool ModifyOrderStatus(string orderID, string status)
    {
        DbCommand cmd = CmdPart.CreateCommand();
        cmd.CommandText = "ModifyOrderStatus";

        DbParameter param = cmd.CreateParameter();
        param.ParameterName = "@OrderID";
        param.Value = orderID;
        param.DbType = DbType.Int32;
        cmd.Parameters.Add(param);

        param = cmd.CreateParameter();
        param.ParameterName = "@Status";
        param.Value = status;
        param.DbType = DbType.Int32;
        cmd.Parameters.Add(param);

        return CmdPart.ExcuteNonSelectCommand(cmd);
    }
}