保健品销售网站 三层架构/Business/CateBusiness.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 CateBusiness
    {

        public int InsertCate(CateEntity cateEntity)
        {
            string[] paraNames = { "@id", "@catename" };
            object[] paraValues = { cateEntity.Id, cateEntity.Catename };
            object obj = Operations.ExecuteSQL("[sp_insert_Cate]", CommandType.StoredProcedure, paraNames, paraValues);
            return Convert.ToInt32(obj);
        }

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

        public int UpdateCate(CateEntity cateEntity)
        {
            string[] paraNames = { "@id", "@catename" };
            object[] paraValues = { cateEntity.Id, cateEntity.Catename };
            object obj = Operations.ExecuteSQL("[sp_update_Cate]", CommandType.StoredProcedure, paraNames, paraValues);
            return Convert.ToInt32(obj);
        }

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

        public CateEntity getCateById(string id)
        {
            string[] paraNames = { "@id" };
            object[] paraValues = { id };
            object[] obj = Operations.GetValues("[sp_query_CateByID]", CommandType.StoredProcedure, paraNames, paraValues);
            CateEntity cateEntity = new CateEntity();
            cateEntity.Id = obj[0].ToString();
            cateEntity.Catename = obj[1].ToString();
            return cateEntity;
        }

        public DataSet getCateByCond(string cond, string val, string tableName)
        {
            string[] paraNames = { "@cond", "@val" };
            object[] paraValues = { cond, val };