/// 생성자 public WtrTrkDtlViewMdl(string FTR_CDE, int FTR_IDN) { try { // 1.상세마스터 Hashtable param = new Hashtable(); param.Add("sqlId", "SelectWtrTrkDtl"); param.Add("FTR_CDE", FTR_CDE); param.Add("FTR_IDN", FTR_IDN); WtrTrkDtl result = new WtrTrkDtl(); result = BizUtil.SelectObject(param) as WtrTrkDtl; //결과를 뷰모델멤버로 매칭 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); //탭2 - 청소이력 param = new Hashtable(); param.Add("sqlId", "selectWttRsrvHtList"); param.Add("FTR_CDE", FTR_CDE); param.Add("FTR_IDN", FTR_IDN); this.Tab02List = (List <LinkWttRsrvHt>)BizUtil.SelectListObj <LinkWttRsrvHt>(param); } catch (Exception) {} }
//신규 시설물 생성자 public UC_RSRV_PS(string _FTR_CDE) : this() { txtFTR_CDE.Text = _FTR_CDE; //신규관리번호채번 Hashtable param = new Hashtable(); param.Add("sqlId", "SelectWtrTrkFTR_IDN"); WtrTrkDtl result = BizUtil.SelectObject(param) as WtrTrkDtl; //채번결과 매칭 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); } }
// 초기조회 private void InitModel() { Hashtable param = new Hashtable(); param.Add("sqlId", "SelectWtrTrkDtl"); param.Add("FTR_CDE", this.FTR_CDE); param.Add("FTR_IDN", this.FTR_IDN); WtrTrkDtl result = BizUtil.SelectObject(param) as WtrTrkDtl; if (result != null) { this.FctDtl = result; } else { //신규등록이면 상세화면표시 if ("Y".Equals(uC_RSRV_PS.btnDel.Tag)) { uC_RSRV_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; wtrTrkDtlView = values[0] as WtrTrkDtlView; //cbFTR_CDE = wtrTrkDtlView.cbFTR_CDE; //지형지물 cbHJD_CDE = wtrTrkDtlView.cbHJD_CDE; //행정동 cbMNG_CDE = wtrTrkDtlView.cbMNG_CDE; //관리기관 cbBLS_CDE = wtrTrkDtlView.cbBLS_CDE; //건물유형 btnBack = wtrTrkDtlView.btnBack; btnDelete = wtrTrkDtlView.btnDelete; btnSave = wtrTrkDtlView.btnSave; //2.화면데이터객체 초기화 InitDataBinding(); //3.권한처리 permissionApply(); // 4.초기조회 //DataTable dt = new DataTable(); Hashtable param = new Hashtable(); param.Add("sqlId", "SelectWtrTrkDtl"); param.Add("FTR_CDE", this.FTR_CDE); param.Add("FTR_IDN", this.FTR_IDN); WtrTrkDtl result = new WtrTrkDtl(); result = BizUtil.SelectObject(param) as WtrTrkDtl; //결과를 뷰모델멤버로 매칭 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); } }