private object[] GetSelectKpiList(UltraWebGrid grid) { object[] objTemp = new object[grid.Rows.Count]; int objCnt = 0; for (int i = 0; i < grid.Rows.Count; i++) { UltraGridRow gr = grid.Rows[i]; CheckBox chkCheck; TemplatedColumn Col_Check = (TemplatedColumn)gr.Band.Columns.FromKey("selchk"); chkCheck = (CheckBox)((CellItem)Col_Check.CellItems[gr.BandIndex]).FindControl("cBox"); if (chkCheck.Checked) { objTemp[objCnt] = DataTypeUtility.GetToInt32(gr.Cells.FromKey("KPI_POOL_REF_ID").Value); objCnt++; } } objCnt = 0; for (int i = 0; i < objTemp.Length; i++) { if (objTemp[i] == null) { break; } objCnt++; } if (objCnt == 0) { return(null); } object[] rtnObj = new object[objCnt]; for (int i = 0; i < rtnObj.Length; i++) { rtnObj[i] = objTemp[i]; } return(rtnObj); }
protected DataTable Get_SaveDT_EstQuestion() { Biz_QuestionDatas questionDatas = new Biz_QuestionDatas(); DataTable saveDT = questionDatas.GetDataTableSchema(); for (int i = 0; i < ugrdEstQuestion.Rows.Count; i++) { DataRow dr = saveDT.NewRow(); TemplatedColumn tc = (TemplatedColumn)ugrdEstQuestion.Rows[i].Cells.FromKey("Q_ITEM").Column; RadioButtonList rdoQuestionItem = (RadioButtonList)((CellItem)tc.CellItems[i]).FindControl("rdoQuestionItem"); string q_obj_id = Q_OBJ_ID; string q_sbj_id = DataTypeUtility.GetString(ugrdEstQuestion.Rows[i].Cells.FromKey("Q_SBJ_ID").Value); string q_itm_id = DataTypeUtility.GetString(rdoQuestionItem.SelectedValue); dr["COMP_ID"] = COMP_ID; dr["EST_ID"] = EST_ID; dr["ESTTERM_REF_ID"] = ESTTERM_REF_ID; dr["ESTTERM_SUB_ID"] = ESTTERM_SUB_ID; dr["ESTTERM_STEP_ID"] = ESTTERM_STEP_ID; dr["EST_DEPT_ID"] = TGT_DEPT_ID; dr["EST_EMP_ID"] = TGT_EMP_ID; dr["TGT_DEPT_ID"] = TGT_DEPT_ID; dr["TGT_EMP_ID"] = TGT_EMP_ID; dr["Q_OBJ_ID"] = q_obj_id; dr["Q_SBJ_ID"] = q_sbj_id; dr["Q_ITM_ID"] = q_itm_id; dr["POINT"] = 0; dr["GRADE_ID"] = ""; dr["TEXT_VALUE"] = ""; dr["OPINION"] = ""; dr["ATTACH_NO"] = ""; dr["USER"] = gUserInfo.Emp_Ref_ID; saveDT.Rows.Add(dr); } return(saveDT); }
/// <summary> /// Delete multiple containers on the grid /// </summary> private void Delete() { lbError.Visible = false; bool success = true; if (dg != null && dg.Rows != null && dg.Rows.Count > 0) { TemplatedColumn col = (TemplatedColumn)dg.Rows[0].Cells.FromKey("Select").Column; if (col != null) { for (int i = 0; i < col.CellItems.Count; i++) { CellItem cellItem = (CellItem)col.CellItems[i]; Infragistics.WebUI.UltraWebGrid.UltraGridRow r = cellItem.Cell.Row; CheckBox cb = (CheckBox)cellItem.FindControl("g_sd"); if (cb != null) { if (cb.Checked) { HyperCatalog.Business.InputFormContainer ifCObj = HyperCatalog.Business.InputFormContainer.GetByKey(Convert.ToInt32(r.Cells.FromKey("InputFormContainerId").Value)); success = ifCObj.Delete(HyperCatalog.Shared.SessionState.User.Id); if (!success) { UpdateDataView(); lbError.CssClass = "hc_error"; lbError.Text = HyperCatalog.Business.InputFormContainer.LastError; lbError.Visible = true; break; } } } } } } if (success) { UpdateDataView(); } }
private bool SaveEstTermSubMap() { Biz_TermSubEstMaps termSubEstMap = new Biz_TermSubEstMaps(); DataTable dataTable = termSubEstMap.GetDataTableSchema(); DataRow dataRow = null; TemplatedColumn ckb_use_yn = null; CheckBox ckbUseYN = null; TemplatedColumn weight_col = null; TextBox txtWeight = null; for (int i = 0; i < uGridSub.Rows.Count; i++) { UltraGridRow row = uGridSub.Rows[i]; ckb_use_yn = (TemplatedColumn)row.Band.Columns.FromKey("USE_YN"); ckbUseYN = (CheckBox)((CellItem)ckb_use_yn.CellItems[row.BandIndex]).FindControl("cBox"); weight_col = (TemplatedColumn)row.Band.Columns.FromKey("WEIGHT"); txtWeight = (TextBox)((CellItem)weight_col.CellItems[row.BandIndex]).FindControl("txtWeight"); if (ckbUseYN.Checked) { dataRow = dataTable.NewRow(); dataRow["COMP_ID"] = COMP_ID; dataRow["EST_ID"] = TreeView1.SelectedValue; dataRow["ESTTERM_SUB_ID"] = uGridSub.Rows[i].Cells.FromKey("ESTTERM_SUB_ID").Value; dataRow["WEIGHT"] = txtWeight.Text; dataRow["DATE"] = DateTime.Now; dataRow["USER"] = EMP_REF_ID; dataTable.Rows.Add(dataRow); } } return(termSubEstMap.SaveTermSubEstMap(dataTable, COMP_ID, TreeView1.SelectedValue)); }
protected void ugrdGradeList_InitializeRow(object sender, RowEventArgs e) { DataRowView drw = (DataRowView)e.Data; e.Row.Cells.FromKey("ITYPE").Value = "U"; DropDownList ddlTempYN; TemplatedColumn yn_col = (TemplatedColumn)e.Row.Band.Columns.FromKey("USE_YN"); ddlTempYN = (DropDownList)((CellItem)yn_col.CellItems[e.Row.BandIndex]).FindControl("ddlUse_YN"); ddlTempYN.Items.Add(new ListItem("사용", "Y")); ddlTempYN.Items.Add(new ListItem("미사용", "N")); PageUtility.FindByValueDropDownList(ddlTempYN, e.Row.Cells.FromKey("USE_YN").Value.ToString()); CheckBox chkMidGradeTemp; TemplatedColumn home_yn_col; home_yn_col = (TemplatedColumn)e.Row.Band.Columns.FromKey("MID_GRADE_YN"); chkMidGradeTemp = (CheckBox)((CellItem)home_yn_col.CellItems[e.Row.BandIndex]).FindControl("chkMidGrade_YN"); if (drw["MID_GRADE_YN"].ToString() == "Y") { chkMidGradeTemp.Checked = true; } else { chkMidGradeTemp.Checked = false; } chkMidGradeTemp.Attributes.Add("onclick", "return selectChkBox(this, '" + ((UltraWebGrid)sender).ClientID + "');"); }
protected void btnSave_Click(object sender, EventArgs e) { int isAllConvertThis = txtThis.Text == "" ? 0 : DataTypeUtility.GetToInt32(txtThis.Text); int isAllConvertFill = txtThis.Text == "" ? 0 : DataTypeUtility.GetToInt32(txtFill.Text); int rowEffect = 0; for (int i = 0; i < ugrdKpiResultList.Rows.Count; i++) { UltraGridRow row = ugrdKpiResultList.Rows[i]; TemplatedColumn Col_Check = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); System.Web.UI.WebControls.CheckBox chkCheck = (System.Web.UI.WebControls.CheckBox)((CellItem)Col_Check.CellItems[row.BandIndex]).FindControl("cBox"); if (chkCheck.Checked) { double target_ms = txtThis.Text != "" && DataTypeUtility.GetToDouble(txtThis.Text) != 0 ? DataTypeUtility.GetToDouble(txtThis.Text) : DataTypeUtility.GetToDouble((row.Cells.FromKey("RESULT_MS").Value)); double target_ts = txtFill.Text != "" && DataTypeUtility.GetToDouble(txtFill.Text) != 0 ? DataTypeUtility.GetToDouble(txtFill.Text) : DataTypeUtility.GetToDouble((row.Cells.FromKey("RESULT_TS").Value)); int kpi_pool_ref_id = DataTypeUtility.GetToInt32((row.Cells.FromKey("KPI_REF_ID").Value)); int esstid = DataTypeUtility.GetToInt32(ddlEstTermInfo.SelectedValue); string ymd = ddlEstTermMonth.SelectedValue; rowEffect += new Biz_Com_Emp_Info().Update_Result(esstid, kpi_pool_ref_id, ymd, target_ms, target_ts); } } if (rowEffect > 0) { ltrScript.Text = JSHelper.GetAlertScript("저장되었습니다."); txtFill.Text = ""; txtThis.Text = ""; Grid_Bind(); } else { ltrScript.Text = JSHelper.GetAlertScript("저장 실패."); return; } }
private void DoCompare() { string strItems = string.Empty; string preference = "c"; string ContainerTypeCode = ddlContainertype.SelectedValue; int nbItems = 0; for (int i = 0; i < dg.Rows.Count; i++) { TemplatedColumn col = (TemplatedColumn)dg.Rows[i].Cells.FromKey("Select").Column; CheckBox cb = (CheckBox)((CellItem)col.CellItems[i]).FindControl("g_sd"); if (cb.Checked) { strItems += dg.Rows[i].Cells.FromKey("ItemId").Text + ","; nbItems++; } } if (txtCompareComponents.Text != string.Empty) { using (Database database = Utils.GetMainDB()) { using (DataSet ds = database.RunSPReturnDataSet("_Item_CompareAnalyzeSkuList", "", new SqlParameter("@SkuList", txtCompareComponents.Text) )) { database.CloseConnection(); foreach (DataRow dr in ds.Tables[0].Rows) { strItems += dr["ItemId"].ToString() + ","; nbItems++; } } } } if (nbItems > 0) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "DoCompare()", "<script>DoCompare('" + strItems + "', '" + cultureCode + "','" + preference + "','" + ContainerTypeCode + "');</script>"); } }
private void Save() { if (dg.Rows.Count > 0) { bool success = true; success = SessionState.EditedUser.Notifications.RemoveAll(); TemplatedColumn col = (TemplatedColumn)dg.Rows[0].Cells.FromKey("Select").Column; foreach (CellItem cell in col.CellItems) { TemplatedColumn colDelay = (TemplatedColumn)cell.Cell.Row.Cells.FromKey("Delay").Column; CellItem cellItemDelay = (CellItem)colDelay.CellItems[cell.Cell.Row.Index]; CheckBox cb = (CheckBox)cell.FindControl("g_sd"); DropDownList ddDelay = (DropDownList)cellItemDelay.FindControl("ddDelay"); if (cb.Checked) { success = success && SessionState.EditedUser.Notifications.Add(Convert.ToInt32(cell.Cell.Row.DataKey), ddDelay.Enabled ? Convert.ToInt32(ddDelay.SelectedValue) : 0); } } SessionState.EditedUser.ClearNotifications(); BindLists(); if (success) { if (SessionState.EditedUser.Id == SessionState.User.Id) { SessionState.User = SessionState.EditedUser; } lbError.Text = "Data saved!"; lbError.CssClass = "hc_success"; lbError.Visible = true; } else { lbError.Text = "Error, update failed" + HyperCatalog.Business.UserNotification.LastError; lbError.CssClass = "hc_error"; lbError.Visible = true; } } }
/// <summary> /// Save exclusion rule /// </summary> private void Save() { //string containerTypeCode = ddlContainerType.SelectedValue; string msg = string.Empty; if (inputFormTypeCode != ' ') { for (int i = 0; i < dg.Rows.Count; i++) { TemplatedColumn col = (TemplatedColumn)dg.Rows[i].Cells.FromKey("Select").Column; CheckBox cb = (CheckBox)((CellItem)col.CellItems[i]).FindControl("g_sd"); string containerTypeCode = dg.Rows[i].Cells.FromKey("Code").ToString(); if (containerTypeCode.Length == 1 && cb.Checked) { InputFormTypeExclusionRule rule = new InputFormTypeExclusionRule(inputFormTypeCode, Convert.ToChar(containerTypeCode)); if (!rule.Save()) { msg = InputFormTypeExclusionRule.LastError + "\\n"; } } } } if (msg.Length == 0) { lbError.Text = "Data saved!"; lbError.CssClass = "hc_success"; lbError.Visible = true; Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "update", "<script>UpdateParentWithClose();</script>"); } else { lbError.Text = msg; lbError.CssClass = "hc_error"; lbError.Visible = true; } }
/// <summary> /// Delete multiple values on the grid /// </summary> private void Delete() { lbError.Visible = false; for (int i = 0; i < dg.Rows.Count; i++) { TemplatedColumn col = (TemplatedColumn)dg.Rows[i].Cells.FromKey("Select").Column; CheckBox cb = (CheckBox)((CellItem)col.CellItems[i]).FindControl("g_sd"); if (cb.Checked) { LookupValue lgValuesObj = LookupValue.GetByKey(Convert.ToInt32(dg.Rows[i].Cells.FromKey("LookupValueId").Text)); if (!lgValuesObj.Delete()) { lbError.CssClass = "hc_error"; lbError.Text = LookupValue.LastError; lbError.Visible = true; break; } } } UpdateDataView(); }
protected void ImgBtnAddRow_Click(object sender, ImageClickEventArgs e) { int cntRow = 0; ugrdGradeList.Rows.Add(); cntRow = ugrdGradeList.Rows.Count - 1; DropDownList ddlTempYN; TemplatedColumn yn_col = (TemplatedColumn)ugrdGradeList.Columns.FromKey("USE_YN"); ddlTempYN = (DropDownList)((CellItem)yn_col.CellItems[ugrdGradeList.Rows[cntRow].BandIndex]).FindControl("ddlUse_YN"); ddlTempYN.Items.Add(new ListItem("사용", "Y")); ddlTempYN.Items.Add(new ListItem("미사용", "N")); DropDownList ddlTempGradeYN; TemplatedColumn grade_col = (TemplatedColumn)ugrdGradeList.Columns.FromKey("MID_GRADE_YN"); ddlTempGradeYN = (DropDownList)((CellItem)grade_col.CellItems[ugrdGradeList.Rows[cntRow].BandIndex]).FindControl("ddlMidGrade_YN"); //ddlTempGradeYN.Items.Add(new ListItem("사용", "Y")); //ddlTempGradeYN.Items.Add(new ListItem("미사용", "N")); //ddlTempGradeYN.SelectedIndex = 1; UltraGridRow row; row = ugrdGradeList.Rows[cntRow]; ugrdGradeList.Rows[cntRow].Cells.FromKey("ITYPE").Value = "A"; ugrdGradeList.Rows[cntRow].Cells.FromKey("EST_DEPT_TYPE").Value = PageUtility.GetByValueDropDownList(ddlDeptType); ugrdGradeList.Rows[cntRow].Cells.FromKey("TYPE_NAME").Value = PageUtility.GetByTextDropDownList(ddlDeptType); }
protected void ugrdAppList_InitializeRow(object sender, RowEventArgs e) { //string strAppId = e.Row.Cells.FromKey("APP_REF_ID").Value.ToString(); //string strVerNo = e.Row.Cells.FromKey("VERSION_NO").Value.ToString(); //string strAppCd = e.Row.Cells.FromKey("APP_CODE").Value.ToString(); //string strURL = String.Format("<span onclick='OpenAppWin({0},{1})'>{2}</span>", strAppId, strVerNo, strAppCd); //e.Row.Cells.FromKey("APP_CODE").Text = strURL; TemplatedColumn cCol = (TemplatedColumn)e.Row.Band.Columns.FromKey("selchk"); CheckBox chkSel = (CheckBox)((CellItem)cCol.CellItems[e.Row.BandIndex]).FindControl("cBox"); string strAppStatusCd = e.Row.Cells.FromKey("APP_CODE").Value.ToString(); if (strAppStatusCd == Biz_Type.app_status_draft) { chkSel.Enabled = false; } else { chkSel.Enabled = true; } }
protected void UltraWebGrid1_InitializeRow(object sender, RowEventArgs e) { double total_weight = 0; //가중치 합계 double weight = 0; //부서 가중치 //가중치 입력 필드에 바인드 for (int i = 0; i < DEPT_TYPE_REF_ID.Length; i++) { string colName = string.Format("WEIGHT_{0}", DEPT_TYPE_REF_ID[i]); TemplatedColumn tc = (TemplatedColumn)UltraWebGrid1.Columns.FromKey("i" + colName); Infragistics.WebUI.WebDataInput.WebNumericEdit ne = (Infragistics.WebUI.WebDataInput.WebNumericEdit)((CellItem)tc.CellItems[e.Row.Index]).FindControl("WEIGHT"); weight = DataTypeUtility.GetToDouble(e.Row.Cells.FromKey(colName).Value); ne.Value = weight; total_weight += weight; } e.Row.Cells.FromKey("TOTAL_WEIGHT").Value = total_weight; }
protected void btnSave_Click(object sender, EventArgs e) { int result = 0; string type = rdoTarget.SelectedValue; int emp_no = DataTypeUtility.GetToInt32(hdfChampionEmpId.Value); for (int i = 0; i < ugrdKpiList.Rows.Count; i++) { UltraGridRow row = ugrdKpiList.Rows[i]; TemplatedColumn Col_Check = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); CheckBox chkCheck = (CheckBox)((CellItem)Col_Check.CellItems[row.BandIndex]).FindControl("cBox"); if (chkCheck.Checked) { if (type == "0") { result = new Biz_Bsc_Kpi_Pool().AllTargetInsert(emp_no, DataTypeUtility.GetToInt32((row.Cells.FromKey("KPI_POOL_REF_ID").Value)) ); } else { result = new Biz_Bsc_Kpi_Pool().AllResultInsert(emp_no, DataTypeUtility.GetToInt32((row.Cells.FromKey("KPI_POOL_REF_ID").Value)) ); } } } if (result > 0) { ltrScript.Text = JSHelper.GetAlertScript("저장되었습니다."); GridBind(); } else { ltrScript.Text = JSHelper.GetAlertScript("저장 실패."); return; } }
private void ApplyChanges(string s) { for (int i = 0; i < dg.Rows.Count; i++) { TemplatedColumn col = (TemplatedColumn)dg.Rows[i].Cells.FromKey("Select").Column; CheckBox cb = (CheckBox)((CellItem)col.CellItems[i]).FindControl("g_sd"); if (cb.Checked) { Item item = Item.GetByKey(Convert.ToInt64(dg.Rows[i].Cells.FromKey("ItemId").Value)); if (!item.UpdateWorkflowStatus(s, DDL_Cultures.SelectedValue, SessionState.User.Id)) { lbMessage.Text = "Error: impossible to update workflowStatus for the bundle " + item.Name; lbMessage.CssClass = "hc_error"; lbMessage.Visible = true; break; } } } DisplayData(); lbMessage.Text = "Changes applied"; lbMessage.CssClass = "hc_success"; lbMessage.Visible = true; }
protected void ugrdEstOpinion_InitializeRow(object sender, RowEventArgs e) { string sFileId = (e.Row.Cells.FromKey("REVIEW_FILE_ID").Value == null) ? "" : e.Row.Cells.FromKey("REVIEW_FILE_ID").Value.ToString(); TemplatedColumn colEst = (TemplatedColumn)e.Row.Cells.FromKey("EST_LEVEL_NAME").Column; System.Web.UI.WebControls.Label lblLevel = (System.Web.UI.WebControls.Label)((CellItem)colEst.CellItems[e.Row.BandIndex]).FindControl("lblEST_LEVEL_NAME"); System.Web.UI.WebControls.ImageButton btnFile = (System.Web.UI.WebControls.ImageButton)((CellItem)colEst.CellItems[e.Row.BandIndex]).FindControl("iBtnReviewFile"); System.Web.UI.WebControls.HiddenField hdfFile = (System.Web.UI.WebControls.HiddenField)((CellItem)colEst.CellItems[e.Row.BandIndex]).FindControl("iHdfReviewFile"); lblLevel.Text = (e.Row.Cells.FromKey("EST_LEVEL_NAME").Value == null) ? "" : e.Row.Cells.FromKey("EST_LEVEL_NAME").Value.ToString(); if (sFileId.Length > 0) { hdfFile.Value = sFileId; btnFile.Visible = true; btnFile.OnClientClick = "return mfUpload('" + hdfFile.ClientID.Replace("$", "_") + "')"; } else { hdfFile.Value = ""; btnFile.Visible = false; } }
protected void btnMapEdit_Click(object sender, EventArgs e) { int rows = ugrdStgList.Rows.Count; if (rows > 0) { for (int i = 0; i < rows; i++) { UltraGridRow row = ugrdStgList.Rows[i]; TemplatedColumn selchk = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); CheckBox cBox = (CheckBox)((CellItem)selchk.CellItems[row.BandIndex]).FindControl("cBox"); if (cBox.Checked) { int stg_ref_id = DataTypeUtility.GetToInt32(row.Cells.FromKey("STG_REF_ID").Value); int view_ref_id = DataTypeUtility.GetToInt32(row.Cells.FromKey("VIEW_REF_ID").Value); new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().KpiPoolMapEdit(stg_ref_id, view_ref_id); } } ltrScript.Text = JSHelper.GetSclipt("변경 되었습니다."); SetStgGrid(); } //new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Pool().KpiPoolMapEdit(1, 1); }
protected void ugrdEstComment_InitializeRow(object sender, RowEventArgs e) { string self_top_id = DataTypeUtility.GetString(e.Row.Cells.FromKey("SELF_TOP_ID")); DataTable dt_question = DataTypeUtility.FilterSortDataTable(DT_EST_SELF_DATA, string.Format("SELF_TOP_ID={0}", self_top_id)); TemplatedColumn tc = (TemplatedColumn)e.Row.Band.Columns.FromKey("EST_COMMENT"); RadioButtonList rdoEstComment = (RadioButtonList)((CellItem)tc.CellItems[e.Row.Index]).FindControl("rdoEstComment"); rdoEstComment.RepeatDirection = RepeatDirection.Horizontal; rdoEstComment.RepeatLayout = RepeatLayout.Table; rdoEstComment.Width = Unit.Percentage(99); rdoEstComment.DataSource = dt_question; rdoEstComment.DataBind(); DataTable dt_q_selected = DataTypeUtility.FilterSortDataTable(dt_question, string.Format("SELECTED > 0")); if (dt_q_selected.Rows.Count > 0) { WebUtility.FindByValueRadioButtonList(rdoEstComment, DataTypeUtility.GetString(dt_q_selected.Rows[0]["SELF_MID_ID"])); } }
private void InitializeGridGrouping() { int i = 0; int x = dg.Rows.Count; TemplatedColumn col = (TemplatedColumn)dg.Columns.FromKey("Select"); groupCount = 0; while (i < dg.Rows.Count) { string containerGroup = dg.Rows[i].Cells.FromKey("Path").Value.ToString(); if (i == 0 || currentGroup != containerGroup) { currentGroup = containerGroup; dg.Rows.Insert(i, new UltraGridRow()); CheckBox c = (CheckBox)((CellItem)col.CellItems[x]).FindControl("g_sd"); c.Visible = false; Label l = (Label)((CellItem)col.CellItems[x]).FindControl("grp_lbl"); l.Visible = true; l.Text = currentGroup; l.CssClass = "ptbgroup"; l.BorderStyle = BorderStyle.None; UltraGridRow groupRow = dg.Rows[i]; UltraGridCell groupCellMax = groupRow.Cells[dg.Columns.Count - 1]; foreach (UltraGridCell cell in groupRow.Cells) { cell.Style.CssClass = string.Empty; } dg.Rows[i].Style.CssClass = "ptbgroup"; UltraGridCell groupCell = groupRow.Cells.FromKey("Select"); groupCell.Text = containerGroup; groupCell.ColSpan = dg.Columns.Count - 1 - groupCell.Column.Index; i++; x++; } i++; } }
protected int UnSetTarget() { int Result; //DataTable DT = UltraGridUtility.GetDataSetByCheckedBox(UltraWebGrid1 // , new string[] { "PRJ_ID" } // , "selchk" // , "cBox").Tables[0]; DataTable DT = new DataTable(); DT.Columns.Add("PRJ_ID"); foreach (UltraGridRow row in UltraWebGrid1.Rows) { string status = DataTypeUtility.GetString(row.Cells.FromKey("PRJ_EST_STATUS").Value); if (!status.Equals("E")) { TemplatedColumn col_cBox = (TemplatedColumn)row.Band.Columns.FromKey("selchk"); CheckBox cBox = (CheckBox)((CellItem)col_cBox.CellItems[row.BandIndex]).FindControl("cBox"); if (cBox.Checked == true) { DT.Rows.Add(row.Cells.FromKey("PRJ_ID").Value); } } } Result = bizPrjInfo.UnSet_Est_Target(DT); if (DT.Rows.Count == 0) { Result = -1; } return(Result); }
protected void ugrdStgList_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { TemplatedColumn cCol = (TemplatedColumn)e.Row.Band.Columns.FromKey("USE_YN"); Image objImg = (Image)((CellItem)cCol.CellItems[e.Row.BandIndex]).FindControl("imgUseYn"); objImg.ImageUrl = (e.Row.Cells.FromKey("USE_YN").Value.ToString() == "Y") ? "../images/icon_o.gif" : "../images/icon_x.gif"; TemplatedColumn cCol1 = (TemplatedColumn)e.Row.Band.Columns.FromKey("MAPYN"); Image objImg1 = (Image)((CellItem)cCol1.CellItems[e.Row.BandIndex]).FindControl("imgUseMapYn"); objImg1.ImageUrl = (e.Row.Cells.FromKey("MAPYN").Value.ToString() == "Y") ? "../images/icon_o.gif" : "../images/icon_x.gif"; string use_yn = (DataTypeUtility.GetValue(e.Row.Cells.FromKey("USE_YN").Value) == "Y") ? "U" : "D"; string stg_ref_id = DataTypeUtility.GetValue(e.Row.Cells.FromKey("STG_REF_ID").Value); string stg_name = DataTypeUtility.GetValue(e.Row.Cells.FromKey("STG_NAME").Value); string url = "<a href='#' onclick='doPoppingUp_StgList(\"{0}\",\"{1}\",\"{2}\",\"{3}\")'>{4}</a>"; string link = string.Format(url, use_yn, IESTTERM_REF_ID, stg_ref_id, ICCB1, stg_name); e.Row.Cells.FromKey("STG_NAME").Value = link; }
private void BindLists() { SessionState.EditedUser.ClearNotifications(); cv = new HyperCatalog.Business.CollectionView(SessionState.EditedUser.Notifications); dg.DataSource = SessionState.EditedUser.Role.Notifications; dg.DataBind(); Utils.InitGridSort(ref dg, false); if (!SessionState.User.HasCapability(CapabilitiesEnum.MANAGE_USERS) || SessionState.User.IsReadOnly) { TemplatedColumn colHeader = (TemplatedColumn)dg.Columns.FromKey("Select"); HeaderItem cellItemHeader = colHeader.HeaderItem; CheckBox cbHeader = (CheckBox)cellItemHeader.FindControl("g_ca"); cbHeader.Enabled = false; foreach (UltraGridRow r in dg.Rows) { TemplatedColumn col = (TemplatedColumn)r.Cells.FromKey("Select").Column; CellItem cellItem = (CellItem)col.CellItems[r.Index]; CheckBox cb = (CheckBox)cellItem.FindControl("g_sd"); cb.Enabled = false; } } }
public static DataSet GetDataSetByCheckedBox(UltraWebGrid ultraWebGrid , string[] strColumnNames , string strTemplateColumnCheckBoxName , string strCheckBoxName) { DataSet dsReturn = new DataSet(); DataTable dtReturn = new DataTable(); dsReturn.Tables.Add(dtReturn); for (int i = 0; i < strColumnNames.Length; i++) { DataColumn dcColumn = new DataColumn(strColumnNames[i], typeof(string)); dtReturn.Columns.Add(dcColumn); } foreach (UltraGridRow ugRow in ultraWebGrid.Rows) { TemplatedColumn col_cBox = (TemplatedColumn)ugRow.Band.Columns.FromKey(strTemplateColumnCheckBoxName); CheckBox cBox = (CheckBox)((CellItem)col_cBox.CellItems[ugRow.BandIndex]).FindControl(strCheckBoxName); DataRow drNew; if (cBox.Checked == true) { drNew = dtReturn.NewRow(); foreach (DataColumn dcItem in dtReturn.Columns) { drNew[dcItem.ColumnName] = ugRow.Cells.FromKey(dcItem.ColumnName).Value; } dtReturn.Rows.Add(drNew); } } return(dsReturn); }
public void SetRecallDraft() { DataTable dtDraft = new DataTable("RECALL_LIST"); dtDraft.Columns.Add("APP_REF_ID", typeof(int)); dtDraft.Columns.Add("VERSION_NO", typeof(int)); DataRow drDraft = null; int iRow = ugrdAppList.Rows.Count; int iCol = ugrdAppList.Columns.Count; TemplatedColumn cCol = (TemplatedColumn)ugrdAppList.Columns.FromKey("selchk"); CheckBox chkSel = null; for (int i = 0; i < iRow; i++) { chkSel = (CheckBox)((CellItem)cCol.CellItems[ugrdAppList.Rows[i].BandIndex]).FindControl("cBox"); if (chkSel.Checked) { drDraft = dtDraft.NewRow(); drDraft["APP_REF_ID"] = int.Parse(ugrdAppList.Rows[i].Cells.FromKey("APP_REF_ID").Value.ToString()); drDraft["VERSION_NO"] = int.Parse(ugrdAppList.Rows[i].Cells.FromKey("VERSION_NO").Value.ToString()); dtDraft.Rows.Add(drDraft); } } if (dtDraft.Rows.Count > 0) { Biz_Com_Approval_Prc objPrc = new Biz_Com_Approval_Prc(); int iRtnRow = objPrc.RecallDraft(null, null, dtDraft, gUserInfo.Emp_Ref_ID); ltrScript.Text = JSHelper.GetAlertScript(objPrc.Transaction_Message, false); } else { ltrScript.Text = JSHelper.GetAlertScript("선택된 문서가 없습니다.", false); } }
/// <summary> /// Delete the selected translation of the TM Expression /// </summary> private void Delete() { for (int i = 0; i < dg.Rows.Count; i++) { TemplatedColumn col = (TemplatedColumn)dg.Rows[i].Cells.FromKey("Select").Column; CheckBox cb = (CheckBox)((CellItem)col.CellItems[i]).FindControl("g_sd"); if (cb.Checked) { using (TMExpressionTranslation tt = TMExpressionTranslation.GetByKey(expressionId, dg.Rows[i].Cells.FromKey("LanguageCode").ToString())) { if (tt != null) { #region Delete result if (!tt.Delete(HyperCatalog.Shared.SessionState.User.Id)) { lbMessage.Text = "Error: Translation [" + dg.Rows[i].Cells.FromKey("LanguageCode").ToString() + "] can't be deleted"; lbMessage.CssClass = "hc_error"; lbMessage.Visible = true; break; } #endregion } else { lbMessage.Text = "Error: Term translation [" + dg.Rows[i].Cells.FromKey("Language").ToString() + "] can't be deleted - translation not found"; lbMessage.CssClass = "hc_error"; lbMessage.Visible = true; } } } } ShowTMTranslations(); lbMessage.Text = "Data deleted"; lbMessage.CssClass = "hc_success"; lbMessage.Visible = true; }
private void Analyze() { lbError.Visible = false; dg.Visible = false; bool showObsolete; string separator = rbList.SelectedValue; //Code modified for Links Requirement (PR664195) - to show/hide obsolete items based on "Include Obsolete" checkbox by Prachi on 18th Jan 2013 if (bLinkFrom) //Analyzing List of Companion; so consider Include Obsolete option { CheckBox cb = (CheckBox)uwToolbar.Items.FromKeyCustom("chkObs").FindControl("chkObsolete"); showObsolete = cb.Checked; } else { showObsolete = true; } //Code modified for Links Requirement (PR658943) - to allow analyze for higher level Node Names by Prachi on 19th Jan 2013 string inputType = rblInput.SelectedValue.ToUpper(); int levelId; if (inputType.Equals("NAME")) { levelId = Convert.ToInt32(ddlLevel.SelectedValue); } else { levelId = 7; //In case of "SKU" selected in Input Type } try { DataSet ds = Link.LinkAnalyze(itemId, SessionState.Culture.Code, txtSKUs.Text, Convert.ToByte(bLinkFrom), linkTypeId, separator, Convert.ToByte(showObsolete), inputType, levelId); if (ds == null || ds.Tables.Count == 0) { lbError.CssClass = "hc_error"; lbError.Text = "Error in retrieving the Dataset"; lbError.Visible = true; } else { // initialize NbSKUs = 0; if (inputType.Equals("SKU")) { txtSKUs.Text = string.Empty; } // Display grid if (ds != null) { dg.DataSource = ds.Tables[0]; dg.DataBind(); dg.Visible = true; ds.Dispose(); } if (inputType.Equals("NAME")) { LoadLevelDDL(); lbLevel.Enabled = true; ddlLevel.Enabled = true; ddlLevel.Items.Remove("Disabled"); ddlLevel.SelectedValue = Convert.ToString(levelId); } // User can or cannot save bool canProceed = false; bool isHeaderChecked = false; if (txtSKUs.Text.Length > 0) { txtSKUs.Text = txtSKUs.Text.Substring(0, txtSKUs.Text.Length); } foreach (UltraGridRow r in dg.Rows) { if ((r.Cells[colErrorIndex].Text == string.Empty) || (Convert.ToInt32(r.Cells.FromKey("SameLink").Value) == 2 && Convert.ToBoolean(r.Cells.FromKey("IsRelevant").Text))) { canProceed = true; break; } } TemplatedColumn colH = (TemplatedColumn)dg.Columns.FromKey("Select"); CheckBox cbH = (CheckBox)colH.HeaderItem.FindControl("g_ca"); // Display or not Save button if (canProceed) { Ultrawebtoolbar2.Items.FromKeyButton("Export").Enabled = true; cbH.Enabled = true; } else { Ultrawebtoolbar2.Items.FromKeyButton("Export").Enabled = true; cbH.Enabled = false; } //selecting/unselecting the header checkbox foreach (UltraGridRow r in dg.Rows) { CheckBox cbItem = (CheckBox)((CellItem)colH.CellItems[r.Index]).FindControl("g_sd"); if (!cbItem.Enabled && cbItem.Checked) { isHeaderChecked = true; } else if (cbItem.Enabled) { if (!cbItem.Checked) { isHeaderChecked = false; break; } else { isHeaderChecked = true; } } } if (isHeaderChecked) { cbH.Checked = true; } // Count of SKUs to save if (NbSKUs > 0) { LbNbSKUs.Text = NbSKUs.ToString() + "/" + dg.Rows.Count.ToString() + " component(s) found. Please make a selection and Click Save."; } else { LbNbSKUs.Text = "The analyze provided 0 possible components. One component at least is required. Please retry or cancel."; } LbNbSKUs.Text = "<br>" + LbNbSKUs.Text; LbNbSKUs.Visible = true; if (!bLinkFrom) // Informative Message should be displayed only in case of Add Host { AddHostCnt.Value = NbSKUs.ToString(); lbMsg.Text = "You are trying to create " + AddHostCnt.Value + " link(s). These links will only be manageable at product level."; } else { AddHostCnt.Value = "-1"; } } } catch (Exception e) { lbError.CssClass = "hc_error"; lbError.Text = "Input String is not in correct Format! Or separator is not used properly!"; lbError.Visible = true; LbNbSKUs.Visible = false; Ultrawebtoolbar2.Items.FromKeyButton("Export").Enabled = false; } }
protected void dg_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e) { //Code modified for Links Requirement (PR658943) - to allow analyze for higher level Node Names by Prachi on 19th Jan 2013 - start string inputType = rblInput.SelectedValue.ToUpper(); string separator = rbList.SelectedValue; // separator TemplatedColumn col = (TemplatedColumn)e.Row.Cells.FromKey("Select").Column; CheckBox cb = (CheckBox)((CellItem)col.CellItems[e.Row.Index]).FindControl("g_sd"); if (e.Row.Cells.FromKey("IsRelevant").Value != null) { cb.Enabled = Convert.ToBoolean(e.Row.Cells.FromKey("IsRelevant").Text); if (Convert.ToInt16(e.Row.Cells.FromKey("FlagExists").Value) == 1 && Convert.ToInt16(e.Row.Cells.FromKey("SameLink").Value) == 1) { cb.Checked = Convert.ToBoolean(e.Row.Cells.FromKey("FlagExists").Text); } } //Added for Links Requirement (PR664364) - to add Host from Companions - Companion should always be SKU Level Item - start if (!bLinkFrom) // for links From -- Adding a Host { dg.Columns.FromKey("ClassName").Hidden = true; dg.Columns.FromKey("MainItemPath").Hidden = false; dg.Columns.FromKey("ItemPath").Hidden = true; dg.Columns.FromKey("ItemName").Hidden = false; } else // for links To -- Adding a Companion { dg.Columns.FromKey("ClassName").Hidden = false; dg.Columns.FromKey("MainItemPath").Hidden = true; } //Added for Links Requirement (PR664364) - to add Host from Companions - Companion should always be SKU Level Item - end if (inputType.Equals("SKU")) { dg.Columns.FromKey("ItemPath").Hidden = true; dg.Columns.FromKey("ItemName").Hidden = false; // If the proposed Sku is incorrect, change the cell style if (e.Row.Cells[colErrorIndex].Value != null && e.Row.Cells[colErrorIndex].Value.ToString().Length > 0) { if (!Convert.ToBoolean(e.Row.Cells.FromKey("IsRelevant").Value)) { e.Row.Cells.FromKey("ItemName").Style.CssClass = "hc_error"; } if (!Convert.ToBoolean(e.Row.Cells.FromKey("IsRelevant").Value) && Convert.ToInt32(e.Row.Cells.FromKey("SameLink").Value) != 2) { e.Row.Cells.FromKey("ItemName").Text = "<b>[" + e.Row.Cells.FromKey("ItemNumber").Text + "]</b> - " + e.Row.Cells[colErrorIndex].Value.ToString(); } else { e.Row.Cells.FromKey("ItemName").Text = e.Row.Cells.FromKey("ItemName").Text + " <b>[" + e.Row.Cells.FromKey("ItemNumber").Text + "] - " + e.Row.Cells[colErrorIndex].Value.ToString() + "</b>"; } if (Convert.ToInt32(e.Row.Cells.FromKey("SameLink").Value) == 2 && Convert.ToBoolean(e.Row.Cells.FromKey("IsRelevant").Text)) { if (txtSKUs.Text.Length > 0 && !txtSKUs.Text.Contains(e.Row.Cells.FromKey("ItemNumber").Text)) { if (separator.Equals("R")) { txtSKUs.Text += "\r\n"; } else { txtSKUs.Text += separator; } } if (!txtSKUs.Text.Contains(e.Row.Cells.FromKey("ItemNumber").Text)) { txtSKUs.Text += e.Row.Cells.FromKey("ItemNumber").Text; } NbSKUs++; } } else { e.Row.Cells.FromKey("ItemName").Text = e.Row.Cells.FromKey("ItemName").Text + " <b>[" + e.Row.Cells.FromKey("ItemNumber").Text + "]</b>"; // Update list of SKU if (txtSKUs.Text.Length > 0 && !txtSKUs.Text.Contains(e.Row.Cells.FromKey("ItemNumber").Text)) { if (separator.Equals("R")) { txtSKUs.Text += "\r\n"; } else { txtSKUs.Text += separator; } } if (!txtSKUs.Text.Contains(e.Row.Cells.FromKey("ItemNumber").Text)) { txtSKUs.Text += e.Row.Cells.FromKey("ItemNumber").Text; } NbSKUs++; } } else if (inputType.Equals("NAME")) { if (bLinkFrom) //Adding a companion { dg.Columns.FromKey("ItemName").Hidden = true; dg.Columns.FromKey("ItemPath").Hidden = false; } // If the Sku is incorrect, change the cell style if (e.Row.Cells[colErrorIndex].Value != null && e.Row.Cells[colErrorIndex].Value.ToString().Length > 0) { if (bLinkFrom) { if (!Convert.ToBoolean(e.Row.Cells.FromKey("IsRelevant").Value)) { e.Row.Cells.FromKey("ItemPath").Style.CssClass = "hc_error"; } if (!Convert.ToBoolean(e.Row.Cells.FromKey("IsRelevant").Value) && Convert.ToInt32(e.Row.Cells.FromKey("SameLink").Value) != 2) { if (e.Row.Cells.FromKey("ItemNumber").Value.ToString().Length > 0) { e.Row.Cells.FromKey("ItemPath").Text = e.Row.Cells.FromKey("ItemPath").Text + " <b>[" + e.Row.Cells.FromKey("ItemNumber").Text + "]</b> - " + e.Row.Cells[colErrorIndex].Value.ToString(); } else { e.Row.Cells.FromKey("ItemPath").Text = e.Row.Cells.FromKey("ItemPath").Text + " - " + e.Row.Cells[colErrorIndex].Value.ToString(); } } else { e.Row.Cells.FromKey("ItemPath").Text = e.Row.Cells.FromKey("ItemPath").Text + " <b>[" + e.Row.Cells.FromKey("ItemNumber").Text + "] - " + e.Row.Cells[colErrorIndex].Value.ToString() + "</b>"; } } else { if (!Convert.ToBoolean(e.Row.Cells.FromKey("IsRelevant").Value)) { e.Row.Cells.FromKey("ItemName").Style.CssClass = "hc_error"; } if (e.Row.Cells.FromKey("ItemNumber").Value != null && e.Row.Cells.FromKey("ItemNumber").Value.ToString().Length > 0) { e.Row.Cells.FromKey("ItemName").Text = e.Row.Cells.FromKey("ItemName").Text + " <b>[" + e.Row.Cells.FromKey("ItemNumber").Text + "]</b> - " + e.Row.Cells[colErrorIndex].Value.ToString(); } else { e.Row.Cells.FromKey("ItemName").Text = e.Row.Cells.FromKey("ItemName").Text + " - " + e.Row.Cells[colErrorIndex].Value.ToString(); } } if (Convert.ToInt32(e.Row.Cells.FromKey("SameLink").Value) == 2 && Convert.ToBoolean(e.Row.Cells.FromKey("IsRelevant").Text)) { NbSKUs++; } } else { if (bLinkFrom) { e.Row.Cells.FromKey("ItemPath").Text = e.Row.Cells.FromKey("ItemPath").Text + " <b>[" + e.Row.Cells.FromKey("ItemNumber").Text + "]</b>"; } else { if (e.Row.Cells.FromKey("ItemNumber").Value != null && e.Row.Cells.FromKey("ItemNumber").Value.ToString().Length > 0) { e.Row.Cells.FromKey("ItemName").Text = e.Row.Cells.FromKey("ItemName").Text + " <b>[" + e.Row.Cells.FromKey("ItemNumber").Text + "]</b>"; } else { e.Row.Cells.FromKey("ItemName").Text = e.Row.Cells.FromKey("ItemName").Text; } } NbSKUs++; } } //Code modified for Links Requirement (PR658943) - to allow analyze for higher level Node Names by Prachi on 19th Jan 2013 - end }
private int UpdateGrade() { UltraGridRow row; int intTxrUser = gUserInfo.Emp_Ref_ID; int intRtn = 0; int intRow = ugrdGradeList.Rows.Count; MicroBSC.BSC.Biz.Biz_Bsc_Est_Dept_Grade objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Est_Dept_Grade(); CheckBox chkTempGradeYN; TemplatedColumn grade_col = (TemplatedColumn)ugrdGradeList.Columns.FromKey("MID_GRADE_YN"); DropDownList ddlTempYN; TemplatedColumn yn_col = (TemplatedColumn)ugrdGradeList.Columns.FromKey("USE_YN"); for (int i = 0; i < intRow; i++) { row = ugrdGradeList.Rows[i]; string iType = Convert.ToString(row.Cells.FromKey("ITYPE").Value.ToString()); int iEstterm_ref_id = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo); int iEstDeptType = (row.Cells.FromKey("EST_DEPT_TYPE").Value == null) ? 0 : Convert.ToInt32(row.Cells.FromKey("EST_DEPT_TYPE").Value.ToString()); int iGradeRefId = (row.Cells.FromKey("GRADE_REF_ID").Value == null) ? 0 : Convert.ToInt32(row.Cells.FromKey("GRADE_REF_ID").Value.ToString()); string iGradeName = row.Cells.FromKey("GRADE_NAME").ToString(); double iMinValue = Convert.ToDouble(row.Cells.FromKey("MIN_VALUE").Value); double iMaxValue = Convert.ToDouble(row.Cells.FromKey("MAX_VALUE").Value); chkTempGradeYN = (CheckBox)((CellItem)grade_col.CellItems[ugrdGradeList.Rows[i].BandIndex]).FindControl("chkMidGrade_YN"); int iSort_order = Convert.ToInt32(row.Cells.FromKey("SORT_ORDER").Value.ToString()); ddlTempYN = (DropDownList)((CellItem)yn_col.CellItems[ugrdGradeList.Rows[i].BandIndex]).FindControl("ddlUse_YN"); int iuser = intTxrUser; if (iType == "U") { intRtn += objBSC.UpdateData(iEstterm_ref_id , iEstDeptType , iGradeRefId , iGradeName , iMinValue , iMaxValue , (chkTempGradeYN.Checked == true)? "Y": "N" , iSort_order , ddlTempYN.SelectedValue.ToString() , iuser); } else if (iType == "A") { intRtn += objBSC.InsertData(iEstterm_ref_id , iEstDeptType , iGradeRefId , iGradeName , iMinValue , iMaxValue , (chkTempGradeYN.Checked == true) ? "Y" : "N" , iSort_order , ddlTempYN.SelectedValue.ToString() , iuser); } } return(intRtn); }
private void Save() { if (dg != null) { bool isOk = false; TemplatedColumn col = (TemplatedColumn)dg.Columns.FromKey("Select"); foreach (UltraGridRow r in dg.Rows) { //Code modified for Links Requirement (PR658943) - to create links for the selected Items by Prachi on 20th Jan 2013 int isRelevant = Convert.ToInt32(r.Cells.FromKey("IsRelevant").Value); int SameValidLink = Convert.ToInt32(r.Cells.FromKey("SameLink").Value); CheckBox cb = (CheckBox)((CellItem)col.CellItems[r.Index]).FindControl("g_sd"); if (((isRelevant == 1) || (SameValidLink == 2)) && cb.Enabled && cb.Checked) { System.Int64 mainId = -1; System.Int64 subId = Convert.ToInt64(r.Cells.FromKey("ItemId").Value); if (!bLinkFrom) // for links From -- Adding a Host { mainId = Convert.ToInt64(r.Cells.FromKey("ItemId").Value); //Modified for Links Requirement (PR664364) - to add Host from Companions - Companion should always be SKU Level Item subId = Convert.ToInt64(r.Cells.FromKey("MainItemId").Value); } else // for links To -- Adding a Companion { mainId = itemId; subId = Convert.ToInt64(r.Cells.FromKey("ItemId").Value); } //prachi 5/5/2016 CR#6914 if (string.IsNullOrEmpty(Convert.ToString(dateValue.Value))) { dateValue.Value = DateTime.Now.ToUniversalTime().Date; } //prachi 5/5/2016 CR#6914 Link link = new Link(mainId, subId, linkTypeId, SessionState.Culture.CountryCode, -1, SessionState.User.Id, DateTime.UtcNow, Convert.ToDateTime(dateValue.Value).ToUniversalTime().Date); if (!link.Save()) { lbError.CssClass = "hc_error"; lbError.Text = Link.LastError; lbError.Visible = true; isOk = false; return; } else { isOk = true; } } } if (isOk) { lbError.CssClass = "hc_success"; lbError.Text = "Data saved!"; lbError.Visible = true; Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "close", "<script>ReloadParent();</script>"); } } }
protected void ugrdLoadMapList_InitializeRow(object sender, RowEventArgs e) { TemplatedColumn tmcPL = (TemplatedColumn)e.Row.Band.Columns.FromKey("MONTHLY_PLAN"); TemplatedColumn tmcDO = (TemplatedColumn)e.Row.Band.Columns.FromKey("DETAILS"); TemplatedColumn tmcDE = (TemplatedColumn)e.Row.Band.Columns.FromKey("ETC_CONTENTS"); TextBox txtPL = (TextBox)((CellItem)tmcPL.CellItems[e.Row.BandIndex]).FindControl("txtMONTHLY_PLAN"); TextBox txtDO = (TextBox)((CellItem)tmcDO.CellItems[e.Row.BandIndex]).FindControl("txtDETAILS"); TextBox txtDE = (TextBox)((CellItem)tmcDE.CellItems[e.Row.BandIndex]).FindControl("txtETC_CONTENTS"); txtPL.Text = (e.Row.Cells.FromKey("MONTHLY_PLAN").Value == null) ? "" : Convert.ToString(e.Row.Cells.FromKey("MONTHLY_PLAN").Value.ToString()); txtDO.Text = (e.Row.Cells.FromKey("DETAILS").Value == null) ? "" : Convert.ToString(e.Row.Cells.FromKey("DETAILS").Value.ToString()); txtDE.Text = (e.Row.Cells.FromKey("ETC_CONTENTS").Value == null) ? "" : Convert.ToString(e.Row.Cells.FromKey("ETC_CONTENTS").Value.ToString()); txtPL.Font.Size = FontUnit.Medium; txtDO.Font.Size = FontUnit.Medium; txtDE.Font.Size = FontUnit.Medium; txtPL.Font.Name = "HY울릉도M"; txtDO.Font.Name = "HY울릉도M"; txtDE.Font.Name = "HY울릉도M"; txtPL.Style.Add("overflow", "auto"); txtDO.Style.Add("overflow", "auto"); txtDE.Style.Add("overflow", "auto"); txtPL.Style.Add("padding-left", "10px"); txtDO.Style.Add("padding-left", "10px"); txtPL.Style.Add("padding-top", "5px"); txtDO.Style.Add("padding-top", "5px"); int intYmd = (e.Row.Cells.FromKey("YMD").Value == null) ? 0 : Convert.ToInt32(e.Row.Cells.FromKey("YMD").Value.ToString()); if ((intYmd % 2) == 1) { e.Row.Style.BackColor = ColorTranslator.FromHtml("#EDF0F5"); txtPL.Style.Add("background-color", "#EDF0F5"); txtDO.Style.Add("background-color", "#EDF0F5"); } else { e.Row.Style.BackColor = ColorTranslator.FromHtml("#DCE1E5"); txtPL.Style.Add("background-color", "#DCE1E5"); txtDO.Style.Add("background-color", "#DCE1E5"); } if (intYmd < Convert.ToInt32(this.IYmd) - 1) { e.Row.Hidden = true; } else if (intYmd == Convert.ToInt32(this.IYmd) + 1) { //e.Row.Style.BackColor = ColorTranslator.FromHtml("#EDF0F5"); //txtPL.Style.Add("background-color", "#EDF0F5"); //txtDO.Style.Add("background-color", "#EDF0F5"); e.Row.Style.BackColor = ColorTranslator.FromHtml("#9DC1CD"); //txtPL.ForeColor = Color.Navy; //txtDO.ForeColor = Color.Navy; e.Row.Activate(); } //string strCheck = e.Row.Cells.FromKey("CLOSE_YN").Value.ToString(); //if (strCheck == "Y") //{ // txtPL.ReadOnly = true; // txtDO.ReadOnly = true; // txtDE.ReadOnly = true; // txtPL.BackColor = Color.WhiteSmoke; // txtDO.BackColor = Color.WhiteSmoke; // txtDE.BackColor = Color.WhiteSmoke; //} //else //{ // txtPL.ReadOnly = (this.IsOpenTerm=="Y") ? false : true; // txtDO.ReadOnly = false; // txtDE.ReadOnly = false; // txtPL.BackColor = (this.IsOpenTerm=="Y") ? Color.White : Color.WhiteSmoke; // txtDO.BackColor = Color.White; // txtDE.BackColor = Color.White; //} }