private void setGridData(DataSet iDsSet)
    {
        double dblPlan = 0.00;
        double dblActl = 0.00;
        double dblRlan = 0.00;
        double dblRslt = 0.00;


        int intRow = iDsSet.Tables[0].Rows.Count;

        for (int i = 0; i < intRow; i++)
        {
            dblPlan += double.Parse(iDsSet.Tables[0].Rows[i]["계획"].ToString());
            dblActl += double.Parse(iDsSet.Tables[0].Rows[i]["실적"].ToString());
            dblRslt += double.Parse(iDsSet.Tables[0].Rows[i]["전년동기실적"].ToString());
        }

        DataRow drTmp = iDsSet.Tables[0].NewRow();

        drTmp["구분"]     = "합       계";
        drTmp["계획"]     = dblPlan;
        drTmp["실적"]     = dblActl;
        drTmp["전년동기실적"] = dblRslt;
        drTmp["차이"]     = dblActl - dblPlan;
        drTmp["달성율(%)"] = (dblPlan == 0) ? 0.00 : Math.Round((dblActl / dblPlan) * 100, 2);
        drTmp["차 이"]    = dblActl - dblRslt;
        drTmp["증가율(%)"] = (dblRslt == 0) ? 0.00 : Math.Round((dblActl / dblRslt) * 100, 2);
        iDsSet.Tables[0].Rows.InsertAt(drTmp, 0);

        UltraWebGrid1.DataSource = iDsSet;
        UltraWebGrid1.DataBind();
    }
Exemple #2
0
 protected void btnReset_Click(object sender, System.EventArgs e)
 {
     UltraWebGrid1.ResetColumns();
     UltraWebGrid1.ResetBands();
     PerformSearch();
     PerformDataBind();
 }
    private void setGridData(DataSet iDsSet)
    {
        double dblPlan = 0.00;
        double dblActl = 0.00;
        double dblRslt = 0.00;


        int intRow = iDsSet.Tables[0].Rows.Count;

        for (int i = 0; i < intRow; i++)
        {
            dblPlan += double.Parse(iDsSet.Tables[0].Rows[i]["S_PLAN"].ToString());
            dblActl += double.Parse(iDsSet.Tables[0].Rows[i]["S_RSLT"].ToString());
            dblRslt += double.Parse(iDsSet.Tables[0].Rows[i]["L_RSLT"].ToString());
        }

        DataRow drTmp = iDsSet.Tables[0].NewRow();

        drTmp["SGBUN_NM"]  = "합       계";
        drTmp["S_PLAN"]    = dblPlan;
        drTmp["S_RSLT"]    = dblActl;
        drTmp["L_RSLT"]    = dblRslt;
        drTmp["S_DIFF"]    = dblActl - dblPlan;
        drTmp["ACHV_RATE"] = (dblPlan == 0) ? 0.00 : Math.Round((dblActl / dblPlan) * 100, 1);
        drTmp["S_ADD"]     = dblActl - dblRslt;
        drTmp["GROW_RATE"] = (dblRslt == 0) ? 0.00 : Math.Round((dblActl / dblRslt) * 100, 1);
        iDsSet.Tables[0].Rows.InsertAt(drTmp, 0);

        UltraWebGrid1.DataSource = iDsSet;
        UltraWebGrid1.DataBind();
    }
        protected void llenarvacio()
        {
            UltraWebGrid1.ResetColumns();
            UltraWebGrid1.DataBind();
            UltraWebGrid1.Columns.Add("Clave única");
            UltraWebGrid1.Columns.Add("Clave defecto");
            UltraWebGrid1.Columns.Add("Descripción");
            UltraWebGrid1.Columns.Add("Tipo defecto");
            UltraWebGrid1.Columns.Add("Proceso");
            UltraWebGrid1.Columns.Add("Responsable");


            UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
            UltraWebGrid1.Columns[1].Header.Caption = "Clave defecto";
            UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
            UltraWebGrid1.Columns[3].Header.Caption = "Tipo defecto";
            UltraWebGrid1.Columns[4].Header.Caption = "Proceso";
            UltraWebGrid1.Columns[5].Header.Caption = "Responsable";



            UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
        }
