Beispiel #1
0
    protected void ddlEstID_SelectedIndexChanged(object sender, EventArgs e)
    {
        UltraWebGrid1.Clear();
        ClearValueControls();

        DropDownListCommom.BindQuestionObject(ddlQObjID, hdfSearchEstID.Value, true);
    }
Beispiel #2
0
    private void SearchEmpInfo()
    {
        EmpInfos emp = new EmpInfos();

        string searchType = WebUtility.GetByValueDropDownList(ddlSchType);
        string searchText = this.txtSearch.Text.Trim();
        int    useYN      = WebUtility.GetIntByValueRadioButtonList(radType);

        if (useYN == 0)
        {
            ibtnRollback.Visible = true;
        }
        else
        {
            ibtnRollback.Visible = false;
        }

        UltraWebGrid1.Clear();
        DataSet ds = emp.GetEmpInfoSearch(searchType, searchText, useYN);

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

        lblRowCount.Text = ds.Tables[0].Rows.Count.ToString();
    }
    private void DoBinding_Project()
    {
        UltraWebGrid1.Clear();

        MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT();
        DataTable dtNHIT = bizNHIT.GetProjectDetail(CR_YEAR, GRP_ONE_B_CODE, GRP_ONE_C_CODE, GRP_ONE_D_CODE);

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

        string title = "{0} 프로젝트 현황";
        string gubun = string.Empty;

        if (GRP_ONE_B_CODE.Length > 0)
        {
            gubun = "고객사 별";
        }

        if (GRP_ONE_C_CODE.Length > 0)
        {
            gubun = "사업유형 별";
        }

        if (GRP_ONE_D_CODE.Length > 0)
        {
            gubun = "본부 별";
        }

        if (dtNHIT.Rows.Count > 0)
        {
            lblTitle.Text        = string.Format(title, gubun);
            lblProjectTotal.Text = string.Format("(Total : {0})", dtNHIT.Rows.Count);
        }
    }
Beispiel #4
0
    private void SetSelectTree()
    {
        if (TreeView1.SelectedNode == null)
        {
            return;
        }
        string deptId = TreeView1.SelectedNode.Value;

        SetFormData(int.Parse(deptId));
        UltraWebGrid1.Clear();

        DataSet ds = GetEmpInfoList(deptId);

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

        lblRowCount.Text = ds.Tables[0].Rows.Count.ToString();

        if (!hImgNew.Visible)
        {
            hImgNew.Visible = true;
        }

        if (!ibtnDelete.Visible)
        {
            ibtnDelete.Visible = true;
        }
    }
Beispiel #5
0
    private void DoBinding(int estTermRefID, int deptID)
    {
        UltraWebGrid1.Clear();


        MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info();

        DataTable dtBscKpiInfo = bizBscKpiInfo.Get_GoalTongDashboard(estTermRefID, deptID);

        if (dtBscKpiInfo.Rows.Count > 0)
        {
            this.ChartView.Visible   = true;
            UltraWebGrid1.DataSource = dtBscKpiInfo;
            UltraWebGrid1.DataBind();

            UltraWebGrid1.Rows[0].Activated = true;
            int    kpi_ref_id = DataTypeUtility.GetToInt32(dtBscKpiInfo.Rows[0]["KPI_REF_ID"]);
            string kpi_name   = DataTypeUtility.GetValue(dtBscKpiInfo.Rows[0]["KPI_NAME"]);

            DoCharting(kpi_ref_id, kpi_name);
        }
        else
        {
            this.ChartView.Visible = false;
            //chartMM.Visible = false;
            //chartDal.Visible = false;
        }
    }
