Backup/AccessDal/ProBigOpe.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 ProBigOpe
    {
        /// <summary>
        /// 添加产品大类
        /// </summary>
        /// <param name="bname">名称</param>
        /// <param name="addtime">时间</param>
        /// <returns></returns>
        public static int Add(string bname, string addtime)
        {
            string sql = "Insert Into Product_Big(BName,AddTime) Values(@bname,@addtime)";
            OleDbParameter[] p = new OleDbParameter[] { new OleDbParameter("@bname", bname), 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_Big 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_Big";
            return (int)OleHelper.ExecuteScalar(OleHelper.connString, CommandType.Text, sql);
        }
        /// <summary>
        /// 获取列表，可分页
        /// </summary>
        /// <param name="start"></param>
        /// <param name="max"></param>
        /// <returns></returns>
        public static DataSet GetListBid(int start, int max)
        {
            string sql = "Select ID,BName,AddTime From Product_Big Order By AddTime DESC";
            return OleHelper.ExecuteDataset(OleHelper.connString, CommandType.Text, sql, start, max);
        }
        /// <summary>
        /// 获取单条
        /// </summary>
        /// <param name="id"></param>