Exemple #5
0
    private void BindGrid()
    {
        UltraWebGrid1.Clear();
        UltraWebGrid1.DataSource = _questionDefine.GetQuestionDefine(EST_ID);

        UltraWebGrid1.DataBind();
    }
        protected void llenarvacio()
        {
            UltraWebGrid1.ResetColumns();
            UltraWebGrid1.DataBind();
            UltraWebGrid1.Columns.Add("Fecha");
            UltraWebGrid1.Columns.Add("Densidad");
            UltraWebGrid1.Columns.Add("BU");
            UltraWebGrid1.Columns.Add("Autorización");
            UltraWebGrid1.Columns.Add("Activo");
            UltraWebGrid1.Columns.Add("Baroi");
            UltraWebGrid1.Columns.Add("Turno");


            UltraWebGrid1.Columns[0].Header.Caption = "Fecha";
            UltraWebGrid1.Columns[1].Header.Caption = "Densidad";
            UltraWebGrid1.Columns[2].Header.Caption = "BU";
            UltraWebGrid1.Columns[3].Header.Caption = "Autorización";
            UltraWebGrid1.Columns[4].Header.Caption = "Activo";
            UltraWebGrid1.Columns[5].Header.Caption = "Baroi";
            UltraWebGrid1.Columns[6].Header.Caption = "Turno";

            UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;


            UltraWebGrid1.Columns[1].Width = 80;
            UltraWebGrid1.Columns[1].Width = 70;
        }
        protected void llenarvacio()
        {
            UltraWebGrid1.ResetColumns();
            UltraWebGrid1.DataBind();
            UltraWebGrid1.Columns.Add("Clave única");
            UltraWebGrid1.Columns.Add("Clave artículo");
            UltraWebGrid1.Columns.Add("Descripción");
            UltraWebGrid1.Columns.Add("Tipo artículo");
            UltraWebGrid1.Columns.Add("Activo");

            UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
            UltraWebGrid1.Columns[1].Header.Caption = "Clave artículo";
            UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
            UltraWebGrid1.Columns[3].Header.Caption = "Tipo artículo";
            UltraWebGrid1.Columns[4].Header.Caption = "Activo";


            UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;

            UltraWebGrid1.Columns[1].Width = 110;
            UltraWebGrid1.Columns[3].Width = 110;
        }
        protected void llenarvacio()
        {
            UltraWebGrid1.ResetColumns();
            UltraWebGrid1.DataBind();
            UltraWebGrid1.Columns.Add("Clave única");
            UltraWebGrid1.Columns.Add("Clave máquina");
            UltraWebGrid1.Columns.Add("Descripción");
            UltraWebGrid1.Columns.Add("Tipo de máquina");
            UltraWebGrid1.Columns.Add("Proceso");
            UltraWebGrid1.Columns.Add("Centro de trabajo");


            UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
            UltraWebGrid1.Columns[1].Header.Caption = "Clave máquina";
            UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
            UltraWebGrid1.Columns[3].Header.Caption = "Tipo de máquina";
            UltraWebGrid1.Columns[4].Header.Caption = "Proceso";
            UltraWebGrid1.Columns[5].Header.Caption = "Centro de trabajo";

            UltraWebGrid1.Columns[2].Width = 160;
            UltraWebGrid1.Columns[3].Width = 120;
            UltraWebGrid1.Columns[5].Width = 120;

            UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
        }
Exemple #9
0
    private void BindingTgtEmp(int est_emp_id)
    {
        Biz_Datas data      = new Biz_Datas();
        DataTable dataTable = data.GetEstData(COMP_ID
                                              , EST_ID
                                              , ESTTERM_REF_ID
                                              , ESTTERM_SUB_ID
                                              , ESTTERM_STEP_ID
                                              , 0
                                              , est_emp_id
                                              , 0
                                              , 0
                                              , YEAR_YN
                                              , MERGE_YN
                                              , OwnerType.Emp_User).Tables[0];


        dataTable = DataTypeUtility.GetGroupByDataTable(dataTable
                                                        , new string[] { "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" });

        dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "", "TGT_EMP_NAME");


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

        lblRowCount.Text = dataTable.Rows.Count.ToString("#,##0");
    }
