private void GridBinding22(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]; UltraWebGrid2.Clear(); UltraWebGrid2.DataSource = BizUtility.GetDeptTree(" "); UltraWebGrid2.DataBind(); }
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(); }
private string GetWeightName(string est_id, string weight_type, ref string weight) { string reVal = "<b>가중치</b><br>"; string weight_name = string.Empty; if (weight_type.Equals("DPT")) { DataRow[] rows = DS_DETAIL.Tables[0].Select(string.Format(" EST_ID = '{0}' ", est_id)); if (rows.Length > 0) { weight = (rows[0]["WEIGHT"].ToString().Equals("")) ? "" : rows[0]["WEIGHT"].ToString(); } else { weight = ""; } if (weight.Equals("")) { weight_name = ""; } else { weight_name = " 부서:" + weight + "%"; } } else if (weight_type.Equals("POS")) { Biz_DeptPosDetails biz = new Biz_DeptPosDetails(); DataSet ds = biz.GetDeptPosDetail(COMP_ID , ESTTERM_REF_ID , DataTypeUtility.GetToInt32(TreeView1.SelectedNode.Value) , est_id); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { string no = " " + row["SEQ"].ToString() + "."; string pos_id = GetPosName(row["POS_ID"].ToString(), row["POS_VALUE"].ToString()); weight = (row["WEIGHT"].ToString().Equals("")) ? "" : row["WEIGHT"].ToString() + "%" + "<br>"; weight_name += no + pos_id + weight; } } else { weight_name = ""; } } reVal += weight_name; if (reVal.Equals("<b>가중치</b><br>")) { return(""); } return(reVal); }
protected void UltraWebGrid1_InitializeLayout(object sender, LayoutEventArgs e) { UltraGridUtility.CreateColumns((UltraWebGrid)sender , COMP_ID , EST_ID , DEFAULT_INDEX_COUNT , out DT_COLUMN_INFO , (OwnerTypeMode == OwnerType.Dept) ? "D" : "P" , EST_JOB_IDS.Split(',') , DEPT_COLUMN_NO_USE_YN); if (e.Layout.Bands[0].Columns.Exists("selchk")) { if (!e.Layout.Bands[0].Columns.FromKey("selchk").Hidden) { e.Layout.Bands[0].Columns.FromKey("selchk").Hidden = true; } } // 가중치 컬럼을 사용할 경우 if (COL_WEIGHT_VISIBLE_YN.Equals("Y") || COL_GRADE_VISIBLE_YN.Equals("Y")) { Biz_DeptEstDetails deptEstDetail = null; Biz_DeptPosDetails deptPosDetail = null; DataTable dtDeptDetail = null; DataRow[] drArrColumn = DT_COLUMN_INFO.Select(@"COL_STYLE_ID = 'BIZ' AND VISIBLE_YN = 'Y'"); foreach (DataRow drColumn in drArrColumn) { if (drColumn["COL_KEY"].ToString().IndexOf("WEIGHT_") < 0) { continue; } string est_id = drColumn["COL_KEY"].ToString().Replace("WEIGHT_", ""); Biz_EstInfos estSubInfo = new Biz_EstInfos(COMP_ID, est_id); if (estSubInfo.Weight_Type != null && estSubInfo.Weight_Type.Equals("DPT")) { deptEstDetail = new Biz_DeptEstDetails(); dtDeptDetail = deptEstDetail.GetDeptEstDetail(COMP_ID, ESTTERM_REF_ID, 0, est_id).Tables[0]; } else if (estSubInfo.Weight_Type != null && estSubInfo.Weight_Type.Equals("POS")) { deptPosDetail = new Biz_DeptPosDetails(); dtDeptDetail = deptPosDetail.GetDeptPosDetail(COMP_ID, ESTTERM_REF_ID, 0, est_id).Tables[0]; } if (DT_DEPT_EST_POS_DETAIL == null) { DT_DEPT_EST_POS_DETAIL = dtDeptDetail; } else { DT_DEPT_EST_POS_DETAIL.Merge(dtDeptDetail); } } } e.Layout.ClientSideEvents.MouseOverHandler = RPT_DTL_ID + e.Layout.ClientSideEvents.MouseOverHandler; e.Layout.ClientSideEvents.DblClickHandler = RPT_DTL_ID + e.Layout.ClientSideEvents.DblClickHandler; }