public void SetMyKpiList()
{
Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight();
DataSet rDs = objBSC.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), gUserInfo.Emp_Ref_ID);
ugrdChildKpi.Clear();
ugrdChildKpi.DataSource = rDs;
ugrdChildKpi.DataBind();
}
public void SetMyKpiList()
{
Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight();
DataSet rDs = objBSC.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), gUserInfo.Emp_Ref_ID);
ugrdChildKpi.Clear();
ugrdChildKpi.DataSource = rDs;
ugrdChildKpi.DataBind();
object[,] objRtn = objBSC.GetMboApprovalState(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), gUserInfo.Emp_Ref_ID);
if (objRtn != null)
{
switch (objRtn[0, 0].ToString())
{
case "": // 결재상태 없음
addKpi.Visible = remKpi.Visible = udtKpi.Visible = true;
break;
case Biz_Type.app_status_nodraft: // 결재상태 없음
addKpi.Visible = remKpi.Visible = udtKpi.Visible = true;
break;
case Biz_Type.app_status_draft: // 상신
addKpi.Visible = remKpi.Visible = udtKpi.Visible = false;
break;
case Biz_Type.app_status_ondraft: // 결재중
addKpi.Visible = remKpi.Visible = udtKpi.Visible = false;
break;
case Biz_Type.app_status_return: // 반려
addKpi.Visible = remKpi.Visible = udtKpi.Visible = true;
break;
case Biz_Type.app_status_recall: // 결재회수
addKpi.Visible = remKpi.Visible = udtKpi.Visible = true;
break;
case Biz_Type.app_status_onmodify: // 수정결재
addKpi.Visible = remKpi.Visible = udtKpi.Visible = true;
break;
case Biz_Type.app_status_complete: // 결재완료
addKpi.Visible = remKpi.Visible = udtKpi.Visible = false;
break;
default:
addKpi.Visible = remKpi.Visible = udtKpi.Visible = false;
break;
}
}
lblRowCount.Text = " " + ugrdChildKpi.Rows.Count.ToString() + " ";
}
private void DoBinding()
{
if (ddlEstTerm.Items.Count < 1)
{
ltrScript.Text = JSHelper.GetAlertScript("등록된 평가기간이 없습니다.");
return;
}
//가중치
Biz_Bsc_Mbo_Kpi_Weight objBSC_weight = new Biz_Bsc_Mbo_Kpi_Weight();
DT_KPI_WEIGHT = objBSC_weight.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTerm), gUserInfo.Emp_Ref_ID).Tables[0];
//월별 실적
Biz_Bsc_Kpi_Info objBSC = new Biz_Bsc_Kpi_Info();
DataSet dsMonthlyTarget = objBSC.GetMBOForWeight(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
, txtKpiCodeRight.Text.Trim()
, txtKpiNameRight.Text.Trim()
, txtChampionNameRight.Text.Trim()
, (ddlComDeptRight.SelectedItem.Value == "" ? 0 : PageUtility.GetIntByValueDropDownList(ddlComDeptRight))
, PageUtility.GetByValueDropDownList(ddlKpiGroup)
, ""//MBO_TYPE
, PageUtility.GetIntByValueDropDownList(ddlKpiCategoryTop)
, PageUtility.GetIntByValueDropDownList(ddlKpiCategoryMid)
, PageUtility.GetIntByValueDropDownList(ddlKpiCategoryLow)
, gUserInfo.Emp_Ref_ID
, User.IsInRole(ROLE_ADMIN));
//KPI목록
DataSet ds = objBSC.GetMBOForDeptKpi(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
, txtKpiCodeRight.Text.Trim()
, txtKpiNameRight.Text.Trim()
, txtChampionNameRight.Text.Trim()
, PageUtility.GetByValueDropDownList(ddlKpiGroup)
, (ddlComDeptRight.SelectedItem.Value == "" ? 0 : PageUtility.GetIntByValueDropDownList(ddlComDeptRight))
, PageUtility.GetIntByValueDropDownList(ddlKpiCategoryTop)
, PageUtility.GetIntByValueDropDownList(ddlKpiCategoryMid)
, PageUtility.GetIntByValueDropDownList(ddlKpiCategoryLow)
, gUserInfo.Emp_Ref_ID
, (User.IsInRole(ROLE_ADMIN) == true ? 1 : 0)
, this.IDEPT_ID);
DataTable dt = addMonthlyTarget(dsMonthlyTarget.Tables[0], ds.Tables[0]);
ugrdMBO.Clear();
ugrdMBO.DataSource = dt;
ugrdMBO.DataBind();
int cntApprovalStatus = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["USE_YN"].ToString().Equals("Y"))
{
if (ds.Tables[0].Rows[i]["APPROVAL_STATUS"].ToString().Equals("N"))
{
cntApprovalStatus++;
}
}
}
if (cntApprovalStatus == 0)
{
DRAFT_BTN_VISIBLE = true;
}
else
{
DRAFT_BTN_VISIBLE = false;
}
double weight = 0;
double tmp;
for (int i = 0; i < ugrdMBO.Rows.Count; i++)
{
tmp = DataTypeUtility.GetToDouble(ugrdMBO.Rows[i].Cells.FromKey("WEIGHT").Value);
if (DataTypeUtility.GetString(ugrdMBO.Rows[i].Cells.FromKey("USE_YN").Value).Equals("N"))
{
continue;
}
if (tmp == (double)0)
{
weight = 0;
break;
}
weight += DataTypeUtility.GetToDouble(ugrdMBO.Rows[i].Cells.FromKey("WEIGHT").Value);
}
if (weight != (double)100)
{
DRAFT_BTN_VISIBLE = false;
}
if (ds.Tables[0].Rows.Count == 0)
{
iBtnDraft.Visible = iBtnMoDraft.Visible = iBtnReDraft.Visible = iBtnReWrite.Visible = iBtnReqModify.Visible = false;
}
this.lblRowCnt.Text = ugrdMBO.Rows.Count.ToString();
DataTable dtWeightApproval = objBSC.GetMBOForWeight_Approval(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
, gUserInfo.Emp_Ref_ID).Tables[0];
if (dtWeightApproval.Rows.Count == 0)
{
this.IAPP_STATUS = "";
this.IAPP_REF_ID = "0";
}
else
{
this.IAPP_STATUS = dtWeightApproval.Rows[0]["APP_STATUS"].ToString();
this.IAPP_REF_ID = dtWeightApproval.Rows[0]["APP_REF_ID"].ToString();
}
string strImg = (this.IAPP_STATUS == "") ? "" : this.IAPP_STATUS;
imgApprovalStatus.Src = Biz_Com_Approval_Info.GetAppImageUrl(strImg);
imgApprovalStatus.Alt = Biz_Com_Approval_Info.GetAppImageText(strImg);
if (IAPP_STATUS.Length > 0)
{
this.strApprovalStatus.Text = DataTypeUtility.GetString(dtWeightApproval.Rows[0]["APP_STATUS_NAME"]);
}
switch (this.IAPP_STATUS)
{
case "": // 결재상태 없음
iBtnDraft.Visible = DRAFT_BTN_VISIBLE;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReWrite.Visible = false;
iBtnReqModify.Visible = false;
break;
case Biz_Type.app_status_nodraft: // 결재상태 없음
iBtnDraft.Visible = DRAFT_BTN_VISIBLE;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReWrite.Visible = false;
iBtnReqModify.Visible = false;
break;
case Biz_Type.app_status_draft: // 상신
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReWrite.Visible = false;
iBtnReqModify.Visible = false;
imgApprovalStatus.Src = "../images/draft/sta_dft.gif";
setVisibleForDraft(false);
break;
case Biz_Type.app_status_ondraft: // 결재중
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReWrite.Visible = false;
iBtnReqModify.Visible = false;
imgApprovalStatus.Src = "../images/draft/sta_oft.gif";
setVisibleForDraft(false);
break;
case Biz_Type.app_status_return: // 반려
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = DRAFT_BTN_VISIBLE;
iBtnReWrite.Visible = false;
iBtnReqModify.Visible = false;
imgApprovalStatus.Src = "../images/draft/sta_rft.gif";
setVisibleForDraft(true);
break;
case Biz_Type.app_status_recall: // 결재회수
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReWrite.Visible = DRAFT_BTN_VISIBLE;
iBtnReqModify.Visible = false;
imgApprovalStatus.Src = "../images/draft/sta_aft.gif";
setVisibleForDraft(true);
break;
case Biz_Type.app_status_onmodify: // 수정결재
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = DRAFT_BTN_VISIBLE;
iBtnReDraft.Visible = false;
iBtnReWrite.Visible = false;
iBtnReqModify.Visible = false;
imgApprovalStatus.Src = "../images/draft/sta_mft.gif";
setVisibleForDraft(true);
break;
case Biz_Type.app_status_complete: // 결재완료
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReWrite.Visible = false;
iBtnReqModify.Visible = DRAFT_BTN_VISIBLE;
iBtnReqModify.Visible = true;
imgApprovalStatus.Src = "../images/draft/sta_cft.gif";
setVisibleForDraft(false);
break;
default:
iBtnDraft.Visible = false;
iBtnMoDraft.Visible = false;
iBtnReDraft.Visible = false;
iBtnReqModify.Visible = false;
iBtnReWrite.Visible = false;
break;
}
}