Bll/tab_productClass.cs

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Model;
using SQLFactoryDAL;
using DAL;

namespace Bll
{
    public class tab_productClass
    {
        SQLAccess sqlManager = new SQLAccess();
        /// <summary>
        /// 执行查询操作
        /// </summary>
        /// <param name="sql">查询语句</param>
        /// <returns>查询结果</returns>
        public DataTable getAll(string sql)
        {
            return sqlManager.ExecuteDataSet(sql).Tables[0];
        }
        /// <summary>
        /// 添加一条数据
        /// </summary>
        /// <param name="proClass">产品类别模型</param>
        /// <returns></returns>
        public int Add(Model.ProductClass proClass)
        {
            StringBuilder strsql = new StringBuilder();
            strsql.Append("insert into tab_productClass values(");
            strsql.AppendFormat("'{0}',", proClass.ProductClassName1);
            strsql.AppendFormat("'{0}',", proClass.ProductParentID1);
            strsql.AppendFormat("'{0}')", proClass.ProductClassContent1);

            return sqlManager.ExecuteNonQuery(strsql.ToString());
        }


        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="productClassID"></param>
        /// <returns></returns>
        public int Delete(int productClassID)
        {
            return sqlManager.ExecuteNonQuery("delete from tab_productClass where productClassID=" + productClassID);
        }

        public object GetItem(string sql)
        {
            return sqlManager.ExecuteSc(sql);
        }

    }
}