Exemplo n.º 1
0
    protected void ibtnSave_Click(object sender, ImageClickEventArgs e)
    {
        TreeNodeCollection treeNodeCol = treeEmp.CheckedNodes;

        DataTable insertDT = new DataTable();

        insertDT.Columns.Add("EMP_REF_ID", typeof(int));

        foreach (TreeNode node in treeNodeCol)
        {
            if (node.ToolTip == "EMP")
            {
                DataRow insertDR = insertDT.NewRow();
                insertDR["EMP_REF_ID"] = DataTypeUtility.GetToInt32(node.Value);
                insertDT.Rows.Add(insertDR);
            }
        }

        Biz_BiasDatas bizBiasData = new Biz_BiasDatas();

        if (bizBiasData.InsertBiasGroupEmp(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, this.IBIAS_GRP_ID, insertDT, gUserInfo.Emp_Ref_ID))
        {
            DoBindingEmpTree(this.IBIAS_GRP_ID);
            DoBindingGroup();
            if (this.IBIAS_GRP_ID > 0)
            {
                DoBindingGroupSelect();
            }
            ltrScript.Text = JSHelper.GetAlertScript("설정하였습니다.");
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript("저장 실패!");
        }
    }
Exemplo n.º 2
0
    private void DoBinding()
    {
        Biz_BiasDatas bizBias = new Biz_BiasDatas();
        DataTable     dt      = bizBias.GetBiasGroup(this.ICOMP_ID, this.IEST_ID, "");

        ugrdGroup.DataSource = dt;
        ugrdGroup.DataBind();
    }
Exemplo n.º 3
0
    protected void ibtnConfirm_Click(object sender, ImageClickEventArgs e)
    {
        Biz_BiasDatas bizBiasData = new Biz_BiasDatas();

        if (bizBiasData.ConfirmBiasPoint(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, this.IESTTERM_SUB_ID, this.IESTTERM_STEP_ID, this.IBIAS_GRP_ID, gUserInfo.Emp_Ref_ID))
        {
            ltrScript.Text = JSHelper.GetAlertScript("정상적으로 Bias 조정점수를 확정하였습니다.");
            return;
        }
        ltrScript.Text = JSHelper.GetAlertScript("점수확정 실패!\\n" + bizBiasData.errMSG);
    }
Exemplo n.º 4
0
    protected void ibtnInsert_Click(object sender, ImageClickEventArgs e)
    {
        Biz_BiasDatas bizBiasData = new Biz_BiasDatas();

        if (bizBiasData.UpdateBiasPoint(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, this.IESTTERM_SUB_ID, this.IESTTERM_STEP_ID, this.IBIAS_GRP_ID, ddlPointType.SelectedItem.Value, gUserInfo.Emp_Ref_ID))
        {
            DoBindingData();
            ltrScript.Text = JSHelper.GetAlertScript("성공적으로 점수를 적용하였습니다.");
            return;
        }
        ltrScript.Text = JSHelper.GetAlertScript("점수적용 실패!\\n" + bizBiasData.errMSG);
    }
Exemplo n.º 5
0
    protected void ibtnExcel_Click(object sender, ImageClickEventArgs e)
    {
        Biz_BiasDatas bizBiasData = new Biz_BiasDatas();

        ugrdGroupEmpList.DataSource = bizBiasData.GetBiasGroupEmpList(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID);
        ugrdGroupEmpList.DataBind();

        ugrdEEP.ExcelStartRow = 4;
        ugrdEEP.ExportMode    = ExportMode.InBrowser;
        ugrdEEP.DownloadName  = "Bias Group List";
        ugrdEEP.WorksheetName = "Bias 그룹대상현황";
        ugrdEEP.Export(ugrdGroupEmpList);
    }
