catagoryaccess.cs

来自「ASP.NET 2.0动态网站设计实例源代码,本书介绍了ASP.NET2.0的基」· CS 代码 · 共 148 行

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




using BookShop.Entity;
using System.Data;
using System.Data.SqlClient;
using System;
namespace BookShop.DataAccess
{
  /// <summary>
  /// 关于分类的数据操作
  /// </summary>
  public class CatagoryAccess
  {

    public CatagoryAccess()
    {

    }

    ~CatagoryAccess()
    {

    }

    public virtual void Dispose()
    {

    }

    /// <summary>
    /// 添加分类信息
    /// </summary>
    /// <param name="category"></param>
    public bool AddCategory(CatagoryEntity category)
    {
      SqlParameter[] parms = new SqlParameter[]{
        new SqlParameter("@Name",SqlDbType.NVarChar,200),
        new SqlParameter("@ParentID",SqlDbType.Int)
       };
      parms[0].Value = category.CatagoryName;
      if (category.ParentID != -1)
        parms[1].Value = category.ParentID;

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


    /// <summary>
    /// 根据ID获取分类信息
    /// </summary>
    /// <param name="catagory"></param>
    public DataSet GetCatagoryByID(CatagoryEntity catagory)
    {
      SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@ID",SqlDbType.Int,4)
   };
      parms[0].Value = catagory.CatagoryID;
      return DbTools.ExecuteQuery("GetCatagoryByID", parms);
      //if (ds.Tables[0].Rows.Count == 0)
      //  return false;
      //else
      //{
      //  catagory.CatagoryName = Convert.ToString(ds.Tables[0].Rows[0]["CtName"]);
      //  if (!Convert.IsDBNull(ds.Tables[0].Rows[0]["CtParentID"]))
      //    catagory.ParentID = Convert.ToInt32(ds.Tables[0].Rows[0]["CtParentID"]);
      //  return true;
      //}
    }

    /// <summary>
    /// 根据父分类ID获取自分类列表
    /// </summary>
    /// <param name="parentID"></param>
    public DataTable GetCatagoryByParentID(int parentID)
    {
      SqlParameter[] parms = new SqlParameter[]{
    new SqlParameter("@ParentID",SqlDbType.Int,4)
   };
      parms[0].Value = parentID;
      return DbTools.ExecuteQuery("GetCatagoryByParentID", parms).Tables[0];
    }

    /// <summary>
    /// 获取一级分类列表
    /// </summary>
    public DataTable GetRootCatagory()
    {
      return DbTools.ExecuteQuery("GetRootCatogory").Tables[0];
    }

    /// <summary>
    /// 修改分类信息
    /// </summary>
    /// <param name="catagory"></param>
    public bool ModifyCatagory(CatagoryEntity catagory)
    {
      SqlParameter[] parms = new SqlParameter[]{
        new SqlParameter("@ID",SqlDbType.Int,4),
        new SqlParameter("@Name",SqlDbType.NVarChar,200)
       };
      parms[0].Value = catagory.CatagoryID;
      parms[1].Value = catagory.CatagoryName;

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

    /// <summary>
    /// 删除分类（仅做标记位而不做直接删除）
    /// </summary>
    /// <param name="category"></param>
    public bool DelteCatagory(CatagoryEntity category)
    {
      SqlParameter[] parms = new SqlParameter[]{
        new SqlParameter("@ID",SqlDbType.Int,4),
       };
      parms[0].Value = category.CatagoryID;
      if (DbTools.ExectueNoQuery("DeleteCatagory", parms) > 0)
        return true;
      else
        return false;
    }


    internal DataTable GetCatagoryByGoodsID(int p)
    {
      SqlParameter[] parms = new SqlParameter[]{
           new SqlParameter("@GoodsID",SqlDbType.Int,4)
       };
      parms[0].Value = p;
      return DbTools.ExecuteQuery("GetCatagoryByGoodsID", parms).Tables[0];
    }
  }//end CatagoryAccess

}//end namespace DataAccess