Esempio n. 1
0
        private void gridToolBar_ButtonClicked(object sender, Infragistics.WebUI.UltraWebToolbar.ButtonEvent be)
        {
            if (!translationManager)
            {
                RepeaterItem item     = (RepeaterItem)((Infragistics.WebUI.UltraWebToolbar.UltraWebToolbar)sender).NamingContainer;
                DataGrid     costGrid = (DataGrid)item.FindControl("costGrid");
                switch (be.Button.Key)
                {
                case "Save":
                    Business.TRClass classe = Classes[item.ItemIndex];
                    if (costGrid != null)
                    {
                        foreach (DataGridItem rowItem in costGrid.Items)
                        {
                            int levelId = (int)((DataSet)datasources[item.ItemIndex]).Tables[0].Rows[rowItem.DataSetIndex].ItemArray[1];
                            for (int i = 1; i <= PeriodRange; i++)
                            {
                                Infragistics.WebUI.WebDataInput.WebNumericEdit numEdit = (Infragistics.WebUI.WebDataInput.WebNumericEdit)rowItem.Cells[i].Controls[0];
                                classe.SetPlanningValue(levelId, Shared.SessionState.User.Id, DateTime.UtcNow.AddMonths(i), Convert.ToInt32(numEdit.ValueInt));
                            }
                        }
                    }

                    break;
                }
                Calculate(costGrid);
            }
        }
 private void InicializarTextBox(Infragistics.WebUI.WebDataInput.WebNumericEdit tb, object valor)
 {
     if (tb.ClientID != this.webNumImpresiones.ClientID)
     {
         return;
     }
     tb.Value = Convert.ToInt32(valor);
 }
Esempio n. 3
0
 public void InstantiateIn(Control container)
 {
     if (Editable)
     {
         Infragistics.WebUI.WebDataInput.WebNumericEdit numEdit = new Infragistics.WebUI.WebDataInput.WebNumericEdit();
         numEdit.MinValue = 0;
         numEdit.Width    = new Unit("25px");
         numEdit.ClientSideEvents.ValueChange = "valueChangeInEdit";
         //      numEdit.ValueChange += new Infragistics.WebUI.WebDataInput.ValueChangeHandler(numEdit_ValueChange);
         numEdit.DataBinding += new EventHandler(onDataBinding);
         container.Controls.Add(numEdit);
     }
     else
     {
         Label num = new Label();
         num.DataBinding += new EventHandler(onDataBinding);
         container.Controls.Add(num);
     }
 }
Esempio n. 4
0
    protected void ugridKpiTargetList_InitializeRow(object sender, RowEventArgs e)
    {
        UltraWebGrid grid = (UltraWebGrid)sender;
        DataRowView  view = (DataRowView)e.Data;

        TemplatedColumn template;
        CellItem        cellItemObject;
        int             userRefId = ((MicroBSC.RolesBasedAthentication.SiteIdentity) this.User.Identity).Emp_Ref_ID;

        // RESULT_MS의 값을 세팅
        template       = (TemplatedColumn)e.Row.Cells.FromKey("resultMs").Column;
        cellItemObject = (CellItem)template.CellItems[e.Row.Index];

        Infragistics.WebUI.WebDataInput.WebNumericEdit txtMs = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtResultMs");
        txtMs.Value = view["RESULT_MS"].ToString();

        // RESULT_TS의 값을 세팅
        template       = (TemplatedColumn)e.Row.Cells.FromKey("resultTs").Column;
        cellItemObject = (CellItem)template.CellItems[e.Row.Index];

        Infragistics.WebUI.WebDataInput.WebNumericEdit txtTs = (Infragistics.WebUI.WebDataInput.WebNumericEdit)cellItemObject.FindControl("txtResultTs");
        txtTs.Value = view["RESULT_TS"].ToString();

        if (userRefId.ToString().Equals(view["CHAMPION_EMP_ID"].ToString()) == false)
        {
            //txtMs.Enabled = false;
            //txtTs.Enabled = false;
        }

        TemplatedColumn col_cBox = (TemplatedColumn)(e.Row.Cells.FromKey("selchk").Column);
        CheckBox        cBox     = (CheckBox)((CellItem)col_cBox.CellItems[e.Row.BandIndex]).FindControl("cBox");


        int app_ref_id = DataTypeUtility.GetToInt32(e.Row.Cells.FromKey("APP_REF_ID").Value);

        if (!app_ref_id.Equals(0))
        {
            cBox.Enabled = false;
        }
    }