Exemplo n.º 6
0
    protected void ibnCalcBiasPoint_Click(object sender, ImageClickEventArgs e)
    {
        if (BiasYN == YesNo.Yes)
        {
            if (tdBiasDept.Visible && hdfEstDept.Value.Trim().Equals(""))
            {
                ltrScript.Text = JSHelper.GetAlertScript("Bias 조정을 위한 부서 범위를 선택하세요.");
                return;
            }

            Biz_BiasDatas biasData = new Biz_BiasDatas();
            bool          isOK     = false;

            isOK = biasData.SetBiasAvg(COMP_ID
                                       , EST_ID
                                       , ESTTERM_REF_ID
                                       , ESTTERM_SUB_ID
                                       , ESTTERM_STEP_ID
                                       , YEAR_YN
                                       , MERGE_YN
                                       , OwnerTypeMode
                                       , DEPT_VALUES
                                       , DateTime.Now
                                       , EMP_REF_ID);

            isOK = biasData.SetBiasSTDev(COMP_ID
                                         , EST_ID
                                         , ESTTERM_REF_ID
                                         , ESTTERM_SUB_ID
                                         , ESTTERM_STEP_ID
                                         , YEAR_YN
                                         , MERGE_YN
                                         , OwnerTypeMode
                                         , DEPT_VALUES
                                         , DateTime.Now
                                         , EMP_REF_ID);

            ltrScript.Text = JSHelper.GetAlertScript("정상적으로 Bias 조정점수를 계산하여 적용하였습니다.");

            BindChart(COMP_ID
                      , EST_ID
                      , ESTTERM_REF_ID
                      , ESTTERM_SUB_ID
                      , ESTTERM_STEP_ID
                      , GraphType
                      , DataType
                      , DEPT_VALUES);
        }
    }
Exemplo n.º 7
0
    private void DoBindingGroup()
    {
        //DropDownListCommom.BindEstTermSub(ddlEstTermSubID, this.ICOMP_ID, this.IEST_ID, "");
        //DropDownListCommom.BindEstTermStep(ddlEstTermStepID, this.ICOMP_ID, this.IEST_ID);

        //평가마감되었는지 확인
        Biz_TermInfos bizTermInfos = new Biz_TermInfos(this.IESTTERM_REF_ID);

        this.IIS_TERM_CLOSE = bizTermInfos.Yearly_Close_YN;

        Biz_BiasDatas bizBiasData = new Biz_BiasDatas();
        DataTable     dt          = bizBiasData.GetBiasGroupEmpCount(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, "Y");

        ugrdGroup.DataSource = dt;
        ugrdGroup.DataBind();
    }
Exemplo n.º 8
0
    private void DoBindingColumn()
    {
        Biz_BiasDatas bizBiasData = new Biz_BiasDatas();
        DataTable     dtColumns   = bizBiasData.GetBiasColumns(this.ICOMP_ID, this.IEST_ID, "", "");

        if (dtColumns.Rows.Count == 0)
        {
            if (bizBiasData.InsertInitBiasColumnData(this.ICOMP_ID, this.IEST_ID, gUserInfo.Emp_Ref_ID))
            {
                dtColumns = bizBiasData.GetBiasColumns(this.ICOMP_ID, this.IEST_ID, "", "");
            }
            else
            {
                return;
            }
        }
        ugrdColumn.DataSource = dtColumns;
        ugrdColumn.DataBind();
    }
Exemplo n.º 9
0
    /// <summary>
    /// Bias 점수 적용
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void ibnConfirmBias_Click(object sender, ImageClickEventArgs e)
    {
        if (tdBiasDept.Visible && hdfEstDept.Value.Trim().Equals(""))
        {
            ltrScript.Text = JSHelper.GetAlertScript("Bias 조정을 위한 부서 범위를 선택하세요.");
            return;
        }

        Biz_BiasDatas biasData = new Biz_BiasDatas();
        bool          isOK     = false;

        isOK = biasData.SetBiasType(COMP_ID
                                    , EST_ID
                                    , ESTTERM_REF_ID
                                    , ESTTERM_SUB_ID
                                    , 0
                                    , WebUtility.GetByValueDropDownList(ddlBiasTypeID)
                                    , DEPT_VALUES
                                    , DateTime.Now
                                    , EMP_REF_ID);

        if (isOK)
        {
            ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0}로 점수를 조정 확정 하였습니다.", WebUtility.GetByTextDropDownList(ddlBiasTypeID)));
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0}로 점수를 조정 처리 중 오류가 발생하였습니다.", WebUtility.GetByTextDropDownList(ddlBiasTypeID)));
        }

        BindChart(COMP_ID
                  , EST_ID
                  , ESTTERM_REF_ID
                  , ESTTERM_SUB_ID
                  , ESTTERM_STEP_ID
                  , GraphType
                  , DataType
                  , DEPT_VALUES);
    }
