/// <summary> /// 조회 /// </summary> /// <param name="obj"></param> private void SearchAction(object obj) { try { //if (treeList.FocusedNode == null) return; Hashtable conditions = new Hashtable(); conditions.Add("HJD_CDE", cbHJD_CDE.EditValue); conditions.Add("FTR_CDE", cbFTR_CDE.EditValue); conditions.Add("FTR_IDN", FmsUtil.Trim(txtFTR_IDN.EditValue)); conditions.Add("FTR_NAM", FmsUtil.Trim(txtFTR_NAM.EditValue)); conditions.Add("CNT_NUM", txtCNT_NUM.Text.Trim()); conditions.Add("CNT_NAM", txtCNT_NAM.Text.Trim()); //conditions.Add("USE_YB", "Y"); conditions.Add("sqlId", "SelectFtrAllList"); /* * 조회후 페이징소스 업데이트 */ 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 ex) { this.TotalCnt = 0; this.ItemCnt = 0; Console.WriteLine(ex.Message); } this.PagedCollection.Clear(); this.PagedCollection.Add(dt); }); } catch (Exception ex) { Messages.ShowErrMsgBoxLog(ex); } }
/// <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> /// <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); } }