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