using ProjectBase.Data.BaseDAL;
using ProjectBase.Data.Logs;
using SIMDP.DAL.IDALSQL;
using SIMDP.Model;
using System;
using System.Collections.Generic;

namespace SIMDP.BLL
{
    /// <summary>
    /// Model_Contrast
    /// </summary>
	public class BlModelContrast : BaseBLL<MoModelContrast>
    {
        private IDalModelContrast dalData;
        public BlModelContrast() : base()
        {
            base.Init(this.GetType().FullName, System.Reflection.Assembly.GetExecutingAssembly().GetName().Name);
            dalData = baseDal as IDalModelContrast;
            dalData.OnOperationLog += new OperationLogEventHandler(BlLogOperation.OnOperationLog);//记录修改
        }

        public int GetPLCCodebyModelCode(string modelCode)
        {
            if (string.IsNullOrEmpty(modelCode)) return -1;

            string sql = $"select top 1 plc_code from model_contrast where model_code = '{modelCode}'";
            var list = dalData.SqlValueList(sql);
            if (string.IsNullOrEmpty(list)) return -1;
            else return Convert.ToInt32(list);
        }
    }
}