Beispiel #6
0
    private void GridBinding(int comp_id)
    {
        if (CheckParam() == false)
        {
            ltrScript.Text = JSHelper.GetAlertScript("평가정보나 평가방법이 설정되지 않았습니다.");
            return;
        }

        Biz_ScaleInfos scaleInfo = new Biz_ScaleInfos();
        DataTable      dtScale   = scaleInfo.GetScaleInfos(comp_id).Tables[0];

        _dwScale      = dtScale.DefaultView;
        _dwScale.Sort = "SCALE_ID";

        Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails();

        _dtEstScale = deptEstDetail.GetDeptEstDetail(comp_id, ESTTERM_REF_ID, 0, EST_ID).Tables[0];

        UltraWebGrid1.Clear();
        UltraWebGrid1.DataSource = BizUtility.GetDeptTree("     ");
        UltraWebGrid1.DataBind();

        EstJobUtility.SetConfirmButtonVisible(COMP_ID
                                              , EST_ID
                                              , ESTTERM_REF_ID
                                              , ESTTERM_SUB_ID
                                              , ESTTERM_STEP_ID
                                              , EST_JOB_ID
                                              , ibnConfirm
                                              , ibnConfirmCancel);
    }
Beispiel #7
0
 protected void ibnSearch_Click(object sender, ImageClickEventArgs e)
 {
     DropDownListCommom.BindQuestionObject(ddlQObjID, hdfSearchEstID.Value, true);
     DropDownListCommom.BindQuestionDefine(ddlQDfnID, hdfSearchEstID.Value, true);
     UltraWebGrid1.Clear();
     ClearValueControls();
 }
Beispiel #8
0
    private void BindGrid()
    {
        UltraWebGrid1.Clear();
        UltraWebGrid1.DataSource = _questionDefine.GetQuestionDefine(EST_ID);

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

        DoBinding_Dept();
    }
Beispiel #10
0
 private void Reload()
 {
     UltraWebGrid1.Clear();
     UltraWebGrid2.Clear();
     DataBindingUnitType();
     DataBindingUnit(hdfUnitGroup.Value);
     txtUnitGroup.Text = "";
 }
Beispiel #11
0
    private void DoBinding()
    {
        Biz_EstDeptOrgScoreInfos bizEDOS = new Biz_EstDeptOrgScoreInfos();
        DataTable dt = bizEDOS.GetEstDeptOrgScoreInfos(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)).Tables[0];

        UltraWebGrid1.Clear();
        UltraWebGrid1.DataSource = dt;
        UltraWebGrid1.DataBind();
    }
Beispiel #12
0
    private void BindQuestionGrid()
    {
        Biz_QuestionEstMaps questionEstMaps = new Biz_QuestionEstMaps();

        UltraWebGrid1.Clear();
        ugrdPrjList.Clear();

        UltraWebGrid1.DataSource = questionEstMaps.GetQuestionEstMap(EST_ID, "");
        UltraWebGrid1.DataBind();
    }
Beispiel #13
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 #14
0
    private void GridBinding()
    {
        this.SetGridHeader();
        DataTable rDt = GetDataTable();

        UltraWebGrid1.Clear();
        UltraWebGrid1.DataSource = rDt.DefaultView;
        UltraWebGrid1.DataBind();

        this.BindingChart(Chart1, rDt);
    }
Beispiel #15
0
 protected void SetFreightEasyData(string txtSQL)
 {
     UltraWebGrid1.Clear();
     FEData = new FreightEasy.DataManager.FreightEasyData();
     FEData.AddToDataSet("SearchList", txtSQL);
     UltraWebGrid1.DataSource = FEData.Tables["SearchList"].DefaultView;
     UltraWebGrid1.DataBind();
     UltraWebGrid1.DisplayLayout.Pager.CurrentPageIndex = 1;
     txtResultBox.Text      = FEData.Tables["SearchList"].Rows.Count.ToString() + " Records Found.";
     btnExcelExport.Visible = true;
 }
Beispiel #16
0
    protected void lBtnGridReload_Click(object sender, EventArgs e)
    {
        string deptId = TreeView1.SelectedNode.Value;

        UltraWebGrid1.Clear();
        DataSet ds = GetEmpInfoList(deptId);

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

        lblRowCount.Text = ds.Tables[0].Rows.Count.ToString();
    }
