using ProjectBase.Data.BaseDAL;
using SIMDP.DAL.IDALSQL;
using SIMDP.Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SIMDP.BLL
{
    public class BlSrsData : BaseBLL<MoSrsData>
    {
        private IDalSrsData dalData; 

        /// <summary>
        /// 构造函数
        /// </summary>  
        public BlSrsData() : base() 
        {
            base.Init(this.GetType().FullName, System.Reflection.Assembly.GetExecutingAssembly().GetName().Name);
            dalData = baseDal as IDalSrsData;
        }

        //public MoSrsData FindbyVinCode(string vinCode)
        //{
        //    string sql = string.Format($"SELECT TOP 1 * FROM SRS_DATA WHERE VIN = '{vinCode}' order by SEQUENCE desc");
        //    var list = dalData.GetList(sql, null);
        //    if (list.Count > 0)
        //        return list[0];
        //    else
        //        return null;
        //}
        //public MoSrsData FindbySequenceID(string sequenceId)
        //{
        //    string sql = string.Format($"SELECT TOP 1 * FROM SRS_DATA WHERE SEQUENCE = '{sequenceId}' order by SEQUENCE desc");
        //    var list = dalData.GetList(sql, null);
        //    if (list.Count > 0)
        //        return list[0];
        //    else
        //        return null;
        //}
    }
}