Exemple #1
0
    protected void doBind_prjEmp()
    {
        UltraWebGrid2.Clear();

        MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data();
        DT_EMP_EST_DATA = bizEstData.GetEstData(COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID, DIRECTION_TYPE, EST_EMP_ID, 0);



        MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data();
        string est_id = "3Q";//프로젝트 기여도 평가 EST_ID

        DT_PRJ_DATA = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID
                                                   , COMP_ID
                                                   , est_id
                                                   , ESTTERM_REF_ID
                                                   , ESTTERM_SUB_ID
                                                   , ESTTERM_STEP_ID);


        DataTable dtPrj_PM_Data = DataTypeUtility.FilterSortDataTable(DT_PRJ_DATA, "TGT_DEPT_ID=-1 AND TGT_EMP_ID=-1");
        object    point         = dtPrj_PM_Data.Rows[0]["POINT"];

        PRJ_POINT = DataTypeUtility.GetString(point);


        UltraWebGrid2.DataSource = DT_PRJ_DATA;
        UltraWebGrid2.DataBind();
    }
Exemple #2
0
    protected void ibnSearch_Click(object sender, ImageClickEventArgs e)
    {
        UltraWebGrid1.Clear();
        UltraWebGrid2.Clear();
        UltraWebGrid3.Clear();

        DoBinding_Dept();
    }
Exemple #3
0
    protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
    {
        UltraWebGrid2.Clear();

        string TGT_DEPT_ID = e.SelectedRows[0].Cells.FromKey("TGT_DEPT_ID").Value.ToString();

        DoBinding_Emp(TGT_DEPT_ID);
    }
Exemple #4
0
 private void Reload()
 {
     UltraWebGrid1.Clear();
     UltraWebGrid2.Clear();
     DataBindingUnitType();
     DataBindingUnit(hdfUnitGroup.Value);
     txtUnitGroup.Text = "";
 }
Exemple #5
0
    private void BindQuestionGrid()
    {
        Biz_QuestionEstMaps questionEstMaps = new Biz_QuestionEstMaps();

        UltraWebGrid1.Clear();
        UltraWebGrid2.Clear();

        UltraWebGrid1.DataSource = questionEstMaps.GetQuestionEstMap(EST_ID, "");
        UltraWebGrid1.DataBind();
    }
    private void DoBinding_InPower()
    {
        UltraWebGrid2.Clear();

        MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT();
        DataTable dtNHIT = bizNHIT.GetInPower(CR_YEAR);

        UltraWebGrid2.DataSource = dtNHIT;
        UltraWebGrid2.DataBind();
    }
Exemple #7
0
    protected void ibnEmp_Click(object sender, ImageClickEventArgs e)
    {
        int cnt = UltraWebGrid2.Rows.Count;

        string emp_ref_id_list = string.Empty;

        for (int i = 0; i < cnt; i++)
        {
            UltraGridRow row = UltraWebGrid2.Rows[i];

            TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
            CheckBox        cBox   = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox");

            if (cBox.Checked)
            {
                emp_ref_id_list += "," + DataTypeUtility.GetValue(row.Cells.FromKey("EMP_REF_ID").Value);
            }
        }

        DataTable dtEmp = new DataTable();

        if (emp_ref_id_list.Length > 0)
        {
            emp_ref_id_list = emp_ref_id_list.Remove(0, 1);
            dtEmp           = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" EMP_REF_ID  IN ({0})  ", emp_ref_id_list));
        }

        DataTable dtDelEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" DEPT_REF_ID  IN ({0})  ", DEPT_REF_ID));


        MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp BizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp();

        string okMsg = BizMulEstEmp.AddEstEmp(dtDelEmp
                                              , dtEmp
                                              , COMP_ID
                                              , EST_ID
                                              , ESTTERM_REF_ID
                                              , ESTTERM_SUB_ID
                                              , rdoEstTypeList.SelectedValue
                                              , DateTime.Now
                                              , this.gUserInfo.Emp_Ref_ID);

        if (okMsg.Length == 0)
        {
            ltrScript.Text = JSHelper.GetAlertScript("정상 처리 되었습니다.", false);

            DoBinding_Dept();
            DEPT_REF_ID = -1;
            UltraWebGrid2.Clear();
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript(okMsg);
        }
    }