Beispiel #17
0
    private void BindGrid()
    {
        UltraWebGrid1.Clear();
        UltraWebGrid1.DataSource = _questionItems.GetQuestionItem("", "", PageUtility.GetByValueDropDownList(ddlQObjID));
        UltraWebGrid1.DataBind();

        if (!Page.ClientScript.IsStartupScriptRegistered(Page.GetType(), "Search"))
        {
            Page.ClientScript.RegisterStartupScript(Page.GetType(), "Search", string.Format("<script>GetDataSet('GetDataSet.aspx','ddlQSbjID','Q_SBJ_NAME','Q_SBJ_ID', 'Survey', 'B', '{0}');"
                                                                                            + "document.forms[0].ddlQSbjID.value={1}; </script>"
                                                                                            , PageUtility.GetByValueDropDownList(ddlQObjID), 0));
        }
    }
Beispiel #18
0
    private void DoBinding_Dept()
    {
        UltraWebGrid1.Clear();
        UltraWebGrid2.Clear();

        Biz_Mul_Est_Data bizMulEstData = new Biz_Mul_Est_Data();

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


        UltraWebGrid1.DataSource = DT;
        UltraWebGrid1.DataBind();
    }
    private void DoBinding_JeonSa()
    {
        UltraWebGrid1.Clear();

        MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT();
        DataTable dtNHIT = bizNHIT.GetJeonSa(GRP_ONE_ID.A.ToString()
                                             , (int)GRP_TWO_ID.GTO_10
                                             , CR_YEAR
                                             , CR_MONTH, TG_GUBUN);

        UltraWebGrid1.DataSource = dtNHIT;
        UltraWebGrid1.DataBind();
    }
Beispiel #20
0
    private void DoLoading(int comp_id, string est_id, int estterm_ref_id, int estterm_sub_id)
    {
        UltraWebGrid1.Clear();

        Biz_JobEstMaps biz = new Biz_JobEstMaps();
        DataSet        ds  = biz.GetJobEstMap(comp_id
                                              , est_id
                                              , estterm_ref_id
                                              , estterm_sub_id
                                              , "");

        UltraWebGrid1.DataSource = ds.Tables[0];
        UltraWebGrid1.DataBind();
    }
Beispiel #21
0
    private void SetGrid1()
    {
        UltraWebGrid1.Clear();

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

        DataTable dtObj = bizObj.GetOrgRank(IEstTermRefID, IYmd, 0);

        if (dtObj.Rows.Count > 0)
        {
            UltraWebGrid1.DataSource = dtObj;
            UltraWebGrid1.DataBind();
        }
    }
Beispiel #22
0
    private void GridBinding2(int comp_id, int estterm_ref_id, string est_id)
    {
        Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails();

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

        Biz_DeptPosDetails deptPosDetail = new Biz_DeptPosDetails();

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

        UltraWebGrid1.Clear();
        UltraWebGrid1.DataSource = BizUtility.GetDeptTree("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
        UltraWebGrid1.DataBind();
    }
Beispiel #23
0
    private void SearchDB()
    {
        UltraWebGrid1.Clear();
        UltraWebGrid1.DataSource = GetSearchData();
        UltraWebGrid1.DataBind();

        if (UltraWebGrid1.Rows.Count <= 0)
        {
            this.iBtnRoleDel.Visible = false;
        }
        else
        {
            this.iBtnRoleDel.Visible = true;
        }
    }
Beispiel #24
0
    private void BindEstJob(string est_id)
    {
        UltraWebGrid1.Clear();
        Biz_JobEstMaps biz = new Biz_JobEstMaps();
        DataSet        ds  = biz.GetJobEstMap(COMP_ID
                                              , est_id
                                              , ESTTERM_REF_ID
                                              , ESTTERM_SUB_ID
                                              , "");

        UltraWebGrid1.DataSource = ds.Tables[0];
        UltraWebGrid1.DataBind();

        //lblRowCount.Text         = ds.Tables[0].Rows.Count.ToString();
    }
Beispiel #25
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();
    }
Beispiel #26
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 #27
0
    protected void doBindKpiPool()
    {
        MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool();
        DataSet ds = objBSC.GetDetailAllList(txtKpiName.Text.Trim()
                                             , ""
                                             , ""
                                             , 0
                                             , 0
                                             , 0
                                             , "");

        DataTable dt_filtered = DataTypeUtility.FilterSortDataTable(ds.Tables[0], "KPI_EXTERNAL_TYPE='EXT'");

        UltraWebGrid1.Clear();
        UltraWebGrid1.DataSource = dt_filtered;
        UltraWebGrid1.DataBind();
    }
