Backup/Business/CookBusiness.cs

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

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

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

using Entity;
using DBAccess;
using System.Data;

namespace Business
{
    public class CookBusiness
    {
        public DataTable GetAllCooks(string tableName)
        {
            return OLEDB.GetDataset("select * from tb_cook",  "cook").Tables["cook"];
        }

        public object[] GetCookDetailsByCookid(int cookid)
        {
            string[] names = { "@cookid" };
            object[] values = { cookid };
            return OLEDB.GetValues("select * from tb_cook where cookid=@cookid",  names, values);
        }

        public int UpdateCookInfoByCookid(Cook c)
        {
            string[] names = { "@cookname", "@sex", "@level", "@photo", "@cookid" };
            object[] values = { c.Cookname, c.Sex, c.Level, c.Photo, c.Cookid};
            return OLEDB.ExecuteSQL("update tb_cook set [cookname]=@cookname,[sex]=@sex,[level]=@level,[photo]=@photo where [cookid]=@cookid",  names, values);
        }

        public int Addcook(Cook c)
        {
            string[] names = { "@cookname", "@sex", "@level", "@photo", "@cookcontent" };
            object[] values = { c.Cookname, c.Sex, c.Level, c.Photo, c.Cookcontent };
            return OLEDB.ExecuteSQL("insert into tb_cook(cookname,sex,[level],photo,cookcontent) values(@cookname,@sex,@level,@photo,@cookcontent)", names, values);
        }

        public DataTable GetAllcook()
        {
            return OLEDB.GetDataset("select * from tb_cook", "c").Tables["c"];
        }

        public object[] GetCookByID(int cookid)
        {
            string[] names = { "@cookid" };
            object[] values = { cookid };
            object[] obj = OLEDB.GetValues("select * from tb_cook where cookid=@cookid", names, values);
            return obj;
        }

        public int UpdateCookByID(Cook c)//存储过程和参数对应 public
        {
            string[] names = { "@cookname", "@sex", "@level", "@photo", "@cookcontent", "@cookid"};
            object[] values = { c.Cookname, c.Sex, c.Level, c.Photo, c.Cookcontent, c.Cookid };
            return OLEDB.ExecuteSQL("update tb_cook set cookname=@cookname,[sex]=@sex,[level]=@level,photo=@photo,cookcontent=@cookcontent where cookid=@cookid", names, values);
        }

        public int DeleteCookByID(int cookid)