/// <summary>
/// 실적상세데이터 조회
/// </summary>
/// <param name="ikpi_ref_id"></param>
/// <param name="sCurYMD"></param>
/// <returns></returns>
public DataSet GetInterfaceData(int ikpi_ref_id, string sCurYMD, out string sMsg, out bool bIsSuccess)
{
Dac_Bsc_Interface_Kpi_Query objQry = new Dac_Bsc_Interface_Kpi_Query(ikpi_ref_id, "");
DataSet rDs = new DataSet();
sMsg = "";
string sQuery = "";
bIsSuccess = false;
try
{
sQuery = objQry.IQuery_Al;
sQuery = sQuery.Replace(QueryOperator.ParamCurrYmd, "'" + sCurYMD + "'");
sQuery = sQuery.Replace(QueryOperator.ParamFirstYmd, "'" + sCurYMD + "'");
rDs = DbAgentObj.FillDataSet(sQuery, "INTERFACE_DATA");
sMsg = "Success";
bIsSuccess = true;
}
catch (Exception e)
{
sMsg = e.Message;
bIsSuccess = false;
}
return(rDs);
}
/// <summary>
/// 당월 인터페이스 실적
/// </summary>
/// <param name="ikpi_ref_id"></param>
/// <param name="sCurYMD"></param>
/// <param name="sMsg"></param>
/// <returns></returns>
public decimal GetInterfaceResultMs(int ikpi_ref_id, string sCurYMD, out string sMsg, out bool bIsSuccess)
{
Dac_Bsc_Interface_Kpi_Query objQry = new Dac_Bsc_Interface_Kpi_Query(ikpi_ref_id, "");
DataSet rDs = new DataSet();
decimal rVal = 0;
string sQry = "";
sMsg = "";
bIsSuccess = false;
try
{
sQry = objQry.IQuery_Ms;
sQry = sQry.Replace(QueryOperator.ParamCurrYmd, "'" + sCurYMD + "'");
sQry = sQry.Replace(QueryOperator.ParamFirstYmd, "'" + sCurYMD + "'");
rDs = DbAgentObj.FillDataSet(sQry, "INTERFACE_DATA");
if (rDs.Tables.Count > 0)
{
if (rDs.Tables[0].Rows.Count > 0)
{
rVal = (rDs.Tables[0].Rows[0][0] == DBNull.Value) ? 0 : decimal.Parse(rDs.Tables[0].Rows[0][0].ToString());
rVal = Math.Round(rVal, 4);
}
else
{
rVal = 0;
}
}
else
{
rVal = 0;
}
sMsg = "Success";
bIsSuccess = true;
}
catch (Exception e)
{
sMsg = e.Message;
rVal = 0;
bIsSuccess = false;
}
return(rVal);
}
