private void DoBinding()
{
DataSet ds;
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result();
int emp_id = this.gUserInfo.Emp_Ref_ID;
if (this.EMP_ROLES.Contains("1") || this.EMP_ROLES.Contains("8"))
{
emp_id = 0;
}
ds = bizBscKpiResult.SelectKpiList(_iestterm_ref_id, _iest_dept_id, _iymd, emp_id);
this.ugridKpiTargetList.DataSource = ds;
this.ugridKpiTargetList.DataBind();
lblRowCount.Text = ugridKpiTargetList.Rows.Count.ToString();
DataRow[] rows = ds.Tables[0].Select(" CLOSE_YN = 'Y' ");
if (rows.Length > 0)
{
lblMsg.Text = "마감된 평가 기간 입니다.";
iBtnApply.Visible = false;
iBtnUpdate.Visible = false;
}
else
{
lblMsg.Text = string.Empty;
iBtnApply.Visible = true;
iBtnUpdate.Visible = true;
}
}
private void DoBinding()
{
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result();
int emp_id = this.gUserInfo.Emp_Ref_ID;
if (this.EMP_ROLES.Contains("1") || this.EMP_ROLES.Contains("8"))
{
emp_id = 0;
}
DS_DATA = bizBscKpiResult.SelectKpiTargetList(_iestterm_ref_id, _iest_dept_id, _iymd, emp_id);
this.ugridKpiTargetList.Clear();
this.ugridKpiTargetList.DataSource = DS_DATA;
this.ugridKpiTargetList.DataBind();
lblRowCount.Text = ugridKpiTargetList.Rows.Count.ToString();
}
public void SetResultListGrid()
{
DataSet ds;
//MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result();
//if (((SitePrincipal)this.User).Roles.Contains("1") == true || ((SitePrincipal)this.User).Roles.Contains("8") == true)
// ds = objBSC.SelectKpiResultYear(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), (txtDeptCode.Value == string.Empty ? 0 : int.Parse(txtDeptCode.Value)), 0);
//else
// ds = objBSC.SelectKpiResultYear(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), (txtDeptCode.Value == string.Empty ? 0 : int.Parse(txtDeptCode.Value)), this.gUserInfo.Emp_Ref_ID);
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result();
int emp_id = this.gUserInfo.Emp_Ref_ID;
if (this.EMP_ROLES.Contains("1") || this.EMP_ROLES.Contains("8"))
{
emp_id = 0;
}
ds = bizBscKpiResult.SelectKpiResultYear(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)
, (txtDeptCode.Value == string.Empty ? 0 : int.Parse(txtDeptCode.Value))
, emp_id);
this.ugridKpiTargetList.Clear();
this.ugridKpiTargetList.DataSource = ds.Tables[0];
this.ugridKpiTargetList.DataBind();
lblRowCount.Text = (ugridKpiTargetList.Rows.Count).ToString();
//MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Result();
DataTable dtBscThresholdCode = bizBscKpiResult.SelectKpiResultYear_BscThresholdCode().Tables[0];
dtTH = dtBscThresholdCode;
}
protected void iBtnUpdate_Click(object sender, EventArgs e)
{
//setUpdate();
DataTable dtResult = new DataTable();
dtResult.Columns.Add("ESTTERM_REF_ID");
dtResult.Columns.Add("KPI_REF_ID");
dtResult.Columns.Add("YMD");
dtResult.Columns.Add("RESULT_MS");
dtResult.Columns.Add("RESULT_TS");
dtResult.Columns.Add("APP_REF_ID");
dtResult.Columns.Add("CHECK_APPING_YN");
int iesttermRefId;
int ikpiRefId;
string iymd;
int itxrUser;
double iresultMs;
double iresultTs;
TemplatedColumn template;
CellItem cellItemObject;
Infragistics.WebUI.WebDataInput.WebNumericEdit inputTxt;
TemplatedColumn col_cBox;
CheckBox cBox;
foreach (Infragistics.WebUI.UltraWebGrid.UltraGridRow row in this.ugridKpiTargetList.Rows)
{
iesttermRefId = DataTypeUtility.GetToInt32(row.Cells.FromKey("estTermRefId").Value);
ikpiRefId = DataTypeUtility.GetToInt32(row.Cells.FromKey("kpiRefId").Value);
iymd = DataTypeUtility.GetValue(row.Cells.FromKey("estYmd").Value);
itxrUser = DataTypeUtility.GetToInt32(this.USERID);
template = (TemplatedColumn)row.Cells.FromKey("resultMs").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
inputTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtResultMs");
iresultMs = inputTxt.ValueDouble;
template = (TemplatedColumn)row.Cells.FromKey("resultTs").Column;
cellItemObject = (CellItem)template.CellItems[row.Index];
inputTxt = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtResultTs");
iresultTs = inputTxt.ValueDouble;
col_cBox = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
cBox = (CheckBox)((CellItem)col_cBox.CellItems[row.BandIndex]).FindControl("cBox");
string check_apping_yn = DataTypeUtility.GetBooleanToYN(cBox.Checked);
DataRow rowResult = dtResult.NewRow();
rowResult["ESTTERM_REF_ID"] = iesttermRefId;
rowResult["KPI_REF_ID"] = ikpiRefId;
rowResult["YMD"] = iymd;
rowResult["RESULT_MS"] = iresultMs;
rowResult["RESULT_TS"] = iresultTs;
rowResult["APP_REF_ID"] = iesttermRefId;
rowResult["CHECK_APPING_YN"] = check_apping_yn;
dtResult.Rows.Add(rowResult);
}
string pagePath = this.Page.Request.Url.AbsolutePath;
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result();
string returnVal = bizBscKpiResult.ModifyKpiResultDataBulker_DB(dtResult
, ""
, this.gUserInfo.Emp_Ref_ID
, DateTime.Now.ToString("yyyy-MM-dd"));
string msg = returnVal;
if (returnVal.Equals(string.Empty))
{
msg = "저장 되었습니다.";
}
ltrScript.Text = JSHelper.GetAlertScript(msg);
}
protected void UltraWebGrid1_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
string col_goal = "GOAL_MS";
string col_target = "TARGET_MS";
string col_result = "RESULT_MS";
string col_goal_dal = "GOAL_DAL_MS";
string col_target_dal = "TARGET_DAL_MS";
if (rdoMethod.SelectedIndex.Equals(1))
{
col_goal = "GOAL_TS";
col_target = "TARGET_TS";
col_result = "RESULT_TS";
col_goal_dal = "GOAL_DAL_TS";
col_target_dal = "TARGET_DAL_TS";
}
double goal_p = 0;
double target_p = 0;
double result = 0;
double goal_dal = 0;
double target_dal = 0;
DataRowView drw = (DataRowView)e.Data;
int kpi_ref_id = DataTypeUtility.GetToInt32(e.Row.Cells.FromKey("KPI_REF_ID").Value);
// 목표
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target_Goal bizBscKpiTargetGoal = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target_Goal();
DataTable dtBscKpiTargetGoal = bizBscKpiTargetGoal.GetBscKpiTargetGoalTong_DB(IEstTermRefID
, kpi_ref_id
, IYmd);
if (dtBscKpiTargetGoal.Rows.Count > 0)
{
goal_p = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTargetGoal.Rows[0][col_goal]).Replace("-", "0"));
goal_dal = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTargetGoal.Rows[0][col_goal_dal]).Replace("-", "0"));
}
// 실적
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result bizBscKpiResult = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Result();
DataTable dtBscKpiResult = bizBscKpiResult.GetBscKpiTargetGoalTong_DB(IEstTermRefID
, kpi_ref_id
, IYmd);
if (dtBscKpiResult.Rows.Count > 0)
{
result = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiResult.Rows[0][col_result]).Replace("-", "0"));
}
// 달성율
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target bizBscKpiTarget = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Target();
DataTable dtBscKpiTarget = bizBscKpiTarget.GetBscKpiTargetGoalTong_DB(IEstTermRefID
, kpi_ref_id
, IYmd);
if (dtBscKpiTarget.Rows.Count > 0)
{
target_p = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTarget.Rows[0][col_target]).Replace("-", "0"));
target_dal = DataTypeUtility.GetToDouble(DataTypeUtility.GetValue(dtBscKpiTarget.Rows[0][col_target_dal]).Replace("-", "0"));
}
e.Row.Cells.FromKey("GOAL_P").Value = goal_p;
e.Row.Cells.FromKey("TARGET_P").Value = target_p;
e.Row.Cells.FromKey("RESULT").Value = result;
e.Row.Cells.FromKey("GOAL_DAL").Value = goal_dal;
e.Row.Cells.FromKey("TARGET_DAL").Value = target_dal;
}
// 탬플릿을 이용한 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);
}
