protected void Page_Load(object sender, EventArgs e) { COMP_ID = GetRequestByInt("COMP_ID"); REL_GRP_ID = GetRequest("REL_GRP_ID"); EST_ID = GetRequest("EST_ID"); ESTTERM_REF_ID = GetRequestByInt("ESTTERM_REF_ID"); ESTTERM_STEP_ID = BizUtility.GetEstTermStepIDByMergeYN(COMP_ID); SENTENCE = BizUtility.GetRelGroupWhereString(COMP_ID , EST_ID , ESTTERM_REF_ID , REL_GRP_ID , "TM"); if (!Page.IsPostBack) { Biz_EstInfos estInfo = new Biz_EstInfos(COMP_ID, EST_ID); OwnerTypeMode = BizUtility.GetOwnerType(estInfo.Owner_Type); DropDownListCommom.BindEstTermSubByYearYN(ddlEstTermSubID, COMP_ID, ""); GridBinding(WebUtility.GetIntByValueDropDownList(ddlEstTermSubID), OwnerTypeMode); } ESTTERM_SUB_ID = WebUtility.GetIntByValueDropDownList(ddlEstTermSubID); ltrScript.Text = ""; }
private void BindingGrid(int comp_id, string est_id, int estterm_ref_id, int estterm_sub_id) { int tgt_emp_id = 0; Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id); OwnerTypeMode = BizUtility.GetOwnerType(estInfo.Owner_Type); if (OwnerTypeMode == OwnerType.Dept) { UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_EMP_NAME").Hidden = true; UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_POS_CLS_NAME").Hidden = true; UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_POS_DUT_NAME").Hidden = true; UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_POS_GRP_NAME").Hidden = true; UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_POS_RNK_NAME").Hidden = true; UltraWebGrid1.DisplayLayout.Bands[0].Columns.FromKey("TGT_POS_KND_NAME").Hidden = true; } Biz_EmpEstTargetMaps empEstTgtMap = new Biz_EmpEstTargetMaps(); DataSet ds = empEstTgtMap.GetEmpEstTargetMap(comp_id , est_id , estterm_ref_id , estterm_sub_id , 0 , 0 , 0 , 0 , tgt_emp_id , OwnerTypeMode); UltraWebGrid1.DataSource = ds; UltraWebGrid1.DataBind(); lblRowCount.Text = ds.Tables[0].Rows.Count.ToString(); }
private void CheckPosGrid(int comp_id, string est_id) { Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id); OwnerTypeMode = BizUtility.GetOwnerType(estInfo.Owner_Type); if (OwnerTypeMode == OwnerType.Dept) { uwgRelGrpPosInfo.Visible = false; uwgRelGrpPosData.Visible = false; trRelPos.Visible = false; trRelPosData.Visible = false; } }
private void DataBindingGrid(int comp_id , string est_id , int estterm_ref_id , int estterm_sub_id , int estterm_step_id , string year_yn , string merge_yn , string owner_type) { _eOwnerType = BizUtility.GetOwnerType(owner_type); 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 , _eOwnerType).Tables[0]; Biz_Grades grade = new Biz_Grades(); DT_GRADE = grade.GetEstGrades(comp_id).Tables[0]; DataTable dataDept = BizUtility.GetDeptTree(" "); if (_eOwnerType == OwnerType.Dept) { dataDept.Columns.Add("B_POINT", typeof(double)); dataDept.Columns.Add("A_POINT", typeof(double)); dataDept.Columns.Add("B_GRADE", typeof(string)); dataDept.Columns.Add("A_GRADE", typeof(string)); dataDept.Columns.Add("IS_EST", typeof(string)); foreach (DataRow dataRow in dataDept.Rows) { dataRow["B_POINT"] = "0"; dataRow["A_POINT"] = "0"; dataRow["B_GRADE"] = "-"; dataRow["A_GRADE"] = "-"; dataRow["IS_EST"] = "N"; } foreach (DataRow drDept in dataDept.Rows) { DataRow[] drEstData = DT_EST_DATA.Select(string.Format("TGT_DEPT_ID = {0}", drDept["DEPT_REF_ID"])); foreach (DataRow dataEstData in drEstData) { drDept["A_POINT"] = DataTypeUtility.GetToDouble(dataEstData["POINT"]); drDept["A_GRADE"] = DataTypeUtility.GetValue(dataEstData["GRADE_ID"]);; drDept["IS_EST"] = "Y"; } } } else if (_eOwnerType == OwnerType.Emp_User) { foreach (DataRow drGrade in DT_GRADE.Rows) { dataDept.Columns.Add("B_" + drGrade["GRADE_ID"].ToString(), typeof(string)); dataDept.Columns.Add("A_" + drGrade["GRADE_ID"].ToString(), typeof(string)); } dataDept.Columns.Add("IS_EST", typeof(string)); foreach (DataRow dataRow in dataDept.Rows) { foreach (DataRow drGrade in DT_GRADE.Rows) { dataRow["B_" + drGrade["GRADE_ID"].ToString()] = "0"; dataRow["A_" + drGrade["GRADE_ID"].ToString()] = "0"; dataRow["IS_EST"] = "N"; } } foreach (DataRow drDept in dataDept.Rows) { DataRow[] drEstData = DT_EST_DATA.Select(string.Format("TGT_DEPT_ID = {0}", drDept["DEPT_REF_ID"])); foreach (DataRow dataEstData in drEstData) { if (dataEstData["GRADE_ID"] != DBNull.Value) { drDept["A_" + DataTypeUtility.GetValue(dataEstData["GRADE_ID"])] = DataTypeUtility.GetToInt32(drDept["A_" + DataTypeUtility.GetValue(dataEstData["GRADE_ID"])]) + 1; } drDept["IS_EST"] = "Y"; } } DataRow dr = dataDept.NewRow(); dr["DEPT_REF_ID"] = -9999; dr["DEPT_NAME"] = "<div align='center'><b>합 계</b></center>"; dr["IS_EST"] = "T"; dataDept.Rows.Add(dr); foreach (DataRow drGrade in DT_GRADE.Rows) { foreach (DataRow drEstSum in dataDept.Rows) { if (DataTypeUtility.GetToInt32(drEstSum["DEPT_REF_ID"]) > 0) { dataDept.Rows[dataDept.Rows.Count - 1]["B_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])] = DataTypeUtility.GetToInt32(dataDept.Rows[dataDept.Rows.Count - 1]["B_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]) + DataTypeUtility.GetToInt32(drEstSum["B_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]); dataDept.Rows[dataDept.Rows.Count - 1]["A_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])] = DataTypeUtility.GetToInt32(dataDept.Rows[dataDept.Rows.Count - 1]["A_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]) + DataTypeUtility.GetToInt32(drEstSum["A_" + DataTypeUtility.GetValue(drGrade["GRADE_ID"])]); } } } } UltraWebGrid1.DataSource = dataDept; UltraWebGrid1.DataBind(); //GridView1.DataSource = dataDept; //GridView1.DataBind(); }