Product.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 Product
    {
        /// <summary>
        /// 添加产品
        /// </summary>
        /// <param name="bid">产品大类id</param>
        /// <param name="mid">产品小类id</param>
        /// <param name="pnum">产品编号</param>
        /// <param name="pname">产品名称</param>
        /// <param name="price">产品价格</param>
        /// <param name="imgurl">产品图片</param>
        /// <param name="pdetail">产品详细信息</param>
        /// <param name="isnew">是否最新</param>
        /// <param name="ishot">是否热卖</param>
        /// <param name="attr1">备注1</param>
        /// <param name="attr2">备注2</param>
        /// <param name="attr3">备注3</param>
        /// <param name="addtime">添加时间</param>
        /// <returns></returns>
        public static int AddProduct(int bid, int mid, string pnum, string pname, decimal price, string imgurl, string pdetail, bool isnew, bool ishot, string attr1, string attr2 ,string attr3, string addtime)
        {
            string sql = "Insert Into ProductInfo (BID,MID,PNum,PName,Price,ImgUrl,PDetail,IsNew,IsHot,Attr1,Attr2,Attr3,AddTime) Values (@bid,@mid,@pnum,@pname,@price,@imgurl,@pdetail,@isnew,@ishot,@attr1,@attr2,@attr3,@addtime)";
            OleDbParameter[] p = new OleDbParameter[] { new OleDbParameter("@bid", bid), new OleDbParameter("@mid", mid), new OleDbParameter("@pnum", pnum), new OleDbParameter("@pname", pname), new OleDbParameter("@price", price), new OleDbParameter("@imgurl", imgurl), new OleDbParameter("@pdetail", pdetail), new OleDbParameter("@isnew", isnew), new OleDbParameter("@ishot", ishot), new OleDbParameter("@attr1", attr1), new OleDbParameter("@attr2", attr2), new OleDbParameter("@attr3", attr3), new OleDbParameter("@addtime", addtime) };
            return OleHelper.ExecuteNonQuery(OleHelper.connString, CommandType.Text, sql, p);
        }
        /// <summary>
        /// 根据是否是热卖获取数量
        /// </summary>
        /// <returns></returns>
        public static int counthot()
        {
            string sql = "Select Count(ID) From ProductInfo Where IsHot=true";
            return (int)OleHelper.ExecuteScalar(OleHelper.connString, CommandType.Text, sql);
        }
        /// <summary>
        /// 根据是否最新获取数量
        /// </summary>
        /// <returns></returns>
        public static int countnew()
        {
            string sql = "Select Count(ID) From ProductInfo Where IsNew=true";
            return (int)OleHelper.ExecuteScalar(OleHelper.connString, CommandType.Text, sql);
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>