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 입니다.");
}
}
