protected void ddlEstID_SelectedIndexChanged(object sender, EventArgs e) { UltraWebGrid1.Clear(); ClearValueControls(); DropDownListCommom.BindQuestionObject(ddlQObjID, hdfSearchEstID.Value, 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 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(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; } }
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); }
protected void ibnSearch_Click(object sender, ImageClickEventArgs e) { DropDownListCommom.BindQuestionObject(ddlQObjID, hdfSearchEstID.Value, true); DropDownListCommom.BindQuestionDefine(ddlQDfnID, hdfSearchEstID.Value, true); UltraWebGrid1.Clear(); ClearValueControls(); }
private void BindGrid() { UltraWebGrid1.Clear(); UltraWebGrid1.DataSource = _questionDefine.GetQuestionDefine(EST_ID); UltraWebGrid1.DataBind(); }
protected void ibnSearch_Click(object sender, ImageClickEventArgs e) { UltraWebGrid1.Clear(); UltraWebGrid2.Clear(); UltraWebGrid3.Clear(); DoBinding_Dept(); }
private void Reload() { UltraWebGrid1.Clear(); UltraWebGrid2.Clear(); DataBindingUnitType(); DataBindingUnit(hdfUnitGroup.Value); txtUnitGroup.Text = ""; }
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(); }
private void BindQuestionGrid() { Biz_QuestionEstMaps questionEstMaps = new Biz_QuestionEstMaps(); UltraWebGrid1.Clear(); ugrdPrjList.Clear(); UltraWebGrid1.DataSource = questionEstMaps.GetQuestionEstMap(EST_ID, ""); UltraWebGrid1.DataBind(); }
protected void iBtnSearch_Click(object sender, ImageClickEventArgs e) { UltraWebGrid1.Clear(); UltraWebGrid2.Clear(); UltraWebGrid2.Bands[0].ResetColumns(); UltraWebGrid3.Clear(); this.TxtBox_Soosik.Text = ""; Project_Bind(); }
private void GridBinding() { this.SetGridHeader(); DataTable rDt = GetDataTable(); UltraWebGrid1.Clear(); UltraWebGrid1.DataSource = rDt.DefaultView; UltraWebGrid1.DataBind(); this.BindingChart(Chart1, rDt); }
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; }
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(); }
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)); } }
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(); }
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(); }
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(); } }
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(" "); UltraWebGrid1.DataBind(); }
private void SearchDB() { UltraWebGrid1.Clear(); UltraWebGrid1.DataSource = GetSearchData(); UltraWebGrid1.DataBind(); if (UltraWebGrid1.Rows.Count <= 0) { this.iBtnRoleDel.Visible = false; } else { this.iBtnRoleDel.Visible = true; } }
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(); }
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(); }
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(); }
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(); }
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(); }
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(); } } }
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(); } }