protected void llenarvacio() { UltraWebGrid1.ResetColumns(); UltraWebGrid1.DataBind(); UltraWebGrid1.Columns.Add("Almacén"); UltraWebGrid1.Columns.Add("Planta"); UltraWebGrid1.Columns.Add("Linea de producción"); UltraWebGrid1.Columns.Add("Proceso"); UltraWebGrid1.Columns.Add("Centro de trabajo"); UltraWebGrid1.Columns.Add("Área"); UltraWebGrid1.Columns.Add("Máquina"); UltraWebGrid1.Columns[0].Header.Caption = "Almacén"; UltraWebGrid1.Columns[1].Header.Caption = "Planta"; UltraWebGrid1.Columns[2].Header.Caption = "Linea de prod."; UltraWebGrid1.Columns[3].Header.Caption = "Proceso"; UltraWebGrid1.Columns[4].Header.Caption = "Centro de trabajo"; UltraWebGrid1.Columns[5].Header.Caption = "Área"; UltraWebGrid1.Columns[6].Header.Caption = "Máquina"; UltraWebGrid1.Columns[2].Width = 135; UltraWebGrid1.Columns[4].Width = 120; UltraWebGrid1.Columns[2].CellStyle.HorizontalAlign = HorizontalAlign.Center; 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; }
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; } }
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 TreeView1_SelectedNodeChanged(object sender, EventArgs e) { string deptId = TreeView1.SelectedNode.Value; UltraWebGrid1.DataSource = GetEmpInfoList(deptId); UltraWebGrid1.DataBind(); }
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(" "); UltraWebGrid1.DataSource = dataTable; UltraWebGrid1.DataBind(); lblRowCount.Text = dataTable.Rows.Count.ToString(); }
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; }
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 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; }
private void SearchDB() { UltraWebGrid1.DataSource = GetSearchData(); UltraWebGrid1.DataBind(); //SearchDetail("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 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); } }
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(); }
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"; } } }
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; }
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; }
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; }
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"); }
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; }
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 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; }
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); }
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; }
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; }
private void BindGrid() { UltraWebGrid1.Clear(); UltraWebGrid1.DataSource = _questionDefine.GetQuestionDefine(EST_ID); UltraWebGrid1.DataBind(); }
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); }
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(); }
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"; // } // } }
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(); }
private void fillGrid() { int rol = Convert.ToInt32(cmbRol.SelectedValue); int modulo = Convert.ToInt32(cmbModulo.SelectedValue); hRol.Value = rol.ToString(); hModulo.Value = modulo.ToString(); DataTable dt_actions = new Combos().GetActionSreens(rol, modulo); DataTable dt_screens = new Combos().GetScreens(rol, modulo); DataSet ds = new DataSet(); ds.Tables.Add(dt_screens); ds.Tables.Add(dt_actions); DataRelation drel = new DataRelation("RolPantallas", dt_screens.Columns["cod_pantalla"], dt_actions.Columns["cod_pantalla"]); ds.Relations.Add(drel); UltraWebGrid1.DataSource = ds; UltraWebGrid1.DataBind(); UltraWebGrid1.DisplayLayout.ViewType = Infragistics.WebUI.UltraWebGrid.ViewType.Hierarchical; UltraWebGrid1.DisplayLayout.AllowUpdateDefault = AllowUpdate.Yes; UltraWebGrid1.Columns[0].Type = ColumnType.CheckBox; UltraWebGrid1.Columns[0].EditorControlID = new CheckBox().UniqueID; UltraWebGrid1.Columns[1].Hidden = true; UltraWebGrid1.Columns[2].Width = 320; }