Exemplo n.º 10
0
    private void DoBindingData()
    {
        this.IESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID);
        if (MERGE_YN.Equals("Y"))
        {
            this.IESTTERM_STEP_ID = BizUtility.GetEstTermStepIDByMergeYN(COMP_ID);
        }
        else
        {
            this.IESTTERM_STEP_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermStepID);
        }

        Biz_BiasDatas bizBiasData = new Biz_BiasDatas();
        DataTable     dtBiasData  = bizBiasData.GetBiasData(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, this.IESTTERM_SUB_ID, this.IESTTERM_STEP_ID, this.IBIAS_GRP_ID);

        ugrdBias.DataSource = dtBiasData;
        ugrdBias.DataBind();

        if (ugrdBias.Rows.Count == 0)
        {
            ddlPointType.Visible = ibtnInsert.Visible = ibtnDownload.Visible = false;//ibtnConfirm.Visible =
        }
        else
        {
            //평가마감되었는지 확인
            BizUtility.SetButtonVisibleByEstJobID(this.IEST_JOB_IDS
                                                  , ibtnCalc
                                                  , this.ICOMP_ID
                                                  , this.IEST_ID
                                                  , this.IESTTERM_REF_ID
                                                  , this.IESTTERM_SUB_ID
                                                  , this.IESTTERM_STEP_ID);
            ibtnInsert.Visible   = ddlPointType.Visible = ibtnCalc.Visible;//ibtnConfirm.Visible =
            ibtnDownload.Visible = true;
        }
        lblRowCount.Text = ugrdBias.Rows.Count.ToString();
    }
Exemplo n.º 11
0
    protected void iBtnSave_Click(object sender, ImageClickEventArgs e)
    {
        Biz_BiasDatas bizBiasData = new Biz_BiasDatas();

        if (bizBiasData.UpdateBiasColumn(this.ICOMP_ID
                                         , this.IEST_ID
                                         , this.ISEQ
                                         , rblVISIBLE_YN.SelectedItem.Value
                                         , DataTypeUtility.GetToInt32(txtCOL_ORDER.Text.Trim())
                                         , txtCOL_KEY.Text.Trim()
                                         , txtCOL_NAME.Text.Trim()
                                         , txtCOL_DESC.Text.Trim()
                                         , ddlTYPE.SelectedItem.Value
                                         , DataTypeUtility.GetToInt32(txtCOL_WIDTH.Text.Trim())
                                         , ddlALIGN.SelectedItem.Value
                                         , ddlDATATYPE.SelectedItem.Value
                                         , txtPROC_NAME.Text.Trim()
                                         , ddlPROCTYPE.SelectedItem.Value
                                         , rblUSE_YN.SelectedItem.Value
                                         , gUserInfo.Emp_Ref_ID))
        {
            DoBindingColumn();
            for (int i = 0; i < ugrdColumn.Rows.Count; i++)
            {
                if (ugrdColumn.Rows[i].Cells.FromKey("SEQ").Value.ToString() == this.ISEQ.ToString())
                {
                    ugrdColumn.Rows[i].Selected = true;
                }
            }
            ltrScript.Text = JSHelper.GetAlertScript("저장하였습니다.");
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript("저장 실패!");
        }
    }
Exemplo n.º 12
0
    private void DoBindingEmpTree(int bias_grp_id)
    {
        Biz_BiasDatas bizBiasData = new Biz_BiasDatas();

        WebCommon.FillBiasEmpOrg(treeEmp, this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, bias_grp_id);
    }
