orderaccess.cs

ASP.NET 2.0动态网站设计实例源代码,本书介绍了ASP.NET2.0的基础知识

///////////////////////////////////////////////////////////
//  OrderAccess.cs
//  Implementation of the Class OrderAccess
//  Generated by Enterprise Architect
//  Created on:      07-五月-2006 14:00:59
///////////////////////////////////////////////////////////




using BookShop.Entity;
using System.Data;
using System.Data.SqlClient;
using System;
namespace BookShop.DataAccess
{
  /// <summary>
  /// 与订单有关的操作
  /// </summary>
  public class OrderAccess
  {

    public OrderAccess()
    {

    }

    ~OrderAccess()
    {

    }

    public virtual void Dispose()
    {

    }

    /// <summary>
    /// 添加订单
    /// </summary>
    /// <param name="order"></param>
    public bool AddOrder(ref OrderEntity order)
    {
      SqlParameter[] parms = new SqlParameter[]{
          new SqlParameter("@MemberID",SqlDbType.Int),
          new SqlParameter("@Order",SqlDbType.NText),
          new SqlParameter("@Date",SqlDbType.DateTime),
          new SqlParameter("@OrderID",SqlDbType.Int)
         };
      parms[0].Value = order.MemberID;
      parms[1].Value = Common.SerializeIt(order);
      parms[2].Value = order.OrderDate;
      parms[3].Direction = ParameterDirection.Output;

      if (DbTools.ExectueNoQuery("AddOrder", parms) > 0)
      {
        order.OrderID = Convert.ToInt32(parms[3].Value);
        return true;
      }
      else
      {
        return false;
      }
    }

    /// <summary>
    /// 删除订单
    /// </summary>
    /// <param name="order"></param>
    public bool DeleteOrder(OrderEntity order)
    {
      SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@OrderID",SqlDbType.Int)
   };
      parms[0].Value = order.OrderID;
      if (DbTools.ExectueNoQuery("DeleteOrder", parms) > 0)
        return false;
      else
        return true;
    }


    /// <summary>
    /// 根据会员ID获取订单列表
    /// </summary>
    /// <param name="memberID"></param>
    public DataTable GetOrderByMemberID(int memberID)
    {
      SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@MemberID",SqlDbType.Int)
   };
      parms[0].Value = memberID;
      return DbTools.ExecuteQuery("GetOrderByMemberID", parms).Tables[0];
    }

    /// <summary>
    /// 修改订单状态
    /// </summary>
    /// <param name="order"></param>
    public bool ModifyOrderStatus(OrderEntity order)
    {
      SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@OrderID",SqlDbType.Int),
    new SqlParameter("@Order",SqlDbType.NText)
   };
      parms[0].Value = order.OrderID;
      parms[1].Value = Common.SerializeIt(order);
      if (DbTools.ExectueNoQuery("ModifyOrderStatus", parms) > 0)
        return false;
      else
        return true;
    }

    /// <summary>
    /// 根据ID获取订单信息
    /// </summary>
    /// <param name="orderid"></param>
    public OrderEntity GetOrderByID(int orderid)
    {
      SqlParameter[] parms = new SqlParameter[]{
        new SqlParameter("@OrderID",SqlDbType.Int)
       };
      parms[0].Value = orderid;
      DataSet ds = DbTools.ExecuteQuery("GetOrderByID", parms);
      string orderString = null;
      if (ds.Tables[0].Rows.Count != 0)
      {
        orderString = Convert.ToString(ds.Tables[0].Rows[0]["OmOrder"]);
        return (OrderEntity)Common.DeserializeIt(orderString, typeof(OrderEntity));
      }
      else
      {
        return null;
      }
    }


    internal DataTable GetOrderList()
    {
      return DbTools.ExecuteQuery("GetOrderList").Tables[0];
    }
  }//end OrderAccess

}//end namespace DataAccess