Esempio n. 5
0
    protected void UltraWebGrid1_InitializeRow(object sender, RowEventArgs e)
    {
        string status_id       = DataTypeUtility.GetString(e.Row.Cells.FromKey("STATUS_ID").Value);
        string status_img_path = DataTypeUtility.GetString(e.Row.Cells.FromKey("STATUS_IMG_PATH").Value);
        string imgTag          = string.Format("<img src=\"{0}\" alt={1}>", status_img_path, status_id);

        e.Row.Cells.FromKey("STATUS_IMG").Value = imgTag;


        string popup_path = "";

        if (EST_TGT_TYPE.Equals("TGT"))
        {
            popup_path = "EST110500M1.ASPX";
        }
        else if (EST_TGT_TYPE.Equals("EST"))
        {
            popup_path = "EST110500M2.ASPX";
        }
        e.Row.Cells.FromKey("POPUP_PATH").Value = popup_path;



        if (EST_TGT_TYPE.Equals("EST"))
        {
            if (ESTTERM_STEP_ID == 2)
            {
                string    est_emp_id     = DataTypeUtility.GetString(e.Row.Cells.FromKey("EST_EMP_ID").Value);
                string    tgt_emp_id     = DataTypeUtility.GetString(e.Row.Cells.FromKey("TGT_EMP_ID").Value);
                string    filter         = string.Format("EST_EMP_ID={0} AND TGT_EMP_ID={1}", est_emp_id, tgt_emp_id);
                DataTable dt_q_sbj_point = DataTypeUtility.FilterSortDataTable(DT_QUESTION_SBJ_POINT, filter);

                if (dt_q_sbj_point.Rows.Count > 0)
                {
                    DataTable dt_groupBy_q_dfn = DataTypeUtility.GetGroupByDataTable(dt_q_sbj_point, "POINT", new string[] { "Q_DFN_ID" }, "POINT");

                    if (dt_groupBy_q_dfn.Rows.Count > 0)
                    {
                        double total_sum = 0;
                        for (int i = 0; i < dt_groupBy_q_dfn.Rows.Count; i++)
                        {
                            string q_dfn_id  = DataTypeUtility.GetString(dt_groupBy_q_dfn.Rows[i]["Q_DFN_ID"]);
                            double avg_point = DataTypeUtility.GetToDouble(dt_groupBy_q_dfn.Rows[i]["AVG_POINT"]);

                            e.Row.Cells.FromKey(q_dfn_id).Value = Math.Round(avg_point, 1);

                            total_sum += avg_point;
                        }

                        double total_avg = total_sum / dt_groupBy_q_dfn.Rows.Count;

                        e.Row.Cells.FromKey("Q_SBJ_POINT_AVG").Value = Math.Round(total_avg, 1);
                    }
                }
            }
            else if (ESTTERM_STEP_ID == 3)
            {
                if (DT_EST_DATA_1ST == null)
                {
                    int est_emp_id;
                    if (IS_ADMIN)
                    {
                        est_emp_id = 0;
                    }
                    else
                    {
                        est_emp_id = gUserInfo.Emp_Ref_ID;
                    }

                    Biz_Datas est_data = new Biz_Datas();
                    DT_EST_DATA_1ST = est_data.GetEstData(COMP_ID
                                                          , EST_ID
                                                          , ESTTERM_REF_ID
                                                          , ESTTERM_SUB_ID
                                                          , 2
                                                          , 0
                                                          , est_emp_id
                                                          , 0
                                                          , 0).Tables[0];//1차 평가 데이터
                }

                string    tgt_emp_id = DataTypeUtility.GetString(e.Row.Cells.FromKey("TGT_EMP_ID").Value);
                string    filter     = string.Format("TGT_EMP_ID={0}", tgt_emp_id);
                DataTable dt_filtered_est_data_1st = DataTypeUtility.FilterSortDataTable(DT_EST_DATA_1ST, filter);

                if (dt_filtered_est_data_1st.Rows.Count > 0)
                {
                    string est_dept_id_1st    = DataTypeUtility.GetString(dt_filtered_est_data_1st.Rows[0]["EST_DEPT_ID"]);
                    string est_emp_id_1st     = DataTypeUtility.GetString(dt_filtered_est_data_1st.Rows[0]["EST_EMP_ID"]);
                    double point_org_1st      = DataTypeUtility.GetToDouble(dt_filtered_est_data_1st.Rows[0]["POINT_ORG"]);
                    double point_ctrl_org_1st = DataTypeUtility.GetToDouble(dt_filtered_est_data_1st.Rows[0]["POINT_CTRL_ORG"]);



                    double point_org      = DataTypeUtility.GetToDouble(e.Row.Cells.FromKey("POINT_ORG").Value);
                    double point_ctrl_org = DataTypeUtility.GetToDouble(e.Row.Cells.FromKey("POINT_CTRL_ORG").Value);
                    double point_balance;

                    if (point_ctrl_org == 0)
                    {
                        point_org = point_ctrl_org_1st;
                        e.Row.Cells.FromKey("POINT_ORG").Value = point_org;

                        point_balance = 0;
                    }
                    else
                    {
                        point_balance = point_ctrl_org - point_org;
                    }



                    TemplatedColumn tc = (TemplatedColumn)UltraWebGrid1.Columns.FromKey("POINT_BALANCE");
                    Infragistics.WebUI.WebDataInput.WebNumericEdit ne = (Infragistics.WebUI.WebDataInput.WebNumericEdit)((CellItem)tc.CellItems[e.Row.Index]).FindControl("POINT_BALANCE");
                    ne.Value = point_balance;

                    e.Row.Cells.FromKey("EST_DEPT_ID_1ST").Value    = est_dept_id_1st;
                    e.Row.Cells.FromKey("EST_EMP_ID_1ST").Value     = est_emp_id_1st;
                    e.Row.Cells.FromKey("POINT_ORG_1ST").Value      = point_org_1st;
                    e.Row.Cells.FromKey("POINT_CTRL_ORG_1ST").Value = point_ctrl_org_1st;
                }
            }
        }
    }