Exemplo n.º 13
0
    protected void ibtnCalc_Click(object sender, ImageClickEventArgs e)
    {
        string selectQuery = string.Empty;
        string joinQuery   = string.Empty;

        Biz_BiasDatas bizBiasData = new Biz_BiasDatas();
        DataTable     dtPointType = bizBiasData.GetBiasColumns(this.ICOMP_ID, this.IEST_ID, "Y", "Y");

        if (dtPointType.Rows.Count > 0)
        {
            DataRow[] drPointType = dtPointType.Select("COL_TYPE = 'USERKEY'", "COL_ORDER ASC");
            foreach (DataRow dr in drPointType)
            {
                selectQuery += @"
        , " + dr["COL_KEY"].ToString() + ".RTNVALUE AS " + dr["COL_KEY"].ToString();
                joinQuery   += @"
LEFT OUTER JOIN " + dr["PROC_NAME"].ToString() + "(@COMP_ID, @EST_ID, @ESTTERM_REF_ID, @ESTTERM_SUB_ID, @ESTTERM_STEP_ID, @BIAS_GRP_ID)  " + dr["COL_KEY"].ToString()
                               + "          ON  " + dr["COL_KEY"].ToString() + ".TGT_EMP_ID = A.EMP_REF_ID";
            }
        }

        DataTable dtBiasData = bizBiasData.CalcBiasData(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, this.IESTTERM_SUB_ID, this.IESTTERM_STEP_ID, this.IBIAS_GRP_ID, selectQuery, joinQuery);

        ugrdBias.DataSource = dtBiasData;
        ugrdBias.DataBind();


        DoSortColumn();

        if (ugrdBias.Rows.Count == 0)
        {
            ibtnInsert.Visible = false;//ibtnConfirm.Visible =
            ltrScript.Text     = JSHelper.GetAlertScript("계산된 데이터가 없습니다.");
        }
        else
        {
            DataTable dtBank = new DataTable();

            string strUserColumnName = string.Empty;
            for (int i = 1; i < 11; i++)
            {
                if (ugrdBias.Columns.FromKey("COL" + i.ToString()) != null)
                {
                    strUserColumnName += "COL" + i.ToString() + ";";
                }
            }

            string[] strUserColumn = { "TGT_DEPT_ID", "TGT_EMP_ID", "TGT_POS_CLS_ID", "TGT_POS_DUT_ID", "TGT_POS_GRP_ID", "TGT_POS_RNK_ID", "", "", "", "", "", "", "", "", "", "" };
            if (strUserColumnName != string.Empty)
            {
                strUserColumnName = strUserColumnName.Substring(0, strUserColumnName.Length - 1);
                for (int i = 0; i < strUserColumnName.Split(';').Length; i++)
                {
                    strUserColumn.SetValue(strUserColumnName.Split(';').GetValue(i).ToString(), 6 + i);
                }
            }


            int cntUserColumnName;
            if (strUserColumnName.Trim().Length == 0)
            {
                cntUserColumnName = 0;
            }
            else
            {
                cntUserColumnName = strUserColumnName.Split(';').Length;
            }


            string[] strFinalColumn = new string[6 + cntUserColumnName];
            for (int i = 0; i < strFinalColumn.Length; i++)
            {
                if (strUserColumn.GetValue(i).ToString() != "")
                {
                    strFinalColumn.SetValue(strUserColumn.GetValue(i).ToString(), i);
                    dtBank.Columns.Add(strUserColumn.GetValue(i).ToString(), (i < 2 ? typeof(int) : typeof(string)));
                }
            }

            //dtBank.Columns.Add("POINT", typeof(double));

            DataTable dtCalcData = UltraGridUtility.GetDataTableByAllValue(ugrdBias
                                                                           , strFinalColumn
                                                                           , dtBank);

            if (dtCalcData.Rows.Count > 0)
            {
                if (bizBiasData.InsertBiasData(this.ICOMP_ID, this.IEST_ID, this.IESTTERM_REF_ID, this.IESTTERM_SUB_ID, this.IESTTERM_STEP_ID, this.IBIAS_GRP_ID, dtCalcData, gUserInfo.Emp_Ref_ID))
                {
                    DoBindingData();
                    ltrScript.Text = JSHelper.GetAlertScript("정상적으로 Bias 조정점수 계산을 완료하였습니다.");
                }
                else
                {
                    ltrScript.Text = JSHelper.GetAlertScript("데이터 적용이 실패하였습니다.\\n" + bizBiasData.errMSG.Replace("\n", ""));
                }
            }
            else
            {
                ltrScript.Text = JSHelper.GetAlertScript("데이터 적용이 실패하였습니다.");
            }
        }
        lblRowCount.Text = ugrdBias.Rows.Count.ToString();
    }
