/// <summary>
/// 조회
/// </summary>
/// <param name="obj"></param>
private void SearchAction(object obj)
{
try
{
//if (treeList.FocusedNode == null) return;
Hashtable conditions = new Hashtable();
conditions.Add("RCV_NUM", cnstCmplSelView.txtRCV_NUM.Text.Trim());
conditions.Add("APL_HJD", cbHJD_CDE.EditValue);
conditions.Add("APL_CDE", cbAPL_CDE.EditValue);
conditions.Add("PRO_CDE", cbPRO_CDE.EditValue);
conditions.Add("RCV_YMD_FROM", cnstCmplSelView.dtRCV_YMD_FROM.EditValue == null ? "" : Convert.ToDateTime(cnstCmplSelView.dtRCV_YMD_FROM.EditValue).ToString("yyyyMMdd"));
conditions.Add("RCV_YMD_TO", cnstCmplSelView.dtRCV_YMD_TO.EditValue == null ? "" : Convert.ToDateTime(cnstCmplSelView.dtRCV_YMD_TO.EditValue).ToString("yyyyMMdd"));
conditions.Add("PRO_YMD_FROM", cnstCmplSelView.dtPRO_YMD_FROM.EditValue == null ? "" : Convert.ToDateTime(cnstCmplSelView.dtPRO_YMD_FROM.EditValue).ToString("yyyyMMdd"));
conditions.Add("PRO_YMD_TO", cnstCmplSelView.dtPRO_YMD_TO.EditValue == null ? "" : Convert.ToDateTime(cnstCmplSelView.dtPRO_YMD_TO.EditValue).ToString("yyyyMMdd"));
conditions.Add("sqlId", "SelectCnstCmplList");
/*
* 조회후 페이징소스 업데이트
*/
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
{
//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 SearchAction(object obj)
{
try
{
//if (treeList.FocusedNode == null) return;
Hashtable conditions = new Hashtable();
conditions.Add("TTL", txtTTL.Text.Trim());
conditions.Add("FTR_CDE", cbFTR_CDE.EditValue);
conditions.Add("FAQ_CAT_CDE", cbFAQ_CAT_CDE.EditValue);
conditions.Add("FAQ_CUZ_CDE", cbFAQ_CUZ_CDE.EditValue);
conditions.Add("sqlId", "SelectFaqList");
/*
* 조회후 페이징소스 업데이트
*/
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
{
//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);
}
}