Esempio n. 6
0
    protected bool saveEstQ()
    {
        Biz_Est_Data bizEstData = new Biz_Est_Data();
        DataTable    dt         = DT_EST_DATA.Clone();

        int balance_plus_cnt  = 0;
        int balance_minus_cnt = 0;

        for (int i = 0; i < UltraWebGrid1.Rows.Count; i++)
        {
            DataRow dr       = dt.NewRow();
            DataRow dr_final = dt.NewRow();


            string comp_id         = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("COMP_ID").Value);
            string est_id          = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("EST_ID").Value);
            string estterm_ref_id  = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("ESTTERM_REF_ID").Value);
            string estterm_sub_id  = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("ESTTERM_SUB_ID").Value);
            string estterm_step_id = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("ESTTERM_STEP_ID").Value);
            string est_dept_id     = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("EST_DEPT_ID").Value);
            string est_emp_id      = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("EST_EMP_ID").Value);
            string tgt_dept_id     = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("TGT_DEPT_ID").Value);
            string tgt_emp_id      = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("TGT_EMP_ID").Value);
            string status_id       = DataTypeUtility.GetString(UltraWebGrid1.Rows[i].Cells.FromKey("STATUS_ID").Value);
            double point_org       = DataTypeUtility.GetToDouble(UltraWebGrid1.Rows[i].Cells.FromKey("POINT_ORG").Value);



            string filter = "COMP_ID='{0}' AND EST_ID='{1}' AND ESTTERM_REF_ID='{2}' AND ESTTERM_SUB_ID='{3}' AND ESTTERM_STEP_ID='{4}' AND EST_DEPT_ID='{5}' AND EST_EMP_ID='{6}' AND TGT_DEPT_ID='{7}' AND TGT_EMP_ID='{8}'";
            filter = string.Format(filter, comp_id, est_id, estterm_ref_id, estterm_sub_id, estterm_step_id, est_dept_id, est_emp_id, tgt_dept_id, tgt_emp_id);
            DataTable dt_tmp = DataTypeUtility.FilterSortDataTable(DT_EST_DATA, filter);
            if (dt_tmp.Rows.Count == 1)
            {
                for (int j = 0; j < dt_tmp.Columns.Count; j++)
                {
                    dr_final[j] = dt_tmp.Rows[0][j];
                }
            }
            else
            {
                this.ltrScript.Text = JSHelper.GetAlertScript("평가데이터에 오류가 있습니다.");
                return(false);
            }



            Biz_Status new_status = bizEstData.Get_New_Est_Status(DataTypeUtility.GetToInt32(comp_id), est_id, status_id, 6, 5);
            if (new_status.Status_ID == null && new_status.Status_ID.Trim().Length > 0)
            {
                this.ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0} 단계로 진행할 수 없는 데이터가 있습니다.", new_status.Status_Name));
                return(false);
            }


            TemplatedColumn tc = (TemplatedColumn)UltraWebGrid1.Columns.FromKey("POINT_BALANCE");
            Infragistics.WebUI.WebDataInput.WebNumericEdit ne = (Infragistics.WebUI.WebDataInput.WebNumericEdit)((CellItem)tc.CellItems[i]).FindControl("POINT_BALANCE");
            double point_balance = DataTypeUtility.GetToDouble(ne.Value);

            if (point_balance > 0)
            {
                balance_plus_cnt++;
            }
            else if (point_balance < 0)
            {
                balance_minus_cnt++;
            }

            double point_ctrl_org = point_org + point_balance;
            double point          = point_ctrl_org * 100 / 5;//환산점수



            dr["COMP_ID"]         = comp_id;
            dr["EST_ID"]          = est_id;
            dr["ESTTERM_REF_ID"]  = estterm_ref_id;
            dr["ESTTERM_SUB_ID"]  = estterm_sub_id;
            dr["ESTTERM_STEP_ID"] = estterm_step_id;
            dr["EST_DEPT_ID"]     = est_dept_id;
            dr["EST_EMP_ID"]      = est_emp_id;
            dr["TGT_DEPT_ID"]     = tgt_dept_id;
            dr["TGT_EMP_ID"]      = tgt_emp_id;
            dr["POINT"]           = point;
            dr["POINT_ORG"]       = point_org;
            dr["POINT_AVG"]       = -1;
            dr["POINT_STD"]       = -1;
            dr["POINT_CTRL_ORG"]  = point_ctrl_org;
            dr["STATUS_ID"]       = new_status.Status_ID;



            dr_final["COMP_ID"]         = comp_id;
            dr_final["EST_ID"]          = est_id;
            dr_final["ESTTERM_REF_ID"]  = estterm_ref_id;
            dr_final["ESTTERM_SUB_ID"]  = estterm_sub_id;
            dr_final["ESTTERM_STEP_ID"] = "1";
            dr_final["EST_DEPT_ID"]     = est_dept_id;
            dr_final["EST_EMP_ID"]      = est_emp_id;
            dr_final["TGT_DEPT_ID"]     = tgt_dept_id;
            dr_final["TGT_EMP_ID"]      = tgt_emp_id;
            dr_final["POINT"]           = point;
            dr_final["POINT_ORG"]       = point_org;
            dr_final["POINT_AVG"]       = -1;
            dr_final["POINT_STD"]       = -1;
            dr_final["POINT_CTRL_ORG"]  = point_ctrl_org;
            dr_final["STATUS_ID"]       = new_status.Status_ID;


            dt.Rows.Add(dr);
            dt.Rows.Add(dr_final);
        }

        int balance_limit = DT_EST_DATA.Rows.Count / 10;

        if (balance_plus_cnt > balance_limit || balance_minus_cnt > balance_limit)
        {
            this.ltrScript.Text = JSHelper.GetAlertScript("점수조정 가능인원을 초과하였습니다.");
            return(false);
        }

        int result = bizEstData.ModifyEstData_Point(dt, gUserInfo.Emp_Ref_ID);

        return(result > 0 ? true : false);
    }
