orderda.cs

项目名称eShop

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

/// <summary>
/// OrderDA 的摘要说明
/// </summary>
public class OrderDA:DBObject
{
	public OrderDA()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    //修改订单信息
    public int ModifyOrder(OrderVO orderVO)
    {
        //flag用来表示添加状态，返回信息
        int flag = 0;
        //修改订单信息
        using (connEShop)
        {
            string strSQL = "update T_ORDER set F_ORDERNUM=@orderNum,F_ORDERSTATE=@orderState,"
              + "F_RECNAME=@recName,F_RECADDRESS=@recAddress,F_RECPOSTCODE=@recPostCode,F_RECTEL=@recTel,"
              + "F_RECEMAIL=@recEmail,F_DELIVERMETHOD=@deliverMethod,F_PAYMETHOD=@payMethod,F_PAID=@paid "
              + "where F_ORDERID=@orderID";
            using (OleDbCommand cmdModifyOrder = new OleDbCommand(strSQL, connEShop))
            {
                cmdModifyOrder.Parameters.Add(new OleDbParameter("@orderNum", orderVO.OrderNum));
                cmdModifyOrder.Parameters.Add(new OleDbParameter("@orderState", orderVO.OrderState));
                cmdModifyOrder.Parameters.Add(new OleDbParameter("@recName", orderVO.RecName));
                cmdModifyOrder.Parameters.Add(new OleDbParameter("@recAddress", orderVO.RecAddress));
                cmdModifyOrder.Parameters.Add(new OleDbParameter("@recPostCode", orderVO.RecPostCode));
                cmdModifyOrder.Parameters.Add(new OleDbParameter("@recTel", orderVO.RecTel));
                cmdModifyOrder.Parameters.Add(new OleDbParameter("@recEmail", orderVO.RecEmail));
                cmdModifyOrder.Parameters.Add(new OleDbParameter("@deliverMethod", orderVO.DeliverMethod));
                cmdModifyOrder.Parameters.Add(new OleDbParameter("@payMethod", orderVO.PayMethod));
                cmdModifyOrder.Parameters.Add(new OleDbParameter("@paid", orderVO.Paid));
                cmdModifyOrder.Parameters.Add(new OleDbParameter("@orderID", orderVO.OrderID));

                connEShop.Open();
                flag = cmdModifyOrder.ExecuteNonQuery();
            }
        }
        return flag;
    }

    //获得订单基本信息
    public OrderVO GetOrderInfo(string orderID)
    {
        OrderVO orderVO = new OrderVO();
        string strSQL = "SELECT a.F_ORDERID, a.F_USERCODE, a.F_ORDERDATE, a.F_BOOKID, a.F_ORDERNUM, a.F_ORDERSTATE, "
          +"a.F_RECNAME, a.F_RECADDRESS, a.F_RECPOSTCODE, a.F_RECTEL, a.F_RECEMAIL, a.F_DELIVERMETHOD, a.F_PAYMETHOD, "
          +"a.F_PAID, b.F_BOOKNAME FROM (T_ORDER a INNER JOIN T_BOOK b ON a.F_BOOKID = b.F_BOOKID) "
          + "where a.F_ORDERID=@orderID";
        using (connEShop)
        {

            using (OleDbCommand cmdGetOrderInfo = new OleDbCommand(strSQL, connEShop))
            {
                cmdGetOrderInfo.Parameters.Add(new OleDbParameter("@orderID", orderID));
                cmdGetOrderInfo.Connection.Open();
                OleDbDataReader dtrGetOrderInfo = cmdGetOrderInfo.ExecuteReader();

                if (dtrGetOrderInfo.Read())
                {
                    orderVO.OrderID = orderID;
                    orderVO.OrderDate = dtrGetOrderInfo["F_ORDERDATE"].ToString().Trim();
                    orderVO.OrderNum = Convert.ToInt32(dtrGetOrderInfo["F_ORDERNUM"].ToString().Trim());
                    orderVO.OrderState = dtrGetOrderInfo["F_ORDERSTATE"].ToString().Trim();
                    orderVO.Paid = Convert.ToSingle(dtrGetOrderInfo["F_PAID"].ToString().Trim());
                    orderVO.PayMethod = dtrGetOrderInfo["F_PAYMETHOD"].ToString().Trim();
                    orderVO.RecAddress = dtrGetOrderInfo["F_RECADDRESS"].ToString().Trim();
                    orderVO.RecEmail = dtrGetOrderInfo["F_RECEMAIL"].ToString().Trim();
                    orderVO.RecName = dtrGetOrderInfo["F_RECNAME"].ToString().Trim();
                    orderVO.RecPostCode = dtrGetOrderInfo["F_RECPOSTCODE"].ToString().Trim();
                    orderVO.RecTel = dtrGetOrderInfo["F_RECTEL"].ToString().Trim();
                    orderVO.UserCode = dtrGetOrderInfo["F_USERCODE"].ToString().Trim();
                    orderVO.BookID = Convert.ToInt32(dtrGetOrderInfo["F_BOOKID"].ToString().Trim());
                    orderVO.BookName = dtrGetOrderInfo["F_BOOKNAME"].ToString().Trim();
                    orderVO.DeliverMethod = dtrGetOrderInfo["F_DELIVERMETHOD"].ToString().Trim();
                }
            }
        }
        return orderVO;
    }
}