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