productselectbll.cs

来自「c#三层架构项目开发的全过程」· CS 代码 · 共 40 行

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using DAL;
using Model;
namespace BLL.Goods
{
  public class ProductSelectBll
    {
        #region 商品表查询,BLL层构造函数
      DAL.Goods.ProductSelectDal ProductSelectShow;
        public ProductSelectBll()
        {
            ProductSelectShow = new DAL.Goods.ProductSelectDal();
        }
        #endregion

        #region 商品表查询
        public List<Model.Goods.ProductModel> GetProduct()
        {
            return ProductSelectShow.GetProduct();
        }
        #endregion

        #region 商品删除
        public int ProductDelete(string product_id)
        {
            string com = "DeleteProduct";
            SqlParameter id = new SqlParameter("@Product_id", SqlDbType.VarChar, 10);
            id.Value = product_id;

            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, com, new SqlParameter[] { id });
        }
        #endregion
    }
}