goodsaccess.cs

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

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

using BookShop.Entity;
using System.Data.SqlClient;
using System.Data;
using System.Collections;
using System;


namespace BookShop.DataAccess
{
  /// <summary>
  /// 与货物有关的数据操作
  /// </summary>
  public class GoodsAccess
  {

    public GoodsAccess()
    {

    }

    ~GoodsAccess()
    {

    }

    public virtual void Dispose()
    {

    }

    /// <summary>
    /// 添加新的货物
    /// </summary>
    /// <param name="goods"></param>
    public bool AddGoods(ref GoodsEntity goods)
    {
      SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@Name",SqlDbType.NVarChar,500),
                new SqlParameter("@TypeID",SqlDbType.Int),  
                new SqlParameter("@Image",SqlDbType.NVarChar,500),
                new SqlParameter("@Writer",SqlDbType.NVarChar,500),
                new SqlParameter("@Publisher",SqlDbType.NText),
                new SqlParameter("@PublishDate",SqlDbType.DateTime),
                new SqlParameter("@PublishTimes",SqlDbType.Int),
                new SqlParameter("@ISBN",SqlDbType.NVarChar,50),
                new SqlParameter("@PageCount",SqlDbType.Int),
                new SqlParameter("@PageSize",SqlDbType.NVarChar,50),
                new SqlParameter("@WordCount",SqlDbType.Int),
                new SqlParameter("@Price",SqlDbType.Float),
                new SqlParameter("@Intro",SqlDbType.NText),
                new SqlParameter("@Contents",SqlDbType.NText),
                new SqlParameter("@StorageCount",SqlDbType.Int),
                new SqlParameter("@GoodsID",SqlDbType.Int)
            };

      parms[0].Value = goods.Name;
      parms[1].Value = goods.CatagoryID;
      parms[2].Value = goods.Image;
      parms[3].Value = goods.Writer;
      parms[4].Value = goods.Publisher;
      parms[5].Value = goods.PublishDate;
      parms[6].Value = goods.PublishTimes;
      parms[7].Value = goods.ISBN;
      parms[8].Value = goods.PageCount;
      parms[9].Value = goods.PageSize;
      parms[10].Value = goods.WordCount;
      parms[11].Value = goods.Price;
      parms[12].Value = goods.Intro;
      parms[13].Value = goods.Contents;
      parms[14].Value = goods.StorageCount;
      parms[15].Direction = ParameterDirection.Output;

      if (DbTools.ExectueNoQuery("AddGoods", parms) > 0)
      {
        goods.GoodsID = Convert.ToInt32(parms[15].Value);
        return true;
      }
      else
        return false;
    }

    /// <summary>
    /// 修改货物信息
    /// </summary>
    /// <param name="goods"></param>
    public bool ModifyGoods(GoodsEntity goods)
    {
      SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@Name",SqlDbType.NVarChar,500),
                new SqlParameter("@TypeID",SqlDbType.Int),
                new SqlParameter("@Image",SqlDbType.NVarChar,500),
                new SqlParameter("@Writer",SqlDbType.NVarChar,500),
                new SqlParameter("@Publisher",SqlDbType.NText),
                new SqlParameter("@PublishDate",SqlDbType.DateTime),
                new SqlParameter("@PublishTimes",SqlDbType.Int),
                new SqlParameter("@ISBN",SqlDbType.NVarChar,50),
                new SqlParameter("@PageCount",SqlDbType.Int),
                new SqlParameter("@PageSize",SqlDbType.NVarChar,50),
                new SqlParameter("@WordCount",SqlDbType.Int),
                new SqlParameter("@Price",SqlDbType.Float),
                new SqlParameter("@Intro",SqlDbType.NText),
                new SqlParameter("@Contents",SqlDbType.NText),
                new SqlParameter("@StorageCount",SqlDbType.Int),
                new SqlParameter("@ID",SqlDbType.Int)
              };

