bll_xfb.cs

饮食管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Entity;
using DataAccess;

namespace BusinessLayer
{
    public class Bll_xfb
    {
        material mat = new material();
        SqlDataAccess sql = new SqlDataAccess();

        public int InsertXfb(Xfb xfb)
        {
            
            return sql.ExecuteDataSetByUpdate("proc_InsertXfb", xfb.Zdh,  xfb.MatName, xfb.MatPrice, xfb.Zk, xfb.Number, xfb.Price, xfb.Dctime, xfb.Jzr,xfb.Remark);
        }

        public DataTable SelectXfb()
        {
            return sql.ExecuteDataSetBySelect("proc_SelectXfb");
        }
        public DataTable SelectXfbByZdh(string zdh)
        {
            return sql.ExecuteDateSetBySelect("proc_SelectXfbByZdh", zdh);
        }
      
    }
}