public string SetEstIframeInfo(EstIframeInfoModels model) { string result = ""; string errorStr = ""; //(msh)추가 2018-06-26 오후16:39 string exeQueryStr = " UPDATE esm_station SET "; exeQueryStr += " EST_NAME = '" + model.Item.EST_NAME + "' "; exeQueryStr += ", ZIPCODE = '" + model.Item.ZIPCODE + "' "; exeQueryStr += ", ADDR = '" + model.Item.ADDR + "' "; exeQueryStr += ", ADDR_EN = '" + model.Item.ADDR_EN + "' "; exeQueryStr += ", TELNO = '" + model.Item.TELNO + "' "; exeQueryStr += ", CREATETIME = CURRENT_TIMESTAMP "; exeQueryStr += ", MEMO = '" + model.Item.MEMO + "' "; exeQueryStr += ", NATION_CODE = '" + model.Item.NATION_CODE + "' "; exeQueryStr += ", START_AIRPORT = '" + model.Item.START_AIRPORT + "' "; exeQueryStr += ", WEIGHT_UNIT = '" + model.Item.WEIGHT_UNIT + "' "; exeQueryStr += ", UTC_HOUR = " + model.Item.UTC_HOUR + " "; exeQueryStr += ", UTC_MINUTE = " + model.Item.UTC_MINUTE + " "; exeQueryStr += ", UTC_SUMMER_TIME = " + model.Item.UTC_SUMMER_TIME + " "; exeQueryStr += ", STATUS = " + model.Item.STATUS + " "; exeQueryStr += " WHERE EST_CODE = '" + model.viewEstCode + "' "; if (exeQuery(exeQueryStr, out errorStr)) { result = "성공."; } else { result = "실패."; } return(result); }
//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 ActionResult EstIframeInfo(EstIframeInfoModels model, string viewEstCode) { //권한 체크=================================================== if (!chk.chkPermission("EstInfo", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== if (!ModelState.IsValid) { return(View(model)); } //Select Box로 설정한 값을 item에 넣기. //model.Item.EST_CODE = model.station; model.Item.NATION_CODE = model.schType; model.Item.WEIGHT_UNIT = model.WEIGHT_UNIT; //라디오버튼 쓰기 if (model.RadioBoxPop == true) { model.Item.STATUS = 1; } else { model.Item.STATUS = 0; } model.RadioBoxPop = false; if (model.Item.STATUS == 1) { model.RadioBoxPop = true; } //라디오버튼 쓰기2 if (model.RadioBoxSummerT == true) { model.Item.STATUS = 1; } else { model.Item.STATUS = 0; } model.RadioBoxSummerT = false; if (model.Item.UTC_SUMMER_TIME == 1) { model.RadioBoxSummerT = true; } if (TempData["PublicMsg"] != null) { ViewBag.PublicMsg = TempData["PublicMsg"].ToString(); } ViewBag.PublicPopupMsg = act.SetEstIframeInfo(model); return(View(model)); }
//EST 기본정보 ==================================================================================================== // GET: Est EST STATION Est 정보 관리 -> EST 기본정보 public ActionResult EstIframeInfo(string msg, string estCode, string NATION_CODE) { //권한 체크=================================================== if (!chk.chkPermission("EstInfo", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== TempData["PublicMsg"] = null; if (!string.IsNullOrEmpty(msg)) { TempData["PublicMsg"] = msg; } EstIframeInfoModels model = new EstIframeInfoModels(); model.viewEstCode = estCode; model.Item = act.GetEstIframeInfo(model, estCode); //Select Box 설정 model.nationArray = comF.GetCommNationSelectBox(); model.weightArray = comF.GetWeightSelectBox(); model.stationArray = act.GetEstCodeSelectBox(estCode); //라디오버튼 쓰기 if (model.RadioBoxPop == true) { model.Item.STATUS = 1; } else { model.Item.STATUS = 0; } model.RadioBoxPop = false; if (model.Item.STATUS == 1) { model.RadioBoxPop = true; } //라디오버튼 쓰기2 if (model.RadioBoxSummerT == true) { model.Item.STATUS = 1; } else { model.Item.STATUS = 0; } model.RadioBoxSummerT = false; if (model.Item.UTC_SUMMER_TIME == 1) { model.RadioBoxSummerT = true; } return(View(model)); }