Beispiel #28
0
    protected void doBind_est()
    {
        UltraWebGrid1.Clear();

        int estterm_step_id = 2;

        string PRJ_NAME = this.txtPRJ_NAME.Text;

        string gubun = this.GUBUN.SelectedValue;

        DataTable DT = bizPrjInfo.Get_Pms_Info_Join_PRj_Info_List(EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, estterm_step_id, PRJ_NAME, EST_EMP_ID, gubun);

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

        UltraWebGrid1.DataSource = DT;
        UltraWebGrid1.DataBind();
    }
Beispiel #29
0
    private void GridBinding()
    {
        Biz_EstDeptOrgDetails estDeptOrgDetail = new Biz_EstDeptOrgDetails();
        Biz_DeptTypeInfo      deptTypeInfo     = new Biz_DeptTypeInfo();

        if (rtlDrildownYN.SelectedIndex == 1)
        {
            if (TreeView1.Nodes.Count > 0)
            {
                UltraWebGrid1.Clear();
                UltraWebGrid1.DataSource = estDeptOrgDetail.GetEstDeptOrgDetail(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), Convert.ToInt32(TreeView1.Nodes[0].Value));
                UltraWebGrid1.DataBind();
            }
            else
            {
                UltraWebGrid1.DataSource = deptTypeInfo.GetDeptTypeList();
                UltraWebGrid1.DataBind();
            }
        }
        else
        {
            if (TreeView1.Nodes.Count > 0)
            {
                if (TreeView1.SelectedNode != null)
                {
                    UltraWebGrid1.Clear();
                    DataSet ds = estDeptOrgDetail.GetEstDeptOrgDetail(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), Convert.ToInt32(TreeView1.SelectedNode.Value));
                    UltraWebGrid1.DataSource = ds;
                    UltraWebGrid1.DataBind();
                }
                else
                {
                    UltraWebGrid1.DataSource = deptTypeInfo.GetDeptTypeList();
                    UltraWebGrid1.DataBind();
                }
            }
            else
            {
                UltraWebGrid1.DataSource = deptTypeInfo.GetDeptTypeList();
                UltraWebGrid1.DataBind();
            }
        }
    }
Beispiel #30
0
    private void _queryGrid()
    {
        string strYMD = (cboYY.SelectedValue + cboMM.SelectedValue);

        OracleConnection _connection = new OracleConnection();

        _connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MainDB_Oracle"].ConnectionString;
        OracleCommand objCmdGrid = new OracleCommand("PKG_SEM_Fina_R025.PROC_Fina_R025_01", _connection);

        _connection.Open();

        objCmdGrid.CommandType = CommandType.StoredProcedure;

        //================================================================== Grid Query
        OracleParameter[] arrOpmGrid = new OracleParameter[3];

        arrOpmGrid[0]           = new OracleParameter("i_YYMM", OracleType.VarChar, 6);
        arrOpmGrid[0].Value     = (strYMD);
        arrOpmGrid[1]           = new OracleParameter("i_BANK", OracleType.VarChar, 12);
        arrOpmGrid[1].Value     = cboBank.SelectedValue;
        arrOpmGrid[2]           = new OracleParameter("O_Fina_R025", OracleType.Cursor);
        arrOpmGrid[2].Direction = ParameterDirection.Output;

        for (int i = 0; i < arrOpmGrid.Length; i++)
        {
            objCmdGrid.Parameters.Add(arrOpmGrid[i]);
        }

        DataSet           dsGrid = new DataSet();
        OracleDataAdapter daGrid = new OracleDataAdapter(objCmdGrid);

        daGrid.Fill(dsGrid);
        //this.setGridData(dsGrid);

        UltraWebGrid1.Clear();
        if (dsGrid.Tables.Count > 0)
        {
            UltraWebGrid1.DataSource = dsGrid;
            UltraWebGrid1.DataBind();
        }
    }