Backup/Business/DessertBusiness.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using DBAccess;
using Entity;
using System.Data;

namespace Business
{
    public class DessertBusiness
    {
        public DataTable GetAllDessert()//GridView显示所有商品
        {
            return OLEDB.GetDataset(" select * from tb_Dessert",  "dessert").Tables["dessert"];
        }

        public int AddDessert(Dessert d)//新增商品
        {
            string[] names = { "@dessertName", "@dessertPic", "@dessertSize", "@dessertPrice", "@dessertDetail"};
            object[] values = { d.DessertName, d.DessertPic, d.DessertSize, d.DessertPrice, d.DessertDetail };
            return OLEDB.ExecuteSQL("insert into tb_Dessert (dessertName,dessertPic,dessertSize,dessertPrice,dessertDetail) values(@dessertName,@dessertPic,@dessertSize,@dessertPrice,@dessertDetail)", names, values);
        }

        public int UpdateDessertByDessertId(Dessert d)//根据商品编号更新商品
        {
            string[] names = { "@dessertid", "@dessertName", "@dessertSize", "@dessertPic", "@dessertPrice", "@dessertDetail" };
            object[] values = { d.Dessertid, d.DessertName, d.DessertSize, d.DessertPic, d.DessertPrice, d.DessertDetail };
            return OLEDB.ExecuteSQL("update tb_dessert set dessertName=@dessertName,dessertSize=@dessertSize,dessertPic=@dessertPic,dessertPrice=@dessertPrice,dessertOrderNum=@dessertOrderNum where dessertid=@dessertid",  names, values);
        }

        public int DeleteDessertByDessertId(int dessertid)//根据商品编号删除商品
        {
            string[] names = { "@dessertid" };
            object[] values = { dessertid };
            return OLEDB.ExecuteSQL("delete from tb_dessert where dessertid=@dessertid", names, values);
        }

        public object[] GetDessertDetaiByDessertId(int dessertid)//根据商品编号显示商品详情!!!!!!!!!!!!!!!!!!!!!11
        {
            string[] names = { "@dessertid" };
            object[] values = { dessertid };
            return OLEDB.GetValues("select * from tb_dessert where dessertid=@dessertid", names, values);
        }

        public int UpdateDessertOrderNumByDessertId(int dessertid, int dessertOrderNum)//根据商品编号更新商品销量
        {
            string[] names = { "@dessertid", "@dessertOrderNum" };
            object[] values = { dessertid, dessertOrderNum };
            return OLEDB.ExecuteSQL(" update tb_dessert set dessertOrderNum=@dessertOrderNum where dessertid=@dessertid  ", names, values);
        }

        public DataTable SelectDessertByDessertname(string dessertName)//显示搜索结果
        {
            string[] names = { "@dessertName"};
            object[] values = {dessertName };
            return OLEDB.GetDataset(" select * from tb_dessert where dessertName like '%'+@dessertName+'%'  ", "dessert", names, values).Tables["dessert"];
        }