      parms[0].Value = goods.Name;
      parms[1].Value = goods.CatagoryID;
      parms[2].Value = goods.Image;
      parms[3].Value = goods.Writer;
      parms[4].Value = goods.Publisher;
      parms[5].Value = goods.PublishDate;
      parms[6].Value = goods.PublishTimes;
      parms[7].Value = goods.ISBN;
      parms[8].Value = goods.PageCount;
      parms[9].Value = goods.PageSize;
      parms[10].Value = goods.WordCount;
      parms[11].Value = goods.Price;
      parms[12].Value = goods.Intro;
      parms[13].Value = goods.Contents;
      parms[14].Value = goods.StorageCount;
      parms[15].Value = goods.GoodsID;
      if (DbTools.ExectueNoQuery("ModifyGoods", parms) > 0)
        return true;
      else
        return false;
    }

    /// <summary>
    /// 修改货物数量
    /// </summary>
    /// <param name="goods"></param>
    public bool ModifyGoodsCount(GoodsEntity goods)
    {
      SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@StorageCount",SqlDbType.Int),
                new SqlParameter("@ID",SqlDbType.Int)
               };
      parms[0].Value = goods.StorageCount;
      parms[1].Value = goods.GoodsID;

      if (DbTools.ExectueNoQuery("ModifyGoodsCount", parms) > 0)
        return true;
      else
        return false;
    }

    /// <summary>
    /// 将指定订单中的货物数量移至发货表
    /// </summary>
    /// <param name="goods"></param>
    /// <param name="order"></param>
    public bool MoveToSent(GoodsEntity goods, OrderEntity order, UserEntity user)
    {
      SqlParameter[] parms = new SqlParameter[]{
                  new SqlParameter("@Count",SqlDbType.Int),
                  new SqlParameter("@StorageID",SqlDbType.Int),
                  new SqlParameter("@SentUserID",SqlDbType.Int),
             };
      bool result = true;
      foreach (DictionaryEntry good in order.Goods)
      {
        parms[0].Value = (int)good.Value;
        parms[1].Value = (int)good.Key;
        parms[2].Value = user.UserID;

        if (!DbTools.ExecuteTrans("MoveToSend", parms))
        {
          result = false;
          break;
        };
      }
      return result;
    }

    /// <summary>
    /// 根据分类ID获取货物列表
    /// </summary>
    /// <param name="categoryID"></param>
    /// <returns></returns>
    public DataTable GetGoodsByCategoryID(int categoryID)
    {
      SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@CategoryID",SqlDbType.Int),
            };
      parms[0].Value = categoryID;
      return DbTools.ExecuteQuery("GetGoodsByCategoryID", parms).Tables[0];
    }
    /// <summary>
    /// 添加折扣信息
    /// </summary>
    /// <param name="discount"></param>
    /// <returns></returns>
    public bool AddGoodsDiscount(DiscountEntity discount)
    {
      SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@GoodsID",SqlDbType.Int),
                new SqlParameter("@MemberLevel",SqlDbType.Int),
                new SqlParameter("@Price",SqlDbType.Money)
            };
      parms[0].Value = discount.GoodsID;
      parms[1].Value = discount.MemberLevel;
      parms[2].Value = discount.Price;
      if (DbTools.ExectueNoQuery("AddGoodsDiscount", parms) > 0)
        return true;
      else
        return false;
    }
    /// <summary>
    /// 根据ID获取货物信息
    /// </summary>
    /// <param name="goods"></param>
    /// <returns></returns>
    public DataTable GetGoodsByID(ref GoodsEntity goods)
    {
      SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@GoodsID",SqlDbType.Int)
      };
      parms[0].Value = goods.GoodsID;
      return DbTools.ExecuteQuery("GetGoodsByID", parms).Tables[0];
    }
    /// <summary>
    /// 删除指定ID的货物的折扣信息
    /// </summary>
    /// <param name="discount"></param>
    public void DeleteDiscount(DiscountEntity discount)
    {
      SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@GoodsID",SqlDbType.Int)
      };
      parms[0].Value = discount.GoodsID;
      DbTools.ExectueNoQuery("DeleteDiscountByGoodsID", parms);
    }
    /// <summary>
    /// 设置指定ID的货物的点击率+1
    /// </summary>
    /// <param name="goods"></param>
    internal void SetGoodsClicked(GoodsEntity goods)
    {
      SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@GoodsID",SqlDbType.Int)
      };
      parms[0].Value = goods.GoodsID;
      DbTools.ExectueNoQuery("SetGoodsClicked", parms);
    }
    /// <summary>
    /// 判断指定ID的货物点击率信息是否存在
    /// </summary>
    /// <param name="goods"></param>
    public bool IsGoodsClickedExist(GoodsEntity goods)
    {
      SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@GoodsID",SqlDbType.Int)
      };
      parms[0].Value = goods.GoodsID;
      if (DbTools.ExecuteQuery("IsGoodsClickedExist", parms).Tables[0].Rows.Count != 0)
      {
        return true;
      }
      else
      {
        return false;
      }
    }

    /// <summary>
    /// 添加指定ID的货物的点击率
    /// </summary>
    /// <param name="goods"></param>
    internal void AddGoodsClicked(GoodsEntity goods)
    {
      SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@GoodsID",SqlDbType.Int)
      };
      parms[0].Value = goods.GoodsID;
      DbTools.ExectueNoQuery("AddGoodsClicked", parms);
    }
    /// <summary>
    /// 根据点击率获取前10个商品信息
    /// </summary>
    /// <returns></returns>
    public DataTable GetGoodsByClicked()
    {
      return DbTools.ExecuteQuery("GetBookByClicked").Tables[0];
    }
    /// <summary>
    /// 根据入库时间获取前10个商品列表
    /// </summary>
    /// <returns></returns>
    internal DataTable GetGoodsByInTime()
    {
      return DbTools.ExecuteQuery("GetBookByInTime").Tables[0];
    }
    /// <summary>
    /// 根据ID获取折扣信息
    /// </summary>
    /// <param name="goods"></param>
    /// <returns></returns>
    internal DataTable GetDiscountByGoodsID(GoodsEntity goods)
    {
      SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@GoodsID",SqlDbType.Int)
      };
      parms[0].Value = goods.GoodsID;
      return DbTools.ExecuteQuery("GetDiscountByGoodsID", parms).Tables[0];
    }
  }//end GoodsAccess

}//end namespace DataAccess