Example #1
0
    protected void ibnSearch_Click(object sender, ImageClickEventArgs e)
    {
        BindingData(COMP_ID
                    , EST_ID
                    , ESTTERM_REF_ID
                    , ESTTERM_SUB_ID
                    , ESTTERM_STEP_ID
                    , GraphType
                    , DataType);

        BizUtility.SetButtonVisibleCommandNameByRolID(EMP_REF_ID, tdImgBox.Controls);
        BizUtility.SetButtonVisibleByEstJobID(EST_JOB_IDS
                                              , tdImgBox.Controls
                                              , COMP_ID
                                              , EST_ID
                                              , ESTTERM_REF_ID
                                              , ESTTERM_SUB_ID
                                              , ESTTERM_STEP_ID);
    }
Example #2
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();
    }
Example #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        EST_JOB_IDS             = WebUtility.GetRequest("EST_JOB_IDS");
        EST_TGT_TYPE            = WebUtility.GetRequest("EST_TGT_TYPE", "EST");
        YEAR_YN                 = WebUtility.GetRequest("YEAR_YN", "N");
        MERGE_YN                = WebUtility.GetRequest("MERGE_YN", "N");
        DEPT_COLUMN_NO_USE_YN   = WebUtility.GetRequest("DEPT_COLUMN_NO_USE_YN", "N");
        ESTTERM_SUB_ALL_USE_YN  = WebUtility.GetRequest("ESTTERM_SUB_ALL_USE_YN", "N");
        ESTTERM_STEP_ALL_USE_YN = WebUtility.GetRequest("ESTTERM_STEP_ALL_USE_YN", "N");

        if (!Page.IsPostBack)
        {
            DropDownListCommom.BindComp(ddlCompID, lblCompTitle);
            DropDownListCommom.BindEstTerm(ddlEstTermRefID);
            DropDownListCommom.BindDefaultValue(ddlEstTermSubID, "----------", "");
            DropDownListCommom.BindDefaultValue(ddlEstTermStepID, "----------", "");

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

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

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

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

            ibnSearch.Attributes.Add("onclick", "return Search();");
            ibnConfirmEstQ.Attributes.Add("onclick", "return confirm('질의평가를 확정하시겠습니까?');");
            ibnAggEstTermStep.Attributes.Add("onclick", "return confirm('평가차수 간에 가중치를 반영하여 점수를 집계하시겠습니까?');");
            ibnGetPrjPoint.Attributes.Add("onclick", "return confirm('프로젝트 점수를 반영하시겠습니까?');");
            ibnProjectToEmpData.Attributes.Add("onclick", "return confirm('사원별 점수로 반영하시겠습니까?');");

            if (!WebUtility.GetRequest("EST_ID").Equals(""))
            {
                txtSearchEstName.Visible = false;
                imgEstButton.Visible     = false;
                ibnSearch.Visible        = false;

                hdfSearchEstID.Value = WebUtility.GetRequest("EST_ID");
                EST_ID = hdfSearchEstID.Value;

                GridBidingData(COMP_ID
                               , EST_ID
                               , ESTTERM_REF_ID
                               , ESTTERM_SUB_ID
                               , ESTTERM_STEP_ID
                               , EMP_REF_ID
                               , SEARCH_ALL);

                BizUtility.SetButtonVisibleCommandNameByRolID(EMP_REF_ID, tdImgBox.Controls);

                BizUtility.SetButtonVisibleByEstJobID(EST_JOB_IDS
                                                      , tdImgBox.Controls
                                                      , COMP_ID
                                                      , hdfSearchEstID.Value
                                                      , ESTTERM_REF_ID
                                                      , ESTTERM_SUB_ID
                                                      , ESTTERM_STEP_ID);

                SetConfirmStatusHtml(EST_JOB_IDS);
            }
        }

        COMP_ID        = WebUtility.GetIntByValueDropDownList(ddlCompID);
        EST_ID         = hdfSearchEstID.Value;
        ESTTERM_REF_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermRefID);

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

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

        ltrScript.Text = "";

        // 상태 html
        HtmlScriptCommon.CreateStatusHtmlTable(tblViewStatus, EST_ID);
    }
Example #4
0
    private void BindChart(int comp_id
                           , string est_id
                           , int estterm_ref_id
                           , int estterm_sub_id
                           , int estterm_step_id
                           , string graphType
                           , BiasType biasType
                           , string dept_values)
    {
        if (tdBiasDept.Visible && hdfEstDept.Value.Trim().Equals(""))
        {
            ltrScript.Text = JSHelper.GetAlertScript("Bias 조정을 위한 부서 범위를 선택하세요.");
            return;
        }

        Biz_Datas data  = new Biz_Datas();
        string    query = data.GetBiasQueryScript(comp_id
                                                  , est_id
                                                  , estterm_ref_id
                                                  , estterm_sub_id
                                                  , estterm_step_id
                                                  , biasType.ToString()
                                                  , dept_values);

        if (graphType.Equals("Radar"))
        {
            //try
            //{
            BindRadarChart(Chart1
                           , query
                           , biasType
                           , ChartImageType.Flash);
            //}
            //catch(Exception ex)
            //{
            //    ltrScript.Text = JSHelper.GetAlertScript("Bias할 수 있는 데이터가 아닙니다." + );
            //    return;
            //}
        }
        else if (graphType.Equals("LowHigh"))
        {
            //try
            //{
            BindRangeColumnChart(Chart1
                                 , query
                                 , biasType
                                 , ChartImageType.Flash);
            //}
            //catch(Exception ex)
            //{
            //    ltrScript.Text = JSHelper.GetAlertScript("Bias할 수 있는 데이터가 아닙니다.");
            //    return;
            //}
        }

        BizUtility.SetButtonVisibleByEstJobID(EST_JOB_IDS
                                              , ibnApplyBiasPoint
                                              , COMP_ID
                                              , EST_ID
                                              , ESTTERM_REF_ID
                                              , ESTTERM_SUB_ID
                                              , ESTTERM_STEP_ID);

        BizUtility.SetButtonVisibleByEstJobID(EST_JOB_IDS
                                              , ibnCalcBiasPoint
                                              , COMP_ID
                                              , EST_ID
                                              , ESTTERM_REF_ID
                                              , ESTTERM_SUB_ID
                                              , ESTTERM_STEP_ID);

        ddlBiasTypeID.Visible = ibnApplyBiasPoint.Visible;
    }
Example #5
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 = "";
    }