/// <summary>
/// 核对该时间段是否已存在配置
/// </summary>
/// <returns></returns>
private bool CheckDate(DateTime?begin, DateTime?end, string configId, decimal type)
{
string where = "";
if (string.IsNullOrEmpty(configId))
{
where = "((APT_CONFIG_SDATE<=TO_DATE('" + begin + "','yyyy-MM-dd hh24:mi:ss') and APT_CONFIG_EDATE>=TO_DATE('" + end + "','yyyy-MM-dd hh24:mi:ss')) or (APT_CONFIG_SDATE>=TO_DATE('" + begin + "','yyyy-MM-dd hh24:mi:ss') and APT_CONFIG_SDATE<=TO_DATE('" + end + "','yyyy-MM-dd hh24:mi:ss')) or (APT_CONFIG_EDATE>=TO_DATE('" + begin + "','yyyy-MM-dd hh24:mi:ss') and APT_CONFIG_EDATE<=TO_DATE('" + end + "','yyyy-MM-dd hh24:mi:ss'))) and APT_TYPE=" + type + " and CREATE_ORG_NO='" + AbpSession.ORG_NO + "'";
}
else
{
where = "((APT_CONFIG_SDATE<=TO_DATE('" + begin + "','yyyy-MM-dd hh24:mi:ss') and APT_CONFIG_EDATE>=TO_DATE('" + end + "','yyyy-MM-dd hh24:mi:ss')) or (APT_CONFIG_SDATE>=TO_DATE('" + begin + "','yyyy-MM-dd hh24:mi:ss') and APT_CONFIG_SDATE<=TO_DATE('" + end + "','yyyy-MM-dd hh24:mi:ss')) or (APT_CONFIG_EDATE>=TO_DATE('" + begin + "','yyyy-MM-dd hh24:mi:ss') and APT_CONFIG_EDATE<=TO_DATE('" + end + "','yyyy-MM-dd hh24:mi:ss'))) and APT_TYPE=" + type + " and CREATE_ORG_NO='" + AbpSession.ORG_NO + "' and APT_CONFIG_ID!='" + configId + "'";
}
var list = _crmAptConfigMstrRepository.GetAptConfigList(where);
return(list != null && list.Count > 0 ? false : true);
}