Exemple #10
0
    private void SearchDB()
    {
        UltraWebGrid1.DataSource = GetSearchData();
        UltraWebGrid1.DataBind();

        // 추가시에는 현재타입의 갯수만큼만 처리되도록 확인처리한다.
        ////int iRowCnt = UltraWebGrid1.Rows.Count;
        ////int iType   = Convert.ToInt32(PageUtility.GetByValueDropDownList(ddlType));

        ////string sAddScript = "";

        ////if (iType > iRowCnt)
        ////{
        ////    sAddScript = string.Format(
        ////                                "return gfConfirmWait(this, '{0}');"
        ////                              , "추가 등급을 적용하려면,\\n\\n"
        ////                              + "KPI 의 THRESHOLD 들을 재설정하셔야 합니다.\\n\\n"
        ////                              + "추가 하시겠습니까?"
        ////                             );
        ////}
        ////else
        ////{
        ////    sAddScript = string.Format(
        ////                                "alert('{0}');return false;"
        ////                              , "현재측정단계에서는 더이상 추가하실 수 없습니다!"
        ////                             );
        ////}

        ////iBtnAdd.Attributes.Remove("onclick");
        ////iBtnAdd.Attributes["onclick"] = sAddScript;
    }
Exemple #11
0
    private void SearchDB()
    {
        UltraWebGrid1.DataSource = GetSearchData();
        UltraWebGrid1.DataBind();

        //SearchDetail("0");
    }
Exemple #12
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();
    }
Exemple #13
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;
        }
    }
    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);
        }
    }
        protected void llenarvacio()
        {
            UltraWebGrid1.ResetColumns();
            UltraWebGrid1.DataBind();
            UltraWebGrid1.Columns.Add("Clave única");
            UltraWebGrid1.Columns.Add("Clave centro trabajo");
            UltraWebGrid1.Columns.Add("Descripción");
            UltraWebGrid1.Columns.Add("Proceso");
            UltraWebGrid1.Columns.Add("Línea de producción");

            UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
            UltraWebGrid1.Columns[1].Header.Caption = "Clave centro de trabajo";
            UltraWebGrid1.Columns[2].Header.Caption = "Descripción";
            UltraWebGrid1.Columns[3].Header.Caption = "Proceso";
            UltraWebGrid1.Columns[4].Header.Caption = "Línea de producción";


            UltraWebGrid1.Columns[1].Header.Style.Wrap = true;
            UltraWebGrid1.Columns[4].Header.Style.Wrap = true;

            UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;

            UltraWebGrid1.Columns[0].Width = 100;
            UltraWebGrid1.Columns[1].Width = 100;
            UltraWebGrid1.Columns[2].Width = 150;
            UltraWebGrid1.Columns[3].Width = 120;
            UltraWebGrid1.Columns[4].Width = 120;
        }
    public void SetGridHeader()
    {
        int iRow = UltraWebGrid1.Columns.Count;

        for (int i = iRow; i > 0; i--)
        {
            UltraWebGrid1.Columns.RemoveAt(iRow);
        }
        UltraWebGrid1.ResetColumns();


        DataTable dtCol = this.CODE_TABLE;

        iRow = dtCol.Rows.Count;

        UltraGridColumn cn = null;

        cn = new UltraGridColumn("YY", "년도", ColumnType.NotSet, "");
        cn.BaseColumnName            = "YY";
        cn.Width                     = Unit.Pixel(120);
        cn.CellStyle.HorizontalAlign = HorizontalAlign.Center;
        UltraWebGrid1.Columns.Add(cn);

        for (int i = 0; i < iRow; i++)
        {
            cn = new UltraGridColumn(dtCol.Rows[i][0].ToString(), dtCol.Rows[i][1].ToString(), ColumnType.NotSet, 0);
            cn.BaseColumnName            = dtCol.Rows[i][0].ToString();
            cn.Width                     = Unit.Pixel(165);
            cn.DataType                  = "System.Double";
            cn.Format                    = "#,###,###,###,###,###,###,###,###,##0.00";
            cn.CellStyle.HorizontalAlign = HorizontalAlign.Right;
            UltraWebGrid1.Columns.Add(cn);
        }
    }
        protected void llenarvacio()
        {
            UltraWebGrid1.ResetColumns();
            UltraWebGrid1.DataBind();
            UltraWebGrid1.Columns.Add("Fecha");
            UltraWebGrid1.Columns.Add("Tiempo espejo");
            UltraWebGrid1.Columns.Add("Viscosidad");
            UltraWebGrid1.Columns.Add("Densidad");
            UltraWebGrid1.Columns.Add("Espesor");
            UltraWebGrid1.Columns.Add("Autorización");
            UltraWebGrid1.Columns.Add("Activo");


            UltraWebGrid1.Columns[0].Header.Caption = "Fecha";
            UltraWebGrid1.Columns[1].Header.Caption = "Tiempo espejo";
            UltraWebGrid1.Columns[2].Header.Caption = "Viscosidad";
            UltraWebGrid1.Columns[3].Header.Caption = "Densidad";
            UltraWebGrid1.Columns[4].Header.Caption = "Espesor";
            UltraWebGrid1.Columns[5].Header.Caption = "Autorización";
            UltraWebGrid1.Columns[6].Header.Caption = "Activo";

            UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;


            UltraWebGrid1.Columns[1].Width = 100;
        }