Exemplo n.º 14
0
    private void DoInitColumn()
    {
        Biz_BiasDatas   bizBaisData = new Biz_BiasDatas();
        DataTable       dtColumn    = bizBaisData.GetBiasColumns(this.ICOMP_ID, this.IEST_ID, "Y", "Y");
        UltraGridColumn ucol        = null;

        foreach (DataRow dr in dtColumn.Rows)
        {
            ucol = new UltraGridColumn();

            ucol.Header.Caption = dr["COL_NAME"].ToString();
            ucol.Header.Style.HorizontalAlign = HorizontalAlign.Center;
            ucol.Header.Column.Key            = ucol.Header.Column.BaseColumnName = dr["COL_KEY"].ToString();
            ucol.Width    = Unit.Pixel(DataTypeUtility.GetToInt32(dr["COL_WIDTH"]));
            ucol.DataType = dr["DATA_TYPE"].ToString();
            if (dr["DATA_TYPE"].ToString() == "System.Double")
            {
                ucol.Format = "##,###,##0.00";
            }
            ucol.CellStyle.HorizontalAlign = GetAlignColumn(dr["COL_ALIGN"].ToString());
            this.ICOLUMN_SORT      += dr["COL_ALIGN"].ToString() + ";";
            this.ICOLUMN_DATA_TYPE += ucol.DataType + ";";
            this.ICOLUMN_FORMAT    += ucol.Format + ";";
            ugrdBias.Columns.Add(ucol);
        }
        if (dtColumn.Rows.Count > 0)
        {
            ucol = new UltraGridColumn();
            ucol.Header.Caption = "확정점수";
            ucol.Header.Style.HorizontalAlign = HorizontalAlign.Center;
            ucol.Header.Column.Key            = ucol.Header.Column.BaseColumnName = "POINT";
            ucol.Width    = Unit.Pixel(80);
            ucol.DataType = "System.Double";
            ucol.Format   = "##,###,##0.00";
            ucol.CellStyle.HorizontalAlign = GetAlignColumn("Right");
            this.ICOLUMN_SORT      += "Right";
            this.ICOLUMN_DATA_TYPE += "System.Double";
            this.ICOLUMN_FORMAT    += "##,###,##0.00";
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "COMP_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "EST_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "ESTTERM_REF_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "ESTTERM_SUB_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "ESTTERM_STEP_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "BIAS_GRP_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_DEPT_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_EMP_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_POS_CLS_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_POS_DUT_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_POS_GRP_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);

            ucol = new UltraGridColumn();
            ucol.Header.Column.BaseColumnName = ucol.Header.Column.Key = "TGT_POS_RNK_ID";
            ucol.Header.Column.Hidden         = true;
            ugrdBias.Columns.Add(ucol);
        }
    }
