protected void ibnCheckID_Click(object sender, ImageClickEventArgs e) { if (txtEstScheID.Text.Trim().Length == 0) { ltrScript.Text = JSHelper.GetAlertScript("일정 ID를 입력해주세요."); return; } string strEstScheID = txtEstScheID.Text.Trim(); Biz_ScheInfos scheInfos = new Biz_ScheInfos(); bool bDuplicate = scheInfos.IsExist(COMP_ID, strEstScheID); if (bDuplicate) { ltrScript.Text = JSHelper.GetAlertScript("존재하는 일정 ID가 있습니다."); } else { ltrScript.Text = JSHelper.GetAlertScript("사용가능한 일정 ID 입니다."); } }
protected void ibnDelete_Click(object sender, ImageClickEventArgs e) { string est_sche_id = hdfEstScheId.Value.Trim(); if (est_sche_id.Length == 0) { ltrScript.Text = JSHelper.GetAlertScript("선택된 일정 ID가 없습니다."); return; } Biz_ScheInfos scheInfos = new Biz_ScheInfos(); bool bResult = scheInfos.RemoveScheInfo(COMP_ID, est_sche_id); if (bResult == true) { BindGrid(COMP_ID); ButtonStatusByInit(); } else { ltrScript.Text = JSHelper.GetAlertBackScript("삭제되지 않았습니다."); return; } }
private void ViewOne(int comp_id, string est_sche_id) { Biz_ScheInfos scheInfos = new Biz_ScheInfos(comp_id, est_sche_id); Biz_ScheInfos scheInfos_up = null; if (!scheInfos.Up_Est_Sche_ID.Equals("")) { scheInfos_up = new Biz_ScheInfos(comp_id, scheInfos.Up_Est_Sche_ID); txtUpEstScheID.Text = scheInfos_up.Est_Sche_Name; } txtEstScheID.Text = scheInfos.Est_Sche_ID; txtEstScheName.Text = scheInfos.Est_Sche_Name; hdfUpEstScheID.Value = scheInfos.Up_Est_Sche_ID; hdfEstID.Value = scheInfos.Est_ID; txtEstScheDesc.Text = scheInfos.Est_Sche_Desc; txtSortOrder.Text = scheInfos.Sort_Order.ToString(); Biz_EstInfos estInfos = new Biz_EstInfos(comp_id, scheInfos.Est_ID); txtEstID.Text = estInfos.Est_Name; DropDownListCommom.BindEstJobMapNotIn(ddlEstJobID, COMP_ID, hdfEstID.Value, true); }
public static void BindJobs(TreeView treeView , bool isCheckBox , TreeNodeSelectAction treeNodeSelectAction , string checkedValues , int comp_id) { string valueStr = "EST_SCHE_ID"; string up_valueStr = "UP_EST_SCHE_ID"; string textStr = "EST_SCHE_NAME"; string iconStr = "EST_SCHE_ID"; string imageUrlDir = "../images/dept_icon/"; bool isExtended = true; DataTable dataTable = null; // 부모 페이지에서 값이 수정되었을 경우를 위해서 체크박스에 대한 값을 처리하기 // 위해서 추가 되는 부분 if (isCheckBox && (checkedValues != null || checkedValues == "")) { dataTable = new DataTable(); DataRow dr = null; dataTable.Columns.Add("VALUE", typeof(string)); dataTable.Columns.Add("OK_YN", typeof(string)); string[] values = checkedValues.Split(','); foreach (string val in values) { dr = dataTable.NewRow(); dr["VALUE"] = val; dr["OK_YN"] = "N"; dataTable.Rows.Add(dr); } } Biz_ScheInfos scheInfos = new Biz_ScheInfos(); DataSet ds = scheInfos.GetScheInfo(comp_id); ds.Relations.Add("NodeRelation" , ds.Tables[0].Columns[valueStr] , ds.Tables[0].Columns[up_valueStr] , false); treeView.Nodes.Clear(); foreach (DataRow dbRow in ds.Tables[0].Rows) { if (dbRow[up_valueStr] == DBNull.Value) { TreeNode rootNode = CreateNode(dbRow[valueStr].ToString() , dbRow[textStr].ToString() , imageUrlDir + ((dbRow["EST_ID"].ToString().Length != 0) ? "blue/E.gif" : "blue/S.gif") , isExtended , treeNodeSelectAction , isCheckBox); if (isCheckBox && (checkedValues != null || checkedValues == "")) { TreeNodeCheck(rootNode, dataTable); } treeView.Nodes.Add(rootNode); PopulateEstTreeJob(dbRow, rootNode, valueStr, textStr, imageUrlDir, iconStr, treeNodeSelectAction, isExtended, isCheckBox, dataTable); } } }
protected void ibnSave_Click(object sender, ImageClickEventArgs e) { string est_sche_id = txtEstScheID.Text.Trim(); if (est_sche_id.Length == 0) { est_sche_id = hdfEstScheId.Value.Trim(); } string up_est_sche_id = hdfUpEstScheID.Value.Trim(); string est_sche_name = txtEstScheName.Text.Trim(); string est_sche_desc = txtEstScheDesc.Text.Trim(); int sort_order = DataTypeUtility.GetToInt32(txtSortOrder.Text); string est_id = hdfEstID.Value.Trim(); Biz_ScheInfos scheInfos = new Biz_ScheInfos(); if (PageWriteMode == WriteMode.New) { bool bDuplicate = scheInfos.IsExist(COMP_ID, est_sche_id); if (bDuplicate == true) { ltrScript.Text = JSHelper.GetAlertScript("존재하는 일정 ID가 있습니다.", false); return; } bool bResult = scheInfos.AddScheInfo(COMP_ID , est_sche_id , up_est_sche_id , est_sche_name , est_sche_desc , sort_order , est_id , DateTime.Now , gUserInfo.Emp_Ref_ID ); if (bResult == true) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 저장되었습니다."); BindGrid(COMP_ID); ButtonStatusByInit(); } else { ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다."); return; } } else if (PageWriteMode == WriteMode.Modify) { bool bIsExist = scheInfos.IsExist(COMP_ID, est_sche_id); if (bIsExist == false) { ltrScript.Text = JSHelper.GetAlertScript("해당 자료가 없습니다."); return; } bool bResult = scheInfos.ModifyScheInfo(COMP_ID , est_sche_id , up_est_sche_id , est_sche_name , est_sche_desc , sort_order , est_id , DateTime.Now , gUserInfo.Emp_Ref_ID ); if (bResult == true) { ltrScript.Text = JSHelper.GetAlertScript("정상적으로 수정되었습니다."); BindGrid(COMP_ID); ButtonStatusByInit(); } else { ltrScript.Text = JSHelper.GetAlertBackScript("수정되지 않았습니다."); return; } } }