SIMDP_FEM02/SIMDP.BLL/BlColorContrast.cs

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>
    /// Color_Contrast
    /// </summary>
	public class BlColorContrast : BaseBLL<MoColorContrast>
    {
        private IDalColorContrast dalData;
        public BlColorContrast() : base()
        {
            base.Init(this.GetType().FullName, System.Reflection.Assembly.GetExecutingAssembly().GetName().Name);
            dalData = baseDal as IDalColorContrast;
            dalData.OnOperationLog += new OperationLogEventHandler(BlLogOperation.OnOperationLog);//记录修改
        }

        public int GetPaintLinebyColorCard(string colorCard)
        {
            if (string.IsNullOrEmpty(colorCard)) return -1;

            string sql = $"select top 1 paint_line from color_contrast where color_card = '{colorCard}'";
            var list = dalData.SqlValueList(sql);
            if (string.IsNullOrEmpty(list))
            {
                sql = $"select top 1 paint_line from color_contrast where color_card like '{colorCard}%'";
                list = dalData.SqlValueList(sql);
            }

            if (string.IsNullOrEmpty(list)) return -1;
            else return Convert.ToInt32(list);
        }
    }
}