Exemple #18
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;
        }
    }
        protected void llenarvacioP()
        {
            UltraWebGrid1.ResetColumns();
            UltraWebGrid1.DataBind();
            UltraWebGrid1.Columns.Add("Fecha");
            UltraWebGrid1.Columns.Add("Proceso");
            UltraWebGrid1.Columns.Add("Centro de trabajo");
            UltraWebGrid1.Columns.Add("Maquina");
            UltraWebGrid1.Columns.Add("Posicion");
            UltraWebGrid1.Columns.Add("Operador");
            UltraWebGrid1.Columns.Add("Defectos");


            UltraWebGrid1.Columns[0].Header.Caption = "Fecha";
            UltraWebGrid1.Columns[1].Header.Caption = "Proceso";
            UltraWebGrid1.Columns[2].Header.Caption = "Centro de trabajo";
            UltraWebGrid1.Columns[3].Header.Caption = "Maquina";
            UltraWebGrid1.Columns[4].Header.Caption = "Posicion";
            UltraWebGrid1.Columns[5].Header.Caption = "Operador";
            UltraWebGrid1.Columns[6].Header.Caption = "Defectos";

            UltraWebGrid1.Columns[4].Hidden = true;


            UltraWebGrid1.Columns[2].Width = 120;
            UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[6].Header.Style.HorizontalAlign = HorizontalAlign.Center;
        }
    private void DoBinding_JeonSa()
    {
        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
                                             , "T");

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

        //dtNHIT = bizNHIT.GetJeonSa(GRP_ONE_ID.A.ToString()
        //                           , (int)GRP_TWO_ID.GTO_10
        //                           , GRP_THREE_ID.ME.ToString()
        //                           , CR_YEAR
        //                           , CR_MONTH);

        DoDrawingJunsaChart1(dtNHIT, chart1);

        dtNHIT = bizNHIT.GetJeonSa(GRP_ONE_ID.A.ToString()
                                   , (int)GRP_TWO_ID.GTO_10
                                   , GRP_THREE_ID.DN.ToString()
                                   , CR_YEAR
                                   , ""
                                   , "T");

        DoDrawingJunsaChart2(dtNHIT, chartMM);
    }
Exemple #21
0
    protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
    {
        string deptId = TreeView1.SelectedNode.Value;

        UltraWebGrid1.DataSource = GetEmpInfoList(deptId);
        UltraWebGrid1.DataBind();
    }
Exemple #22
0
        protected void llenarvacio()
        {
            UltraWebGrid1.ResetColumns();
            UltraWebGrid1.DataBind();
            UltraWebGrid1.Columns.Add("Código");
            UltraWebGrid1.Columns.Add("Proceso");
            UltraWebGrid1.Columns.Add("Proceso Padre");
            UltraWebGrid1.Columns.Add("Manufacturing");
            UltraWebGrid1.Columns.Add("Requerido");
            UltraWebGrid1.Columns.Add("Orden");

            UltraWebGrid1.Columns[0].Header.Caption = "Código";
            UltraWebGrid1.Columns[1].Header.Caption = "Proceso";
            UltraWebGrid1.Columns[2].Header.Caption = "Proceso Padre";
            UltraWebGrid1.Columns[3].Header.Caption = "MFG";
            UltraWebGrid1.Columns[4].Header.Caption = "Requerido";
            UltraWebGrid1.Columns[5].Header.Caption = "Orden";

            UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[5].Header.Style.HorizontalAlign = HorizontalAlign.Center;


            UltraWebGrid1.Columns[3].Width = 70;
            UltraWebGrid1.Columns[4].Width = 70;
            UltraWebGrid1.Columns[5].Width = 70;
        }
