/// <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;
}
}
