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

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

        public DataTable SelectMaterail()
        {
            return sql.ExecuteDataSetBySelect("proc_SelectMaterail");
        }
        public DataTable SelectMatByMid(material mat)
        {

            return sql.ExecuteDateSetBySelect("proc_SelectMatByMid", mat.MatID);
          
            
        }
        public string SelectWaiidByMatname(string n)
        {
            DataTable dt = sql.ExecuteDateSetBySelect("proc_SelectWaiidByMatname", n);
            return dt.Rows[0][0].ToString();
        }
    }
}