/// 생성자 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() { 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)); } }
/// 생성자 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) {} }
/// <summary> /// 초기조회 및 바인딩 /// </summary> private void InitDataBinding() { try { // cbMNG_CDE 관리기관 BizUtil.SetCmbCode(cbMNG_CDE, "250101", "선택"); // cbUPPER_FTR_CDE 상위블록코드 //Func<DataRow, bool> filter = Row => (Row.Field<string>("FTR_CDE").Contains("BZ001") || Row.Field<string>("FTR_CDE").Contains("BZ002"));//대블록,중블록 //BizUtil.SetCombo(cbUPPER_FTR_CDE, "Select_FTR_LIST", "FTR_CDE", "FTR_NAM", null, filter); cbUPPER_FTR_CDE.DisplayMember = "FTR_NAM"; cbUPPER_FTR_CDE.ValueMember = "FTR_CDE"; Hashtable param = new Hashtable(); param.Add("sqlId", "Select_FTR_LIST3"); param.Add("FTR_CDE", "BZ"); List <FctDtl> lst = BizUtil.SelectListObj <FctDtl>(param) as List <FctDtl>; ItemLst = lst.FindAll(f => !f.FTR_CDE.Contains("BZ003")); } catch (Exception ex) { Messages.ShowErrMsgBoxLog(ex); } }
//초기모델조회 private void InitModel() { Hashtable param = new Hashtable(); param.Add("sqlId", "SelectFileDtl2"); param.Add("FIL_SEQ", txtFIL_SEQ.Text); ItemsSelect = new ObservableCollection <FileDtl>(BizUtil.SelectListObj <FileDtl>(param)); }
/// 생성자 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() { try { //초기조회 Hashtable param = new Hashtable(); param.Add("sqlId", "SelectPdjtInHtPopList"); param.Add("PDH_NUM", PDH_NUM); GrdLst = new ObservableCollection <PdjtInDtl>(BizUtil.SelectListObj <PdjtInDtl>(param)); } catch (Exception e) { Console.WriteLine(e); } }
/// <summary> /// 조회작업 /// </summary> private void initModel() { try { //초기조회 Hashtable param = new Hashtable(); param.Add("sqlId", "SelectWttSubcDtList2"); param.Add("CNT_NUM", this.CNT_NUM); GrdLst = new ObservableCollection <WttSubcDt>(BizUtil.SelectListObj <WttSubcDt>(param)); } catch (Exception e) { Console.WriteLine(e); } }
// 업로드 스레드핸들러 private void UploadFileListFX() { try { //로딩바.. fileMngView.Dispatcher.Invoke(DispatcherPriority.ApplicationIdle, new Action((delegate() { (fileMngView.FindName("waitindicator") as WaitIndicator).DeferedVisibility = true; }))); //업로드시작... UploadFileList(); // 생성된 첨부파일아이디 반환 -> 뷰쪽으로 바인딩 -> 부모창에서 접근가능 Dtl.FIL_SEQ = ret_fil_seq; fileMngView.Dispatcher.Invoke(DispatcherPriority.ApplicationIdle, new Action((delegate() { (fileMngView.FindName("waitindicator") as WaitIndicator).DeferedVisibility = false; //첨부파일 그리드에 재조회 Hashtable param = new Hashtable(); param.Add("sqlId", "SelectFileDtl2"); param.Add("FIL_SEQ", Dtl.FIL_SEQ); ItemsSelect = new ObservableCollection <FileDtl>(BizUtil.SelectListObj <FileDtl>(param)); Messages.ShowOkMsgBox(); //팝업닫기 //btnClose.RaiseEvent(new RoutedEventArgs(Button.ClickEvent)); }))); } catch (Exception ex) { fileMngView.Dispatcher.Invoke(DispatcherPriority.ApplicationIdle, new Action((delegate() { (fileMngView.FindName("waitindicator") as WaitIndicator).DeferedVisibility = false; Messages.ShowErrMsgBoxLog(ex); }))); } }
/// <summary> /// 조회작업 /// </summary> private void initModel() { try { //초기조회 Hashtable param = new Hashtable(); param.Add("sqlId", "SelectPdhUseList"); param.Add("SCL_NUM", SCL_NUM); param.Add("FTR_CDE", FTR_CDE); param.Add("FTR_IDN", FTR_IDN); param.Add("SEQ", SEQ); param.Add("PDT_CAT_CDE", PDT_CAT_CDE); //소모품 GrdLst = new ObservableCollection <PdjtHtDtl>(BizUtil.SelectListObj <PdjtHtDtl>(param)); } catch (Exception e) { Console.WriteLine(e); } }
/// <summary> /// 조회작업 /// </summary> private void SearchAction(object obj) { try { DataTable dt = new DataTable(); Hashtable param = new Hashtable(); param.Add("sqlId", "SelectPdjtMaMngList"); param.Add("PDT_NAM", pdjtMngListView.txtPDT_NAM.Text); param.Add("PDT_MDL_STD", pdjtMngListView.txtPDT_MDL_STD.Text); param.Add("PDT_MNF", pdjtMngListView.txtPDT_MNF.Text); param.Add("PDT_CAT_CDE", pdjtMngListView.cbPDT_CAT_CDE.EditValue); //소모품 GrdLst = new ObservableCollection <PdjtMaDtl>(BizUtil.SelectListObj <PdjtMaDtl>(param)); } catch (Exception e) { Console.WriteLine(e); } }
/// <summary> /// 초기화 바인딩 /// </summary> private void InitDataBinding() { try { // cbMNG_CDE 관리기관 BizUtil.SetCmbCode(uC_BLKS_AS.cbMNG_CDE, "250101", "선택"); uC_BLKS_AS.cbUPPER_FTR_CDE.DisplayMember = "FTR_NAM"; uC_BLKS_AS.cbUPPER_FTR_CDE.ValueMember = "FTR_CDE"; Hashtable param = new Hashtable(); param.Add("sqlId", "Select_FTR_LIST3"); param.Add("FTR_CDE", "BZ"); List <FctDtl> lst = BizUtil.SelectListObj <FctDtl>(param) as List <FctDtl>; ItemLst = lst.FindAll(f => !f.FTR_CDE.Contains("BZ003")); } catch (Exception ex) { Messages.ShowErrMsgBoxLog(ex); } }
/// <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> private void SearchAction() { DataTable dt = new DataTable(); Hashtable param = new Hashtable(); param.Add("sqlId", "SelectChscMaList"); param.Add("TIT_NAM", txtTIT_NAM.Text); param.Add("CKM_PEO", txtCKM_PEO.Text); //점검월 param.Add("CHK_YM", Convert.ToDateTime(dtCHK_YM.EditValue).ToString("yyyyMM")); param.Add("MNG_CDE", cbMNG_CDE.EditValue); //관리기관 param.Add("SCL_CDE", cbSCL_CDE.EditValue); param.Add("SCL_STAT_CDE", cbSCL_STAT_CDE.EditValue); List <ChscMaDtl> lst = (List <ChscMaDtl>)BizUtil.SelectListObj <ChscMaDtl>(param); grid.ItemsSource = lst; }
// 초기조회 private void InitModel() { try { ChscMaLst.Clear(); } catch (Exception) { } //리소스소스 ResSrcs = new ObservableCollection <ResSrc>(); ResSrcs.Add(ResSrc.Create(Id: 1, Name: "점검일정")); //점검스케줄 Hashtable param = new Hashtable(); param.Add("sqlId", "SelectChscMaList"); param.Add("MNG_CDE", cbMNG_CDE.EditValue); param.Add("SCL_CDE", cbSCL_CDE.EditValue); param.Add("SCL_STAT_CDE", cbSCL_STAT_CDE.EditValue); param.Add("TIT_NAM", txtTIT_NAM.Text.Trim()); param.Add("CKM_PEO", txtCKM_PEO.Text.Trim()); ChscMaLst = new ObservableCollection <ChscMaDtl>(BizUtil.SelectListObj <ChscMaDtl>(param)); //기존목록 이벤트핸들러 등록 /* */ foreach (ChscMaDtl item in ChscMaLst) { item.PropertyChanged += ChscMaDtl_PropertyChanged; } //목록변경 이벤트핸들러 등록 ChscMaLst.CollectionChanged += Lst_CollectionChanged; }
/// 생성자 public CnstMngDtlViewMdl(string CNT_NUM) { try { // 1.상세마스터 Hashtable param = new Hashtable(); param.Add("sqlId", "SelectWttConsMaDtl"); param.Add("CNT_NUM", CNT_NUM); CnstDtl result = new CnstDtl(); result = BizUtil.SelectObject(param) as CnstDtl; //결과를 뷰모델멤버로 매칭 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.Tab(4) //공사비지급내역 param = new Hashtable(); param.Add("CNT_NUM", CNT_NUM); param.Add("sqlId", "SelectWttCostDtList"); this.Tab01List = (List <WttCostDt>)BizUtil.SelectListObj <WttCostDt>(param); //설계변경내역 param = new Hashtable(); param.Add("CNT_NUM", CNT_NUM); param.Add("sqlId", "SelectWttChngDtList"); this.Tab02List = (List <WttChngDt>)BizUtil.SelectListObj <WttChngDt>(param); //공사하도급내역 param = new Hashtable(); param.Add("CNT_NUM", CNT_NUM); param.Add("sqlId", "SelectWttSubcDtList2"); this.Tab03List = (List <WttSubcDt>)BizUtil.SelectListObj <WttSubcDt>(param); //하자보수목록 param = new Hashtable(); param.Add("CNT_NUM", CNT_NUM); param.Add("sqlId", "SelectWttFlawDtList"); this.Tab04List = (List <WttFlawDt>)BizUtil.SelectListObj <WttFlawDt>(param); } catch (Exception) {} }