private void ViewOne(int comp_id, string est_id, string col_key) { Biz_ColumnInfos columnInfos = new Biz_ColumnInfos(comp_id, est_id, col_key); Biz_ColumnStyles columnStyles = new Biz_ColumnStyles(columnInfos.Col_Style_ID); txtSeq.Text = columnInfos.Seq.ToString(); txtColName.Text = columnInfos.Col_Name; WebUtility.FindByValueDropDownList(ddlColStyleID, columnInfos.Col_Style_ID); txtColKey.Text = columnInfos.Col_Key; txtCaption.Text = columnInfos.Caption; txtWidth.Text = columnInfos.Width.ToString(); WebUtility.FindByValueDropDownList(ddlDataType, columnInfos.Data_Type); WebUtility.FindByValueDropDownList(ddlHAlign, columnInfos.Halign); txtBackColor.Text = columnInfos.Back_Color; txtFormat.Text = columnInfos.Format; txtFormula.Text = columnInfos.Formula; txtDefaultValue.Text = columnInfos.Default_Value; txtColDesc.Text = columnInfos.Col_Desc; ckbBackColorYN.Checked = DataTypeUtility.GetYNToBoolean(columnInfos.Back_color_YN); ckbFormatYN.Checked = DataTypeUtility.GetYNToBoolean(columnInfos.Format_YN); ckbFormularYN.Checked = DataTypeUtility.GetYNToBoolean(columnInfos.Formula_YN); ckbDefaultValueYN.Checked = DataTypeUtility.GetYNToBoolean(columnInfos.Default_Value_YN); WebUtility.FindByValueRadioButtonList(rbnVisibleYN, columnInfos.Visible_YN); WebUtility.FindByValueRadioButtonList(rbnColEmpVisibleYN, columnInfos.Col_Emp_Visible_YN); //WebUtility.FindByValueRadioButtonList(rbnGradeToPointVisibleYN, columnInfos.Col_Grade_To_Point_Visible_YN); BindEstJob(COMP_ID, EST_ID, col_key); ddlColStyleID_SelectedIndexChanged(null, null); }
private void ViewOne(string col_style_id) { Biz_ColumnStyles columnStyles = new Biz_ColumnStyles(col_style_id); txtColStyleID.Text = columnStyles.Col_Style_ID; txtColStyleName.Text = columnStyles.Col_Style_Name; hdfColStyleID.Value = columnStyles.Col_Style_ID; }
private void GridBinding() { Biz_ColumnStyles columnStyles = new Biz_ColumnStyles(); DataSet ds = columnStyles.GetColumnStyles(); UltraWebGrid1.DataSource = ds; UltraWebGrid1.DataBind(); lblRowCount.Text = ds.Tables[0].Rows.Count.ToString(); }
protected void ibnSave_Click(object sender, ImageClickEventArgs e) { string col_style_id = txtColStyleID.Text.Trim(); string col_style_name = txtColStyleName.Text.Trim(); Biz_ColumnStyles columnStyles = new Biz_ColumnStyles(); if (PageWriteMode == WriteMode.New) { bool bDuplicate = columnStyles.IsExist(col_style_id); if (bDuplicate) { ltrScript.Text = JSHelper.GetAlertScript("존재하는 컬럼스타일ID가 있습니다."); return; } bool bResult = columnStyles.AddColumnStyle(col_style_id , col_style_name , DateTime.Now , EMP_REF_ID); if (bResult) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장되었습니다."); GridBinding(); ButtonStatusInit(); } else { ltrScript.Text = JSHelper.GetAlertScript("저장 중 오류가 발생되었습니다."); return; } } else if (PageWriteMode == WriteMode.Modify) { bool bResult = columnStyles.ModifyColumnStyle(col_style_id , col_style_name , DateTime.Now , EMP_REF_ID); if (bResult) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 수정되었습니다.", false); GridBinding(); ButtonStatusInit(); } else { ltrScript.Text = JSHelper.GetAlertScript("수정 중 오류가 발생하였습니다."); return; } } }
public static void BindColumnStyle(DropDownList ddl, bool isBlank) { Biz_ColumnStyles columnStyles = new Biz_ColumnStyles(); ddl.DataSource = columnStyles.GetColumnStyles(); ddl.DataTextField = "COL_STYLE_NAME"; ddl.DataValueField = "COL_STYLE_ID"; ddl.DataBind(); if (isBlank) { ListItem itemA = new ListItem("선택없음", ""); ddl.Items.Insert(0, itemA); } }
protected void UltraWebGrid1_InitializeRow(object sender, RowEventArgs e) { DataRowView dr = (DataRowView)e.Data; Biz_ColumnStyles columnStyles = new Biz_ColumnStyles(dr["COL_STYLE_ID"].ToString()); e.Row.Cells.FromKey("COL_STYLE_NAME").Value = columnStyles.Col_Style_Name; if (dr["VISIBLE_YN"].ToString().Equals("Y")) { e.Row.Cells.FromKey("VISIBLE_YN_IMG").Value = "<img src='../images/icon/color/blue.gif'/>"; } else { e.Row.Cells.FromKey("VISIBLE_YN_IMG").Value = "<img src='../images/icon/color/red.gif'/>"; } }
protected void ibnDelete_Click(object sender, ImageClickEventArgs e) { string col_style_id = hdfColStyleID.Value; Biz_ColumnStyles columnStyles = new Biz_ColumnStyles(); bool bResult = columnStyles.RemoveColumnStyle(col_style_id); if (bResult) { ltrScript.Text = JSHelper.GetAlertScript("삭제되었습니다.", false); GridBinding(); ButtonStatusInit(); } else { ltrScript.Text = JSHelper.GetAlertScript("삭제되지 않았습니다."); } }
protected void ibnCheckID_Click(object sender, ImageClickEventArgs e) { if (txtColStyleID.Text.Trim().Length == 0) { ltrScript.Text = JSHelper.GetAlertScript("컬럼스타일ID를 입력해주세요."); return; } string col_style_id = txtColStyleID.Text.Trim(); Biz_ColumnStyles columnStyles = new Biz_ColumnStyles(); bool bDuplicate = columnStyles.IsExist(col_style_id); if (bDuplicate) { ltrScript.Text = JSHelper.GetAlertScript("존재하는 컬럼스타일ID가 있습니다."); } else { ltrScript.Text = JSHelper.GetAlertScript("사용가능한 컬럼스타일ID 입니다."); } }