/// <summary> /// 엑셀다운로드 /// </summary> /// <param name="obj"></param> private void ExcelDownAction(object obj) { try { /// 데이터조회 Hashtable conditions = new Hashtable(); conditions.Add("MNG_CDE", cbMNG_CDE.EditValue); conditions.Add("HJD_CDE", cbHJD_CDE.EditValue); conditions.Add("MOF_CDE", cbMOF_CDE.EditValue); conditions.Add("FTR_IDN", FmsUtil.Trim(txtFTR_IDN.EditValue)); conditions.Add("CNT_NUM", txtCNT_NUM.Text.Trim()); conditions.Add("SHT_NUM", txtSHT_NUM.Text.Trim()); conditions.Add("FIR_DIP", txtFIR_DIP.Text.Trim()); conditions.Add("SUP_HIT", txtSUP_HIT.Text.Trim()); try { conditions.Add("IST_YMD_FROM", dtIST_YMD_FROM.EditValue == null ? null : Convert.ToDateTime(dtIST_YMD_FROM.EditValue).ToString("yyyyMMdd")); conditions.Add("IST_YMD_TO", dtIST_YMD_TO.EditValue == null ? null : Convert.ToDateTime(dtIST_YMD_TO.EditValue).ToString("yyyyMMdd")); } catch (Exception) { } if (!BizUtil.ValidDateBtw(conditions["IST_YMD_FROM"], conditions["IST_YMD_TO"])) { Messages.ShowInfoMsgBox("설치일자 범위를 확인하세요"); return; } conditions.Add("page", 0); conditions.Add("rows", 1000000); conditions.Add("sqlId", "SelectFireFacList"); exceldt = BizUtil.SelectList(conditions); saveFileDialog = null; saveFileDialog = new System.Windows.Forms.SaveFileDialog(); saveFileDialog.Title = "저장경로를 지정하세요."; //초기 파일명 지정 saveFileDialog.FileName = DateTime.Now.ToString("yyyyMMdd") + "_" + "소방시설목록.xlsx"; saveFileDialog.OverwritePrompt = true; saveFileDialog.Filter = "Excel|*.xlsx"; //그리드헤더정보 추출 columnList = new GridColumn[grid.Columns.Count]; grid.Columns.CopyTo(columnList, 0); listCols = new List <string>(); //컬럼헤더정보 가져오기 foreach (GridColumn gcol in columnList) { try { if ("PrintN".Equals(gcol.Tag.ToString())) { continue; //엑셀출력제외컬럼 } } catch (Exception) { } listCols.Add(gcol.FieldName.ToString()); } if (saveFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { strFileName = saveFileDialog.FileName; thread = new Thread(new ThreadStart(ExcelExportFX)); thread.Start(); } } catch (Exception ex) { Messages.ShowErrMsgBoxLog(ex); } }
/// <summary> /// 생성자 /// </summary> public ChkSchAddViewModel() { /* RichTextBox를 바인딩하기위한 부분 : 사용안함 * FlowDocument d = new FlowDocument(); * Paragraph paragraph = new Paragraph(); * Run a = new Run(); * a.Text = "ASDFASDFASDFASDFASDF"; * paragraph.Inlines.Add(a); * d.Blocks.Add(paragraph); * * Doc = d; */ dtl = new ChscMaDtl(); this.LoadedCommand = new DelegateCommand <object>(delegate(object obj) { // 0.화면객체인스턴스화 if (obj == null) { return; } chkSchAddView = obj as ChkSchAddView; cbMNG_CDE = chkSchAddView.cbMNG_CDE; cbSCL_CDE = chkSchAddView.cbSCL_CDE; btnSave = chkSchAddView.btnSave; btnClose = chkSchAddView.btnClose; //2.화면데이터객체 초기화 InitDataBinding(); //3.권한처리 permissionApply(); }); //신규저장 this.SaveCommand = new DelegateCommand <object>(delegate(object obj) { // 필수체크 (Tag에 필수체크 표시한 EditBox, ComboBox 대상으로 수행) if (!BizUtil.ValidReq(chkSchAddView)) { return; } //날짜체크 if (!BizUtil.ValidDateBtw(Dtl.STA_YMD, Dtl.END_YMD)) { Messages.ShowInfoMsgBox("점검일자 범위를 확인하세요"); return; } if (Messages.ShowYesNoMsgBox("저장하시겠습니까?") != MessageBoxResult.Yes) { return; } try { //다큐먼트는 따로 처리 this.Dtl.CHK_CTNT = new TextRange(chkSchAddView.richBox.Document.ContentStart, chkSchAddView.richBox.Document.ContentEnd).Text.Trim(); BizUtil.Update2(this.Dtl, "SaveChscMaDtl"); } catch (Exception ex) { Messages.ShowErrMsgBox("저장 처리중 오류가 발생하였습니다." + ex.Message); return; } Messages.ShowOkMsgBox(); //화면닫기 btnClose.RaiseEvent(new RoutedEventArgs(Button.ClickEvent)); }); }
/// <summary> /// 조회 /// </summary> /// <param name="obj"></param> private void SearchAction(object obj) { try { //if (treeList.FocusedNode == null) return; Hashtable conditions = new Hashtable(); conditions.Add("MNG_CDE", cbMNG_CDE.EditValue); conditions.Add("HJD_CDE", cbHJD_CDE.EditValue); conditions.Add("MOF_CDE", cbMOF_CDE.EditValue); conditions.Add("FTR_IDN", FmsUtil.Trim(txtFTR_IDN.EditValue)); conditions.Add("CNT_NUM", txtCNT_NUM.Text.Trim()); conditions.Add("SHT_NUM", txtSHT_NUM.Text.Trim()); conditions.Add("FIR_DIP", txtFIR_DIP.Text.Trim()); conditions.Add("SUP_HIT", txtSUP_HIT.Text.Trim()); try { conditions.Add("IST_YMD_FROM", dtIST_YMD_FROM.EditValue == null ? null : Convert.ToDateTime(dtIST_YMD_FROM.EditValue).ToString("yyyyMMdd")); conditions.Add("IST_YMD_TO", dtIST_YMD_TO.EditValue == null ? null : Convert.ToDateTime(dtIST_YMD_TO.EditValue).ToString("yyyyMMdd")); } catch (Exception) { } if (!BizUtil.ValidDateBtw(conditions["IST_YMD_FROM"], conditions["IST_YMD_TO"])) { Messages.ShowInfoMsgBox("설치일자 범위를 확인하세요"); return; } conditions.Add("sqlId", "SelectFireFacList"); /* * 조회후 페이징소스 업데이트 */ int page_idx = 0; //페이지버튼으로 조회 if (obj is int) { page_idx = (int)obj; } //조회버튼으로 조회는 버튼위치(PageIndex) 초기화 else { PageIndex = -1; } BizUtil.SelectListPage(conditions, page_idx, delegate(DataTable dt) { // TotalCnt 설정 try { this.TotalCnt = Convert.ToInt32(dt.Rows[0]["ROWCNT"]); this.ItemCnt = (int)Math.Ceiling((double)this.TotalCnt / FmsUtil.PageSize); } catch (Exception) { this.TotalCnt = 0; this.ItemCnt = 0; } this.PagedCollection.Clear(); this.PagedCollection.Add(dt); }); } catch (Exception ex) { Messages.ShowErrMsgBoxLog(ex); } }
/// <summary> /// 조회 /// </summary> /// <param name="obj"></param> private void SearchAction(object obj) { try { Hashtable conditions = new Hashtable(); conditions.Add("CNT_CDE", cbCNT_CDE.EditValue); conditions.Add("CNT_NUM", txtCNT_NUM.Text.Trim()); conditions.Add("CNT_NAM", txtCNT_NAM.Text.Trim()); conditions.Add("TCT_AMT_FROM", txtTCT_AMT_FROM.EditValue); conditions.Add("TCT_AMT_TO", txtTCT_AMT_TO.EditValue); try { conditions.Add("BEG_YMD_FROM", dtBEG_YMD_FROM.EditValue == null ? null : Convert.ToDateTime(dtBEG_YMD_FROM.EditValue).ToString("yyyyMMdd")); conditions.Add("BEG_YMD_TO", dtBEG_YMD_TO.EditValue == null ? null : Convert.ToDateTime(dtBEG_YMD_TO.EditValue).ToString("yyyyMMdd")); } catch (Exception) { } try { conditions.Add("FNS_YMD_FROM", dtFNS_YMD_FROM.EditValue == null ? null : Convert.ToDateTime(dtFNS_YMD_FROM.EditValue).ToString("yyyyMMdd")); conditions.Add("FNS_YMD_TO", dtFNS_YMD_TO.EditValue == null ? null : Convert.ToDateTime(dtFNS_YMD_TO.EditValue).ToString("yyyyMMdd")); } catch (Exception) { } if (!BizUtil.ValidDateBtw(conditions["TCT_AMT_FROM"], conditions["TCT_AMT_TO"])) { Messages.ShowInfoMsgBox("계약금액 범위를 확인하세요"); return; } if (!BizUtil.ValidDateBtw(conditions["BEG_YMD_FROM"], conditions["BEG_YMD_TO"])) { Messages.ShowInfoMsgBox("착공일자 범위를 확인하세요"); return; } if (!BizUtil.ValidDateBtw(conditions["FNS_YMD_FROM"], conditions["FNS_YMD_TO"])) { Messages.ShowInfoMsgBox("준공일자 범위를 확인하세요"); return; } conditions.Add("CTT_CDE", cbCTT_CDE.EditValue); conditions.Add("CNT_LOC", txtCNT_LOC.Text.Trim()); conditions.Add("sqlId", "SelectWttConsMaList"); /* * 조회후 페이징소스 업데이트 */ int page_idx = 0; //페이징 버튼으로 조회 if (obj is int) { page_idx = (int)obj; } //조회버튼으로 조회는 버튼위치(PageIndex) 초기화 else { PageIndex = -1; } BizUtil.SelectListPage(conditions, page_idx, delegate(DataTable dt) { // TotalCnt 설정 try { this.TotalCnt = Convert.ToInt32(dt.Rows[0]["ROWCNT"]); this.ItemCnt = (int)Math.Ceiling((double)this.TotalCnt / FmsUtil.PageSize); } catch (Exception) { this.TotalCnt = 0; this.ItemCnt = 0; } //조회결과 매핑 this.PagedCollection.Clear(); this.PagedCollection.Add(dt); }); } catch (Exception ex) { Messages.ShowErrMsgBoxLog(ex); } }