public ActionResult BaseLocalView(BaseLocalModels model)
{
if (model.act_type == "ins")
{
//권한 체크===================================================
if (!chk.chkPermission("BaseLocal", "PER_INSERT"))
{
return(RedirectToAction("BaseLocalView", new { msg = chk.alertStr }));
}
//===========================================================
}
if (model.act_type == "updt")
{
//권한 체크===================================================
if (!chk.chkPermission("BaseLocal", "PER_UPDATE"))
{
return(RedirectToAction("BaseLocalView", new { msg = chk.alertStr }));
}
//===========================================================
}
model.Item.NATION_CODE = model.schType;
string PublicPopupMsg = act.setBaseLocal(model);
return(RedirectToAction("BaseLocalView", new { seqNo = model.act_key, Msg = PublicPopupMsg }));
}
//Base 현지 배송업체 설정 =================================================================================================
// GET: Base 현지 배송업체 설정
public ActionResult BaseLocal(string msg)
{
//권한 체크===================================================
if (!chk.chkPermission("BaseLocal", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = null;
if (!string.IsNullOrEmpty(msg))
{
TempData["PublicMsg"] = msg;
}
BaseLocalModels model = new BaseLocalModels();
model = act.GetBaseLocalList(model);
//SELECT BOX ARRAY 데이터 설정
model.nationArray = comModel.GetCommNationSelectBox();
return(View(model));
}
public BaseLocalModels GetBaseLocalList(BaseLocalModels model)
{
string errorStr = "";
string listQuery = " SELECT SEQNO , " + string.Join(",", column_BaseLocal) + " FROM conf_local_delivery WHERE 1=1 ";
if (!String.IsNullOrEmpty(model.schType))
{
listQuery += "AND NATION_CODE = '" + model.schType + "'";
}
listQuery += " ORDER BY SEQNO ";
DataTable listDt = getQueryResult(listQuery, out errorStr);
if (listDt != null && listDt.Rows.Count != 0)
{
for (int i = 0; i < listDt.Rows.Count; i++)
{
ConfLocalDelivery temp = new ConfLocalDelivery();
temp.SEQNO = int.Parse(listDt.Rows[i]["SEQNO"].ToString().Trim());
temp.NATION_CODE = listDt.Rows[i]["NATION_CODE"].ToString().Trim();
temp.NAME = listDt.Rows[i]["NAME"].ToString().Trim();
temp.HOMEPAGE = listDt.Rows[i]["HOMEPAGE"].ToString().Trim();
temp.COM_ID = listDt.Rows[i]["COM_ID"].ToString().Trim();
temp.MEMO = listDt.Rows[i]["MEMO"].ToString().Trim();
model.Items.Add(temp);
}
}
return(model);
}
public string setBaseLocal(BaseLocalModels model)
{
string errorStr = "";
string result = "";
string exeQueryStr = "";
if (model.act_type != null && model.act_type == "ins")
{
exeQueryStr = " INSERT INTO conf_local_delivery (" + string.Join(",", column_BaseLocal) + " )VALUES( ";
exeQueryStr += " '" + model.Item.NATION_CODE + "'";
exeQueryStr += ", '" + model.Item.NAME + "'";
exeQueryStr += ", '" + model.Item.HOMEPAGE + "'";
exeQueryStr += ", '" + model.Item.COM_ID + "'";
exeQueryStr += ", '" + model.Item.MEMO + "'";
exeQueryStr += " ) ";
}
else if (model.act_type != null && model.act_type == "updt")
{
exeQueryStr = " UPDATE conf_local_delivery SET ";
exeQueryStr += " NATION_CODE = '" + model.Item.NATION_CODE + "'";
exeQueryStr += ", NAME = '" + model.Item.NAME + "'";
exeQueryStr += ", HOMEPAGE = '" + model.Item.HOMEPAGE + "'";
exeQueryStr += ", COM_ID = '" + model.Item.COM_ID + "'";
exeQueryStr += ", MEMO = '" + model.Item.MEMO + "'";
exeQueryStr += " WHERE SEQNO = " + model.Item.SEQNO;
}
else
{
result = "잘못된 접근입니다.";
return(result);
}
if (exeQuery(exeQueryStr, out errorStr))
{
result = "성공.";
}
else
{
result = "실패.";
}
return(result);
}
public ActionResult BaseLocalView(string seqNo, string Msg)
{
//권한 체크===================================================
if (!chk.chkPermission("BaseLocal", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
BaseLocalModels model = new BaseLocalModels();
int pSeqNo = 0;
if (int.TryParse(seqNo, out pSeqNo))
{
model.act_type = "updt";
model.act_key = pSeqNo;
}
else
{
model.act_type = "ins";
model.Item.SEQNO = 0;
}
if (!String.IsNullOrEmpty(Msg))
{
ViewBag.PublicPopupMsg = Msg;
}
model.Item = act.GetBaseLocalView(pSeqNo);
//SELECT BOX ARRAY 데이터 설정
model.nationArray = comModel.GetCommNationSelectBox();
return(View(model));
}
public ActionResult BaseLocal(BaseLocalModels model)
{
//권한 체크===================================================
if (!chk.chkPermission("BaseLocal", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
string PublicMsg = "";
//삭제일 경우
if (model.act_type == "del")
{
//권한 체크===================================================
if (!chk.chkPermission("BaseLocal", "PER_DELETE"))
{
return(RedirectToAction("BaseLocal", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = act.delBaseLocal(model.act_key); //삭제
model.act_type = "list";
model.act_key = 0;
return(RedirectToAction("BaseLocal", new { Msg = PublicMsg }));
}
model = act.GetBaseLocalList(model);
//SELECT BOX ARRAY 데이터 설정
model.nationArray = comModel.GetCommNationSelectBox();
return(View(model));
}