Esempio n. 7
0
    protected bool doSave()
    {
        bool   result      = false;
        double total_point = 0;
        int    count       = 0;

        DataTable dtSaveQuestiondata = new DataTable();

        dtSaveQuestiondata.Columns.Add("COMP_ID");
        dtSaveQuestiondata.Columns.Add("EST_ID");
        dtSaveQuestiondata.Columns.Add("ESTTERM_REF_ID");
        dtSaveQuestiondata.Columns.Add("ESTTERM_SUB_ID");
        dtSaveQuestiondata.Columns.Add("ESTTERM_STEP_ID");
        dtSaveQuestiondata.Columns.Add("EST_DEPT_ID");
        dtSaveQuestiondata.Columns.Add("EST_EMP_ID");
        dtSaveQuestiondata.Columns.Add("TGT_DEPT_ID");
        dtSaveQuestiondata.Columns.Add("TGT_EMP_ID");
        dtSaveQuestiondata.Columns.Add("Q_OBJ_ID");
        dtSaveQuestiondata.Columns.Add("Q_SBJ_ID");
        dtSaveQuestiondata.Columns.Add("Q_ITM_ID");
        dtSaveQuestiondata.Columns.Add("Q_DFN_ID");
        dtSaveQuestiondata.Columns.Add("POINT");
        dtSaveQuestiondata.Columns.Add("GRADE_ID");
        dtSaveQuestiondata.Columns.Add("TEXT_VALUE");
        dtSaveQuestiondata.Columns.Add("OPINION");
        dtSaveQuestiondata.Columns.Add("ATTACH_NO");
        dtSaveQuestiondata.Columns.Add("USER");

        for (int i = 0; i < ugrdEstQuestion.Rows.Count; i++)
        {
            TemplatedColumn tc = (TemplatedColumn)ugrdEstQuestion.Rows.Band.Columns.FromKey("Q_FIRST");
            Infragistics.WebUI.WebDataInput.WebNumericEdit ne = (Infragistics.WebUI.WebDataInput.WebNumericEdit)((CellItem)tc.CellItems[i]).FindControl("Q_FIRST");
            double point = DataTypeUtility.GetToDouble(ne.Value);

            if (point > 0)
            {
                DataRow dr = dtSaveQuestiondata.NewRow();

                string q_obj_id = Q_OBJ_ID;
                string q_sbj_id = DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_SBJ_ID").Value);
                string q_dfn_id = DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_DFN_ID").Value);


                dr["COMP_ID"]         = COMP_ID;
                dr["EST_ID"]          = EST_ID;
                dr["ESTTERM_REF_ID"]  = ESTTERM_REF_ID;
                dr["ESTTERM_SUB_ID"]  = ESTTERM_SUB_ID;
                dr["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID;
                dr["EST_DEPT_ID"]     = EST_DEPT_ID;
                dr["EST_EMP_ID"]      = EST_EMP_ID;
                dr["TGT_DEPT_ID"]     = TGT_DEPT_ID;
                dr["TGT_EMP_ID"]      = TGT_EMP_ID;
                dr["Q_OBJ_ID"]        = q_obj_id;
                dr["Q_SBJ_ID"]        = q_sbj_id;
                dr["Q_DFN_ID"]        = q_dfn_id;
                dr["USER"]            = EMP_REF_ID;



                //Biz_QuestionItems questionItems = new Biz_QuestionItems();
                //DataTable dt_item = questionItems.GetQuestionItem("", q_sbj_id, Q_OBJ_ID).Tables[0];
                //string filter = string.Format("POINT={0}", point);
                //DataTable dt_item_filtered = DataTypeUtility.FilterSortDataTable(dt_item, filter);
                //dr["Q_ITM_ID"] = DataTypeUtility.GetString(dt_item_filtered.Rows[0]["Q_ITM_ID"]);
                dr["Q_ITM_ID"] = DBNull.Value;



                dr["POINT"] = Math.Round(point, 1);



                //가중치
                DataTable dt_est_question_filtered = DataTypeUtility.FilterSortDataTable(DT_EST_QUESTION, string.Format("Q_SBJ_ID='{0}'", q_sbj_id));
                int       weight = DataTypeUtility.GetToInt32(dt_est_question_filtered.Rows[0]["WEIGHT"]);

                total_point += point * weight / 100;


                //count += new MicroBSC.Integration.EST.Biz.Biz_Est_Question_Data().Insert("1", "3N", ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID
                //        , EST_DEPT_ID, EST_EMP_ID, TGT_DEPT_ID, TGT_EMP_ID
                //        , DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_OBJ_ID").Value)
                //        , DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_SBJ_ID").Value)
                //        , DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_ITM_ID").Value)
                //        , point, EMP_REF_ID);

                dtSaveQuestiondata.Rows.Add(dr);
                count++;
            }
            else
            {
                count = 0;
                break;
            }
        }

        if (count > 0)
        {
            MicroBSC.Estimation.Biz.Biz_QuestionDatas questionDatas = new MicroBSC.Estimation.Biz.Biz_QuestionDatas();
            Biz_Est_Data bizEstData = new Biz_Est_Data();


            Biz_Status bizStatus = bizEstData.Get_New_Est_Status(COMP_ID, EST_ID, STATUS_ID, 4, 1);

            if (bizStatus.Status_ID != null && bizStatus.Status_ID.Trim().Length > 0)
            {
                DataTable dtSaveEstData = AddNewEstDataRow();

                double point_org = Math.Round(total_point, 1);
                dtSaveEstData.Rows[0]["POINT_ORG"]      = point_org;
                dtSaveEstData.Rows[0]["POINT_CTRL_ORG"] = point_org;
                dtSaveEstData.Rows[0]["POINT"]          = point_org * 100 / 5;//환산점수
                dtSaveEstData.Rows[0]["STATUS_ID"]      = bizStatus.Status_ID;

                result = questionDatas.SaveQuestionData(dtSaveQuestiondata, dtSaveEstData, gUserInfo.Emp_Ref_ID);
            }
            else
            {
                this.ltrScript.Text = JSHelper.GetAlertScript(string.Format("{0} 단계로 진행할 수 없습니다.", bizStatus.Status_Name));
            }
        }

        return(result);
    }
Esempio n. 8
0
    protected void ugrdEstQuestion_InitializeRow(object sender, RowEventArgs e)
    {
        string q_sbj_id = DataTypeUtility.GetString(e.Row.Cells.FromKey("Q_SBJ_ID").Value);


        //자기평가 결과
        //DataTable ItemDt = new MicroBSC.Integration.EST.Biz.Biz_Est_Question_Data().SelectEstQuestionDataSelfPoint(Q_OBJ_ID, q_sbj_id);


        Biz_QuestionDatas questionDatas = new Biz_QuestionDatas(COMP_ID
                                                                , EST_ID
                                                                , ESTTERM_REF_ID
                                                                , ESTTERM_SUB_ID
                                                                , ESTTERM_STEP_ID
                                                                , TGT_DEPT_ID
                                                                , TGT_EMP_ID
                                                                , TGT_DEPT_ID
                                                                , TGT_EMP_ID
                                                                , q_sbj_id);


        Biz_QuestionItems questionItems = new Biz_QuestionItems();
        DataTable         ItemDt        = questionItems.GetQuestionItem(questionDatas.Q_Itm_ID, q_sbj_id, Q_OBJ_ID).Tables[0];


        UltraGridCell uc = e.Row.Cells.FromKey("Q_ITEM_NAME_SELF");

        uc.Value = ItemDt.Rows[0]["Q_ITEM_NAME"].ToString();

        UltraGridCell ugItemNo = e.Row.Cells.FromKey("Q_ITM_ID");

        ugItemNo.Value = ItemDt.Rows[0]["Q_ITM_ID"].ToString();

        UltraGridCell ugobjId = e.Row.Cells.FromKey("Q_OBJ_ID");

        ugobjId.Value = ItemDt.Rows[0]["Q_OBJ_ID"].ToString();


        //다면평가 결과
        DataTable dtPoint = new MicroBSC.Integration.EST.Biz.Biz_Est_Question_Data().SelectEstQuestionDataSelfPointResultPoint(
            ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID, Q_OBJ_ID, TGT_EMP_ID, "3O");


        int    count = 0;
        double sum   = 0;

        for (int i = 0; i < dtPoint.Rows.Count; i++)
        {
            if (dtPoint.Rows[i]["Q_SBJ_ID"].ToString().Equals(q_sbj_id))
            {
                UltraGridCell ugc = e.Row.Cells.FromKey((dtPoint.Rows[i]["EST_EMP_ID"].ToString()));
                ugc.Value = dtPoint.Rows[i]["POINT"].ToString();
                sum      += double.Parse(dtPoint.Rows[i]["POINT"].ToString());
                count++;
            }
        }

        //다면평가 평균
        UltraGridCell ugAv = e.Row.Cells.FromKey("Q_AVERAGE");

        if (count == 0)
        {
            ugAv.Value = "-";
        }
        else
        {
            ugAv.Value = Math.Round(sum / count, 2);
        }


        //1차 평가 결과
        questionDatas = new Biz_QuestionDatas(COMP_ID
                                              , EST_ID
                                              , ESTTERM_REF_ID
                                              , ESTTERM_SUB_ID
                                              , ESTTERM_STEP_ID
                                              , EST_DEPT_ID
                                              , EST_EMP_ID
                                              , TGT_DEPT_ID
                                              , TGT_EMP_ID
                                              , q_sbj_id);

        TemplatedColumn tc = (TemplatedColumn)e.Row.Band.Columns.FromKey("Q_FIRST");

        Infragistics.WebUI.WebDataInput.WebNumericEdit ne = (Infragistics.WebUI.WebDataInput.WebNumericEdit)((CellItem)tc.CellItems[e.Row.Index]).FindControl("Q_FIRST");
        ne.Value = DataTypeUtility.GetToDouble(questionDatas.Point);

        if (STATUS_ID.Equals("E"))
        {
            ne.ReadOnly = true;
        }
    }