/// <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);
}
}