Exemple #23
0
    private void BindingGrid(int comp_id, string est_id, int estterm_ref_id, int estterm_sub_id)
    {
        Biz_Datas data = new Biz_Datas();

        DT_EST_DATA = data.GetData(COMP_ID
                                   , EST_ID
                                   , ESTTERM_REF_ID
                                   , ESTTERM_SUB_ID
                                   , ESTTERM_STEP_ID
                                   , 0
                                   , 0
                                   , 0
                                   , 0
                                   , YEAR_YN
                                   , MERGE_YN
                                   , OwnerType.Dept).Tables[0];


        DataTable dataTable = BizUtility.GetDeptTree("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");

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

        lblRowCount.Text = dataTable.Rows.Count.ToString();
    }
Exemple #24
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("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
        UltraWebGrid1.DataBind();

        EstJobUtility.SetConfirmButtonVisible(COMP_ID
                                              , EST_ID
                                              , ESTTERM_REF_ID
                                              , ESTTERM_SUB_ID
                                              , ESTTERM_STEP_ID
                                              , EST_JOB_ID
                                              , ibnConfirm
                                              , ibnConfirmCancel);
    }
        protected void llenargrid()
        {
            svcSCPP.SCPPClient svc = new svcSCPP.SCPPClient();
            List <Common.SolutionEntityFramework.BaseSolutionEntity> Lista = svc.ObtenerAlmacen();

            UltraWebGrid1.DataSource = Lista;
            if (Lista.Count <= 0)
            {
                llenarvacio();
            }
            else
            {
                UltraWebGrid1.ResetColumns();
                UltraWebGrid1.DataBind();
                UltraWebGrid1.Columns[3].Hidden = true;


                UltraWebGrid1.Columns[0].Header.Caption = "Clave única";
                UltraWebGrid1.Columns[1].Header.Caption = "Clave almacén";
                UltraWebGrid1.Columns[2].Header.Caption = "Descripción";


                UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
                UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
                UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;

                UltraWebGrid1.Columns[2].Width = 180;

                UltraWebGrid1.Columns[0].CellStyle.HorizontalAlign = HorizontalAlign.Center;

                UltraWebGrid1.Columns[1].CellStyle.HorizontalAlign = HorizontalAlign.Center;
            }
        }
Exemple #26
0
        private void PerformDataBind()
        {
            UltraWebGrid1.DataSource = ds.Tables[ParentTable].DefaultView;
            UltraWebGrid1.DataBind();
            this.UltraWebGrid1.DisplayLayout.Pager.PageCount = iPageCount;

            //			if(UltraWebGrid1.Rows.Count<1)
            //			{
            //				UltraWebGrid1.Visible = false;
            //				lblNoData.Text = "No Data was found!";
            //				lblNoData.Visible = true;
            //			}
            //			else
            //			{
            //				lblNoData.Visible = false;
            //			}

            //			foreach(UltraGridColumn aColumn in this.UltraWebGrid1.Columns)
            //			{
            //				if(aColumn.DataType == "System.DateTime")
            //				{
            //					aColumn.Format = "MM/dd/yyyy";
            //				}
            //			}
        }
