public BaseNationModels GetBaseNationList() { string errorStr = ""; string listQuery = " SELECT SEQNO , " + string.Join(",", column_BaseNation) + " FROM conf_shipping_country ORDER BY SEQNO "; DataTable listDt = getQueryResult(listQuery, out errorStr); BaseNationModels model = new BaseNationModels(); if (listDt != null && listDt.Rows.Count != 0) { for (int i = 0; i < listDt.Rows.Count; i++) { ConfShippingCountry temp = new ConfShippingCountry(); temp.SEQNO = int.Parse(listDt.Rows[i]["SEQNO"].ToString().Trim()); temp.NATION_CODE = listDt.Rows[i]["NATION_CODE"].ToString().Trim(); temp.NATION_NAME = listDt.Rows[i]["NATION_NAME"].ToString().Trim(); temp.WEIGHT_UNIT = listDt.Rows[i]["WEIGHT_UNIT"].ToString().Trim(); temp.CURRENCY_UNIT = listDt.Rows[i]["CURRENCY_UNIT"].ToString().Trim(); temp.USE_YN = int.Parse(listDt.Rows[i]["USE_YN"].ToString().Trim()); model.Items.Add(temp); } } return(model); }
public string setBaseNation(BaseNationModels model) { string errorStr = ""; string result = ""; string exeQueryStr = ""; if (model.act_type != null && model.act_type == "ins") { exeQueryStr = " INSERT INTO conf_shipping_country (" + string.Join(",", column_BaseNation) + " )VALUES( "; exeQueryStr += " '" + model.Item.NATION_CODE + "'"; exeQueryStr += ", '" + model.Item.NATION_NAME + "'"; exeQueryStr += ", '" + model.Item.WEIGHT_UNIT + "'"; exeQueryStr += ", '" + model.Item.CURRENCY_UNIT + "'"; exeQueryStr += ", " + model.Item.USE_YN + ""; exeQueryStr += " ) "; } else if (model.act_type != null && model.act_type == "updt") { exeQueryStr = " UPDATE conf_shipping_country SET "; exeQueryStr += " NATION_CODE = '" + model.Item.NATION_CODE + "'"; exeQueryStr += ", NATION_NAME = '" + model.Item.NATION_NAME + "'"; exeQueryStr += ", WEIGHT_UNIT = '" + model.Item.WEIGHT_UNIT + "'"; exeQueryStr += ", CURRENCY_UNIT = '" + model.Item.CURRENCY_UNIT + "'"; exeQueryStr += ", USE_YN = " + model.Item.USE_YN + ""; exeQueryStr += " WHERE SEQNO = " + model.Item.SEQNO; } else { result = "잘못된 접근입니다."; return(result); } if (exeQuery(exeQueryStr, out errorStr)) { result = "성공."; } else { result = "실패."; } return(result); }
public ActionResult BaseNationView(BaseNationModels model) { if (model.act_type == "ins") { //권한 체크=================================================== if (!chk.chkPermission("BaseNation", "PER_INSERT")) { return(RedirectToAction("BaseNationView", new { msg = chk.alertStr })); } //=========================================================== } if (model.act_type == "updt") { //권한 체크=================================================== if (!chk.chkPermission("BaseNation", "PER_UPDATE")) { return(RedirectToAction("BaseNationView", new { msg = chk.alertStr })); } //=========================================================== } //유효성 검사 if (!ModelState.IsValid) { return(View(model)); } model.nationArray = comModel.GetCommNationSelectBox(); foreach (schTypeArray tempS in model.nationArray) { if (tempS.opt_key == model.Item.NATION_CODE) { model.Item.NATION_NAME = tempS.opt_value; } } model.Item.CURRENCY_UNIT = Request.Form["CURRENCY_UNIT"]; model.Item.WEIGHT_UNIT = Request.Form["WEIGHT_UNIT"]; string PublicPopupMsg = act.setBaseNation(model); return(RedirectToAction("BaseNationView", new { seqNo = model.act_key, Msg = PublicPopupMsg })); }
//Base 배송가능 국가 관리 ================================================================================================= // GET: Base 배송가능 국가 관리 public ActionResult BaseNation(string msg) { //권한 체크=================================================== if (!chk.chkPermission("BaseNation", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== TempData["PublicMsg"] = null; if (!string.IsNullOrEmpty(msg)) { TempData["PublicMsg"] = msg; } BaseNationModels model = new BaseNationModels(); model = act.GetBaseNationList(); return(View(model)); }