protected void ugrdMapKpi_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { e.Row.Height = Unit.Pixel(20); DataRowView drw = (DataRowView)e.Data; //if (drw["APPROVAL_STATUS"].ToString() == "0") //{ // e.Row.Cells.FromKey("CONFIRMSTATUS").Value = string.Format("<div class='stext'><img src='../images/icon_x.gif'></div>"); //} //else //{ // e.Row.Cells.FromKey("CONFIRMSTATUS").Value = string.Format("<div class='stext'><img src='../images/icon_o.gif'></div>"); //} TemplatedColumn cCol = (TemplatedColumn)e.Row.Band.Columns.FromKey("APP_STATUS"); System.Web.UI.WebControls.Image objImg = (System.Web.UI.WebControls.Image)((CellItem)cCol.CellItems[e.Row.BandIndex]).FindControl("imgApp"); string strImg = e.Row.Cells.FromKey("APP_STATUS").Value.ToString(); objImg.ImageUrl = Biz_Com_Approval_Info.GetAppImageUrl(strImg); objImg.AlternateText = Biz_Com_Approval_Info.GetAppImageText(strImg); string kpi_ref_id = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_REF_ID").Value); string kpi_name = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_NAME").Value); string url = "<a href='#null' onclick='doPoppingUp_KPI(\"{0}\",\"{1}\")' style=\"color:Navy;\">{2}</a>"; string temp = string.Format(url, IEstTermRefID, kpi_ref_id, kpi_name); e.Row.Cells.FromKey("KPI_NAME").Value = temp; }
protected void ugrdDeptKpi_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { CheckBox chkCheck; TemplatedColumn Col_Check = (TemplatedColumn)e.Row.Band.Columns.FromKey("selchk"); chkCheck = (CheckBox)((CellItem)Col_Check.CellItems[e.Row.BandIndex]).FindControl("cBox"); //e.Row.Cells.FromKey("APP_STATUS_NAME").Value = "Y"; //if (e.Row.Cells.FromKey("APP_STATUS").Value != null) //{ // if (e.Row.Cells.FromKey("APP_STATUS").Value.ToString() != Biz_Type.app_status_complete) // { // chkCheck.Enabled = false; // e.Row.Cells.FromKey("APP_STATUS_NAME").Value = "N"; // } //} //DataRowView drv = (DataRowView)e.Data; //if (drv["COM_DEPT_REF_ID"].ToString() != this.IDEPT_ID.ToString()) // chkCheck.Enabled = false; string kpi_code = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_POOL_REF_ID").Value); string kpi_name = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_NAME").Value); string onclick = "<a href='#null' onclick=\"doLinking_Pool('{0}')\">{1}</a>"; string link = string.Format(onclick, kpi_code, kpi_name); e.Row.Cells.FromKey("KPI_NAME").Value = link; }
public bool RemoveCtrlEstMap(DataTable dataTable) { int affectedRow = 0; IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { foreach (DataRow dataRow in dataTable.Rows) { affectedRow += _ctrlEstMap.Delete(conn , trx , DataTypeUtility.GetValue(dataRow["CTRL_ID"]) , DataTypeUtility.GetValue(dataRow["EST_ID"])); } trx.Commit(); } catch (Exception ex) { trx.Rollback(); return(false); } finally { conn.Close(); } return((affectedRow > 0) ? true : false); }
protected void ugrdKpiResultList_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { DataRowView drw = (DataRowView)e.Data; string strTrend = e.Row.Cells.FromKey("TREND").Value.ToString(); switch (strTrend) { case "UP": e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_e_up.gif'>";; break; case "DOWN": e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_b_down.gif'>";; break; case "FLAT": e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_m.gif'>";; break; default: break; } e.Row.Cells.FromKey("THRESHOLD_IMG").Value = "<div align=center><img src='../images/" + e.Row.Cells.FromKey("THRESHOLD_IMG").Value.ToString() + "'></div>"; double dTemp = 0; string sARate = DataTypeUtility.GetValue(e.Row.Cells.FromKey("ACHV_RATE").Value); e.Row.Cells.FromKey("ACHV_RATE").Value = (double.TryParse(sARate, out dTemp)) ? Convert.ToDouble(sARate.Replace('-', '0')).ToString("#,###,###,##0.00") : sARate; //_iTRow += 1; //lblCountRow.Text = "Total Rows : " + _iTRow.ToString(); }
protected void ugrdDraft_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { DataRowView drw = (DataRowView)e.Data; if (drw["CHECK_YN"].ToString() == "N") { e.Row.Cells.FromKey("CHECK_YN").Text = string.Format("<div class='stext'><img src='../images/icon_x.gif'></div>"); } else { e.Row.Cells.FromKey("CHECK_YN").Text = string.Format("<div class='stext'><img src='../images/icon_o.gif'></div>"); } if (drw["CHECKSTATUS"].ToString() == "N") { e.Row.Cells.FromKey("CHECKSTATUS").Text = string.Format("<div class='stext'><img src='../images/icon_x.gif'></div>"); } else { e.Row.Cells.FromKey("CHECKSTATUS").Text = string.Format("<div class='stext'><img src='../images/icon_o.gif'></div>"); } TemplatedColumn cCol = (TemplatedColumn)e.Row.Band.Columns.FromKey("APP_STATUS"); System.Web.UI.WebControls.Image objImg = (System.Web.UI.WebControls.Image)((CellItem)cCol.CellItems[e.Row.BandIndex]).FindControl("imgApp"); string strImg = DataTypeUtility.GetValue(e.Row.Cells.FromKey("APP_STATUS").Value); objImg.ImageUrl = Biz_Com_Approval_Info.GetAppImageUrl(strImg); objImg.AlternateText = Biz_Com_Approval_Info.GetAppImageText(strImg); }
public Biz_Prj_QuestionPrjMap(int comp_id , int estterm_ref_id , int estterm_sub_id , int estterm_step_id , string est_id , string q_obj_id , int prj_ref_id) { DataSet ds = null; ds = _questionPrjMap.Select(comp_id , estterm_ref_id , estterm_sub_id , estterm_step_id , est_id , q_obj_id , prj_ref_id); DataRow dr; if (ds != null && ds.Tables[0].Rows.Count == 1) { dr = ds.Tables[0].Rows[0]; _estterm_ref_id = DataTypeUtility.GetToInt32(dr["ESTTERM_REF_ID"]); _estterm_sub_id = DataTypeUtility.GetToInt32(dr["ESTTERM_SUB_ID"]); _estterm_step_id = DataTypeUtility.GetToInt32(dr["ESTTERM_STEP_ID"]); _est_id = DataTypeUtility.GetValue(dr["EST_ID"]); _q_obj_id = DataTypeUtility.GetValue(dr["Q_OBJ_ID"]); _prj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]); _update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]); _update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]); } }
/// <summary> /// 평가차수의 총가중치 합 반환 /// </summary> /// <param name="est_id"></param> /// <returns></returns> public static double GetTotalWeightEstTermStep(int comp_id, string est_id) { Biz_EstInfos estInfo = new Biz_EstInfos(comp_id, est_id); Biz_TermStepEstMaps estterm = new Biz_TermStepEstMaps(); DataTable dataTable = estterm.GetTermStepEstMap(comp_id, est_id).Tables[0]; double total = 0; foreach (DataRow dataRow in dataTable.Rows) { // 상향평가가 아닌 가중치만 더한다. if (!DataTypeUtility.GetYNToBoolean(DataTypeUtility.GetValue(dataRow["FIXED_WEIGHT_YN"]))) { total += DataTypeUtility.GetToDouble(dataRow["WEIGHT"]); } } // 만약 상향평가일 경우 고정가중치를 더해준다. if (DataTypeUtility.GetYNToBoolean(estInfo.Fixed_Weight_Use_YN)) { total += DataTypeUtility.GetToDouble(estInfo.Fixed_Weight); } if (total == 0) { return(100); } return(total); }
private void DoBinding(int estTermRefID, int deptID) { UltraWebGrid1.Clear(); MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info(); DataTable dtBscKpiInfo = bizBscKpiInfo.Get_GoalTongDashboard(estTermRefID, deptID); if (dtBscKpiInfo.Rows.Count > 0) { this.ChartView.Visible = true; UltraWebGrid1.DataSource = dtBscKpiInfo; UltraWebGrid1.DataBind(); UltraWebGrid1.Rows[0].Activated = true; int kpi_ref_id = DataTypeUtility.GetToInt32(dtBscKpiInfo.Rows[0]["KPI_REF_ID"]); string kpi_name = DataTypeUtility.GetValue(dtBscKpiInfo.Rows[0]["KPI_NAME"]); DoCharting(kpi_ref_id, kpi_name); } else { this.ChartView.Visible = false; //chartMM.Visible = false; //chartDal.Visible = false; } }
protected void UltraWebGrid1_InitializeRow(object sender, RowEventArgs e) { DataRowView drw = (DataRowView)e.Data; TemplatedColumn hdf_col = (TemplatedColumn)e.Row.Band.Columns.FromKey("CTRL_EMP"); HiddenField hdfTgtEmpID = (HiddenField)((CellItem)hdf_col.CellItems[e.Row.BandIndex]).FindControl("hdfTgtEmpID"); TemplatedColumn txt_col = (TemplatedColumn)e.Row.Band.Columns.FromKey("CTRL_EMP"); TextBox txtTgtEmpName = (TextBox)((CellItem)txt_col.CellItems[e.Row.BandIndex]).FindControl("txtTgtEmpName"); TemplatedColumn ltr_col = (TemplatedColumn)e.Row.Band.Columns.FromKey("CTRL_EMP"); Literal ltrImage = (Literal)((CellItem)ltr_col.CellItems[e.Row.BandIndex]).FindControl("ltrImage"); DataRow[] drArr = DT_TGT_OPINION.Select(string.Format(@"TGT_DEPT_ID = {0}", drw["DEPT_REF_ID"])); ltrImage.Text = string.Format(string.Format("<a href='#null' onclick=\"SelectEmp('{0}', '{1}', '{2}');\"><img align='absMiddle' border='0' src='../images/btn/b_008.gif' /></a>" , hdfTgtEmpID.ClientID , txtTgtEmpName.ClientID , drw["DEPT_REF_ID"])); e.Row.Cells.FromKey("TGT_DEPT_ID").Value = drw["DEPT_REF_ID"]; if (drArr.Length > 0) { hdfTgtEmpID.Value = DataTypeUtility.GetValue(drArr[0]["TGT_EMP_ID"]); txtTgtEmpName.Text = DataTypeUtility.GetValue(drArr[0]["TGT_EMP_NAME"]); } else { } }
protected void iBtnTemplete_Click(object sender, ImageClickEventArgs e) { int cnt = ugrdKPIPool.Rows.Count; string kpi_pool_id_list = string.Empty; for (int i = 0; i < cnt; i++) { UltraGridRow row = ugrdKPIPool.Rows[i]; TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); CheckBox cBox = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox"); if (cBox.Checked) { kpi_pool_id_list += "," + DataTypeUtility.GetValue(row.Cells.FromKey("KPI_POOL_REF_ID").Value); } } if (kpi_pool_id_list.Length > 0) { BizUtility.KPI_POOL_LIST = kpi_pool_id_list.Remove(0, 1); } string url = "BSC0301M4.aspx"; string str = string.Format("gfOpenWindow('{0}', 800, 400, false, false, '_bk');", url); ltrScript.Text = JSHelper.GetSclipt(str); }
public Biz_Boards(string board_id, string board_category_id) { DataSet ds = _board.Select(board_id, board_category_id, 0, ""); DataRow dr; if (ds.Tables[0].Rows.Count == 1) { dr = ds.Tables[0].Rows[0]; _board_id = DataTypeUtility.GetValue(dr["BOARD_ID"]); _board_category_id = DataTypeUtility.GetValue(dr["BOARD_CATEGORY_ID"]); _subject_text = DataTypeUtility.GetValue(dr["SUBJECT_TEXT"]); _content_text = DataTypeUtility.GetValue(dr["CONTENT_TEXT"]); _read_count = DataTypeUtility.GetToInt32(dr["READ_COUNT"]); _attach_no = DataTypeUtility.GetValue(dr["ATTACH_NO"]); _p_board_id = DataTypeUtility.GetValue(dr["P_BOARD_ID"]); _group_id = DataTypeUtility.GetValue(dr["GROUP_ID"]); _level_id = DataTypeUtility.GetToInt32(dr["LEVEL_ID"]); _seq_id = DataTypeUtility.GetToInt32(dr["SEQ_ID"]); _start_date = DataTypeUtility.GetToDateTime(dr["START_DATE"]); _end_date = DataTypeUtility.GetToDateTime(dr["END_DATE"]); _menu_ref_id = DataTypeUtility.GetToInt32(dr["MENU_REF_ID"]); _pop_up_yn = DataTypeUtility.GetValue(dr["POP_UP_YN"]); _write_emp_id = DataTypeUtility.GetToInt32(dr["WRITE_EMP_ID"]); _write_emp_name = DataTypeUtility.GetValue(dr["WRITE_EMP_NAME"]); _update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]); _update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]); } }
public Dac_Prj_Schedule(int iprj_ref_id, int itask_ref_id) { DataSet ds = this.GetOneList(iprj_ref_id, itask_ref_id); DataRow dr; if (ds.Tables[0].Rows.Count > 0) { dr = ds.Tables[0].Rows[0]; _iprj_ref_id = DataTypeUtility.GetToInt32(dr["PRJ_REF_ID"]); _itask_ref_id = DataTypeUtility.GetToInt32(dr["TASK_REF_ID"]); _itask_name = DataTypeUtility.GetValue(dr["TASK_NAME"]); _itask_type = DataTypeUtility.GetValue(dr["TASK_TYPE"]); _itask_weight = DataTypeUtility.GetToDecimal(dr["TASK_WEIGHT"]); _iup_task_ref_id = DataTypeUtility.GetToInt32(dr["UP_TASK_REF_ID"]); _itask_code = DataTypeUtility.GetValue(dr["TASK_CODE"]); _iplan_start_date = dr["PLAN_START_DATE"]; _iplan_end_date = dr["PLAN_END_DATE"]; _iactual_start_date = dr["ACTUAL_START_DATE"]; _iactual_end_date = dr["ACTUAL_END_DATE"]; _iproceed_rate = DataTypeUtility.GetToDecimal(dr["PROCEED_RATE"]); _iatt_file = DataTypeUtility.GetValue(dr["ATT_FILE"]); _icomplete_yn = DataTypeUtility.GetValue(dr["COMPLETE_YN"]); _iisdelete = DataTypeUtility.GetValue(dr["ISDELETE"]); _inode_depth = DataTypeUtility.GetToInt32(dr["NODE_DEPTH"]); _iafter_task_ref_id = DataTypeUtility.GetToInt32(dr["AFTER_TASK_REF_ID"]); _idesction = DataTypeUtility.GetString(dr["DESCTION"]); _icreate_user = DataTypeUtility.GetToInt32(dr["CREATE_USER"]); _icreate_date = DataTypeUtility.GetToDateTime(dr["CREATE_DATE"]); _iupdate_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]); _iupdate_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]); } }
protected void ibnSearch_Click(object sender, ImageClickEventArgs e) { string page_name = ""; string title_name = ""; Dac_EISDatas obj = new Dac_EISDatas(); DataTable dt = obj.GetEISSub(WebUtility.GetIntByValueDropDownList(ddlMain), WebUtility.GetIntByValueDropDownList(ddlSub)); if (dt.Rows.Count > 0) { page_name = DataTypeUtility.GetValue(dt.Rows[0]["PAGE_NAME"]); title_name = DataTypeUtility.GetValue(dt.Rows[0]["TITLE_NAME"]); } ((_common_lib_MicroBSC)this.Master).SetTitle(title_name); if (page_name.IndexOf("?") >= 0) { ifmContent.Attributes.Add("src", string.Format("{0}&ESTTERM_REF_ID={1}&YMD={2}&M_ID={3}&S_ID={4}" , page_name , WebUtility.GetIntByValueDropDownList(ddlEstRefID) , WebUtility.GetIntByValueDropDownList(ddlYMD) , WebUtility.GetIntByValueDropDownList(ddlMain) , WebUtility.GetIntByValueDropDownList(ddlSub))); } else { ifmContent.Attributes.Add("src", string.Format("{0}?ESTTERM_REF_ID={1}&YMD={2}&M_ID={3}&S_ID={4}" , page_name , WebUtility.GetIntByValueDropDownList(ddlEstRefID) , WebUtility.GetIntByValueDropDownList(ddlYMD) , WebUtility.GetIntByValueDropDownList(ddlMain) , WebUtility.GetIntByValueDropDownList(ddlSub))); } }
public bool GetSendMailUser(decimal iapp_ref_id, int iversion_no, int itxr_user, out string sC_EMP_MAIL, out string sP_EMP_MAIL, out string sN_EMP_MAIL) { bool blnRtn = false; DataSet rDs = base.GetAllList(iapp_ref_id, iversion_no); string sEmpRefID = "0"; sC_EMP_MAIL = ""; sP_EMP_MAIL = ""; sN_EMP_MAIL = ""; int iRow = rDs.Tables[0].Rows.Count; for (int i = 0; i < iRow; i++) { sEmpRefID = DataTypeUtility.GetValue(rDs.Tables[0].Rows[i]["EMP_REF_ID"]); if (sEmpRefID == itxr_user.ToString()) { blnRtn = true; sC_EMP_MAIL = DataTypeUtility.GetValue(rDs.Tables[0].Rows[i]["EMP_EMAIL"]); if (i > 0) { sP_EMP_MAIL = DataTypeUtility.GetValue(rDs.Tables[0].Rows[i - 1]["EMP_EMAIL"]); } if ((i + 1) < iRow) { sN_EMP_MAIL = DataTypeUtility.GetValue(rDs.Tables[0].Rows[i + 1]["EMP_EMAIL"]); } break; } } return(blnRtn); }
protected void ibnAddEstData_Click(object sender, ImageClickEventArgs e) { int cnt = UltraWebGrid1.Rows.Count; string dept_ref_id_list = string.Empty; for (int i = 0; i < cnt; i++) { UltraGridRow row = UltraWebGrid1.Rows[i]; TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); CheckBox cBox = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox"); if (cBox.Checked) { dept_ref_id_list += "," + DataTypeUtility.GetValue(row.Cells.FromKey("DEPT_REF_ID").Value); } } if (dept_ref_id_list.Length > 0) { dept_ref_id_list = dept_ref_id_list.Remove(0, 1); } else { dept_ref_id_list = "-1"; } DataTable dtEmp = DataTypeUtility.FilterSortDataTable(DT_ESTTARGETMAP, string.Format(" TGT_DEPT_ID IN ({0}) AND DIRECTION_TYPE = '{1}' ", dept_ref_id_list, ConDIRECTION_TYPE)); DataTable dtDel = DataTypeUtility.GetGroupByDataTable(dtEmp.Copy(), new string[] { "TGT_EMP_ID" }); MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data(); string okMsg = bizEstData.AddData(dtDel , dtEmp , COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ConESTTERM_STEP_ID , ConDIRECTION_TYPE , "N" , DateTime.Now , DateTime.Now , this.gUserInfo.Emp_Ref_ID); if (okMsg.Length == 0) { ltrScript.Text = JSHelper.GetAlertScript("정상 처리 되었습니다.", false); DoBinding_Dept(); DEPT_REF_ID = -1; } else { ltrScript.Text = JSHelper.GetAlertScript(okMsg); } }
public bool SaveDeptPosScaleAll(DataTable dtDept, DataTable dtScaleData) { int affectedRow = 0; IDbConnection conn = DbAgentHelper.CreateDbConnection(); conn.Open(); IDbTransaction trx = conn.BeginTransaction(); try { if (dtScaleData.Rows.Count > 0) { foreach (DataRow dataRowDept in dtDept.Rows) { affectedRow += _deptPosScale.Delete(conn , trx , DataTypeUtility.GetToInt32(dtScaleData.Rows[0]["COMP_ID"]) , DataTypeUtility.GetToInt32(dtScaleData.Rows[0]["ESTTERM_REF_ID"]) , DataTypeUtility.GetToInt32(dataRowDept["DEPT_REF_ID"]) , DataTypeUtility.GetValue(dtScaleData.Rows[0]["EST_ID"]) , 0); } } foreach (DataRow dataRowDept in dtDept.Rows) { foreach (DataRow dataRowScaleData in dtScaleData.Rows) { affectedRow = _deptPosScale.Insert(conn , trx , DataTypeUtility.GetToInt32(dataRowScaleData["COMP_ID"]) , DataTypeUtility.GetToInt32(dataRowScaleData["ESTTERM_REF_ID"]) , DataTypeUtility.GetToInt32(dataRowDept["DEPT_REF_ID"]) , DataTypeUtility.GetValue(dataRowScaleData["EST_ID"]) , DataTypeUtility.GetToInt32(dataRowScaleData["SEQ"]) , DataTypeUtility.GetValue(dataRowScaleData["POS_ID"]) , DataTypeUtility.GetValue(dataRowScaleData["POS_VALUE"]) , DataTypeUtility.GetValue(dataRowScaleData["SCALE_ID"]) , DataTypeUtility.GetToDateTime(dataRowScaleData["DATE"]) , DataTypeUtility.GetToInt32(dataRowScaleData["USER"])); } } trx.Commit(); } catch (Exception ex) { trx.Rollback(); return(false); } finally { conn.Close(); } return((affectedRow > 0) ? true : false); }
protected void UltraWebGrid1_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { DataRowView drw = (DataRowView)e.Data; if (drw["IS_EST"].ToString().Equals("N")) { e.Row.Style.BackColor = Color.FromName("#FFF0F0"); } if (drw["IS_EST"].ToString().Equals("T")) { e.Row.Style.BackColor = Color.FromName("#EBEBEB"); } if (_eOwnerType == OwnerType.Dept) { if (DataTypeUtility.GetToDouble(drw["B_POINT"]) > 0) { e.Row.Cells.FromKey("B_POINT").Style.Font.Bold = true; e.Row.Cells.FromKey("B_POINT").Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand; } if (DataTypeUtility.GetToDouble(drw["A_POINT"]) > 0) { e.Row.Cells.FromKey("A_POINT").Style.Font.Bold = true; e.Row.Cells.FromKey("A_POINT").Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand; } if (!DataTypeUtility.GetValue(drw["B_GRADE"]).Equals("-")) { e.Row.Cells.FromKey("B_GRADE").Style.Font.Bold = true; e.Row.Cells.FromKey("B_GRADE").Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand; } if (!DataTypeUtility.GetValue(drw["A_GRADE"]).Equals("-")) { e.Row.Cells.FromKey("A_GRADE").Style.Font.Bold = true; e.Row.Cells.FromKey("A_GRADE").Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand; } } else if (_eOwnerType == OwnerType.Emp_User) { foreach (DataRow drGrade in DT_GRADE.Rows) { if (DataTypeUtility.GetToInt32(drw["B_" + drGrade["GRADE_ID"].ToString()]) > 0) { e.Row.Cells.FromKey("B_" + drGrade["GRADE_ID"].ToString()).Style.Font.Bold = true; e.Row.Cells.FromKey("B_" + drGrade["GRADE_ID"].ToString()).Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand; } if (DataTypeUtility.GetToInt32(drw["A_" + drGrade["GRADE_ID"].ToString()]) > 0) { e.Row.Cells.FromKey("A_" + drGrade["GRADE_ID"].ToString()).Style.Font.Bold = true; e.Row.Cells.FromKey("A_" + drGrade["GRADE_ID"].ToString()).Style.Cursor = Infragistics.WebUI.Shared.Cursors.Hand; } } } }
protected void ugrdResultStatus_InitializeRow(object sender, RowEventArgs e) { DataRowView dr = (DataRowView)e.Data; UltraGridCell cell; cell = e.Row.Cells.FromKey("THRESHOLD_IMG"); string img = "../images/stg/" + cell.Value.ToString(); e.Row.Cells.FromKey("THRESHOLD_IMG").Text = string.Format("<img alt='' src='{0}'/>", img); if (dr["CHECK_YN"].ToString() == "N") { e.Row.Cells.FromKey("CHECK_YN").Text = string.Format("<div class='stext'><img src='../images/icon_x.gif'></div>"); } else { e.Row.Cells.FromKey("CHECK_YN").Text = string.Format("<div class='stext'><img src='../images/icon_o.gif'></div>"); } string strTrend = e.Row.Cells.FromKey("TREND").Value.ToString(); switch (strTrend) { case "UP": e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_e_up.gif'>";; break; case "DOWN": e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_b_down.gif'>";; break; case "FLAT": e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_m.gif'>";; break; default: break; } _iTRow += 1; lblRowCount.Text = _iTRow.ToString(); string kpi_ref_id = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_REF_ID").Value); string kpi_name = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_NAME").Value); string url = "<a href=\"javascript:gfOpenWindow('../BSC/BSC0304P1.aspx?iType=POP&ESTTERM_REF_ID={0}&KPI_REF_ID={1}&YMD={2}',800,600,'no','no');\" style=\"color:Navy;\">{3}</a>"; e.Row.Cells.FromKey("KPI_NAME").Text = string.Format(url , Estterm_Ref_ID , kpi_ref_id , Ymd , kpi_name); }
protected void ugrdKPIPoolTemplete_SelectedRowsChange(object sender, SelectedRowsEventArgs e) { if (e.SelectedRows.Count > 0) { txtKpiPoolTempleteID.Text = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("KPI_POOL_TEMPLETE_ID").Value); MODE = "U"; } }
protected void Page_Load(object sender, EventArgs e) { ugrdResultStatus.DisplayLayout.Bands[0].Columns.FromKey("CHAMPION_EMP_NAME").Header.Caption = this.GetText("LBL_00001", "KPI담당자"); ltrScript.Text = "?"; if (!Page.IsPostBack) { WebCommon.SetEstTermDropDownList(ddlEstTermInfo); WebCommon.SetTermMonthDropDownList(ddlMonthInfo, PageUtility.GetIntByValueDropDownList(ddlEstTermInfo)); WebCommon.SetSumTypeDropDownList(ddlSumType, false); WebCommon.SetSignalDropDownList(ddlSignal, true); SetPageData(); if (Request["ESTTERM_REF_ID"] != null) { Estterm_Ref_ID = GetRequestByInt("ESTTERM_REF_ID"); Est_Dept_Ref_ID = GetRequestByInt("EST_DEPT_REF_ID"); hdfDeptID.Value = Est_Dept_Ref_ID.ToString(); Ymd = GetRequest("YMD"); PageUtility.FindByValueDropDownList(ddlEstTermInfo, Est_Dept_Ref_ID); PageUtility.FindByValueDropDownList(ddlMonthInfo, Ymd); //처음로그인시 사용자 부서로 초기 세팅 Est_Dept_Ref_ID = int.Parse(DataTypeUtility.GetValue(gUserInfo.Dept_Ref_ID)); hdfDeptID.Value = Est_Dept_Ref_ID.ToString(); } else { Estterm_Ref_ID = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo); } this.IisAdmin = (User.IsInRole(ROLE_ADMIN) ? "Y" : "N"); if (this.IisAdmin == "Y") { //WebCommon.SetComDeptDropDownList(ddlDeptList, true, gUserInfo.Emp_Ref_ID); //PageUtility.FindByValueDropDownList(ddlDeptList, this.IDEPT_ID); Est_Dept_Ref_ID = int.Parse(DataTypeUtility.GetValue(gUserInfo.Dept_Ref_ID)); WebCommon.SetComDeptDropDownList(ddlDeptList, false, gUserInfo.Emp_Ref_ID); PageUtility.FindByValueDropDownList(ddlDeptList, Est_Dept_Ref_ID); } else { BindDeptList(); } Est_Dept_Ref_ID = int.Parse(DataTypeUtility.GetValue(gUserInfo.Dept_Ref_ID)); SetPageData(); SetResultGrid(); //WebCommon.FillEstTree(trvEstDept, Estterm_Ref_ID, gUserInfo.Emp_Ref_ID); //SetResultGrid(); } }
protected void UltraWebGrid5_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { string EMP_NAME = DataTypeUtility.GetValue(e.Row.Cells.FromKey("EMP_NAME").Value); string EMP_REF_ID = DataTypeUtility.GetValue(e.Row.Cells.FromKey("EMP_REF_ID").Value); string url = "<a href=\"javascript:setOpenerLocation('../BSC/BSC1004S1.ASPX?{1}');\" style=\"color:Navy;\">{0}</a>"; string link = string.Format(url, EMP_NAME, "&EMP_REF_ID=" + EMP_REF_ID); e.Row.Cells.FromKey("EMP_NAME").Text = link; }
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e) { if (e.SelectedRows.Count > 0) { int kpi_ref_id = DataTypeUtility.GetToInt32(e.SelectedRows[0].Cells.FromKey("KPI_REF_ID").Value); string kpi_name = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("KPI_NAME").Value); DoCharting(kpi_ref_id, kpi_name); } }
protected void ugrdKpiResultList_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { TemplatedColumn cCol = (TemplatedColumn)e.Row.Band.Columns.FromKey("APP_STATUS"); System.Web.UI.WebControls.Image objImg = (System.Web.UI.WebControls.Image)((CellItem)cCol.CellItems[e.Row.BandIndex]).FindControl("imgApp"); string strImg = DataTypeUtility.GetValue(e.Row.Cells.FromKey("APP_STATUS").Value); objImg.ImageUrl = Biz_Com_Approval_Info.GetAppImageUrl(strImg); objImg.AlternateText = Biz_Com_Approval_Info.GetAppImageText(strImg); }
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 ugrdInPower_SelectedRowsChange(object sender, Infragistics.WebUI.UltraWebGrid.SelectedRowsEventArgs e) { if (e.SelectedRows.Count > 0) { string cr_year = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("CR_YEAR").Value); string cr_month = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("CR_MONTH").Value); string project_name = DataTypeUtility.GetValue(e.SelectedRows[0].Cells.FromKey("PROJECT_NAME").Value); DoBinding_Emp(cr_year, cr_month, project_name); } }
protected void UltraWebGrid1_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { TEMPLETE_ID = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_POOL_TEMPLETE_ID").Value); TEMPLETE_NAME = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_POOL_TEMPLETE_NAME").Value); MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool_Templete_Map bizBscKpiPoolTempleteMap = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool_Templete_Map(); DataTable dtBscKpiPoolTempleteMap = bizBscKpiPoolTempleteMap.GetBscKpiPoolTempleteMap_DB(TEMPLETE_ID); e.Row.Cells.FromKey("KPI_CNT").Value = dtBscKpiPoolTempleteMap.Rows.Count; }
protected void ugrdSCHD_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { string schd_mid = DataTypeUtility.GetValue(e.Row.Cells.FromKey("schd_mid").Value); string link_dir = DataTypeUtility.GetValue(e.Row.Cells.FromKey("link_dir").Value); string link_page_name = DataTypeUtility.GetValue(e.Row.Cells.FromKey("link_page_name").Value); string url = "<a href='{0}{1}'>{2}</a>"; string link = string.Format(url, link_dir, link_page_name, schd_mid); e.Row.Cells.FromKey("schd_mid").Text = link; }
private string GetPageName(int m_id, int s_id) { Dac_EISDatas obj = new Dac_EISDatas(); DataTable dt = obj.GetEISSub(m_id, s_id); if (dt.Rows.Count > 0) { return(DataTypeUtility.GetValue(dt.Rows[0]["PAGE_NAME"])); } return(""); }
protected void UltraWebGrid1_SelectedRowsChange(object sender, SelectedRowsEventArgs e) { 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 UltraWebGrid3_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { string ESTTERM_REF_ID = DataTypeUtility.GetValue(e.Row.Cells.FromKey("ESTTERM_REF_ID").Value); string YMD = DataTypeUtility.GetValue(e.Row.Cells.FromKey("YMD").Value); string EST_DEPT_REF_ID = DataTypeUtility.GetValue(e.Row.Cells.FromKey("EST_DEPT_REF_ID").Value); string DEPT_NAME = DataTypeUtility.GetValue(e.Row.Cells.FromKey("DEPT_NAME").Value); string url = "<a href='../BSC/BSC0404S1.ASPX?{1}{2}{3}'>{0}</a>"; string link = string.Format(url, DEPT_NAME, "&ESTTERM_REF_ID=" + ESTTERM_REF_ID, "&YMD=" + YMD, "&EST_DEPT_REF_ID=" + EST_DEPT_REF_ID); e.Row.Cells.FromKey("DEPT_NAME").Text = link; }