//EST STATION EST 정보 관리 -> EST 기본 정보 public EsmStation GetEstIframeInfo(EstIframeInfoModels getModel, string estCode) { string errorStr = ""; EsmStation model = new EsmStation(); string listQuery = " SELECT SEQNO , " + string.Join(",", selectColumn_EstInfo) + " FROM esm_station WHERE EST_CODE = '" + estCode + "' "; //string listQuery = " SELECT SEQNO , " + string.Join(",", selectColumn_EstInfo) + " FROM esm_station ORDER BY SEQNO "; DataTable listDt = getQueryResult(listQuery, out errorStr); if (listDt != null && listDt.Rows.Count != 0) { model.SEQNO = int.Parse(listDt.Rows[0]["SEQNO"].ToString().Trim()); model.EST_CODE = listDt.Rows[0]["EST_CODE"].ToString().Trim(); model.EST_NAME = listDt.Rows[0]["EST_NAME"].ToString().Trim(); model.ZIPCODE = listDt.Rows[0]["ZIPCODE"].ToString().Trim(); model.ADDR = listDt.Rows[0]["ADDR"].ToString().Trim(); model.ADDR_EN = listDt.Rows[0]["ADDR_EN"].ToString().Trim(); model.TELNO = listDt.Rows[0]["TELNO"].ToString().Trim(); model.CREATETIME = listDt.Rows[0]["CREATETIME"].ToString().Trim(); model.MEMO = listDt.Rows[0]["MEMO"].ToString().Trim(); model.NATION_CODE = listDt.Rows[0]["NATION_CODE"].ToString().Trim(); model.START_AIRPORT = listDt.Rows[0]["START_AIRPORT"].ToString().Trim(); model.WEIGHT_UNIT = listDt.Rows[0]["WEIGHT_UNIT"].ToString().Trim(); model.UTC_HOUR = int.Parse(listDt.Rows[0]["UTC_HOUR"].ToString().Trim()); model.UTC_MINUTE = int.Parse(listDt.Rows[0]["UTC_MINUTE"].ToString().Trim()); model.UTC_SUMMER_TIME = int.Parse(listDt.Rows[0]["UTC_SUMMER_TIME"].ToString().Trim()); model.USERINPUTCODE = listDt.Rows[0]["USERINPUTCODE"].ToString().Trim(); model.STATUS = int.Parse(listDt.Rows[0]["STATUS"].ToString().Trim()); } return(model); }
public EstInfoModels GetEstInfoList(EstInfoModels model) { string errorStr = ""; string listQuery = " SELECT SEQNO , " + string.Join(",", selectColumn_EstInfo); string cntQuery = " SELECT count(*) as cnt "; string baseQuery = " FROM esm_station WHERE 1=1 "; if (!String.IsNullOrEmpty(model.schType)) //국가 { baseQuery += " AND NATION_CODE = " + model.schType.Trim(); } if (!String.IsNullOrEmpty(model.station)) //STATION { baseQuery += " AND EST_CODE = " + model.station.Trim(); } if (!String.IsNullOrEmpty(model.schSdt)) //생성날짜 (시작일) { baseQuery += " AND CREATETIME >= " + model.schSdt.Trim(); } if (!String.IsNullOrEmpty(model.schEdt)) //생성날짜 (종료일) { baseQuery += " AND CREATETIME <= " + model.schEdt.Trim(); } if (!String.IsNullOrEmpty(model.schTypeTxt) && !String.IsNullOrEmpty(model.schTxt)) //검색조건 검색어 { baseQuery += " AND " + model.schTypeTxt.Trim() + " like '%" + model.schTxt.Trim() + "%' "; } string endQuery = " ORDER BY " + model.sortKey.ToString().Trim() + " DESC limit " + ((model.Paging.page - 1) * model.Paging.pageNum) + " , " + model.Paging.pageNum; //정렬 cntQuery += baseQuery; //토탈 카운트 쿼리 listQuery += baseQuery + endQuery; //리스트 쿼리 int totCnt = getQueryCnt(cntQuery, out errorStr); //전체 리스트 갯수 구하기 model.Paging.pageTotNum = (totCnt / model.Paging.pageNum) + 1; //총 페이징 갯수 구하기 DataTable listDt = getQueryResult(listQuery, out errorStr); if (listDt != null && listDt.Rows.Count != 0) { for (int i = 0; i < listDt.Rows.Count; i++) { EsmStation temp = new EsmStation(); temp.SEQNO = int.Parse(listDt.Rows[i]["SEQNO"].ToString().Trim()); temp.EST_CODE = listDt.Rows[i]["EST_CODE"].ToString().Trim(); temp.EST_NAME = listDt.Rows[i]["EST_NAME"].ToString().Trim(); temp.ZIPCODE = listDt.Rows[i]["ZIPCODE"].ToString().Trim(); temp.ADDR = listDt.Rows[i]["ADDR"].ToString().Trim(); temp.ADDR_EN = listDt.Rows[i]["ADDR_EN"].ToString().Trim(); temp.TELNO = listDt.Rows[i]["TELNO"].ToString().Trim(); temp.CREATETIME = listDt.Rows[i]["CREATETIME"].ToString().Trim(); temp.MEMO = listDt.Rows[i]["MEMO"].ToString().Trim(); temp.NATION_CODE = listDt.Rows[i]["NATION_CODE"].ToString().Trim(); temp.START_AIRPORT = listDt.Rows[i]["START_AIRPORT"].ToString().Trim(); temp.WEIGHT_UNIT = listDt.Rows[i]["WEIGHT_UNIT"].ToString().Trim(); temp.UTC_HOUR = int.Parse(listDt.Rows[i]["UTC_HOUR"].ToString().Trim()); temp.UTC_MINUTE = int.Parse(listDt.Rows[i]["UTC_MINUTE"].ToString().Trim()); temp.UTC_SUMMER_TIME = int.Parse(listDt.Rows[i]["UTC_SUMMER_TIME"].ToString().Trim()); temp.USERINPUTCODE = listDt.Rows[i]["USERINPUTCODE"].ToString().Trim(); temp.STATUS = int.Parse(listDt.Rows[i]["STATUS"].ToString().Trim()); //Comnation 에서 국가 목록을 다 긁어와서 넣어줘야 한다. model.Items.Add(temp); } } return(model); }