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