/// <summary> /// 삭제처리 /// </summary> /// <param name="obj"></param> private void OnDelete(object obj) { //0.삭제전 체크 Hashtable param = new Hashtable(); param.Add("sqlId", "selectChscResSubList"); param.Add("sqlId2", "SelectFileMapList"); param.Add("sqlId3", "SelectCmmWttAttaDt"); param.Add("FTR_CDE", this.FTR_CDE); param.Add("FTR_IDN", this.FTR_IDN); param.Add("BIZ_ID", string.Concat(this.FTR_CDE, this.FTR_IDN)); Hashtable result = BizUtil.SelectLists(param); DataTable dt = new DataTable(); DataTable dt2 = new DataTable(); DataTable dt3 = new DataTable(); try { dt = result["dt"] as DataTable; if (dt.Rows.Count > 0) { Messages.ShowInfoMsgBox("유지보수내역이 존재합니다."); return; } } catch (Exception) { } // 1.삭제처리 if (Messages.ShowYesNoMsgBox("수원지를 삭제하시겠습니까?") != MessageBoxResult.Yes) { return; } try { dt2 = result["dt2"] as DataTable; if (dt2.Rows.Count > 0) { //Messages.ShowInfoMsgBox("파일첨부내역이 존재합니다."); //return; //첨부파일삭제 foreach (DataRow row in dt2.Rows) { //a.FIL_SEQ 첨부파일삭제 BizUtil.DelFileSeq(row["FIL_SEQ"]); //b.FILE_MAP 업무파일매핑삭제 param = new Hashtable(); param.Add("sqlId", "DeleteFileMap"); param.Add("BIZ_ID", FTR_CDE + FTR_IDN); param.Add("FIL_SEQ", row["FIL_SEQ"]); BizUtil.Update(param); } } } catch (Exception) { } try { dt3 = result["dt3"] as DataTable; if (dt3.Rows.Count > 0) { //Messages.ShowInfoMsgBox("부속시설 세부현황이 존재합니다."); //return; WttAttaDt dtl = new WttAttaDt(); dtl.FTR_CDE = FTR_CDE; dtl.FTR_IDN = FTR_IDN; BizUtil.Update2(dtl, "DeleteWttAttaDt"); } } catch (Exception) { } try { BizUtil.Update2(this, "deleteWtrSourDtl"); } catch (Exception) { Messages.ShowErrMsgBox("삭제 처리중 오류가 발생하였습니다."); return; } Messages.ShowOkMsgBox(); BackCommand.Execute(null); }
/// <summary> /// 삭제처리 /// </summary> /// <param name="obj"></param> private void OnDelete(object obj) { //0.삭제전 체크 Hashtable param = new Hashtable(); param.Add("sqlId", "selectChscResSubList"); param.Add("sqlId2", "SelectFileMapList"); param.Add("sqlId3", "SelectCmmWttAttaDt"); param.Add("FTR_CDE", this.FTR_CDE); param.Add("FTR_IDN", this.FTR_IDN); param.Add("BIZ_ID", string.Concat(this.FTR_CDE, this.FTR_IDN)); Hashtable result = BizUtil.SelectLists(param); DataTable dt = new DataTable(); DataTable dt2 = new DataTable(); DataTable dt3 = new DataTable(); try { dt = result["dt"] as DataTable; if (dt.Rows.Count > 0) { Messages.ShowInfoMsgBox("유지보수내역이 존재합니다."); return; } } catch (Exception) { } // 1.삭제처리 if (Messages.ShowYesNoMsgBox("배수지를 삭제하시겠습니까?") != MessageBoxResult.Yes) { return; } try { dt2 = result["dt2"] as DataTable; if (dt2.Rows.Count > 0) { //Messages.ShowInfoMsgBox("파일첨부내역이 존재합니다."); //return; //첨부파일삭제 foreach (DataRow row in dt2.Rows) { //a.FIL_SEQ 첨부파일삭제 BizUtil.DelFileSeq(row["FIL_SEQ"]); //b.FILE_MAP 업무파일매핑삭제 param = new Hashtable(); param.Add("sqlId", "DeleteFileMap"); param.Add("BIZ_ID", FTR_CDE + FTR_IDN); param.Add("FIL_SEQ", row["FIL_SEQ"]); BizUtil.Update(param); } } } catch (Exception) { } try { dt3 = result["dt3"] as DataTable; if (dt3.Rows.Count > 0) { //Messages.ShowInfoMsgBox("부속시설 세부현황이 존재합니다."); //return; WttAttaDt dtl = new WttAttaDt(); dtl.FTR_CDE = FTR_CDE; dtl.FTR_IDN = Convert.ToInt32(FTR_IDN); BizUtil.Update2(dtl, "DeleteWttAttaDt"); } } catch (Exception) { } try { BizUtil.Update2(this.FctDtl, "deleteWtrSupDtl"); } catch (Exception) { Messages.ShowErrMsgBox("삭제 처리중 오류가 발생하였습니다."); return; } // 2.위치정보 삭제처리 ContentControl cctl = uC_SERV_PS.Parent as ContentControl; EditWinViewModel editWinViewModel = ((((cctl.Parent as Grid).Parent as Grid).Parent as Grid).Parent as Window).DataContext as EditWinViewModel; editWinViewModel.OnDelCmd(null); //Messages.ShowOkMsgBox(); //InitModel(); }
/// <summary> /// 로딩작업 /// </summary> /// <param name="obj"></param> private void OnLoaded(object obj) { //throw new NotImplementedException(); // 0.화면객체인스턴스화 if (obj == null) { return; } attFacDtlView = obj as AttFacDtlView; cbCRE_YY = attFacDtlView.cbCRE_YY; btnDelete = attFacDtlView.btnDelete; btnSave = attFacDtlView.btnSave; btnClose = attFacDtlView.btnClose; //2.화면데이터객체 초기화 InitDataBinding(); //3.권한처리 permissionApply(); // 4.초기조회 //DataTable dt = new DataTable(); Hashtable param = new Hashtable(); param.Add("sqlId", "SelectCmmWttAttaDt"); param.Add("FTR_CDE", this.FTR_CDE); param.Add("FTR_IDN", this.FTR_IDN); param.Add("ATTA_SEQ", this.ATTA_SEQ); WttAttaDt result = new WttAttaDt(); result = BizUtil.SelectObject(param) as WttAttaDt; if (result != null) { //결과를 뷰모델멤버로 매칭 Type dbmodel = result.GetType(); Type model = this.GetType(); //모델프로퍼티 순회 foreach (PropertyInfo prop in model.GetProperties()) { string propName = prop.Name; //db프로퍼티 순회 foreach (PropertyInfo dbprop in dbmodel.GetProperties()) { string colName = dbprop.Name; var colValue = dbprop.GetValue(result, null); if (colName.Equals(propName)) { try { prop.SetValue(this, colValue); } catch (Exception) { } } } Console.WriteLine(propName + " - " + prop.GetValue(this, null)); } } //다큐먼트는 따로 처리 Paragraph p = new Paragraph(); try { p.Inlines.Add(this.ATT_DES ?? ""); attFacDtlView.txtATT_DES.Document.Blocks.Clear(); attFacDtlView.txtATT_DES.Document.Blocks.Add(p); } catch (Exception e) { Console.WriteLine(e.Message); } //버튼처리 btnDelete.Visibility = Visibility.Visible; //5.신규/수정구분처리 if (ATTA_SEQ < 0) { //채번 param = new Hashtable(); param.Add("FTR_CDE", FTR_CDE); param.Add("FTR_IDN", FTR_IDN); param.Add("sqlId", "selectATTA_SEQ"); WttAttaDt res = new WttAttaDt(); res = BizUtil.SelectObject(param) as WttAttaDt; //채번결과 매칭 ATTA_SEQ = res.ATTA_SEQ; //시설물명 가져오기 attFacDtlView.txtFTR_NAM.Text = BizUtil.GetCodeNm("Select_FTR_LIST2", FTR_CDE); //버튼처리 btnDelete.Visibility = Visibility.Hidden; } }