Exemplo n.º 15
0
    protected void Page_Load(object sender, EventArgs e)
    {
        YEAR_YN     = WebUtility.GetRequest("YEAR_YN", "N");
        MERGE_YN    = WebUtility.GetRequest("MERGE_YN", "N");
        EST_JOB_IDS = WebUtility.GetRequest("EST_JOB_IDS");

        //BizUtility.SetButtonVisibleCommandNameByRolID(EMP_REF_ID, ibnApplyBiasPoint);
        //BizUtility.SetButtonVisibleCommandNameByRolID(EMP_REF_ID, ibnCalcBiasPoint);

        if (!Page.IsPostBack)
        {
            this.IEST_ID      = WebUtility.GetRequest("EST_ID", "");
            this.IEST_JOB_IDS = WebUtility.GetRequest("EST_JOB_IDS", "");

            lblCalc1.Font.Size = lblCalc2.Font.Size = FontUnit.Point(8);
            DropDownListCommom.BindComp(ddlCompID, lblCompTitle);
            DropDownListCommom.BindEstTerm(ddlEstTermRefID);
            DropDownListCommom.BindDefaultValue(ddlEstTermSubID, "----------", "");
            DropDownListCommom.BindDefaultValue(ddlEstTermStepID, "----------", "");

            if (this.ICOMP_ID == 0)
            {
                this.ICOMP_ID = WebUtility.GetIntByValueDropDownList(ddlCompID);
            }

            if (this.IESTTERM_REF_ID == 0)
            {
                this.IESTTERM_REF_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermRefID);
            }

            DropDownListCommom.BindEstTermSub(ddlEstTermSubID, this.ICOMP_ID, this.IEST_ID, "");
            DropDownListCommom.BindEstTermStep(ddlEstTermStepID, this.ICOMP_ID, this.IEST_ID);

            if (this.IESTTERM_SUB_ID == 0)
            {
                this.IESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID);
            }

            if (this.IESTTERM_STEP_ID == 0)
            {
                this.IESTTERM_STEP_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermStepID);
            }

            if (MERGE_YN.Equals("Y"))
            {
                this.IESTTERM_STEP_ID = BizUtility.GetEstTermStepIDByMergeYN(COMP_ID);
            }
            else
            {
                if (ESTTERM_STEP_ALL_USE_YN.Equals("Y"))
                {
                    this.IESTTERM_STEP_ID = 0;
                }
                else
                {
                    this.IESTTERM_STEP_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermStepID);
                }
            }

            //평가마감되었는지 확인
            BizUtility.SetButtonVisibleByEstJobID(this.IEST_JOB_IDS
                                                  , ibtnCalc
                                                  , this.ICOMP_ID
                                                  , this.IEST_ID
                                                  , this.IESTTERM_REF_ID
                                                  , this.IESTTERM_SUB_ID
                                                  , this.IESTTERM_STEP_ID);
            ibtnInsert.Visible = ddlPointType.Visible = ibtnCalc.Visible;//ibtnConfirm.Visible =

            Biz_BiasDatas bizBiasData = new Biz_BiasDatas();
            DataTable     dtGroup     = bizBiasData.GetBiasGroup(this.ICOMP_ID, this.IEST_ID, "Y");
            ddlGroup.DataTextField  = "BIAS_GRP_NM";
            ddlGroup.DataValueField = "BIAS_GRP_ID";
            ddlGroup.DataSource     = dtGroup;
            ddlGroup.DataBind();
            ddlGroup.Width = Unit.Pixel(200);

            this.IBIAS_GRP_ID = WebUtility.GetIntByValueDropDownList(ddlGroup);

            DataTable dtPointType = bizBiasData.GetBiasColumns(this.ICOMP_ID, this.IEST_ID, "Y", "Y");
            if (dtPointType.Rows.Count > 0)
            {
                DataRow[] drPointType = dtPointType.Select("COL_TYPE = 'USERKEY' AND PROC_TYPE = 'Y'", "COL_ORDER ASC");
                foreach (DataRow dr in drPointType)
                {
                    ddlPointType.Items.Add(new ListItem(dr["COL_NAME"].ToString(), dr["COL_KEY"].ToString()));
                }
                if (ddlPointType.Items.Count > 0)
                {
                    ddlPointType.Items[0].Selected = true;
                }
            }

            if (!this.IEST_ID.Equals(""))
            {
                DoBindingData();
            }
            else
            {
                ibtnCalc.Visible = ddlPointType.Visible = ibtnInsert.Visible = ibtnDownload.Visible = false;//ibtnConfirm.Visible =
            }
            DoBindingBiasMethod();
        }

        if (YEAR_YN.Equals("Y"))
        {
            this.IESTTERM_SUB_ID = BizUtility.GetEstTermSubIDByYearYN(COMP_ID);
        }
        else
        {
            this.IESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID);
        }

        if (MERGE_YN.Equals("Y"))
        {
            this.IESTTERM_STEP_ID = BizUtility.GetEstTermStepIDByMergeYN(COMP_ID);
        }
        else
        {
            this.IESTTERM_STEP_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermStepID);
        }

        DoSortColumn();
        if (ddlPointType.Items.Count == 0)
        {
            ibtnInsert.Visible = ddlPointType.Visible = false;//ibtnConfirm.Visible =
        }
        ltrScript.Text = "";
    }