SIMDP_FEM02/SIMDP.BLL/BlProductData.cs

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 BlProductData : BaseBLL<MoProductData>
    {
        private IDalProductData dalData;

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

            dalData = baseDal as IDalProductData;
        }

        public MoProductData Find2Bind(string vin)
        {
            if (string.IsNullOrEmpty(vin)) return null;
                string sql = $"batchid = '{vin}'";
            return dalData.FindSingle(sql);
        }


    
        /// <summary>
        /// 根据VIN码查询要绑定的生产数据
        /// </summary>
        /// <param name="vinCode"></param>
        /// <param name="everyDayProcuction"></param>
        /// <returns></returns>
        public MoProductData FindbyContainsVIN(string vinCode, int everyDayProcuction = 1500)
        {
            string sql = string.Format($"SELECT TOP {everyDayProcuction} * FROM product_data WHERE data_value like '%{0}%' order by data_id desc", vinCode);
            var list = dalData.GetList(sql, null);
            if (list.Count > 0) return list[0];
            else return null;
        }

    }
}