using Demo.IDAL.Basic;
using Kingdee.BOS;
using Kingdee.BOS.ServiceHelper;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Demo.DAL.Basic
{
    public class BD_MaterialDAL : IBD_MaterialDAL
    {
        readonly Context Context;
        public BD_MaterialDAL(Context context)
        {
            this.Context = context;
        }
        public void GetMaterialById(long materialId)
        {
            throw new NotImplementedException();
        }

        public string GetMaterialNameByNumber(string number)
        {
            string sql = $"select t2.fname from t_bd_material t1 left join t_bd_material_l t2 on t1.fmaterialid = t2.fmaterialid where fnumber ='{number}'";
            return DBServiceHelper.ExecuteScalar<string>(Context, sql, "");
        }

        public void GetMaterialRecordBySearch()
        {
            throw new NotImplementedException();
        }
    }
}