Exemple #8
0
    private void DoBinding_Emp(string TGT_DEPT_ID)
    {
        UltraWebGrid2.Clear();

        Biz_Mul_Est_Data bizMulEstData = new Biz_Mul_Est_Data();

        DataTable DT = bizMulEstData.Get_Est_Status_By_Emp(hdfEstID.Value, ESTTERM_REF_ID.ToString(), ESTTERM_SUB_ID.ToString(), TGT_DEPT_ID);

        UltraWebGrid2.DataSource = DT;
        UltraWebGrid2.DataBind();
    }
Exemple #9
0
    protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
    {
        UltraWebGrid2.Clear();
        UltraWebGrid2.Bands[0].ResetColumns();

        PRJ_ID = e.SelectedRows[0].Cells.FromKey("PROJECTID").Value.ToString();

        Project_Detail_Bind();
        Custom_Col_Bind();
        Soosik_Bind();
    }
Exemple #10
0
    protected void iBtnSearch_Click(object sender, ImageClickEventArgs e)
    {
        UltraWebGrid1.Clear();
        UltraWebGrid2.Clear();
        UltraWebGrid2.Bands[0].ResetColumns();
        UltraWebGrid3.Clear();

        this.TxtBox_Soosik.Text = "";

        Project_Bind();
    }
Exemple #11
0
    protected void ibnSearchAll_Click(object sender, ImageClickEventArgs e)
    {
        EST_EMP_ID = 0;

        BindingPosBizByTgt();
        BindingTgtEmp(EST_EMP_ID);

        hdfTgtEmpID.Value    = "";
        hdfTgtPosKndID.Value = "";

        UltraWebGrid2.Clear();
    }
    private void DoBinding_Emp(string cr_year, string cr_month, string project_name)
    {
        UltraWebGrid2.Clear();

        MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT();
        DataTable dtNHIT = bizNHIT.GetEmpProjectDetail(cr_year
                                                       , cr_month
                                                       , project_name);

        UltraWebGrid2.DataSource = dtNHIT;
        UltraWebGrid2.DataBind();

        lblEmpTotal.Text = string.Format("(Total : {0})", dtNHIT.Rows.Count);
    }
Exemple #13
0
    private void GridBinding2(int comp_id, int estterm_ref_id, string est_id)
    {
        Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails();

        _dtEstScale = deptEstDetail.GetDeptEstDetail(comp_id, estterm_ref_id, 0, est_id).Tables[0];

        Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales();

        _dtPosScale = deptPosScale.GetDeptPosScale(comp_id, estterm_ref_id, 0, est_id).Tables[0];

        UltraWebGrid2.Clear();
        UltraWebGrid2.DataSource = BizUtility.GetDeptTree("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
        UltraWebGrid2.DataBind();
    }
    private void SetGrid2()
    {
        UltraWebGrid2.Clear();

        MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score bizObj = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score();

        DataTable dtObj = bizObj.GetOrgRankBonbuDesc(IEstTermRefID, IYmd, "4", "TS", 5);

        if (dtObj.Rows.Count > 0)
        {
            UltraWebGrid2.DataSource = dtObj;
            UltraWebGrid2.DataBind();
        }
    }
Exemple #15
0
    protected void doBind_project()
    {
        UltraWebGrid1.Clear();
        UltraWebGrid2.Clear();

        string est_id = "3Q";

        MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data();
        DT_ENDED_PRJ = bizPrjData.Get_Ended_Prj_Est(COMP_ID, est_id, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID);

        this.lblRowCount.Text = DT_ENDED_PRJ.Rows.Count.ToString();

        UltraWebGrid1.DataSource = DT_ENDED_PRJ;
        UltraWebGrid1.DataBind();
    }
Exemple #16
0
    protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
    {
        UltraWebGrid2.Clear();
        UltraWebGrid3.Clear();

        if (e.SelectedRows.Count > 0)
        {
            string dept_name = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("DEPT_NAME").Value);

            lblTitleDept.Text = string.Format("({0})", dept_name);

            DEPT_REF_ID = DataTypeUtility.GetToInt32(e.SelectedRows[0].Cells.FromKey("DEPT_REF_ID").Value);
            DoBinding_Emp(DEPT_REF_ID);
        }
    }
