/// <summary>
/// 구성Vo조회
/// </summary>
/// <param name="configurationVo">구성Vo</param>
/// <returns>구성Vo</returns>
public ConfigurationVo selectConfigurationVo(ConfigurationVo configurationVo)
{
ConfigurationVo rtnConfigurationVo = new ConfigurationVo();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_CONFIGURATION_SELECT";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@CONFIGURATION_ID", configurationVo.configuration.configurationId));
DataSet ds = sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
if ((ds != null) &&
(ds.Tables != null) && (ds.Tables[0] != null) &&
(ds.Tables[0].Rows.Count > 0) && (ds.Tables[0].Rows[0] != null))
{
rtnConfigurationVo.configuration.configurationId = ds.Tables[0].Rows[0]["CONFIGURATION_ID"].ToString();
rtnConfigurationVo.configuration.configurationNm = ds.Tables[0].Rows[0]["CONFIGURATION_NM"].ToString();
rtnConfigurationVo.configuration.configurationVal = ds.Tables[0].Rows[0]["CONFIGURATION_VAL"].ToString();
rtnConfigurationVo.configuration.configurationUsed = bool.Parse(ds.Tables[0].Rows[0]["CONFIGURATION_USED"].ToString());
rtnConfigurationVo.configuration.configurationSubgroupNo = int.Parse(ds.Tables[0].Rows[0]["CONFIGURATION_SUBGROUP_NO"].ToString());
}
}
return(rtnConfigurationVo);
}
/// <summary>
/// 구성Vo조회
/// </summary>
/// <param name="configurationVo">구성Vo</param>
/// <returns>구성Vo</returns>
public ConfigurationVo selectConfigurationVo(ConfigurationVo configurationVo)
{
ConfigurationVo rtnConfigurationVo = new ConfigurationVo();
using (ConfigurationService configurationService = new ConfigurationService())
{
rtnConfigurationVo = configurationService.selectConfigurationVo(configurationVo);
}
return(rtnConfigurationVo);
}
/// <summary>
/// 구성Vo조회
/// </summary>
/// <param name="configurationVo">구성Vo</param>
/// <returns>구성Vo</returns>
public ConfigurationVo selectConfigurationVo(ConfigurationVo configurationVo)
{
ConfigurationVo rtnConfigurationVo = new ConfigurationVo();
using (ConfigurationCache configurationCache = new ConfigurationCache())
{
rtnConfigurationVo = configurationCache.selectConfigurationVo(configurationVo);
if ((rtnConfigurationVo == null) || (rtnConfigurationVo.configuration == null) ||
(rtnConfigurationVo.configuration.configurationUsed == false))
{
rtnConfigurationVo = null;
}
}
return(rtnConfigurationVo);
}
private string getConfiguration(string configurationId)
{
ConfigurationVo rtnConfigurationVo = new ConfigurationVo();
using (FCcmnFacade fccmnFacade = new FCcmnFacade())
{
ConfigurationVo configurationVo = new ConfigurationVo();
configurationVo.configuration.configurationId = configurationId;
rtnConfigurationVo = fccmnFacade.selectConfigurationVo(configurationVo);
}
if ((rtnConfigurationVo == null) || (rtnConfigurationVo.configuration == null) ||
(rtnConfigurationVo.configuration.configurationUsed == false))
{
return("");
}
return(rtnConfigurationVo.configuration.configurationVal);
}
/// <summary>
/// 구성Vo조회
/// </summary>
/// <param name="configurationVo">구성Vo</param>
/// <returns>구성Vo</returns>
public ConfigurationVo selectConfigurationVo(ConfigurationVo configurationVo)
{
ConfigurationVo rtnConfigurationVo = new ConfigurationVo();
ObjectCache cache = MemoryCache.Default;
ConfigurationVo configurationVoHOME = cache["HOME"] as ConfigurationVo;
if (configurationVoHOME != null)
{
rtnConfigurationVo = configurationVoHOME;
}
else
{
using (ConfigurationDao configurationDao = new ConfigurationDao())
{
rtnConfigurationVo = configurationDao.selectConfigurationVo(configurationVo);
CacheItemPolicy policy = new CacheItemPolicy();
policy.AbsoluteExpiration = DateTimeOffset.Now.AddMinutes(10);
cache.Set("HOME", rtnConfigurationVo, policy);
}
}
return(rtnConfigurationVo);
}
