public DataTable GetBscKpiTargetGoalTong_DB(int estterm_ref_id
, int kpi_ref_id
, string ymd)
{
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result dacBscKpiResult = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result();
return(dacBscKpiResult.Select_DB(estterm_ref_id, kpi_ref_id, ymd).Tables[0]);
}
public bool UpdateKpiResultDataByAdmin(DataTable dataTable)
{
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result dac = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result();
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
foreach (DataRow dataRow in dataTable.Rows)
{
affectedRow += dac.UpdateKpiResultDataByAdmin(conn
, trx
, dataRow["ESTTERM_REF_ID"]
, dataRow["KPI_REF_ID"]
, dataRow["YMD"]
, dataRow["RESULT_MS"]
, dataRow["RESULT_TS"]
, dataRow["CAUSE_TEXT_MS"]
, dataRow["CAUSE_TEXT_TS"]
, dataRow["MEASURE_TEXT_MS"]
, dataRow["MEASURE_TEXT_TS"]
, dataRow["CHECKSTATUS"]
, dataRow["UPDATE_DATE"]
, dataRow["UPDATE_USER"]);
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
public string ModifyKpiResultDataBulker_DB(DataTable dt
, string title
, int create_user
, string create_date)
{
string returnVal = string.Empty;
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow row = dt.Rows[i];
object estterm_ref_id = row["ESTTERM_REF_ID"];
object kpi_ref_id = row["KPI_REF_ID"];
object ymd = row["YMD"];
object result_ms = row["RESULT_MS"];
object result_ts = row["RESULT_TS"];
object checkstatus = "Y";
bool check_Apping_yn = DataTypeUtility.GetYNToBoolean(DataTypeUtility.GetValue(row["CHECK_APPING_YN"]));
int app_ref_id = DataTypeUtility.GetToInt32(row["APP_REF_ID"]);
if (check_Apping_yn)
{
MicroBSC.Integration.COM.Dac.Dac_Com_Approval_Info dacApprovalInfo = new MicroBSC.Integration.COM.Dac.Dac_Com_Approval_Info();
app_ref_id = dacApprovalInfo.SelectMaxAppRefID(conn, trx);
int app_version_id = 1;
string biz_type = "KRA";
string app_code = string.Format("{0}-{1}-{2}", biz_type, app_ref_id, app_version_id);
string active_yn = "Y";
string app_status = "CFT";
string draft_status = "FD";
affectedRow = dacApprovalInfo.InsertApprovalinfo_DB(conn
, trx
, app_ref_id
, app_version_id
, app_code
, active_yn
, DBNull.Value
, title
, biz_type
, app_status
, draft_status
, create_user
, create_date);
MicroBSC.Integration.COM.Dac.Dac_Com_Approval_Prc dacApprovalPrc = new MicroBSC.Integration.COM.Dac.Dac_Com_Approval_Prc();
affectedRow = dacApprovalPrc.InsertApprovalPrc_DB(conn
, trx
, app_ref_id
, app_version_id
, 1
, create_user
, "Y"
, title
, DBNull.Value
, "D"
, "NAME"
, create_user
, create_date);
}
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result dacBscKpiResult = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result();
affectedRow = dacBscKpiResult.UpdataData_DB(conn
, trx
, estterm_ref_id
, kpi_ref_id
, ymd
, result_ms
, result_ts
, app_ref_id
, checkstatus
, create_user
, create_date);
}
//trx.Rollback();
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
returnVal = ex.Message;
return(returnVal);
}
finally
{
conn.Close();
}
return(returnVal);
}
public string ModifyKpiResult_DB(int iestterm_ref_id
, int ikpi_ref_id
, string iymd
, double iresult_ms
, double iresult_ts
, int isequence
, double ical_result_ms
, double ical_result_ts
, string cal_apply_yn
, string cal_apply_reason
, string cause_text_ms
, string cause_text_ts
, string cause_file_id
, string imeasure_text_ms
, string imeasure_text_ts
, string imeasure_file_id
, string iremark
, string initiative_do
, string do_file
, DateTime create_date
, int create_user)
{
string returnVal = string.Empty;
int affectedRow = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Initiative dacBscKpiInitiative = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Initiative();
DataTable dtBscKpiInitiative = dacBscKpiInitiative.SelectData_DB(iestterm_ref_id
, ikpi_ref_id
, iymd).Tables[0];
try
{
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result dacBscKpiResult = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result();
affectedRow = dacBscKpiResult.UpdataData_DB(conn
, trx
, iestterm_ref_id
, ikpi_ref_id
, iymd
, iresult_ms
, iresult_ts
, isequence
, "Y"
, ical_result_ms
, ical_result_ts
, cal_apply_yn
, cal_apply_reason
, cause_text_ms
, cause_text_ts
, cause_file_id
, imeasure_text_ms
, imeasure_text_ts
, imeasure_file_id
, iremark
, create_user
, create_date);
if (dtBscKpiInitiative.Rows.Count > 0)
{
affectedRow = dacBscKpiInitiative.UpdateDo_DB(conn
, trx
, iestterm_ref_id
, ikpi_ref_id
, iymd
, initiative_do
, do_file
, create_date
, create_user);
}
else
{
affectedRow = dacBscKpiInitiative.InsertData_DB(conn
, trx
, iestterm_ref_id
, ikpi_ref_id
, iymd
, DBNull.Value
, initiative_do
, do_file
, DBNull.Value
, create_user);
}
//trx.Rollback();
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
returnVal = ex.Message;
return(returnVal);
}
finally
{
conn.Close();
}
return(returnVal);
}
/// <summary>
/// 조직KPI에서 복사한 MBO를 삭제
/// </summary>
/// <param></param>
/// <returns></returns>
public string RemoveMboToKpi_DB(int estterm_ref_id
, string[] objList)
{
string rtnValue = string.Empty;
int okCnt = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Info dacBscKpiInfo = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Info();
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Target_Version dacBscKpiTargetVersion = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Target_Version();
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result dacBscKpiResult = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Result();
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Term dacBscKpiTerm = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Term();
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Target dacBscKpiTarget = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Target();
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Threshold_Info dacBscKpiThresholdInfo = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Threshold_Info();
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Initiative dacBscKpiInitiative = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Initiative();
MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Classification dacBscKpiClassification = new MicroBSC.Integration.BSC.Dac.Dac_Bsc_Kpi_Classification();
foreach (string obj in objList)
{
okCnt = dacBscKpiInfo.Delete_DB(conn
, trx
, estterm_ref_id
, obj);
okCnt = dacBscKpiTargetVersion.Delete_DB(conn
, trx
, estterm_ref_id
, obj);
okCnt = dacBscKpiResult.DeleteData_DB(conn
, trx
, estterm_ref_id
, obj);
okCnt = dacBscKpiTerm.Delete_DB(conn
, trx
, estterm_ref_id
, obj);
okCnt = dacBscKpiTarget.Delete_DB(conn
, trx
, estterm_ref_id
, obj);
okCnt = dacBscKpiThresholdInfo.Delete_DB(conn
, trx
, estterm_ref_id
, obj);
okCnt = dacBscKpiInitiative.DeleteData_DB(conn
, trx
, estterm_ref_id
, obj);
okCnt = dacBscKpiClassification.Delete_DB(conn
, trx
, estterm_ref_id
, obj);
}
trx.Commit();
}
catch (Exception ex)
{
rtnValue = ex.Message;
trx.Rollback();
}
finally
{
conn.Close();
}
return(rtnValue);
}