Exemple #17
0
    protected void ibnDelPool_Click(object sender, ImageClickEventArgs e)
    {
        UltraWebGrid2.Clear();
        UltraWebGrid3.Clear();

        if (doDelete_Est_Target_Pool())
        {
            this.ltrScript.Text = JSHelper.GetAlertScript("삭제하였습니다.");
        }
        else
        {
            this.ltrScript.Text = JSHelper.GetAlertScript("실패했습니다.");
        }

        DoBinding_Dept();
    }
Exemple #18
0
    protected void ibnSavePool_Click(object sender, ImageClickEventArgs e)
    {
        if (doSave_Est_Target_Pool())
        {
            this.ltrScript.Text = JSHelper.GetAlertScript("저장하였습니다.");
        }
        else
        {
            this.ltrScript.Text = JSHelper.GetAlertScript("실패했습니다.");
        }

        UltraWebGrid1.Clear();
        UltraWebGrid2.Clear();
        UltraWebGrid3.Clear();

        DoBinding_Dept();
    }
Exemple #19
0
    public void DoBindingTempleteMap(int templete_code)
    {
        UltraWebGrid2.Clear();

        MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool bizBscKpiPool = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool();

        DataTable dtBscKpiPool = bizBscKpiPool.GetKpiPool_DB(""
                                                             , ""
                                                             , ""
                                                             , 0
                                                             , templete_code);

        UltraWebGrid2.DataSource = dtBscKpiPool;
        UltraWebGrid2.DataBind();

        //lblRowCount.Text = dtBscKpiPool.Rows.Count.ToString();
    }
Exemple #20
0
    private void BindQuestionDeptEmpMapGrid()
    {
        Biz_QuestionDeptEmpMaps questionDeptEmpMaps = new Biz_QuestionDeptEmpMaps();

        UltraWebGrid2.Clear();
        DataSet ds = null;

        if (OwnerTypeMode == OwnerType.Emp_User)
        {
            pnlDept.Visible = false;
            pnlEmp.Visible  = true;

            ds = questionDeptEmpMaps.GetQuestionEmpMapping(COMP_ID
                                                           , ESTTERM_REF_ID
                                                           , ESTTERM_SUB_ID
                                                           , ESTTERM_STEP_ID
                                                           , EST_ID
                                                           , Q_OBJ_ID
                                                           , 0
                                                           , 0
                                                           , OwnerType.Emp_User);
        }
        else if (OwnerTypeMode == OwnerType.Dept)
        {
            pnlDept.Visible = true;
            pnlEmp.Visible  = false;

            ds = questionDeptEmpMaps.GetQuestionDeptMapping(COMP_ID
                                                            , ESTTERM_REF_ID
                                                            , ESTTERM_SUB_ID
                                                            , ESTTERM_STEP_ID
                                                            , EST_ID
                                                            , Q_OBJ_ID
                                                            , 0);

            hdfEstDept.Value = WebUtility.GetValueForSplit(ds.Tables[0]
                                                           , "TGT_DEPT_ID"
                                                           , ",");
        }

        UltraWebGrid2.DataSource = ds;
        UltraWebGrid2.DataBind();
    }
Exemple #21
0
    protected void ibnSave_Click(object sender, ImageClickEventArgs e)
    {
        if (TGT_EMP_ID.Equals(""))
        {
            ltrScript.Text = JSHelper.GetAlertScript("선택된 피평가자가 없습니다.");
            return;
        }

        Biz_EmpPositionBizMaps empPosBizMap = new Biz_EmpPositionBizMaps();
        DataTable dataTable = empPosBizMap.GetDataTableSchema();

        dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid2
                                                              , "cBox"
                                                              , "selchk"
                                                              , new string[] { "POS_BIZ_ID" }
                                                              , dataTable);

        foreach (DataRow dataRow in dataTable.Rows)
        {
            dataRow["EMP_REF_ID"] = TGT_EMP_ID;
            dataRow["DATE"]       = DateTime.Now;
            dataRow["USER"]       = EMP_REF_ID;
        }

        bool isOK = empPosBizMap.SavePosBizMap(dataTable, TGT_EMP_ID);

        if (isOK)
        {
            BindingPosBizByTgt();
            BindingEmp();

            hdfTgtEmpID.Value    = "";
            hdfTgtPosKndID.Value = "";
            UltraWebGrid2.Clear();

            ltrScript.Text = JSHelper.GetAlertScript("정상적으로 직무설정 되었습니다.");
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다.");
        }
    }
