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 DataTable GetRelGroupData(int comp_id, string est_id, int estterm_ref_id) { Biz_EmpInfos empInfo = new Biz_EmpInfos(); Biz_RelGroupInfos relGrpInfo = new Biz_RelGroupInfos(); Biz_RelGroupTgtMaps relGrpTgtMap = new Biz_RelGroupTgtMaps(); DataTable dataTable = relGrpTgtMap.GetDataTableSchema(); DataRow dataRow = null; DataTable dtRelGrp = relGrpInfo.GetRelGroupInfo(comp_id, "", est_id, estterm_ref_id).Tables[0]; foreach (DataRow dataRowRelGrp in dtRelGrp.Rows) { DataTable dtTgt = null; string rel_grp_id = dataRowRelGrp["REL_GRP_ID"].ToString(); string where_sentence = ""; where_sentence = BizUtility.GetRelGroupWhereString(COMP_ID , EST_ID , ESTTERM_REF_ID , rel_grp_id , "TM"); if (OwnerTypeMode == OwnerType.Dept) { dtTgt = empInfo.GetRelDeptList("WHERE", where_sentence, "TM").Tables[0]; } else if (OwnerTypeMode == OwnerType.Emp_User) { dtTgt = empInfo.GetRelEmpList("WHERE", where_sentence, "TM").Tables[0]; } foreach (DataRow dataRowTgt in dtTgt.Rows) { dataRow = dataTable.NewRow(); dataRow["COMP_ID"] = comp_id; dataRow["REL_GRP_ID"] = rel_grp_id; dataRow["EST_ID"] = est_id; dataRow["ESTTERM_REF_ID"] = estterm_ref_id; dataRow["TGT_DEPT_ID"] = dataRowTgt["TGT_DEPT_ID"]; dataRow["TGT_EMP_ID"] = dataRowTgt["TGT_EMP_ID"]; dataRow["DATE"] = DateTime.Now; dataRow["USER"] = EMP_REF_ID; dataTable.Rows.Add(dataRow); } } return(dataTable); }