// 탬플릿을 이용한 kpi 복사
public string CopyKpiToMboUsingTemplete(int estterm_ref_id
, object[] objKpiPoolList
, string templete_id
, string templete_name
, int emp_ref_id
, string nowDate
, string result_measurement_step
, int unit_type_ref_id
, string class_type
, DataTable dtBscThresholdStep)
{
string reVal = string.Empty;
MicroBSC.BSC.Dac.Dac_Bsc_Kpi_Info dac = new MicroBSC.BSC.Dac.Dac_Bsc_Kpi_Info();
Dac_Bsc_Mbo_Kpi_Classification dacBscMboKpiClassification = new Dac_Bsc_Mbo_Kpi_Classification();
Dac_Bsc_Kpi_Target_Version dacBscKpiTargetVersion = new Dac_Bsc_Kpi_Target_Version();
Dac_Bsc_Kpi_Result dacBscKpiResult = new Dac_Bsc_Kpi_Result();
Dac_Com_Emp_Role_Rel dacEmpRoleRel = new Dac_Com_Emp_Role_Rel();
Dac_Bsc_Kpi_Term dacBscKpiTerm = new Dac_Bsc_Kpi_Term();
Dac_Bsc_Kpi_Target dacBscKpiTarget = new Dac_Bsc_Kpi_Target();
Dac_Bsc_Kpi_Threshold_Info dacBscKpiThresholdInfo = new Dac_Bsc_Kpi_Threshold_Info();
Dac_Bsc_Kpi_Initiative dacBscKpiInitiative = new Dac_Bsc_Kpi_Initiative();
int rtn_kpi_ref_id = 0;
int affectedRow = 0;
bool Result;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
//for (int i = 0; i < objList.Length; i++)
//{
// DataTable dt = dacBscMboKpiClassification.Select_DB(conn, trx, estterm_ref_id, emp_ref_id, 0, objList[i], "");
// if (dt.Rows.Count > 0 && DataTypeUtility.GetToInt32(dt.Rows[0]["ESTTERM_REF_ID"]) > 0)
// return false;
//}
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new Biz_Bsc_Kpi_Result();
for (int i = 0; i < objKpiPoolList.Length; i++)
{
rtn_kpi_ref_id = dac.SelectMaxBscKpiInfo_DB(conn, trx);
object kpi_pool_ref_id = objKpiPoolList[i];
#region 기존 코드에서 strQuery1
//KPI INFO COPY
int okCnt = _data.InsertData_DB(conn
, trx
, estterm_ref_id
, rtn_kpi_ref_id
, rtn_kpi_ref_id
, kpi_pool_ref_id
, string.Format("{0}_{1}", templete_id, templete_name)
, ""
, emp_ref_id
, "MAN"
, "ATY"
, "ETC"
, result_measurement_step
, "RATE"
, unit_type_ref_id
, 1
, ""
, ""
, "N"
, "N"
, "N"
, "Y"
, nowDate
, emp_ref_id);
//MAX KPI_REF_ID
//rtn_kpi_ref_id = _data.Select_Max_Kpi_Ref_Id(conn, trx);
//KPI TARGET VERSION INSERT
dacBscKpiTargetVersion.Insert_DB(conn, trx
, estterm_ref_id
, rtn_kpi_ref_id
, 1
, "당초계획"
, "당초계획(자동생성)"
, 1
, 12
, "Y"
, emp_ref_id);
//Champion Role Insert
dacEmpRoleRel.Delete_DB(conn, trx, emp_ref_id, 3);
dacEmpRoleRel.Insert_DB(conn, trx, emp_ref_id, 3);
//지표구분테이블에 일상업무정보 추가 BSC_MBO_KPI_CLASSIFICATION
dacBscMboKpiClassification.Insert_DB(conn
, trx
, estterm_ref_id
, emp_ref_id
, rtn_kpi_ref_id
, rtn_kpi_ref_id
, class_type
, emp_ref_id);
#endregion
affectedRow = 0;
if (rtn_kpi_ref_id > 0)
{
string year = DateTime.Now.Year.ToString();
#region 기존코드에서 strQuery2
for (int k = 1; k < 13; k++)
{
string month = k.ToString().PadLeft(2, '0');
string ymd = year + month;
//KPI RESULT INSERT
affectedRow += bizBscKpiResult.InsertData_DB(conn
, trx
, estterm_ref_id
, rtn_kpi_ref_id
, ymd
, 0
, 0
, ymd
, 0
, 0
, "N"
, ""
, ""
, ""
, ""
, ""
, ""
, ""
, ""
, nowDate
, emp_ref_id);
dacBscKpiTerm.Insert_DB(conn
, trx
, estterm_ref_id
, rtn_kpi_ref_id
, ymd
, "N"
, "N"
, "N"
, emp_ref_id);
dacBscKpiTarget.InsertData_DB(conn
, trx
, estterm_ref_id
, rtn_kpi_ref_id
, 1
, ymd
, 0
, 0
, emp_ref_id);
dacBscKpiInitiative.InsertData_DB(conn
, trx
, estterm_ref_id
, rtn_kpi_ref_id
, ymd
, DBNull.Value
, DBNull.Value
, DBNull.Value
, DBNull.Value
, emp_ref_id);
}
if (affectedRow != 12)
{
return("false");
}
#endregion
////////////////////////////////////////////////////
// KPI THRESHOLD
////////////////////////////////////////////////////
for (int k = 0; k < dtBscThresholdStep.Rows.Count; k++)
{
string threshold_ref_id = DataTypeUtility.GetValue(dtBscThresholdStep.Rows[k]["THRESHOLD_REF_ID"]);
dacBscKpiThresholdInfo.InsertData_DB(conn
, trx
, estterm_ref_id
, rtn_kpi_ref_id
, threshold_ref_id
, result_measurement_step
, 0
, 0
, 0
, 0
, nowDate
, emp_ref_id);
}
}
}
trx.Commit();
}
catch (Exception ex)
{
reVal = ex.Message;
trx.Rollback();
rtn_kpi_ref_id = 0;
}
finally
{
conn.Close();
}
return(reVal);
}
/// <summary>
/// 프로젝트 평가점수와 KPI실적 연계
/// </summary>
/// <param name="est_id">조직KPI:3A, 개인KPI:3GA</param>
/// <param name="ymd">KPI 기간 yyyyMM</param>
public bool Modify_Point_Rel_Prj_Kpi(IDbConnection conn, IDbTransaction trx
, int comp_id
, string est_id
, int estterm_ref_id
, int estterm_sub_id
, int est_dept_id
, int est_emp_id
, int tgt_dept_id
, int tgt_emp_id
, int kpi_ref_id
, string ymd
, int update_user_ref_id)
{
bool result = false;
int affectedRow = 0;
Dac_Est_Data dacEstData = new Dac_Est_Data();
Dac_Bsc_Kpi_Result dacBscKpiResult = new Dac_Bsc_Kpi_Result();
Dac_Com_Approval_Info dacComApprovalInfo = new Dac_Com_Approval_Info();
Dac_Com_Approval_Prc dacComApprovalPrc = new Dac_Com_Approval_Prc();
string bizType = "";
if (est_id.Equals("3A"))
{
bizType = "KRA";
}
else if (est_id.Equals("3GA"))
{
bizType = "TRA";
}
DataTable dtEstData = dacEstData.Select_Est_Data_Join_Est_Esu(conn, trx
, comp_id
, est_id
, estterm_ref_id
, estterm_sub_id
, 1 //estterm_step_id
, est_dept_id
, est_emp_id
, tgt_dept_id
, tgt_emp_id
, ""
, ""
, OwnerType.All).Tables[0];
if (dtEstData.Rows.Count > 0 && bizType.Length > 0)
{
try
{
string prj_point = DataTypeUtility.GetString(dtEstData.Rows[0]["POINT"]);
int app_ref_id = dacComApprovalInfo.SelectMaxAppRefID(conn, trx);
affectedRow += dacComApprovalInfo.InsertApprovalinfo_DB(conn, trx
, app_ref_id
, 1 //VERSION_NO
, "" //APP_CODE
, "Y" //ACTIVE_YN
, "" //ORI_DOC
, "프로젝트 평가" //TITLE
, bizType
, "CFT" //APP_STATUS
, "FD" //DRAFT_STATUS : FD, MD, RD
, update_user_ref_id
, System.DateTime.Now.ToString("yyyy-MM-dd"));
affectedRow += dacComApprovalPrc.InsertApprovalPrc_DB(conn, trx
, app_ref_id
, 1 //VERSION_NO
, 1 //LINE_STEP
, update_user_ref_id //APP_EMP_ID
, "Y" //COMPLETE_TN
, "" //COMMENTS
, "" //RETURN_REASON
, "D" //LINE_TYPE
, "NAME" //APP_METHOD
, update_user_ref_id
, System.DateTime.Now.ToString("yyyy-MM-dd"));
affectedRow += dacBscKpiResult.UpdateData_DB(conn, trx
, estterm_ref_id
, kpi_ref_id
, ymd
, prj_point
, prj_point
, app_ref_id
, update_user_ref_id);
if (affectedRow == 3)
{
trx.Commit();
result = true;
}
else
{
trx.Rollback();
affectedRow = 0;
}
}
catch (Exception ex)
{
trx.Rollback();
affectedRow = 0;
}
finally
{
conn.Close();
}
}
return(result);
}
public bool CopyKpiToMbo(int estterm_ref_id
, object[] objList
, int emp_ref_id
, string estYear
, string class_type)
{
Dac_Bsc_Mbo_Kpi_Classification dacBscMboKpiClassification = new Dac_Bsc_Mbo_Kpi_Classification();
Dac_Bsc_Kpi_Target_Version dacBscKpiTargetVersion = new Dac_Bsc_Kpi_Target_Version();
Dac_Bsc_Kpi_Result dacBscKpiResult = new Dac_Bsc_Kpi_Result();
Dac_Com_Emp_Role_Rel dacEmpRoleRel = new Dac_Com_Emp_Role_Rel();
Dac_Bsc_Kpi_Term dacBscKpiTerm = new Dac_Bsc_Kpi_Term();
Dac_Bsc_Kpi_Target dacBscKpiTarget = new Dac_Bsc_Kpi_Target();
Dac_Bsc_Kpi_Threshold_Info dacBscKpiThresholdInfo = new Dac_Bsc_Kpi_Threshold_Info();
Dac_Bsc_Kpi_Initiative dacBscKpiInitiative = new Dac_Bsc_Kpi_Initiative();
int rtn_kpi_ref_id = 0;
int affectedRow;
bool Result;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
for (int i = 0; i < objList.Length; i++)
{
DataTable dt = dacBscMboKpiClassification.Select_DB(conn, trx, estterm_ref_id, emp_ref_id, 0, objList[i], "");
if (dt.Rows.Count > 0 && DataTypeUtility.GetToInt32(dt.Rows[0]["ESTTERM_REF_ID"]) > 0)
{
return(false);
}
}
for (int i = 0; i < objList.Length; i++)
{
#region 기존 코드에서 strQuery1
//KPI INFO COPY
_data.Insert_DB_From_Bsc_Kpi_Info(conn, trx
, estterm_ref_id
, 0
, "MicroPolis_0"
, emp_ref_id
, DataTypeUtility.GetToInt32(objList[i]));
//MAX KPI_REF_ID
//rtn_kpi_ref_id = _data.Select_Max_Kpi_Ref_Id(conn, trx);
MicroBSC.BSC.Dac.Dac_Bsc_Kpi_Info dac = new MicroBSC.BSC.Dac.Dac_Bsc_Kpi_Info();
rtn_kpi_ref_id = dac.SelectMaxBscKpiInfo_DB(conn, trx);
//KPI TARGET VERSION INSERT
dacBscKpiTargetVersion.Delete_DB(conn, trx, estterm_ref_id, rtn_kpi_ref_id);
dacBscKpiTargetVersion.Insert_DB(conn, trx
, estterm_ref_id
, rtn_kpi_ref_id
, 1
, "당초계획"
, "당초계획(자동생성)"
, 1
, 12
, "Y"
, emp_ref_id);
//KPI RESULT INSERT
dacBscKpiResult.DeleteData_DB(conn, trx, estterm_ref_id, rtn_kpi_ref_id);
dacBscKpiResult.Insert_DB_From_Estterm_Detail(conn, trx
, estterm_ref_id
, rtn_kpi_ref_id
, emp_ref_id);
_data.Update_Bsc_Kpi_Info(conn, trx
, 0
, estterm_ref_id
, rtn_kpi_ref_id);
//Champion Role Insert
dacEmpRoleRel.Delete_DB(conn, trx, emp_ref_id, 3);
dacEmpRoleRel.Insert_DB(conn, trx, emp_ref_id, 3);
//지표구분테이블에 일상업무정보 추가 BSC_MBO_KPI_CLASSIFICATION
dacBscMboKpiClassification.Insert_DB(conn, trx
, estterm_ref_id
, emp_ref_id
, rtn_kpi_ref_id
, DataTypeUtility.GetToInt32(objList[i])
, class_type
, emp_ref_id);
#endregion
if (rtn_kpi_ref_id > 0)
{
#region 기존코드에서 strQuery2
affectedRow = dacBscKpiTerm.Insert_DB_From_Bsc_Kpi_Term(conn, trx
, estterm_ref_id
, rtn_kpi_ref_id
, DataTypeUtility.GetToInt32(objList[i])
, emp_ref_id);
if (affectedRow != 12)
{
return(false);
}
#endregion
if (class_type.ToString().Equals("PRS"))
{
//기존코드에서 strQuery6
dacBscKpiTarget.InsertData_DB_From_BSC_KPI_TARGET(conn, trx
, estterm_ref_id
, DataTypeUtility.GetToInt32(objList[i])
, rtn_kpi_ref_id
, emp_ref_id);
}
else
{
for (int j = 0; j < 13; j++)
{
Result = dacBscKpiTarget.Proc_Update(conn, trx
, "A"
, estterm_ref_id
, rtn_kpi_ref_id
, 1
, estYear.ToString() + j.ToString().PadLeft(2, '0')
, 0
, 0
, emp_ref_id);
if (!Result)
{
return(false);
}
}
}
////////////////////////////////////////////////////
// KPI THRESHOLD
////////////////////////////////////////////////////
//기존코드에서 strQuery3
dacBscKpiThresholdInfo.Delete_DB(conn, trx
, estterm_ref_id
, rtn_kpi_ref_id);
//기존코드에서 strQuery4
dacBscKpiThresholdInfo.Insert_DB_From_Bsc_Kpi_Threshold_Info(conn, trx
, class_type
, estterm_ref_id
, rtn_kpi_ref_id
, DataTypeUtility.GetToInt32(objList[i])
, emp_ref_id);
#region 기존코드에서 strQuery5
if (class_type.ToString().Equals("PRS"))
{
dacBscKpiInitiative.InsertData_DB_From_Bsc_Kpi_Initiative(conn, trx
, estterm_ref_id
, DataTypeUtility.GetToInt32(objList[i])
, rtn_kpi_ref_id
, emp_ref_id);
}
else
{
affectedRow = 0;
for (int j = 1; j < 13; j++)
{
dacBscKpiInitiative.InsertData_DB(conn, trx
, estterm_ref_id
, rtn_kpi_ref_id
, estYear.ToString() + j.ToString().PadLeft(2, '0')
, DBNull.Value
, DBNull.Value
, DBNull.Value
, DBNull.Value
, emp_ref_id);
}
}
#endregion
}
else
{
return(false);
}
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
rtn_kpi_ref_id = 0;
}
finally
{
conn.Close();
}
return(rtn_kpi_ref_id > 0 ? true : false);
}