Exemple #22
0
    protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e)
    {
        if (e.SelectedRows.Count > 0)
        {
            hdfTgtEmpID.Value = e.SelectedRows[0].Cells.FromKey("EMP_REF_ID").Value.ToString();

            if (e.SelectedRows[0].Cells.FromKey("POS_KND_ID").Value == null)
            {
                ltrScript.Text = JSHelper.GetAlertScript("선택된 사원의 직종이 없습니다.");
                BindingPosBizByTgt();
                BindingEmp();
                hdfTgtEmpID.Value    = "";
                hdfTgtPosKndID.Value = "";
                UltraWebGrid2.Clear();
                return;
            }

            hdfTgtPosKndID.Value = e.SelectedRows[0].Cells.FromKey("POS_KND_ID").Value.ToString();

            BindingPosBizByTgt();
            BindingPosBiz(hdfTgtPosKndID.Value);
        }
    }
Exemple #23
0
    private void DoBinding_Dept()
    {
        DEPT_REF_ID = -1;
        UltraWebGrid1.Clear();
        UltraWebGrid2.Clear();

        MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map bizEmpEstTargetMaps = new MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map();
        //MicroBSC.Estimation.Biz.Biz_EmpEstTargetMaps bizEmpEstTargetMaps = new Biz_EmpEstTargetMaps();

        DT_ESTTARGETMAP = bizEmpEstTargetMaps.GetEmpEstTargetMap(COMP_ID
                                                                 , EST_ID
                                                                 , ESTTERM_REF_ID
                                                                 , ESTTERM_SUB_ID
                                                                 , ConESTTERM_STEP_ID
                                                                 , 0
                                                                 , 0
                                                                 , 0
                                                                 , 0).Tables[0];

        DataRow[] rows = DT_ESTTARGETMAP.Select(string.Format(" DIRECTION_TYPE = '{0}' ", ConDIRECTION_TYPE));

        if (rows.Length > 0)
        {
            ibnDeptAdd.Visible = false;
            ibnDeptDel.Visible = false;
            ibnEmp.Visible     = false;
        }
        else
        {
            ibnDeptAdd.Visible = true;
            ibnDeptDel.Visible = true;
            ibnEmp.Visible     = true;
        }

        MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp bizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp();

        DataTable dtMulEstEmp = bizMulEstEmp.GetDeptMapping_DB(COMP_ID
                                                               , EST_ID
                                                               , ESTTERM_REF_ID
                                                               , ESTTERM_SUB_ID);

        UltraWebGrid1.DataSource = dtMulEstEmp;
        UltraWebGrid1.DataBind();

        if (dtMulEstEmp.Rows.Count > 0)
        {
            ibnDeptAdd.Enabled = true;
            ibnDeptDel.Enabled = true;
        }
        else
        {
            ibnDeptAdd.Enabled = false;
            ibnDeptDel.Enabled = false;
        }

        // 평가자 목록 (EST_TYPE : EST)
        DT_ESTEMP = bizMulEstEmp.GetEstEmp_DB(COMP_ID
                                              , EST_ID
                                              , ESTTERM_REF_ID
                                              , ESTTERM_SUB_ID
                                              , 0
                                              , "");

        //// 피평가자 목록 (EST_TYPE : TGT)
        //DT_TGTEMP = bizMulEstEmp.GetEstEmp_DB(COMP_ID
        //                                     , EST_ID
        //                                     , ESTTERM_REF_ID
        //                                     , ESTTERM_SUB_ID
        //                                     , 0
        //                                     , "TGT");

        MicroBSC.Integration.COM.Biz.Biz_Rel_Dept_Emp bizRelDeptEmp = new MicroBSC.Integration.COM.Biz.Biz_Rel_Dept_Emp();

        DT_DEPTEMP = bizRelDeptEmp.GetRelDeptEmp_DB(0
                                                    , COMP_ID
                                                    , EST_ID
                                                    , ESTTERM_REF_ID
                                                    , ESTTERM_SUB_ID);
    }
