//초기모델조회
private void InitModel()
{
//1.상세마스터
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectWtlLeakDtl");
param.Add("FTR_CDE", _FTR_CDE);
param.Add("FTR_IDN", _FTR_IDN);
LeakDtl result = new LeakDtl();
result = BizUtil.SelectObject(param) as LeakDtl;
this.Dtl = result;
//다큐먼트는 따로 처리
Paragraph p = new Paragraph();
try
{
p.Inlines.Add(this.Dtl.REP_EXP ?? "");
lekSiteDtlView.richREP_EXP.Document.Blocks.Clear();
lekSiteDtlView.richREP_EXP.Document.Blocks.Add(p);
}
catch (Exception) {}
p = new Paragraph();
try
{
p.Inlines.Add(this.Dtl.LEK_EXP ?? "");
lekSiteDtlView.richLEK_EXP.Document.Blocks.Clear();
lekSiteDtlView.richLEK_EXP.Document.Blocks.Add(p);
}
catch (Exception) {}
}
/// 생성자
public HydtMetrDtlViewMdl(string FTR_CDE, int FTR_IDN)
{
try
{
// 1.상세마스터
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectHydtMetrDtl");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
Dtl = BizUtil.SelectObject(param) as HydtMetrDtl;
//2.탭1 - 유지보수
param = new Hashtable();
param.Add("sqlId", "selectChscResSubList");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
this.Tab01List = (List <LinkFmsChscFtrRes>)BizUtil.SelectListObj <LinkFmsChscFtrRes>(param);
//텝4 - 급수전계량기
param = new Hashtable();
param.Add("sqlId", "selectWttMetaHtList");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
this.Tab02List = (List <WttMetaHt>)BizUtil.SelectListObj <WttMetaHt>(param);
}
catch (Exception) {}
}
private void InitModel()
{
//DataTable dt = new DataTable();
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectWtlPipeDtl2");
param.Add("FTR_CDE", this.FTR_CDE);
param.Add("FTR_IDN", this.FTR_IDN);
PipeDtl result = new PipeDtl();
result = BizUtil.SelectObject(param) as PipeDtl;
//결과를 뷰모델멤버로 매칭
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));
}
}
/// 생성자
public ValvFacDtlViewMdl(string FTR_CDE, int FTR_IDN)
{
try
{
// 1.상세마스터
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectValvFacDtl");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
Dtl = BizUtil.SelectObject(param) as ValvFacDtl;
//2.유지보수(탭)
param = new Hashtable();
param.Add("sqlId", "selectChscResSubList");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
this.Tab01List = (List <LinkFmsChscFtrRes>)BizUtil.SelectListObj <LinkFmsChscFtrRes>(param);
}
catch (Exception) {}
}
//초기모델조회
private void InitModel()
{
//1.상세마스터
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectWttWserMa");
param.Add("WSER_SEQ", _WSER_SEQ);
WserDtl result = new WserDtl();
result = BizUtil.SelectObject(param) as WserDtl;
this.Dtl = result;
//다큐먼트는 따로 처리
Paragraph p = new Paragraph();
try
{
p.Inlines.Add(this.Dtl.APL_EXP ?? "");
splyCmplDtlView.richAPL_EXP.Document.Blocks.Clear();
splyCmplDtlView.richAPL_EXP.Document.Blocks.Add(p);
}
catch (Exception) {}
p = new Paragraph();
try
{
p.Inlines.Add(this.Dtl.PRO_EXP ?? "");
splyCmplDtlView.richPRO_EXP.Document.Blocks.Clear();
splyCmplDtlView.richPRO_EXP.Document.Blocks.Add(p);
}
catch (Exception) {}
}
//초기모델조회
private void InitModel()
{
Hashtable param = new Hashtable();
// 0.파일첨부내역
param.Add("sqlId", "SelectFileMap");
param.Add("BIZ_ID", txtBIZ_ID.Text);
param.Add("FIL_SEQ", txtFIL_SEQ.Text);
FileMapDtl result = BizUtil.SelectObject(param) as FileMapDtl;
// 내역없으면 신규첨부내용
if (!FmsUtil.IsNull(result))
{
// 0.상세정보
Dtl = result;
// 1.첨부파일
param.Clear();
param.Add("sqlId", "SelectFileDtl2");
param.Add("FIL_SEQ", txtFIL_SEQ.Text);
ItemsSelect = new ObservableCollection <FileDtl>(BizUtil.SelectListObj <FileDtl>(param));
}
}
/// <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 OnLoaded(object obj)
{
//throw new NotImplementedException();
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
splyDtlView = values[0] as SplyDtlView;
cbHJD_CDE = splyDtlView.cbHJD_CDE;
btnBack = splyDtlView.btnBack;
btnDelete = splyDtlView.btnDelete;
btnSave = splyDtlView.btnSave;
btnDup = splyDtlView.btnDup;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회
//DataTable dt = new DataTable();
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectWttSplyMaDtl");
param.Add("CNT_NUM", Dtl.CNT_NUM);
Dtl = BizUtil.SelectObject(param) as SplyDtl;
////결과를 뷰모델멤버로 매칭
//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));
//}
}
// 초기조회
public void InitModel()
{
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectWttConsMaDtl");
param.Add("CNT_NUM", Dtl.CNT_NUM);
Dtl = BizUtil.SelectObject(param) as CnstDtl;
}
/// 생성자
public WtlPipeDtlViewMdl(string FTR_CDE, int FTR_IDN)
{
try
{
// 1.상세마스터
//DataTable dt = new DataTable();
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectWtlPipeDtl2");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
PipeDtl result = new PipeDtl();
result = BizUtil.SelectObject(param) as PipeDtl;
//결과를 뷰모델멤버로 매칭
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));
}
//2.유지보수(탭1)
param = new Hashtable();
param.Add("sqlId", "selectChscResSubList");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
this.Tab01List = (List <LinkFmsChscFtrRes>)BizUtil.SelectListObj <LinkFmsChscFtrRes>(param);
//3.누수지점(탭3)
param = new Hashtable();
param.Add("sqlId", "selectWtlLeakSubList");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
this.Tab03List = (List <LinkWtlLeakPs>)BizUtil.SelectListObj <LinkWtlLeakPs>(param);
}
catch (Exception) {}
}
/// 생성자
public SupDutDtlViewMdl(string FTR_CDE, int FTR_IDN)
{
try
{
// 1.상세마스터
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectSupDutDtl");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
SupDutDtl result = new SupDutDtl();
result = BizUtil.SelectObject(param) as SupDutDtl;
//결과를 뷰모델멤버로 매칭
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));
}
//2.텝1 - 유지보tn
param = new Hashtable();
param.Add("sqlId", "selectChscResSubList");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
this.Tab01List = (List <LinkFmsChscFtrRes>)BizUtil.SelectListObj <LinkFmsChscFtrRes>(param);
//텝4 - 급수전계량기
param = new Hashtable();
param.Add("sqlId", "SelectHydtMetrDtl");
param.Add("FTR_CDE", FTR_CDE);
param.Add("FTR_IDN", FTR_IDN);
this.Tab02List = (List <HydtMetrDtl>)BizUtil.SelectListObj <HydtMetrDtl>(param);
}
catch (Exception) { }
}
/// <summary>
/// 초기조회
/// </summary>
private void InitModel()
{
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectFaqDtl");
param.Add("SEQ", this.SEQ);
FaqDtl result = new FaqDtl();
result = BizUtil.SelectObject(param) as FaqDtl;
//결과를 뷰모델멤버로 매칭
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.QUESTION ?? "");
faqDocView.richQUESTION.Document.Blocks.Clear();
faqDocView.richQUESTION.Document.Blocks.Add(p);
}
catch (Exception) { }
p = new Paragraph();
try
{
p.Inlines.Add(this.REPL ?? "");
faqDocView.richREPL.Document.Blocks.Clear();
faqDocView.richREPL.Document.Blocks.Add(p);
}
catch (Exception) { }
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
valvFacAddView = values[0] as ValvFacAddView;
cbFTR_CDE = valvFacAddView.cbFTR_CDE; //지형지물
cbHJD_CDE = valvFacAddView.cbHJD_CDE; //행정동
cbMNG_CDE = valvFacAddView.cbMNG_CDE; //관리기관
cbVAL_MOF = valvFacAddView.cbVAL_MOF; //형식
cbVAL_MOP = valvFacAddView.cbVAL_MOP; //관재질
cbSAE_CDE = valvFacAddView.cbSAE_CDE; //제수변회전방향
cbMTH_CDE = valvFacAddView.cbMTH_CDE; //제수변구동방법
cbVAL_FOR = valvFacAddView.cbVAL_FOR; //시설물형태
cbCST_CDE = valvFacAddView.cbCST_CDE; //이상상태
cbOFF_CDE = valvFacAddView.cbOFF_CDE; //개폐여부
btnBack = valvFacAddView.btnBack;
btnSave = valvFacAddView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회 - 신규관리번호 채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectValvFacFTR_IDN");
ValvFacDtl result = new ValvFacDtl();
result = BizUtil.SelectObject(param) as ValvFacDtl;
//채번결과 매칭
this.FTR_IDN = result.FTR_IDN;
this.FTR_CDE = "SA200";
this.IST_YMD = Convert.ToDateTime(DateTime.Today).ToString("yyyy-MM-dd");
//공통팝업창 사이즈 원복
FmsUtil.popWinView.Height = 440;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
/// <summary>
/// 초기조회
/// </summary>
private void InitModel()
{
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectFaqDtl");
param.Add("SEQ", this.SEQ);
FaqDtl result = new FaqDtl();
result = BizUtil.SelectObject(param) as FaqDtl;
//결과를 뷰모델멤버로 매칭
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));
}
// CLOB 데이터는 OleDbConnection으로 따로 조회
try
{
string sql = "";
sql += " SELECT QUESTION, REPL FROM FAQ WHERE SEQ = :SEQ ;";
param = new Hashtable();
param.Add("sql", sql);
param.Add("SEQ", this.SEQ);
DataTable dt = DBUtil.Select(param);
this.QUESTION = dt.Rows[0]["QUESTION"].ToString();
this.REPL = dt.Rows[0]["REPL"].ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
/// 생성자
public SplyDtlViewMdl(string CNT_NUM)
{
try
{
// 1.상세마스터
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectWttSplyMaDtl");
param.Add("CNT_NUM", CNT_NUM);
Dtl = BizUtil.SelectObject(param) as SplyDtl;
}
catch (Exception) {}
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
intkStAddView = values[0] as IntkStAddView;
// cbFTR_CDE = intkStAddView.cbFTR_CDE; //지형지물
cbHJD_CDE = intkStAddView.cbHJD_CDE; //행정동
cbMNG_CDE = intkStAddView.cbMNG_CDE; //관리기관
cbWSR_CDE = intkStAddView.cbWSR_CDE; //수원구분
cbWRW_CDE = intkStAddView.cbWRW_CDE; //도수방법
cbWGW_CDE = intkStAddView.cbWGW_CDE; //취소방법
btnBack = intkStAddView.btnBack;
btnSave = intkStAddView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회 - 신규관리번호 채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectIntkStFTR_IDN");
IntkStDtl result = new IntkStDtl();
result = BizUtil.SelectObject(param) as IntkStDtl;
//채번결과 매칭
this.FTR_IDN = result.FTR_IDN;
this.FTR_CDE = "SA112";
//this.FNS_YMD = Convert.ToDateTime(DateTime.Today).ToString("yyyy-MM-dd");
//공통팝업창 사이즈 변경 3
FmsUtil.popWinView.Height = 360;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
flowMtAddView = values[0] as FlowMtAddView;
// cbFTR_CDE = flowMtAddView.cbFTR_CDE; //지형지물
cbHJD_CDE = flowMtAddView.cbHJD_CDE; //행정동
cbMNG_CDE = flowMtAddView.cbMNG_CDE; //관리기관
cbGAG_CDE = flowMtAddView.cbGAG_CDE; //유량계종류
cbMOF_CDE = flowMtAddView.cbMOF_CDE; //유형
btnBack = flowMtAddView.btnBack;
btnSave = flowMtAddView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회 - 신규관리번호 채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectFlowMtFTR_IDN");
FlowMtDtl result = new FlowMtDtl();
result = BizUtil.SelectObject(param) as FlowMtDtl;
//채번결과 매칭
this.FTR_IDN = result.FTR_IDN;
this.FTR_CDE = "SA117";
this.IST_YMD = Convert.ToDateTime(DateTime.Today).ToString("yyyy-MM-dd");
//공통팝업창 사이즈 변경
FmsUtil.popWinView.Height = 320;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
//신규 시설물 생성자
public UC_FIRE_PS(string _FTR_CDE) : this()
{
cbFTR_CDE.EditValue = _FTR_CDE;
//신규관리번호채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectFireFacFTR_IDN");
FireFacDtl result = BizUtil.SelectObject(param) as FireFacDtl;
//채번결과 매칭
txtFTR_IDN.Text = result.FTR_IDN.ToString();
btnDel.Tag = "Y";//신규채번 플래그
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
wtlPipeAddView = values[0] as WtlPipeAddView;
cbMNG_CDE = wtlPipeAddView.cbMNG_CDE;
cbHJD_CDE = wtlPipeAddView.cbHJD_CDE;
cbMOP_CDE = wtlPipeAddView.cbMOP_CDE;
cbJHT_CDE = wtlPipeAddView.cbJHT_CDE;
cbSAA_CDE = wtlPipeAddView.cbSAA_CDE;
btnBack = wtlPipeAddView.btnBack;
btnSave = wtlPipeAddView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회 - 신규관리번호 채번
//DataTable dt = new DataTable();
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectWtlPipeFTR_IDN");
param.Add("FTR_CDE", "SA001");
PipeDtl result = new PipeDtl();
result = BizUtil.SelectObject(param) as PipeDtl;
//채번결과 매칭
this.FTR_IDN = result.FTR_IDN;
this.FTR_CDE = "SA001";
this.IST_YMD = Convert.ToDateTime(DateTime.Today).ToString("yyyy-MM-dd");
//공통팝업창 사이즈
FmsUtil.popWinView.Height = 360;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
//신규 시설물 생성자
public UC_META_PS(string _FTR_CDE) : this()
{
txtFTR_CDE.Text = _FTR_CDE;
//신규관리번호채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectHydtMetrFTR_IDN");
HydtMetrDtl result = BizUtil.SelectObject(param) as HydtMetrDtl;
//채번결과 매칭
txtFTR_IDN.Text = result.FTR_IDN.ToString();
btnDel.Tag = "Y";//신규채번 플래그
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
hydtMetrAddView = values[0] as HydtMetrAddView;
cbFTR_CDE = hydtMetrAddView.cbFTR_CDE; //지형지물
cbHJD_CDE = hydtMetrAddView.cbHJD_CDE; //행정동
cbHOM_HJD = hydtMetrAddView.cbHOM_HJD; //수용가행정동
cbSBI_CDE = hydtMetrAddView.cbSBI_CDE; //업종
cbMET_MOF = hydtMetrAddView.cbMET_MOF; //형식
btnBack = hydtMetrAddView.btnBack;
btnSave = hydtMetrAddView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회 - 신규관리번호 채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectHydtMetrFTR_IDN");
HydtMetrDtl result = new HydtMetrDtl();
result = BizUtil.SelectObject(param) as HydtMetrDtl;
//채번결과 매칭
this.FTR_IDN = result.FTR_IDN;
this.FTR_CDE = "SA122";//급수전계량기
this.IST_YMD = Convert.ToDateTime(DateTime.Today).ToString("yyyy-MM-dd");
//공통팝업창 사이즈 변경 3
FmsUtil.popWinView.Height = 360;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
//신규 시설물 생성자
public UC_BLKM_AS(string _FTR_CDE) : this()
{
txtFTR_CDE.Text = _FTR_CDE;
//신규관리번호채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectBlk02FTR_IDN");
BlkDtl result = BizUtil.SelectObject(param) as BlkDtl;
//채번결과 매칭
txtFTR_IDN.Text = result.FTR_IDN.ToString();
btnDel.Tag = "Y";//신규채번 플래그
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
wtrTrkAddView = values[0] as WtrTrkAddView;
cbHJD_CDE = wtrTrkAddView.cbHJD_CDE; //행정동
cbMNG_CDE = wtrTrkAddView.cbMNG_CDE; //관리기관
cbBLS_CDE = wtrTrkAddView.cbBLS_CDE; //건물유형
btnBack = wtrTrkAddView.btnBack;
btnSave = wtrTrkAddView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회 - 신규관리번호 채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectWtrTrkFTR_IDN");
WtrTrkDtl result = new WtrTrkDtl();
result = BizUtil.SelectObject(param) as WtrTrkDtl;
//채번결과 매칭
this.FTR_IDN = result.FTR_IDN;
this.FTR_CDE = "SA120";
//시설물명 가져오기
wtrTrkAddView.txtFTR_NAM.Text = BizUtil.GetCodeNm("Select_FTR_LIST2", FTR_CDE);
//공통팝업창 사이즈 변경 4
FmsUtil.popWinView.Height = 400;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
filtPltAddView = values[0] as FiltPltAddView;
// cbFTR_CDE = filtPltAddView.cbFTR_CDE; //지형지물
cbHJD_CDE = filtPltAddView.cbHJD_CDE; //행정동
cbMNG_CDE = filtPltAddView.cbMNG_CDE; //관리기관
cbWSR_CDE = filtPltAddView.cbWSR_CDE; //수원구분
cbSAM_CDE = filtPltAddView.cbSAM_CDE; //여과방법
btnBack = filtPltAddView.btnBack;
btnSave = filtPltAddView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회 - 신규관리번호 채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectFiltPltFTR_IDN");
FiltPltDtl result = new FiltPltDtl();
result = BizUtil.SelectObject(param) as FiltPltDtl;
//채번결과 매칭
this.FTR_IDN = result.FTR_IDN;
this.FTR_CDE = "SA113";
//공통팝업창 사이즈 변경 3
FmsUtil.popWinView.Height = 360;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
//신규 시설물 생성자
public UC_SPLY_LS(string _FTR_CDE) : this()
{
txtFTR_CDE.Text = _FTR_CDE;
//신규관리번호채번
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectSupDutFTR_IDN");
param.Add("FTR_CDE", "SA001");
SupDutDtl result = BizUtil.SelectObject(param) as SupDutDtl;
//채번결과 매칭
txtFTR_IDN.Text = result.FTR_IDN.ToString();
btnDel.Tag = "Y";//신규채번 플래그
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
valvFacDtlView = values[0] as ValvFacDtlView;
//cbFTR_CDE = valvFacDtlView.cbFTR_CDE; //지형지물
cbHJD_CDE = valvFacDtlView.cbHJD_CDE; //행정동
cbMNG_CDE = valvFacDtlView.cbMNG_CDE; //관리기관
cbVAL_MOF = valvFacDtlView.cbVAL_MOF; //형식
cbVAL_MOP = valvFacDtlView.cbVAL_MOP; //관재질
cbSAE_CDE = valvFacDtlView.cbSAE_CDE; //제수변회전방향
cbMTH_CDE = valvFacDtlView.cbMTH_CDE; //제수변구동방법
cbVAL_FOR = valvFacDtlView.cbVAL_FOR; //시설물형태
cbCST_CDE = valvFacDtlView.cbCST_CDE; //이상상태
cbOFF_CDE = valvFacDtlView.cbOFF_CDE; //개폐여부
btnBack = valvFacDtlView.btnBack;
btnDelete = valvFacDtlView.btnDelete;
btnSave = valvFacDtlView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회
//DataTable dt = new DataTable();
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectValvFacDtl");
param.Add("FTR_CDE", Dtl.FTR_CDE);
param.Add("FTR_IDN", Dtl.FTR_IDN);
this.Dtl = BizUtil.SelectObject(param) as ValvFacDtl;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
blk03DtlView = obj as Blk03DtlView;
cbMNG_CDE = blk03DtlView.cbMNG_CDE; //관리기관
cbUPPER_FTR_CDE = blk03DtlView.cbUPPER_FTR_CDE; //상위블록
cbUPPER_FTR_IDN = blk03DtlView.cbUPPER_FTR_IDN;
btnBack = blk03DtlView.btnBack;
btnDelete = blk03DtlView.btnDelete;
btnSave = blk03DtlView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회
//DataTable dt = new DataTable();
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectBlk03Dtl");
param.Add("FTR_CDE", Dtl.FTR_CDE);
param.Add("FTR_IDN", Dtl.FTR_IDN);
Dtl = BizUtil.SelectObject(param) as BlkDtl;
// cbUPPER_FTR_IDN 상위블록
BizUtil.SetFTR_IDN(Dtl.UPPER_FTR_CDE, cbUPPER_FTR_IDN);
// 콤보변경이벤트설정
cbUPPER_FTR_CDE.SelectedIndexChanged += OnUpFtrCdeChanged;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
//초기모델조회
private void InitModel()
{
//1.상세마스터
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectWttWserMa");
param.Add("WSER_SEQ", _WSER_SEQ);
WserDtl result = new WserDtl();
result = BizUtil.SelectObject(param) as WserDtl;
this.Dtl = result;
//다큐먼트는 따로 처리
Paragraph p = new Paragraph();
try
{
p.Inlines.Add(this.Dtl.APL_EXP ?? "");
cnstCmplDtlView.richAPL_EXP.Document.Blocks.Clear();
cnstCmplDtlView.richAPL_EXP.Document.Blocks.Add(p);
}
catch (Exception) {}
p = new Paragraph();
try
{
p.Inlines.Add(this.Dtl.PRO_EXP.Trim());
cnstCmplDtlView.richPRO_EXP.Document.Blocks.Clear();
cnstCmplDtlView.richPRO_EXP.Document.Blocks.Add(p);
}
catch (Exception) {}
//2.누수지점
param = new Hashtable();
param.Add("sqlId", "SelectCmplLeakList");
param.Add("RCV_NUM", this.Dtl.RCV_NUM);
dt = BizUtil.SelectList(param);
cnstCmplDtlView.grid.ItemsSource = dt;
}
/// <summary>
/// 조회작업
/// </summary>
private void initModel()
{
// 4.초기조회
//a.마스터
//DataTable dt = new DataTable();
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectChscMaList");
param.Add("SCL_NUM", Dtl.SCL_NUM);
Dtl = BizUtil.SelectObject(param) as ChscMaDtl;
//점검결과 다큐먼트 수동세팅
try
{
chkSchDtlView.richBox.Document.Blocks.Clear();
Paragraph paragraph = new Paragraph();
paragraph.Inlines.Add(Dtl.CHK_CTNT.Trim());
chkSchDtlView.richBox.Document.Blocks.Add(paragraph);
}
catch (Exception) {}
//b.점검결과
param = new Hashtable();
param.Add("sqlId", "SelectChscResultList");
param.Add("SCL_NUM", Dtl.SCL_NUM);
GrdLst = new ObservableCollection <ChscResultDtl>(BizUtil.SelectListObj <ChscResultDtl>(param));
// 1.1 점검결과 첫행선택
if (GrdLst.Count > 0)
{
//SEL_FTR_CDE = GrdLst[0].FTR_CDE.ToString();
//SEL_FTR_IDN = dt.Rows[0]["FTR_IDN"].ToString();
//SEL_SEQ = dt.Rows[0]["SEQ"].ToString();
}
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
blk01DtlView = obj as Blk01DtlView;
cbMNG_CDE = blk01DtlView.cbMNG_CDE; //관리기관
btnBack = blk01DtlView.btnBack;
btnDelete = blk01DtlView.btnDelete;
btnSave = blk01DtlView.btnSave;
//2.화면데이터객체 초기화
InitDataBinding();
//3.권한처리
permissionApply();
// 4.초기조회
//DataTable dt = new DataTable();
Hashtable param = new Hashtable();
param.Add("sqlId", "SelectBlk01Dtl");
param.Add("FTR_CDE", Dtl.FTR_CDE);
param.Add("FTR_IDN", Dtl.FTR_IDN);
Dtl = BizUtil.SelectObject(param) as BlkDtl;
}
catch (Exception e)
{
Console.WriteLine(e);
}
}