Beispiel #1
0
    private void DoBinding_EstEmp()
    {
        DataTable DT = bizMulEstTargetPool.Get_MulEstEmp_List(COMP_ID, EMP_REF_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID);

        UltraWebGrid3.DataSource = DT;
        UltraWebGrid3.DataBind();
    }
Beispiel #2
0
    private void DoBinding_EST(int est_emp_id)
    {
        DataTable dtEST = DataTypeUtility.FilterSortDataTable(DT_ESTTARGETMAP, string.Format(" TGT_EMP_ID = {0} ", est_emp_id), " EST_DEPT_NAME, EST_EMP_NAME ");

        UltraWebGrid3.DataSource = dtEST;
        UltraWebGrid3.DataBind();
    }
    private void DoBinding_ETC()
    {
        MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT();
        DataTable dtNHIT_B = bizNHIT.GetEtc(GRP_ONE_ID.B.ToString()
                                            , CR_YEAR
                                            , CR_MONTH
                                            , "T");

        UltraWebGrid3.DataSource = dtNHIT_B;
        UltraWebGrid3.DataBind();
        DoDrawingEtcChart(dtNHIT_B, chart3, 4);


        DataTable dtNHIT_C = bizNHIT.GetEtc(GRP_ONE_ID.C.ToString()
                                            , CR_YEAR
                                            , CR_MONTH
                                            , "T");

        UltraWebGrid4.DataSource = dtNHIT_C;
        UltraWebGrid4.DataBind();
        DoDrawingEtcChart(dtNHIT_C, chart4, 17);


        DataTable dtNHIT_D = bizNHIT.GetEtc(GRP_ONE_ID.D.ToString()
                                            , CR_YEAR
                                            , CR_MONTH
                                            , "T");



        UltraWebGrid5.DataSource = dtNHIT_D;
        UltraWebGrid5.DataBind();
        DoDrawingEtcChart(dtNHIT_D, chart5, 13);
    }
    private void DoBinding_ETC()
    {
        MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT();
        DataTable dtNHIT_B = bizNHIT.GetEtc(GRP_ONE_ID.B.ToString()
                                            , CR_YEAR
                                            , CR_MONTH
                                            , TG_GUBUN);

        UltraWebGrid3.DataSource = dtNHIT_B;
        UltraWebGrid3.DataBind();

        DataTable dtNHIT_C = bizNHIT.GetEtc(GRP_ONE_ID.C.ToString()
                                            , CR_YEAR
                                            , CR_MONTH
                                            , TG_GUBUN);

        UltraWebGrid4.DataSource = dtNHIT_C;
        UltraWebGrid4.DataBind();

        DataTable dtNHIT_D = bizNHIT.GetEtc(GRP_ONE_ID.D.ToString()
                                            , CR_YEAR
                                            , CR_MONTH
                                            , TG_GUBUN);

        UltraWebGrid5.DataSource = dtNHIT_D;
        UltraWebGrid5.DataBind();
    }
Beispiel #5
0
    protected void Custom_Col_Bind()
    {
        DataTable DT = bizPmsColInfo.Get_Custom_Col_List(PRJ_ID);

        UltraWebGrid3.DataSource = DT;
        UltraWebGrid3.DataBind();
    }
Beispiel #6
0
    private void SelectBizGridBinding(string pos_knd_id)
    {
        Biz_PositionBizs positionBizs = new Biz_PositionBizs();
        DataSet          ds           = positionBizs.GetPositionBizs();

        UltraWebGrid3.DataSource = ds;
        UltraWebGrid3.DataBind();
    }
Beispiel #7
0
    protected void ibnSearch_Click(object sender, ImageClickEventArgs e)
    {
        UltraWebGrid1.Clear();
        UltraWebGrid2.Clear();
        UltraWebGrid3.Clear();

        DoBinding_Dept();
    }
Beispiel #8
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();
    }
Beispiel #9
0
    private void DataBindingSchool(string sabun)
    {
        string query = @"SELECT SCHOOL.EMP_ENTER_DATE,                          -- 입학년월
                                SCHOOL.EMP_GRADUATE_DATE,                       -- 졸업년월
                                SCHOOL.EMP_SCHOOL,                              -- 최종학교
                                SCHOOL.EMP_STUDY                                -- 전공
                            FROM SEM_EMPLOYEE_SCHOOL SCHOOL
                                WHERE SCHOOL.EMP_SABUN_T = '" + sabun + @"'";

        UltraWebGrid3.DataSource = GetDataSet(query);
        UltraWebGrid3.DataBind();
    }