Exemple #24
0
    private void DoBinding_Dept()
    {
        MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data();
        DT_EST_DATA = bizEstData.GetEstData(COMP_ID
                                            , EST_ID
                                            , ESTTERM_REF_ID
                                            , ESTTERM_SUB_ID
                                            , ConESTTERM_STEP_ID
                                            , ConDIRECTION_TYPE);


        DEPT_REF_ID = -1;
        UltraWebGrid1.Clear();
        UltraWebGrid2.Clear();
        UltraWebGrid3.Clear();

        MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map bizEmpEstTargetMaps = new MicroBSC.Integration.EST.Biz.Biz_Est_Emp_Est_Target_Map();
        DT_ESTTARGETMAP = bizEmpEstTargetMaps.GetEmpEstTargetMap(COMP_ID
                                                                 , EST_ID
                                                                 , ESTTERM_REF_ID
                                                                 , ESTTERM_SUB_ID
                                                                 , ConESTTERM_STEP_ID
                                                                 , 0
                                                                 , 0
                                                                 , 0
                                                                 , 0).Tables[0];

        string[] groupBy = { "TGT_DEPT_ID"
                             , "TGT_DEPT_NAME"
                             , "TGT_EMP_ID"
                             , "TGT_EMP_NAME"
                             , "TGT_POS_CLS_ID"
                             , "TGT_POS_CLS_NAME"
                             , "TGT_POS_DUT_ID"
                             , "TGT_POS_DUT_NAME"
                             , "TGT_POS_GRP_ID"
                             , "TGT_POS_GRP_NAME"
                             , "TGT_POS_RNK_ID"
                             , "TGT_POS_RNK_NAME"
                             , "TGT_POS_KND_ID"
                             , "TGT_POS_KND_NAME"
                             , "DIRECTION_TYPE" };

        DataTable dtEst = DT_ESTTARGETMAP.Copy();
        DataTable dtTgt = DT_ESTTARGETMAP.Copy();

        DT_ESTTARGETMAP_GROUPBYEST = DataTypeUtility.GetGroupByDataTable(dtEst, groupBy);

        DT_ESTTARGETMAP_GROUPBYTGT = DataTypeUtility.GetGroupByDataTable(dtTgt, new string[] { "EST_DEPT_ID", "EST_EMP_ID", "DIRECTION_TYPE" });



        MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp bizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp();
        DataTable dtMulEstEmp = bizMulEstEmp.GetDeptMapping_DB(COMP_ID
                                                               , EST_ID
                                                               , ESTTERM_REF_ID
                                                               , ESTTERM_SUB_ID);



        // 평가자 목록 (EST_TYPE : EST)

        /*
         * DT_ESTEMP = bizMulEstEmp.GetEstEmp_DB(COMP_ID
         *                                   , EST_ID
         *                                   , ESTTERM_REF_ID
         *                                   , ESTTERM_SUB_ID
         *                                   , 0
         *                                   , "");
         */
        MicroBSC.Integration.COM.Biz.Biz_Rel_Dept_Emp bizRelDeptEmp = new MicroBSC.Integration.COM.Biz.Biz_Rel_Dept_Emp();
        DT_DEPTEMP = bizRelDeptEmp.GetRelDeptEmp_DB(0
                                                    , COMP_ID
                                                    , EST_ID
                                                    , ESTTERM_REF_ID
                                                    , ESTTERM_SUB_ID);

        DT_DEPTEMP.Columns.Add("TGT_DEPT_ID");
        DT_DEPTEMP.Columns.Add("TGT_EMP_ID");
        DT_DEPTEMP.Columns.Add("TGT_EMP_NAME");
        DT_DEPTEMP.Columns.Add("TGT_CLASS_CODE");
        DT_DEPTEMP.Columns.Add("TGT_CLS_NAME");
        DT_DEPTEMP.Columns.Add("TGT_GRP_CODE");
        DT_DEPTEMP.Columns.Add("TGT_GRP_NAME");
        DT_DEPTEMP.Columns.Add("TGT_RANK_CODE");
        DT_DEPTEMP.Columns.Add("TGT_RANK_NAME");
        DT_DEPTEMP.Columns.Add("TGT_DUTY_CODE");
        DT_DEPTEMP.Columns.Add("TGT_DUT_NAME");
        DT_DEPTEMP.Columns.Add("TGT_KIND_CODE");
        DT_DEPTEMP.Columns.Add("TGT_KND_NAME");



        //랜덤 지정/해제 버튼 보이기 상태
        setRndButtonVisible();



        //매핑 확정/취소 버튼 보이기상태
        if (CheckPossiblityCancelConfirm())
        {
            ibnAddEstData.Visible = true;
            ibnDelEstData.Visible = true;
        }
        else
        {
            ibnAddEstData.Visible = false;
            ibnDelEstData.Visible = false;
        }



        //바인드
        UltraWebGrid1.DataSource = dtMulEstEmp;
        UltraWebGrid1.DataBind();

        if (dtMulEstEmp.Rows.Count > 0)
        {
            ibnRandom.Enabled    = true;
            ibnDelRandom.Enabled = true;
        }
        else
        {
            ibnRandom.Enabled    = false;
            ibnDelRandom.Enabled = false;
        }
    }
