protected void Page_Load(object sender, EventArgs e) { ltrScript.Text = ""; SetQueryStringData(); if (EST_DEPT_REF_ID == 0) { Biz_EstDeptOrgDetails estDeptOrgDetail = new Biz_EstDeptOrgDetails(); EST_DEPT_REF_ID = estDeptOrgDetail.GetEstDeptRefID(ESTTERM_REF_ID, EMP_REF_ID); if (EST_DEPT_REF_ID < 1) { this.Page.ClientScript.RegisterClientScriptBlock(typeof(string), "noAccess", JSHelper.GetAlertBackScript("권한이 없습니다.")); } } if (!IsPostBack) { WebCommon.FillEstTree(trvEstDept, ESTTERM_REF_ID, EMP_REF_ID); txtDeptID.Text = EST_DEPT_REF_ID.ToString(); WebCommon.SetExternalScoreCheckBox(chkApplyExtScore, ESTTERM_REF_ID); chkApplyExtScore.Checked = this.IExtKpiYN; ViewKPI = true; SetCtrlSetting(ESTTERM_REF_ID , int.Parse(txtDeptID.Text)); } }
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e) { Biz_EstDeptOrgMaps estDeptOrgMap = new Biz_EstDeptOrgMaps(Convert.ToInt32(TreeView1.SelectedNode.Value)); txtDeptName_Org.Text = estDeptOrgMap.Dept_Name_Org; txtSort_Org.Text = estDeptOrgMap.Sort_Org.ToString(); PageUtility.FindByValueDropDownList(ddlHearderType, estDeptOrgMap.Header_Img_Org.ToString()); PageUtility.FindByValueDropDownList(ddlDeptType, estDeptOrgMap.Dept_Type.ToString()); SetVisibleButton(); GridBinding(); CheckDrillDownYN(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)); Biz_EstDeptOrgDetails estDeptOrgDetail = new Biz_EstDeptOrgDetails(); cBoxEstDeptTopYN.Checked = estDeptOrgDetail.IsEstDeptTopYN(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), Convert.ToInt32(TreeView1.SelectedNode.Value)); if (iBtnSave_1.Visible == false) { iBtnSave_1.Visible = true; //iBtnSave_2.Visible = true; //itnClearEstDeptOrg.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { int i = DateTime.Now.Second; //if (i > 0 && i <= 20) // ImageType = "1"; //else if (i > 20 && i <= 40) // ImageType = "2"; //else // ImageType = "3"; ImageType = "19"; Biz_EstDeptOrgDetails estDeptOrgDetail = new Biz_EstDeptOrgDetails(); Biz_EstDeptOrgMaps estDeptOrgMap = null; int ESTTERM_REF_ID = GetRequestByInt("ESTTERM_REF_ID"); int MONTH = GetRequestByInt("TMCODE"); int EST_DEPT_REF_ID = GetRequestByInt("EST_DEPT_REF_ID");; if (Request["DRILLDOWN_YN"] == null) { EST_DEPT_REF_ID = estDeptOrgDetail.GetEstDeptRefID(ESTTERM_REF_ID); estDeptOrgMap = new Biz_EstDeptOrgMaps(ESTTERM_REF_ID, MONTH); estDeptOrgMap.Emp_Ref_ID = EMP_REF_ID; estDeptOrgMap.Is_Embed = true; estDeptOrgMap.Est_Dept_Ref_ID = EST_DEPT_REF_ID; //estDeptOrgMap.Est_Dept_Ref_ID = GetRequestByInt("EST_DEPT_REF_ID", EST_DEPT_REF_ID); ltrScript.Text = estDeptOrgMap.GetHtml(); } else if (GetRequest("DRILLDOWN_YN").Equals("X")) { ltrScript.Text = string.Format("<script language=javascript> parent.location.href='../BSC/BSC0406S1.aspx?ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&YMD={2}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, MONTH); } else if (GetRequest("DRILLDOWN_YN").Equals("N")) { //Literal1.Text = string.Format("<script language=javascript> parent.location.href='usr10001.aspx?ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&TMCODE={2}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, MONTH); ltrScript.Text = string.Format("<script language=javascript> parent.location.href='usr10001.aspx?ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&TMCODE={2}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, MONTH); //usr_ana_view.aspx } else { if (estDeptOrgDetail.IsDrillDownPosible(ESTTERM_REF_ID, EST_DEPT_REF_ID)) { estDeptOrgMap = new Biz_EstDeptOrgMaps(ESTTERM_REF_ID, MONTH); estDeptOrgMap.Emp_Ref_ID = EMP_REF_ID; estDeptOrgMap.Is_Embed = true; estDeptOrgMap.Est_Dept_Ref_ID = EST_DEPT_REF_ID; ltrScript.Text = estDeptOrgMap.GetHtml(); } else { //Literal1.Text = string.Format("<script language=javascript> parent.location.href='usr10001.aspx?ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&TMCODE={2}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, MONTH); ltrScript.Text = string.Format("<script language=javascript> parent.location.href='usr10001_embed.aspx?ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&TMCODE={2}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, MONTH); } } }
protected void itnClearDeptDrill_Click(object sender, ImageClickEventArgs e) { Biz_EstDeptOrgDetails estDeptOrgDetail = new Biz_EstDeptOrgDetails(); estDeptOrgDetail.RemoveEstDeptOrgDetail(null, null, PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), int.Parse(TreeView1.SelectedValue), 0); iBtnSearch_Click(null, null); BindingOrgType(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)); iBtnSave_1.Visible = false; }
protected void itnClearEstDeptOrg_Click(object sender, ImageClickEventArgs e) { Biz_EstDeptOrgDetails estDeptOrgDetail = new Biz_EstDeptOrgDetails(); estDeptOrgDetail.RemoveEstDeptOrgDetail(null, null, PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), 0, 0); iBtnSearch_Click(null, null); BindingOrgType(PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)); iBtnSave_1.Visible = false; //iBtnSave_2.Visible = false; //itnClearEstDeptOrg.Visible = false; }
private void CheckDrillDownYN(int estterm_ref_id) { Biz_EstDeptOrgDetails estDeptOrgDetail = new Biz_EstDeptOrgDetails(); bool isDrilldown = estDeptOrgDetail.IsDrillDown(estterm_ref_id); rtlDrildownYN.ClearSelection(); if (isDrilldown) { rtlDrildownYN.SelectedIndex = 0; } else { rtlDrildownYN.SelectedIndex = 1; } }
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(); } } }
protected void Page_Load(object sender, EventArgs e) { string master_site = WebUtility.GetConfig("SITE", "") + "/"; ImageType = WebUtility.GetConfig("DEPT_ORG_IMAGE", "1"); string back_img = string.Format("background-image:url(../images/{0}org/back_org_{1}.jpg); background-position:top; background-repeat:repeat-x", master_site, ImageType); //legend 위치 - 루트노드에서 우측으로 위치 legend_offsetLeft = WebUtility.GetRequestByInt("LEGEND_OFFSETLEFT", 150); legend_offsetTop = WebUtility.GetRequestByInt("LEGEND_OFFSETTOP", 15); legend_colCnt = WebUtility.GetRequestByInt("LEGEND_COLCNT", 1); tblMain.Attributes.Add("style", back_img); // 조직상황판 백그라운드 이미지 타입 (1부터 시작) Biz_EstDeptOrgDetails estDeptOrgDetail = new Biz_EstDeptOrgDetails(); Biz_EstDeptOrgMaps estDeptOrgMap = null; int ESTTERM_REF_ID = GetRequestByInt("ESTTERM_REF_ID"); int MONTH = GetRequestByInt("TMCODE"); int EST_DEPT_REF_ID = GetRequestByInt("EST_DEPT_REF_ID"); string EXT_KPI_YN = GetRequest("EXT_KPI_YN", "N"); DEPT_ORG_SCORE_USE_YN = WebUtility.GetConfig("DEPT_ORG_SCORE_USE_YN", "Y"); WORKING_MAP_USE_YN = WebUtility.GetConfig("WORKING_MAP_USE_YN", "N"); WebUtility.GetConfig("", ""); string lineColor = "#cccccc"; string lineWidth = "2"; if (Request["DRILLDOWN_YN"] == null) { EST_DEPT_REF_ID = estDeptOrgDetail.GetEstDeptRefID(ESTTERM_REF_ID); bool Include_Ext_Kpi_Score = (EXT_KPI_YN == "Y") ? true : false; if (legend_colCnt > 0) { estDeptOrgMap = new Biz_EstDeptOrgMaps(ESTTERM_REF_ID, MONTH, Include_Ext_Kpi_Score, lineColor, lineWidth, legend_colCnt); } else { estDeptOrgMap = new Biz_EstDeptOrgMaps(ESTTERM_REF_ID, MONTH, Include_Ext_Kpi_Score, lineColor, lineWidth); } estDeptOrgMap.Emp_Ref_ID = EMP_REF_ID; estDeptOrgMap.Est_Dept_Ref_ID = GetRequestByInt("EST_DEPT_REF_ID", EST_DEPT_REF_ID); estDeptOrgMap.DeptTitleWidth = 152; estDeptOrgMap.DeptTitleHeight = 39; estDeptOrgMap.SignalPaddingRight = 3; ltrScript.Text = estDeptOrgMap.GetHtml(); } else if (GetRequest("DRILLDOWN_YN").Equals("X")) { ltrScript.Text = string.Format("<script language=javascript> parent.location.href='/BSC/BSC0404S1.aspx?ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&YMD={2}&SUM_TYPE=MS&EXT_KPI_YN={3}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, MONTH, EXT_KPI_YN); } else if (GetRequest("DRILLDOWN_YN").Equals("N")) { ///ltrScript.Text = string.Format("<script language=javascript> parent.location.href='usr_ana_view.aspx?ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&TMCODE={2}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, MONTH); ltrScript.Text = string.Format("<script language=javascript> parent.location.href='usr10001.aspx?ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&YMD={2}&EXT_KPI_YN={3}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, MONTH, EXT_KPI_YN); } else if (GetRequest("DRILLDOWN_YN").Equals("S")) { ltrScript.Text = string.Format("<script language=javascript> parent.location.href='/BSC/BSC0403S4.aspx?ITYPE=POP&ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&YMD={2}&SUM_TYPE=MS&EXT_KPI_YN={3}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, MONTH, EXT_KPI_YN); } else if (GetRequest("DRILLDOWN_YN").Equals("W")) { ltrScript.Text = string.Format("<script language=javascript> parent.location.href='usr10002.aspx?ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&EXT_KPI_YN={2}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, EXT_KPI_YN); } else { if (estDeptOrgDetail.IsDrillDownPosible(ESTTERM_REF_ID, EST_DEPT_REF_ID)) { estDeptOrgMap = new Biz_EstDeptOrgMaps(ESTTERM_REF_ID, MONTH); estDeptOrgMap.Emp_Ref_ID = EMP_REF_ID; estDeptOrgMap.Est_Dept_Ref_ID = EST_DEPT_REF_ID; ltrScript.Text = estDeptOrgMap.GetHtml(); } else { //ltrScript.Text = string.Format("<script language=javascript> parent.location.href='usr_ana_view.aspx?ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&TMCODE={2}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, MONTH); ltrScript.Text = string.Format("<script language=javascript> parent.location.href='usr10001.aspx?ESTTERM_REF_ID={0}&EST_DEPT_REF_ID={1}&YMD={2}&EXT_KPI_YN={3}'; </script>", ESTTERM_REF_ID, EST_DEPT_REF_ID, MONTH, EXT_KPI_YN); } } }
protected void iBtnSave_2_Click(object sender, ImageClickEventArgs e) { UltraGridRow row; CheckBox cBoxHome_YN_Org; CheckBox cBoxHeader_YN_Org; CheckBox cBoxContent_YN_Org; DropDownList ddlPosition_Org; TemplatedColumn home_yn_col; TemplatedColumn header_yn_col; TemplatedColumn content_yn_col; TemplatedColumn position_col; int est_dept_ref_id = 0; string ynStr = "N"; Biz_DeptTypeInfo deptTypeInfo = new Biz_DeptTypeInfo(); Biz_EstDeptOrgDetails estDeptOrgDetail = new Biz_EstDeptOrgDetails(); IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { // 드릴다운 사용 안할 때 if (rtlDrildownYN.SelectedValue.Equals("0")) { if (TreeView1.Nodes.Count > 0) { est_dept_ref_id = int.Parse(TreeView1.Nodes[0].Value); } else { ltrScript.Text = JSHelper.GetAlertScript("조직정보가 없습니다.", false); return; } ynStr = "Y"; estDeptOrgDetail.RemoveEstDeptOrgDetail(conn, trx, PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), 0, 0); } else // 드릴다운 사용 { if (TreeView1.SelectedNode != null) { est_dept_ref_id = int.Parse(TreeView1.SelectedValue); estDeptOrgDetail.ModifyEstDeptOrgDetail(conn, trx, PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), "N"); estDeptOrgDetail.RemoveEstDeptOrgDetail(conn, trx, PageUtility.GetIntByValueDropDownList(ddlEstTermInfo), est_dept_ref_id, 0); } else { ltrScript.Text = JSHelper.GetAlertScript("드릴다운 방식으로 하실 때에는 조직 부서를 선택하셔야 합니다.", false); return; } ynStr = TypeUtility.GetBooleanToYN(cBoxEstDeptTopYN.Checked); } for (int i = 0; i < UltraWebGrid1.Rows.Count; i++) { row = UltraWebGrid1.Rows[i]; home_yn_col = (TemplatedColumn)row.Band.Columns.FromKey("HOME_YN_ORG"); header_yn_col = (TemplatedColumn)row.Band.Columns.FromKey("HEADER_YN_ORG"); content_yn_col = (TemplatedColumn)row.Band.Columns.FromKey("CONTENT_YN_ORG"); position_col = (TemplatedColumn)row.Band.Columns.FromKey("POSITION_ORG"); cBoxHome_YN_Org = (CheckBox)((CellItem)home_yn_col.CellItems[row.BandIndex]).FindControl("cBoxHome_YN_Org"); cBoxHeader_YN_Org = (CheckBox)((CellItem)header_yn_col.CellItems[row.BandIndex]).FindControl("cBoxHeader_YN_Org"); cBoxContent_YN_Org = (CheckBox)((CellItem)content_yn_col.CellItems[row.BandIndex]).FindControl("cBoxContent_YN_Org"); ddlPosition_Org = (DropDownList)((CellItem)position_col.CellItems[row.BandIndex]).FindControl("ddlPosition_Org"); estDeptOrgDetail.AddEstDeptOrgDetail(conn , trx , PageUtility.GetIntByValueDropDownList(ddlEstTermInfo) , est_dept_ref_id , int.Parse(row.Cells.FromKey("TYPE_REF_ID").Value.ToString()) , TypeUtility.GetBooleanToYN(cBoxHome_YN_Org.Checked) , TypeUtility.GetBooleanToYN(cBoxHeader_YN_Org.Checked) , TypeUtility.GetBooleanToYN(cBoxContent_YN_Org.Checked) , ynStr , int.Parse(ddlPosition_Org.SelectedValue) , gUserInfo.Emp_Ref_ID); if (cBoxHome_YN_Org.Checked || cBoxHeader_YN_Org.Checked) { ddlPosition_Org.Enabled = true; } else { ddlPosition_Org.Enabled = false; } } trx.Commit(); ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장되었습니다.", false); } catch (Exception ex) { trx.Rollback(); conn.Close(); } finally { conn.Close(); } }