Beispiel #10
0
    protected void lbnSavePOS_Click(object sender, EventArgs e)
    {
        Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales();
        Biz_DeptInfos     deptInfo     = new Biz_DeptInfos();
        DataTable         dataTable    = deptPosScale.GetDataTableSchema();
        DataTable         dtDept       = deptInfo.GetDataTableSchema();
        DataRow           drRow        = null;

        string[] dept_values = hdfDeptID.Value.Split(',');

        dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid3
                                                            , new string[] { "SEQ", "POS_ID", "POS_VALUE", "SCALE_ID" }
                                                            , dataTable);

        foreach (string dept_value in dept_values)
        {
            drRow = dtDept.NewRow();
            drRow["DEPT_REF_ID"] = DataTypeUtility.GetToInt32(dept_value);
            dtDept.Rows.Add(drRow);
        }

        if (dataTable.Rows.Count == 0)
        {
            ltrScript.Text = JSHelper.GetAlertScript("적용하려는 부서별 평가방법이 없습니다.");
            return;
        }

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

        bool isOK = deptPosScale.SaveDeptPosScaleAll(dtDept, dataTable);

        if (isOK)
        {
            ltrScript.Text = JSHelper.GetAlertScript("선택부서의 평가방법을 일괄 적용하였습니다.");

            GridBinding2(COMP_ID, ESTTERM_REF_ID, EST_ID);
            UltraWebGrid3.Clear();
            hdfDeptID.Value = "";
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript("정상적으로 처리 않았습니다.");
        }
    }
    private void SetGrid3()
    {
        UltraWebGrid3.Clear();

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

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

        if (dtObj.Rows.Count > 0)
        {
            UltraWebGrid3.DataSource = dtObj;
            UltraWebGrid3.DataBind();
        }
    }
Beispiel #12
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);
        }
    }
Beispiel #13
0
    private void GridBinding3(int comp_id, int estterm_ref_id, int dept_ref_id, string est_id)
    {
        if (dept_ref_id == 0)
        {
            return;
        }

        Biz_DeptPosDetails deptPosDetail = new Biz_DeptPosDetails();

        _dtPosDetail = deptPosDetail.GetDeptPosDetail(comp_id, estterm_ref_id, dept_ref_id, est_id).Tables[0];

        UltraWebGrid3.Clear();
        UltraWebGrid3.DataSource = _dtPosDetail;
        UltraWebGrid3.DataBind();
    }
Beispiel #14
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();
    }
Beispiel #15
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();
    }
Beispiel #16
0
    protected void ibnInit2_Click(object sender, ImageClickEventArgs e)
    {
        Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales();
        Biz_DeptInfos     deptInfo     = new Biz_DeptInfos();
        DataTable         dataTable    = deptPosScale.GetDataTableSchema();
        DataTable         dtDept       = deptInfo.GetDataTableSchema();

        dtDept.Columns.Add("COMP_ID", typeof(int));
        dtDept.Columns.Add("EST_ID", typeof(string));
        dtDept.Columns.Add("ESTTERM_REF_ID", typeof(int));

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

        if (dtDept.Rows.Count == 0)
        {
            ltrScript.Text = JSHelper.GetAlertScript("초기화하려는 부서를 선택하세요.");
            return;
        }

        foreach (DataRow dataRow in dtDept.Rows)
        {
            dataRow["COMP_ID"]        = COMP_ID;
            dataRow["EST_ID"]         = EST_ID;
            dataRow["ESTTERM_REF_ID"] = ESTTERM_REF_ID;
        }

        bool isOK = deptPosScale.InitDept(dtDept);

        if (isOK)
        {
            ltrScript.Text = JSHelper.GetAlertScript("정상적으로 선택부서를 초기화 하였습니다.");

            GridBinding2(COMP_ID, ESTTERM_REF_ID, EST_ID);
            UltraWebGrid3.Clear();
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript("정상적으로 처리되지 않았습니다.");
        }
    }
Beispiel #17
0
    protected void ibnSavePosAll_Click(object sender, ImageClickEventArgs e)
    {
        Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales();
        Biz_DeptInfos     deptInfo     = new Biz_DeptInfos();
        DataTable         dataTable    = deptPosScale.GetDataTableSchema();
        DataTable         dtDept       = deptInfo.GetDataTableSchema();

        dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid3
                                                            , new string[] { "SEQ", "POS_ID", "POS_VALUE", "SCALE_ID" }
                                                            , dataTable);

        dtDept = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid2
                                                         , new string[] { "DEPT_REF_ID" }
                                                         , dtDept);

        if (dataTable.Rows.Count == 0)
        {
            ltrScript.Text = JSHelper.GetAlertScript("적용하려는 부서별 평가방법이 없습니다.");
            return;
        }

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

        bool isOK = deptPosScale.SaveDeptPosScaleAll(dtDept, dataTable);

        if (isOK)
        {
            ltrScript.Text = JSHelper.GetAlertScript("모든 부서의 평가방법을 일괄 적용하였습니다.");

            GridBinding2(COMP_ID, ESTTERM_REF_ID, EST_ID);
            UltraWebGrid3.Clear();
        }
        else
        {
            ltrScript.Text = JSHelper.GetAlertScript("정상적으로 처리 않았습니다.");
        }
    }