Exemple #25
0
    protected void ibnPMS_IF_Click(object sender, EventArgs e)
    {
        int  Pms_Com_Info_Idx = 1;
        bool Result;

        object start_date = prj_sDate.Value;
        object end_date   = prj_eDate.Value;


        DataTable dtPrj_ID = bizPmsInfo.Get_Vw_ProjectID((DateTime)start_date, (DateTime)end_date);

        dtPrj_ID = DataTypeUtility.FilterSortDataTable(dtPrj_ID, " STATUS_ID IS NULL");


        Result = bizPmsColInfo.Sync_Col_Info(Pms_Com_Info_Idx, dtPrj_ID, gUserInfo.Emp_Ref_ID.ToString());
        if (Result)
        {
            /*
             * for (int i = 0; i < dtPrj_ID.Rows.Count; i++)
             * {
             *  string prj_id = dtPrj_ID.Rows[i]["PROJECTID"].ToString();
             *
             *  DataTable dtColList = bizPmsColInfo.Get_Col_Info_List(prj_id);
             *  System.Text.StringBuilder colList = new StringBuilder();
             *  for (int j = 0; j < dtColList.Rows.Count; j++)
             *  {
             *      if (colList.Length > 0)
             *          colList.Append(", ");
             *      colList.Append(dtColList.Rows[j]["PRJ_COL_ID"].ToString());
             *  }
             *  Result = bizPmsInfo.Add_Project_Info_To_Pms((DateTime)start_date, (DateTime)end_date, prj_id, colList.ToString());
             *
             *  if (!Result)
             *      break;
             * }
             */


            DataTable dtComInfo    = bizPmsComInfo.Get_Pms_Com_Info(Pms_Com_Info_Idx);
            string    srcIF_COL_ID = dtComInfo.Rows[0]["IF_COL_ID"].ToString();
            string    tgtIF_COL_ID = "";
            string    tmpIF_COL_ID;
            string[]  arrIF_COL_ID = bizPmsColInfo.Remove_Escape_Blank_Char(srcIF_COL_ID).Split(',');
            for (int i = 0; i < arrIF_COL_ID.Length; i++)
            {
                string col_type = bizPmsColInfo.Proc_Col_Type(arrIF_COL_ID[i]);
                if (col_type.Equals("B"))
                {
                    tmpIF_COL_ID = arrIF_COL_ID[i];
                }
                else
                {
                    tmpIF_COL_ID = arrIF_COL_ID[i].Substring(0, arrIF_COL_ID[i].IndexOf("("));
                }

                if (tgtIF_COL_ID.Length > 0)
                {
                    tgtIF_COL_ID += ", ";
                }
                tgtIF_COL_ID += tmpIF_COL_ID;
            }

            string prj_id_list = "";
            for (int i = 0; i < dtPrj_ID.Rows.Count; i++)
            {
                if (prj_id_list.Length > 0)
                {
                    prj_id_list += ", ";
                }
                prj_id_list += "'" + dtPrj_ID.Rows[i]["PROJECTID"].ToString() + "'";
            }
            Result = bizPmsInfo.Add_Project_Info_To_Pms((DateTime)start_date, (DateTime)end_date, prj_id_list, tgtIF_COL_ID);
        }



        if (Result)
        {
            this.ltrScript.Text = JSHelper.GetAlertScript("저장되었습니다.");
        }
        else
        {
            this.ltrScript.Text = JSHelper.GetAlertScript("저장에 실패하였습니다.");
        }


        UltraWebGrid1.Clear();
        UltraWebGrid2.Clear();
        UltraWebGrid2.Bands[0].ResetColumns();
        UltraWebGrid3.Clear();

        this.TxtBox_Soosik.Text = "";

        Project_Bind();
    }