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 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) {} }
/// <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_PIPE_LM(string _FTR_CDE) : this() { txtFTR_CDE.Text = _FTR_CDE; //신규관리번호채번 Hashtable param = new Hashtable(); param.Add("sqlId", "SelectWtlPipeFTR_IDN"); param.Add("FTR_CDE", "SA001"); PipeDtl result = BizUtil.SelectObject(param) as PipeDtl; //채번결과 매칭 txtFTR_IDN.Text = result.FTR_IDN.ToString(); btnDel.Tag = "Y";//신규채번 플래그 }
// 초기조회 private void InitModel() { Hashtable param = new Hashtable(); param.Add("sqlId", "SelectWtlPipeDtl2"); param.Add("FTR_CDE", this.FTR_CDE); param.Add("FTR_IDN", this.FTR_IDN); PipeDtl result = BizUtil.SelectObject(param) as PipeDtl; if (result != null) { this.FctDtl = result; } else { //신규등록이면 상세화면표시 if ("Y".Equals(uC_PIPE_LM.btnDel.Tag)) { uC_PIPE_LM.grid.Visibility = Visibility.Visible; //DB데이터가 없으면 빈페이지표시 } } }