/// 생성자 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) {} }
//신규 시설물 생성자 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); } }
// 초기조회 private void InitModel() { Hashtable param = new Hashtable(); param.Add("sqlId", "SelectHydtMetrDtl"); param.Add("FTR_CDE", this.FTR_CDE); param.Add("FTR_IDN", this.FTR_IDN); HydtMetrDtl result = BizUtil.SelectObject(param) as HydtMetrDtl; if (result != null) { this.FctDtl = result; } else { //신규등록이면 상세화면표시 if ("Y".Equals(uC_META_PS.btnDel.Tag)) { uC_META_PS.grid.Visibility = Visibility.Visible; //DB데이터가 없으면 빈페이지표시 } } }
/// <summary> /// 로딩작업 /// </summary> /// <param name="obj"></param> private void OnLoaded(object obj) { try { // 0.화면객체인스턴스화 if (obj == null) { return; } var values = (object[])obj; hydtMetrDtlView = values[0] as HydtMetrDtlView; //cbFTR_CDE = hydtMetrDtlView.cbFTR_CDE; //지형지물 cbHJD_CDE = hydtMetrDtlView.cbHJD_CDE; //행정동 cbHOM_HJD = hydtMetrDtlView.cbHOM_HJD; //수용가행정동 cbSBI_CDE = hydtMetrDtlView.cbSBI_CDE; //업종 cbMET_MOF = hydtMetrDtlView.cbMET_MOF; //형식 btnBack = hydtMetrDtlView.btnBack; btnDelete = hydtMetrDtlView.btnDelete; btnSave = hydtMetrDtlView.btnSave; //2.화면데이터객체 초기화 InitDataBinding(); //3.권한처리 permissionApply(); // 4.초기조회 //DataTable dt = new DataTable(); Hashtable param = new Hashtable(); param.Add("sqlId", "SelectHydtMetrDtl"); param.Add("FTR_CDE", this.FTR_CDE); param.Add("FTR_IDN", this.FTR_IDN); HydtMetrDtl result = new HydtMetrDtl(); result = BizUtil.SelectObject(param) as HydtMetrDtl; //결과를 뷰모델멤버로 매칭 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)); } } catch (Exception e) { Console.WriteLine(e); } }