Beispiel #18
0
        protected void Page_Load(object sender, System.EventArgs e)
        {
            Session.LCID       = 1033;
            elt_account_number = Request.Cookies["CurrentUserInfo"]["elt_account_number"];
            user_id            = Request.Cookies["CurrentUserInfo"]["user_id"];
            user_right         = Request.Cookies["CurrentUserInfo"]["user_right"];
            login_name         = Request.Cookies["CurrentUserInfo"]["login_name"];

            if (Session["Accounting_sPeriod"] == null)
            {
                Response.Redirect("./GLSelection.aspx?parm=bal");
            }

            if (login_name == "imoon")
            {
                this.TextBox1.Width = new Unit("100px");
                this.TextBox2.Width = new Unit("100px");
            }

            if (!IsPostBack)
            {
                ViewState["Count"] = 1;

                if (Request.UrlReferrer == null)
                {
                    Response.Redirect(ParentPage);
                }
                else
                {
                    ViewState["Parent"] = Request.UrlReferrer.ToString();
                }

                PerformSearch();
                PerformDataBind();
            }
            else
            {
                ViewState["Count"] = (int)ViewState["Count"] + 1;
            }
            UltraWebGrid1.ExpandAll(true);
            UltraWebGrid2.ExpandAll(true);
            UltraWebGrid3.ExpandAll(true);
        }
Beispiel #19
0
        private void PerformDataBind()
        {
            UltraWebGrid1.DataSource = ds.Tables["HEAD"].DefaultView;
            UltraWebGrid2.DataSource = ds_AS.Tables["HEAD"].DefaultView;
            UltraWebGrid3.DataSource = ds_LE.Tables["HEAD"].DefaultView;

            UltraWebGrid1.DataBind();
            UltraWebGrid2.DataBind();
            UltraWebGrid3.DataBind();

            if (UltraWebGrid1.Rows.Count < 1)
            {
                lblNoData.Text    = "No Data was found!";
                lblNoData.Visible = true;
            }
            else
            {
                UltraWebGrid1.Visible = false;
                lblNoData.Visible     = false;
            }
        }
Beispiel #20
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;
        }
    }
Beispiel #21
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                svcSCPPHH.SCPP_HHClient d = new svcSCPPHH.SCPP_HHClient();
                BC.SCPP_HH bc             = new BC.SCPP_HH();
                DataSet    ds             = new DataSet();//d.SyncServHH(DropDownList1.SelectedValue.ToString(), DateTime.Today.Date.AddDays(-20), DateTime.Today, DateTime.Today);
                //DataSet ds = bc.SyncServHH(DropDownList1.SelectedValue.ToString(), DateTime.Today.Date.AddDays(-20), DateTime.Today, DateTime.Today);
                //List<DataSet> lds = d.SyncServHHLDS(DateTime.Today.Date.AddDays(-30), DateTime.Today, DateTime.Today);
                //List<StringReader[]> lxmlDS = bc.SyncServHH(DateTime.Today.Date.AddDays(-30), DateTime.Today, DateTime.Today);
                //DataSet beRes = new DataSet();
                //List<DataSet> lds = new List<DataSet>();
                //foreach (StringReader[] xmlSR in lxmlDS)
                //{
                //    beRes.Clear();
                //    beRes = new DataSet();
                //    beRes.ReadXmlSchema(xmlSR[0]);
                //    beRes.ReadXml(xmlSR[1], XmlReadMode.Auto);
                //    lds.Add(beRes);
                //}
                //DataTable dt = d.TablasCatalogosHH();

                DataTable dt = null;
                try
                {
                    dt = d.Login("a", "a");
                }
                catch { }
                try
                { dt = d.ObtenerSupervisorPorDefecto(42); }
                catch { }
                DataSet xmlDS = new DataSet();
                DataSet ds2   = new DataSet();
                try
                {
                    StringReader   xmlSchema  = new StringReader(ds.GetXmlSchema().ToString());
                    StringReader   xmlInfo    = new StringReader(ds.GetXml().ToString());
                    StringReader[] xmlDataSet = { xmlSchema, xmlInfo };

                    ds2.ReadXmlSchema(xmlDataSet[0]);
                    ds2.ReadXml(xmlDataSet[1], XmlReadMode.Auto);
                }
                catch { }

                if (ds2.Tables.Count > 0)
                {
                    UltraWebGrid1.DataSource = ds2.Tables[0];
                    String tableName = ds2.Tables[1].TableName.Substring(3).ToString();
                    ObtenerUpdate(ds2.Tables[1], tableName);
                    UltraWebGrid2.DataSource = ds2.Tables[1];
                    UltraWebGrid3.DataSource = ds2.Tables[2];
                }
                int i = d.ActualizarColorPieza(21, 3);
                UltraWebGrid1.DataBind();
                UltraWebGrid2.DataBind();
                UltraWebGrid3.DataBind();
            }
            catch (Exception er)
            {
                CallBackManager.AddScriptBlock(this.Page, WebAsyncRefreshPanel1, "<script type='text/javascript'>alert('" + er.Message.Replace("'", "\"") + "');</script>");
                Console.Write("Error:" + er.Message);
            }
        }
Beispiel #22
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();
    }