示例#1
0
    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;
        }
    }
示例#2
0
    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();
    }
示例#3
0
    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;
    }
示例#4
0
    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);
    }
示例#5
0
    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;
    }
示例#6
0
        // 탬플릿을 이용한 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);
        }