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 BlPcData : BaseBLL<MoPcData>
    {
        private IDalPcData dalData;

        /// <summary>
        /// 构造函数
        /// </summary>  
        public BlPcData() : base()
        {
            base.Init(this.GetType().FullName, System.Reflection.Assembly.GetExecutingAssembly().GetName().Name);

            dalData = baseDal as IDalPcData;
        }

    

        public List<MoPcData> GetDATA2PLC(int presentID)
        {
            string sql = $"select top 12* from PC_DATA where ID >= {presentID}";
            var list = dalData.GetList(sql, null);
            if (list.Count > 0) return list;
            else return null;
        }

        public int TruncateTable()
        {
            string sql = "TRUNCATE TABLE PC_DATA";
            int res = dalData.SqlExecute(sql);
            return res;
        }

        public MoPcData FindbyVinCode(string vincode)
        {
            string sql = $"select * from pc_data where vin = '{vincode}' order by ID desc ";
            var list = dalData.GetList(sql, null);
            if (list.Count > 0) return list[0];
            else return null;
        }
    }
}