Backup/AccessDal/ProMidOpe.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using Model;
using System.Data;
using System.Data.OleDb;

namespace AccessDal
{
    /// <summary>
    /// 产品小类数据库操作类
    /// </summary>
    public class ProMidOpe
    {
        /// <summary>
        /// 添加小类
        /// </summary>
        /// <param name="bid">大类id</param>
        /// <param name="mname">小类名称</param>
        /// <param name="ishot">是否置顶</param>
        /// <param name="addtime">添加时间</param>
        /// <returns></returns>
        public static int Add(int bid, string mname, bool ishot ,string addtime)
        {
            string sql = "Insert Into Product_Middle(BID,MName,IsHot,AddTime) Values(@bid,@mname,@ishot,@addtime)";
            OleDbParameter[] p = new OleDbParameter[] { new OleDbParameter("@bid", bid), new OleDbParameter("@mname", mname), new OleDbParameter("@ishot",ishot),new OleDbParameter("@addtime", addtime) };
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text, sql, p);
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static int Delete(int id)
        {
            string sql = "Delete From Product_Middle Where ID=@id";
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text, sql, new OleDbParameter[] { new OleDbParameter("@id", id) });
        }
        /// <summary>
        /// 获取数量
        /// </summary>
        /// <returns></returns>
        public static int GetCount()
        {
            string sql = "Select COUNT(ID) From Product_Middle";
            return (int)OleHelper.ExecuteScalar(OleHelper.connString, CommandType.Text, sql);
        }
        /// <summary>
        /// 跟据大类id，获取数量
        /// </summary>
        /// <param name="bid"></param>
        /// <returns></returns>
        public static int GetCount(int bid)
        {
            string sql = "Select COUNT(ID) From Product_Middle Where BID=@bid";
            return (int)OleHelper.ExecuteScalar(OleHelper.connString, CommandType.Text, sql, new OleDbParameter[] { new OleDbParameter("@bid", bid) });
        }
        /// <summary>
        /// 根据大类id，获取小类前几条列表
        /// </summary>