public ActionResult EstInfo(EstInfoModels model)
{
//권한 체크===================================================
if (!chk.chkPermission("EstInfo", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
if (TempData["PublicMsg"] != null)
{
ViewBag.PublicMsg = TempData["PublicMsg"].ToString();
}
ViewData["pageing"] = comM.setPaging(model.Paging); //페이징 HTML 만들기
//셀렉트박스
model.Item.NATION_CODE = model.schType;
model.Item.EST_CODE = model.station;
model.nationArray = act.GetNationCodeSelectBox();
model = act.GetEstInfoList(model); //리스트 가져오기
return(View(model));
}
// GET: Est EST STATION EST 정보 관리
public ActionResult EstInfo(string searchString, string msg)
{
//권한 체크===================================================
if (!chk.chkPermission("EstInfo", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = null;
if (!string.IsNullOrEmpty(msg))
{
TempData["PublicMsg"] = msg;
}
EstInfoModels model = new EstInfoModels();
//페이징 설정 초기화
model.Paging.page = 1;
model.Paging.pageNum = 10;
model.sortKey = "SEQNO";
//리스트 가져오기
model = act.GetEstInfoList(model);
ViewData["pageing"] = comM.setPaging(model.Paging); //페이징 HTML 만들기
//셀렉트박스
model.nationArray = act.GetNationCodeSelectBox();
//model.stationArray = act.GetEstCodeSelectBox();
return(View(model));
}
// GET: Est EST STATION EST 정보 관리 뷰 팝업
public ActionResult EstInfoView(string msg, string estCode)
{
//권한 체크===================================================
if (!chk.chkPermission("EstInfo", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = null;
if (!string.IsNullOrEmpty(msg))
{
TempData["PublicMsg"] = msg;
}
EstInfoModels model = new EstInfoModels();
model.viewEstCode = estCode;
return(View(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);
}
