保健品销售网站 三层架构/Business/GoodsBusiness.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Entity;
using Business;
using DBAccess;
namespace Business
{
    public class GoodsBusiness
    {

        public int InsertGoods(GoodsEntity goodsEntity)
        {
            string[] paraNames = { "@id", "@name", "@cateid", "@nationid", "@areaid", "@weights", "@sizes", "@marketprice", "@nowprice", "@recommend", "@special", "@image", "@intro" };
            object[] paraValues = { goodsEntity.Id, goodsEntity.Name, goodsEntity.Cateid, goodsEntity.Nationid, goodsEntity.Areaid, goodsEntity.Weights, goodsEntity.Sizes, goodsEntity.Marketprice, goodsEntity.Nowprice, goodsEntity.Recommend, goodsEntity.Special, goodsEntity.Image, goodsEntity.Intro };
            object obj = Operations.ExecuteSQL("[sp_insert_Goods]", CommandType.StoredProcedure, paraNames, paraValues);
            return Convert.ToInt32(obj);
        }

        public int DeleteGoodsById(string id)
        {
            string[] paraNames = { "@id" };
            object[] paraValues = { id };
            object obj = Operations.ExecuteSQL("[sp_delete_Goods]", CommandType.StoredProcedure, paraNames, paraValues);
            return Convert.ToInt32(obj);
        }

        public int UpdateGoods(GoodsEntity goodsEntity)
        {
            string[] paraNames = { "@id", "@name", "@cateid", "@nationid", "@areaid", "@weights", "@sizes", "@marketprice", "@nowprice", "@recommend", "@special", "@image", "@intro" };
            object[] paraValues = { goodsEntity.Id, goodsEntity.Name, goodsEntity.Cateid, goodsEntity.Nationid, goodsEntity.Areaid, goodsEntity.Weights, goodsEntity.Sizes, goodsEntity.Marketprice, goodsEntity.Nowprice, goodsEntity.Recommend, goodsEntity.Special, goodsEntity.Image, goodsEntity.Intro };
            object obj = Operations.ExecuteSQL("[sp_update_Goods]", CommandType.StoredProcedure, paraNames, paraValues);
            return Convert.ToInt32(obj);
        }

        public DataSet getALLGoods(string tableName)
        {
            string[] paraNames = { };
            object[] paraValues = { };
            DataSet ds = Operations.GetDataSet("[sp_query_Goods]", CommandType.StoredProcedure, tableName);
            return ds;
        }

        public GoodsEntity getGoodsById(string id)
        {
            string[] paraNames = { "@id" };
            object[] paraValues = { id };
            object[] obj = Operations.GetValues("[sp_query_GoodsByID]", CommandType.StoredProcedure, paraNames, paraValues);
            GoodsEntity goodsEntity = new GoodsEntity();
            goodsEntity.Id = obj[0].ToString();
            goodsEntity.Name = obj[1].ToString();
            goodsEntity.Cateid = obj[2].ToString();
            goodsEntity.Nationid = obj[3].ToString();
            goodsEntity.Areaid = obj[4].ToString();
            goodsEntity.Weights = obj[5].ToString();
            goodsEntity.Sizes = obj[6].ToString();
            goodsEntity.Marketprice = obj[7].ToString();
            goodsEntity.Nowprice = obj[8].ToString();