private void DoBinding_TgtEmp() { DataTable DT = bizMulEstTargetPool.Get_MulTgtEmp_List(COMP_ID, DEPT_REF_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID); UltraWebGrid2.DataSource = DT; UltraWebGrid2.DataBind(); }
private void DataBindingMenuRole(int menu_ref_id) { RoleInfos role = new RoleInfos(); UltraWebGrid2.DataSource = role.GetMenuRoles(menu_ref_id); UltraWebGrid2.DataBind(); }
protected void doBind_prjEmp() { UltraWebGrid2.Clear(); MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data(); DT_EMP_EST_DATA = bizEstData.GetEstData(COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID, DIRECTION_TYPE, EST_EMP_ID, 0); MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new Biz_Prj_Data(); string est_id = "3Q";//프로젝트 기여도 평가 EST_ID DT_PRJ_DATA = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID , COMP_ID , est_id , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID); DataTable dtPrj_PM_Data = DataTypeUtility.FilterSortDataTable(DT_PRJ_DATA, "TGT_DEPT_ID=-1 AND TGT_EMP_ID=-1"); object point = dtPrj_PM_Data.Rows[0]["POINT"]; PRJ_POINT = DataTypeUtility.GetString(point); UltraWebGrid2.DataSource = DT_PRJ_DATA; UltraWebGrid2.DataBind(); }
private void DoBinding_Emp(int dept_ref_id) { DataTable dtDeptEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" DEPT_REF_ID = {0} ", dept_ref_id), " EMP_NAME "); UltraWebGrid2.DataSource = dtDeptEmp; UltraWebGrid2.DataBind(); //if (rdoEstTypeList.SelectedIndex.Equals(0)) //{ // MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp bizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp(); //} //else //{ //} if (dtDeptEmp.Rows.Count > 0) { ibnEmp.Enabled = true; } else { ibnEmp.Enabled = false; } }
private void DataLoad() { ApprovalLines app = new ApprovalLines(); UltraWebGrid2.DataSource = app.GetApprovalLine(biz_type_code, EmpID); UltraWebGrid2.DataBind(); }
private void DataBindingRole() { Biz_RoleInfos role = new Biz_RoleInfos(); UltraWebGrid2.DataSource = role.GetRoleInfos(); UltraWebGrid2.DataBind(); }
private void Reload() { UltraWebGrid1.Clear(); UltraWebGrid2.Clear(); DataBindingUnitType(); DataBindingUnit(hdfUnitGroup.Value); txtUnitGroup.Text = ""; }
private void DataBindingUnit(string unit_type) { UnitTypeInfos unitInfo = new UnitTypeInfos(unit_type); DataSet ds = unitInfo.GetAllUnitTypeInfo(unit_type); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); }
protected void ibnSearch_Click(object sender, ImageClickEventArgs e) { UltraWebGrid1.Clear(); UltraWebGrid2.Clear(); UltraWebGrid3.Clear(); DoBinding_Dept(); }
private void DoBinding_InPower() { MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT(); DataTable dtNHIT = bizNHIT.GetInPower(CR_YEAR); UltraWebGrid2.DataSource = dtNHIT; UltraWebGrid2.DataBind(); }
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e) { UltraWebGrid2.Clear(); string TGT_DEPT_ID = e.SelectedRows[0].Cells.FromKey("TGT_DEPT_ID").Value.ToString(); DoBinding_Emp(TGT_DEPT_ID); }
private void BindingPosBiz(string pos_knd_id) { Biz_PositionKindBizMaps posKndBiz = new Biz_PositionKindBizMaps(); DataSet ds = posKndBiz.GetPosKndBizMap(pos_knd_id, ""); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); }
private void KndBizMapGridBinding() { Biz_PositionKindBizMaps maps = new Biz_PositionKindBizMaps(); DataSet ds = maps.GetPosKndBizMaps(); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); }
protected void Project_Detail_Bind() { object StartDate = this.prj_sDate.Value; object EndDate = this.prj_eDate.Value; DataTable DT = bizPmsInfo.Get_Project_Detail(PRJ_ID, (DateTime)StartDate, (DateTime)EndDate); UltraWebGrid2.DataSource = DT; UltraWebGrid2.DataBind(); }
private void DetailGridBinding(string pos_id) { Biz_Positions positions = new Biz_Positions("EST_POSITION_" + pos_id, pos_id); DataSet ds = positions.GetPositions(); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); InitForm(); }
private void BindQuestionGrid() { Biz_QuestionEstMaps questionEstMaps = new Biz_QuestionEstMaps(); UltraWebGrid1.Clear(); UltraWebGrid2.Clear(); UltraWebGrid1.DataSource = questionEstMaps.GetQuestionEstMap(EST_ID, ""); UltraWebGrid1.DataBind(); }
// 평가단계별 등급코드를 가져온다 private void BindThresholdStepList() { Biz_Bsc_Threshold_Step biz = new Biz_Bsc_Threshold_Step(); string strLevel = GetValue(ddlLevel.SelectedValue); DataSet ds = biz.GetThresholdLevelList(strLevel); UltraWebGrid2.DataSource = ds; UltraWebGrid2.DataBind(); }
protected void ibnEmp_Click(object sender, ImageClickEventArgs e) { int cnt = UltraWebGrid2.Rows.Count; string emp_ref_id_list = string.Empty; for (int i = 0; i < cnt; i++) { UltraGridRow row = UltraWebGrid2.Rows[i]; TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); CheckBox cBox = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox"); if (cBox.Checked) { emp_ref_id_list += "," + DataTypeUtility.GetValue(row.Cells.FromKey("EMP_REF_ID").Value); } } DataTable dtEmp = new DataTable(); if (emp_ref_id_list.Length > 0) { emp_ref_id_list = emp_ref_id_list.Remove(0, 1); dtEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" EMP_REF_ID IN ({0}) ", emp_ref_id_list)); } DataTable dtDelEmp = DataTypeUtility.FilterSortDataTable(DT_DEPTEMP, string.Format(" DEPT_REF_ID IN ({0}) ", DEPT_REF_ID)); MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp BizMulEstEmp = new MicroBSC.Integration.MUL.Biz.Biz_Mul_Est_Emp(); string okMsg = BizMulEstEmp.AddEstEmp(dtDelEmp , dtEmp , COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , rdoEstTypeList.SelectedValue , DateTime.Now , this.gUserInfo.Emp_Ref_ID); if (okMsg.Length == 0) { ltrScript.Text = JSHelper.GetAlertScript("정상 처리 되었습니다.", false); DoBinding_Dept(); DEPT_REF_ID = -1; UltraWebGrid2.Clear(); } else { ltrScript.Text = JSHelper.GetAlertScript(okMsg); } }
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 DoBinding_Emp(string TGT_DEPT_ID) { UltraWebGrid2.Clear(); Biz_Mul_Est_Data bizMulEstData = new Biz_Mul_Est_Data(); DataTable DT = bizMulEstData.Get_Est_Status_By_Emp(hdfEstID.Value, ESTTERM_REF_ID.ToString(), ESTTERM_SUB_ID.ToString(), TGT_DEPT_ID); UltraWebGrid2.DataSource = DT; UltraWebGrid2.DataBind(); }
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e) { UltraWebGrid2.Clear(); UltraWebGrid2.Bands[0].ResetColumns(); PRJ_ID = e.SelectedRows[0].Cells.FromKey("PROJECTID").Value.ToString(); Project_Detail_Bind(); Custom_Col_Bind(); Soosik_Bind(); }
private void BindingCommandNameRoleMap(int role_ref_id) { Biz_ButtonCommandRoleMaps btnCmdRoleMap = new Biz_ButtonCommandRoleMaps(); _dtButtonCommandRole = btnCmdRoleMap.GetButtonCommandRoleMap(role_ref_id, "").Tables[0]; Biz_ButtonCommandInfos btnCmdInfo = new Biz_ButtonCommandInfos(); UltraWebGrid2.DataSource = btnCmdInfo.GetButtonCommandInfos(); UltraWebGrid2.DataBind(); }
protected void ibnSearchAll_Click(object sender, ImageClickEventArgs e) { EST_EMP_ID = 0; BindingPosBizByTgt(); BindingTgtEmp(EST_EMP_ID); hdfTgtEmpID.Value = ""; hdfTgtPosKndID.Value = ""; UltraWebGrid2.Clear(); }
private void DataBindingFamily(string sabun) { string query = @"SELECT FAMILY.EMP_SABUN_T, FAMILY.EMP_RELATION, -- 관계 FAMILY.EMP_NAME, -- 가족 명 FAMILY.EMP_BRTH_DATE, -- 생년월일 FAMILY.EMP_JOB -- 직업 FROM SEM_EMPLOYEE_FAMILY FAMILY WHERE FAMILY.EMP_SABUN_T = '" + sabun + @"'"; UltraWebGrid2.DataSource = GetDataSet(query); UltraWebGrid2.DataBind(); }
private void BindEstJob(int comp_id, string est_id) { if (!est_id.Equals("")) { Biz_JobEstMaps jobEstMap = new Biz_JobEstMaps(); _dtEstJobMap = jobEstMap.GetJobEstMap(comp_id, est_id, "").Tables[0]; } Biz_JobInfos jobInfo = new Biz_JobInfos(); UltraWebGrid2.DataSource = jobInfo.GetJobInfos("N"); UltraWebGrid2.DataBind(); }
private void GridBinding2(int comp_id, int estterm_ref_id, string est_id) { Biz_DeptEstDetails deptEstDetail = new Biz_DeptEstDetails(); _dtEstScale = deptEstDetail.GetDeptEstDetail(comp_id, estterm_ref_id, 0, est_id).Tables[0]; Biz_DeptPosScales deptPosScale = new Biz_DeptPosScales(); _dtPosScale = deptPosScale.GetDeptPosScale(comp_id, estterm_ref_id, 0, est_id).Tables[0]; UltraWebGrid2.Clear(); UltraWebGrid2.DataSource = BizUtility.GetDeptTree(" "); UltraWebGrid2.DataBind(); }
private void DoBinding_Emp(string cr_year, string cr_month, string project_name) { UltraWebGrid2.Clear(); MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT(); DataTable dtNHIT = bizNHIT.GetEmpProjectDetail(cr_year , cr_month , project_name); UltraWebGrid2.DataSource = dtNHIT; UltraWebGrid2.DataBind(); lblEmpTotal.Text = string.Format("(Total : {0})", dtNHIT.Rows.Count); }
private void SetGrid2() { UltraWebGrid2.Clear(); MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score bizObj = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Intro_Score(); DataTable dtObj = bizObj.GetOrgRankBonbuDesc(IEstTermRefID, IYmd, "4", "TS", 5); if (dtObj.Rows.Count > 0) { UltraWebGrid2.DataSource = dtObj; UltraWebGrid2.DataBind(); } }
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e) { UltraWebGrid2.Clear(); UltraWebGrid3.Clear(); if (e.SelectedRows.Count > 0) { string dept_name = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("DEPT_NAME").Value); lblTitleDept.Text = string.Format("({0})", dept_name); DEPT_REF_ID = DataTypeUtility.GetToInt32(e.SelectedRows[0].Cells.FromKey("DEPT_REF_ID").Value); DoBinding_Emp(DEPT_REF_ID); } }
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(); }