using ProjectBase.Data.BaseDAL;
using ProjectBase.Data.Logs;
using SIMDP.DAL.IDALSQL;
using SIMDP.Model;
using System;
using System.Collections.Generic;
namespace SIMDP.BLL
{
///
/// Color_Contrast
///
public class BlColorContrast : BaseBLL
{
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);
}
}
}