/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
//throw new NotImplementedException();
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
wtrTrkHtDtlView = obj as WtrTrkHtDtlView;
btnSave = wtrTrkHtDtlView.btnSave;
btnClose = wtrTrkHtDtlView.btnClose;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
//4.신규/상세 모드
if (Dtl.SEQ < 0)
{
//채번
Hashtable param = new Hashtable();
param.Add("FTR_CDE", Dtl.FTR_CDE);
param.Add("FTR_IDN", Dtl.FTR_IDN);
param.Add("sqlId", "selectCLN_SEQ");
WttRsrvHtDtl res = new WttRsrvHtDtl();
res = BizUtil.SelectObject(param) as WttRsrvHtDtl;
//채번결과 매칭
Dtl.SEQ = res.SEQ;
//시설물명가져오기
Dtl.FTR_NAM = BizUtil.GetCodeNm("Select_FTR_LIST2", Dtl.FTR_CDE);
wtrTrkHtDtlView.btnDel.Visibility = Visibility.Collapsed;
}
else
{
Hashtable param = new Hashtable();
param.Add("sqlId", "selectWttRsrvHt");
param.Add("FTR_CDE", Dtl.FTR_CDE);
param.Add("FTR_IDN", Dtl.FTR_IDN);
param.Add("SEQ", Dtl.SEQ);
Dtl = BizUtil.SelectObject(param) as WttRsrvHtDtl;
wtrTrkHtDtlView.btnDel.Visibility = Visibility.Visible;
}
}
/// <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", "selectWttRsrvHt");
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;
WttRsrvHtDtl dtl = new WttRsrvHtDtl();
dtl.FTR_CDE = FTR_CDE;
dtl.FTR_IDN = Convert.ToInt32(FTR_IDN);
BizUtil.Update2(dtl, "deleteWttRsrvHt");
}
}
catch (Exception) { }
try
{
BizUtil.Update2(this.FctDtl, "deleteWtrTrkDtl");
}
catch (Exception e)
{
Messages.ShowErrMsgBox("삭제 처리중 오류가 발생하였습니다." + e.Message);
return;
}
// 2.위치정보 삭제처리
ContentControl cctl = uC_RSRV_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 OnDelete(object obj)
{
//0.삭제전 체크
Hashtable param = new Hashtable();
param.Add("sqlId", "selectChscResSubList");
param.Add("sqlId2", "SelectFileMapList");
param.Add("sqlId3", "selectWttRsrvHt");
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;
WttRsrvHtDtl dtl = new WttRsrvHtDtl();
dtl.FTR_CDE = FTR_CDE;
dtl.FTR_IDN = FTR_IDN;
BizUtil.Update2(dtl, "deleteWttRsrvHt");
}
}
catch (Exception) { }
try
{
BizUtil.Update2(this, "deleteWtrTrkDtl");
}
catch (Exception e)
{
Messages.ShowErrMsgBox("삭제 처리중 오류가 발생하였습니다." + e.Message);
return;
}
Messages.ShowOkMsgBox();
BackCommand.Execute(null);
}
