/// <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); }