Exemple #27
0
    private void GridDataBinding()
    {
        string query = @"
                SELECT ISNULL(CE.EMP_REF_ID,0) as EMP_REF_ID,
				       RTRIM(ISNULL(DE.DEPT_NAME,'')) as DEPT_NAME,
	                   ISNULL(CE.EMP_NAME,'') as EMP_NAME,
					   MAX(ISNULL(CE.EMP_EMAIL,'')) as EMP_EMAIL
                  FROM KPI_INFO KI, 
                       COM_EMP_INFO CE, 
	                   COM_DEPT_INFO DE, 
	                   REL_DEPT_EMP RD,
					   KPI_RESULT KR,
	                  (SELECT "     + hdnMM.Value + @" as TMCODE,  MON_" + hdnMM.Value + @"_FLAG as  CHECK_YN, KPI_REF_ID FROM KPI_TERM WHERE KPI_TERM_TYPE = 0) TM
                 WHERE KI.KPI_REF_ID *= KR.KPI_REF_ID
				   AND KI.KPI_REF_ID *= TM.KPI_REF_ID
                   AND KI.CHAMPION_EMP_ID *= CE.EMP_REF_ID
                   AND RD.EMP_REF_ID = CE.EMP_REF_ID
                   AND RD.DEPT_REF_ID = DE.DEPT_REF_ID
				   AND TM.CHECK_YN = 1
				   AND KR.CHECKSTATUS IN ("                 + ddlApplyYN.SelectedValue + @")
				   AND KR.TMCODE = "                 + hdnMM.Value + @"
				 GROUP BY DE.DEPT_REF_ID,DE.DEPT_NAME,CE.EMP_REF_ID, CE.EMP_NAME

        ";

        MicroBSC.Data.DBAgent gDbAgent = new MicroBSC.Data.DBAgent(System.Configuration.ConfigurationManager.ConnectionStrings["MainDB"].ConnectionString);
        DataSet  ds  = gDbAgent.FillDataSet(query, "data");
        EmpInfos emp = new EmpInfos();

        UltraWebGrid1.DataSource = ds.Tables[0].DefaultView;
        UltraWebGrid1.DataBind();
    }
Exemple #28
0
        protected void llenarvacio()
        {
            UltraWebGrid1.ResetColumns();
            UltraWebGrid1.DataBind();
            UltraWebGrid1.Columns.Add("Clave turno");
            UltraWebGrid1.Columns.Add("Descripción");
            UltraWebGrid1.Columns.Add("Hora inicio");
            UltraWebGrid1.Columns.Add("Hora fin");
            UltraWebGrid1.Columns.Add("Activo");


            UltraWebGrid1.Columns[0].Header.Caption = "Clave turno";
            UltraWebGrid1.Columns[1].Header.Caption = "Descripción";
            UltraWebGrid1.Columns[2].Header.Caption = "Hora inicio";
            UltraWebGrid1.Columns[3].Header.Caption = "Hora fin";
            UltraWebGrid1.Columns[4].Header.Caption = "Activo";

            UltraWebGrid1.Columns[0].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[1].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[2].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[3].Header.Style.HorizontalAlign = HorizontalAlign.Center;
            UltraWebGrid1.Columns[4].Header.Style.HorizontalAlign = HorizontalAlign.Center;



            UltraWebGrid1.Columns[4].Width = 70;
        }
    private void setGridData(DataSet iDsSet)
    {
        /*
         * double dblCYActl = 0.00;
         * double dblPYActl = 0.00;
         * double dblDiff = 0.00;
         * double dblRate = 0.00;
         *
         *
         * int intRow = iDsSet.Tables[0].Rows.Count;
         * for (int i = 0; i < intRow; i++)
         * {
         *  dblCYActl += double.Parse(iDsSet.Tables[0].Rows[i]["월실적"].ToString());
         *  dblPYActl += double.Parse(iDsSet.Tables[0].Rows[i]["전년동기실적"].ToString());
         * }
         *
         * DataRow drTmp = iDsSet.Tables[0].NewRow();
         * drTmp["지역명"] = "합       계";
         * drTmp["월실적"] = dblCYActl;
         * drTmp["전년동기실적"] = dblPYActl;
         * drTmp["전년대비증감"] = (dblCYActl - dblPYActl);
         * drTmp["증감율"] = (dblPYActl == 0) ? 0.00 : Math.Round((dblCYActl / dblPYActl) * 100, 2);
         * iDsSet.Tables[0].Rows.InsertAt(drTmp, 0);
         *
         */

        UltraWebGrid1.DataSource = iDsSet;
        UltraWebGrid1.DataBind();
    }
Exemple #30
0
        private void PerformDataBind()
        {
            performDetailDataRefine();

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

            if (UltraWebGrid1.Rows.Count < 1)
            {
                UltraWebGrid1.Visible = false;
                lblNoData.Text        = "No Data was found!";
                lblNoData.Visible     = true;
            }
            else
            {
                lblNoData.Visible = false;
            }

            foreach (UltraGridColumn aColumn in this.UltraWebGrid1.Columns)
            {
                if (aColumn.DataType == "System.DateTime")
                {
                    aColumn.Format = "MM/dd/yyyy";
                }
            }
        }