public ActionResult BaseOutPutTypeView(BaseOutPutTypeModels model)
{
if (model.act_type == "ins")
{
//권한 체크===================================================
if (!chk.chkPermission("BaseOutPutType", "PER_INSERT"))
{
return(RedirectToAction("BaseOutPutTypeView", new { msg = chk.alertStr }));
}
//===========================================================
}
if (model.act_type == "updt")
{
//권한 체크===================================================
if (!chk.chkPermission("BaseOutPutType", "PER_UPDATE"))
{
return(RedirectToAction("BaseOutPutTypeView", new { msg = chk.alertStr }));
}
//===========================================================
}
model.Item.NATION_CODE = model.schType;
string PublicPopupMsg = act.setBaseOutPutType(model);
return(RedirectToAction("BaseOutPutTypeView", new { seqNo = model.act_key, Msg = PublicPopupMsg }));
}
public ActionResult BaseOutPutRate(BaseOutPutRateModels model)
{
string PublicMsg = "";
string error_str = "";
//목록 버튼 클릭
if (model.act_type == "list")
{
BaseOutPutTypeModels returlModel = new BaseOutPutTypeModels();
returlModel.schType = model.schType;
return(RedirectToAction("BaseOutPutType", returlModel));
}
if (model.act_type == "excel")
{
act.setBaseOutPutRate(model, out error_str);
if (error_str != "")
{
ViewBag.PublicMsg = error_str;
}
model = act.GetBaseOutPutRateView(model);
return(View(model));
}
//시퀸스 넘버 오류 일경우
return(RedirectToAction("BaseOutPutType", new { Msg = "잘못된 경로입니다." }));
}
public ActionResult BaseOutPutType(BaseOutPutTypeModels model)
{
//권한 체크===================================================
if (!chk.chkPermission("BaseOutPutType", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
string PublicMsg = "";
//삭제일 경우
if (model.act_type == "del")
{
//권한 체크===================================================
if (!chk.chkPermission("BaseOutPutType", "PER_DELETE"))
{
return(RedirectToAction("BaseOutPutType", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = act.delBaseOutPutType(model.act_key); //삭제
model.act_type = "list";
model.act_key = 0;
return(RedirectToAction("BaseOutPutType", new { Msg = PublicMsg }));
}
model = act.GetBaseOutPutTypeList(model);
//SELECT BOX ARRAY 데이터 설정
model.nationArray = comModel.GetCommNationSelectBox();
return(View(model));
}
public BaseOutPutTypeModels GetBaseOutPutTypeList(BaseOutPutTypeModels model)
{
string errorStr = "";
string listQuery = " SELECT SEQNO , " + string.Join(",", column_BaseOutPutType) + " FROM conf_release_type 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++)
{
ConfReleaseType temp = new ConfReleaseType();
temp.SEQNO = int.Parse(listDt.Rows[i]["SEQNO"].ToString().Trim());
temp.NATION_CODE = listDt.Rows[i]["NATION_CODE"].ToString().Trim();
temp.RELEASE_NAME = listDt.Rows[i]["RELEASE_NAME"].ToString().Trim();
temp.RELEASE_CODE = listDt.Rows[i]["RELEASE_CODE"].ToString().Trim();
temp.MEMO = listDt.Rows[i]["MEMO"].ToString().Trim();
temp.DELV_CODE = listDt.Rows[i]["DELV_CODE"].ToString().Trim();
model.Items.Add(temp);
}
}
return(model);
}
public string setBaseOutPutType(BaseOutPutTypeModels model)
{
string errorStr = "";
string result = "";
string exeQueryStr = "";
if (model.act_type != null && model.act_type == "ins")
{
exeQueryStr = " INSERT INTO conf_release_type (" + string.Join(",", column_BaseOutPutType) + " )VALUES( ";
exeQueryStr += " '" + model.Item.NATION_CODE + "'";
exeQueryStr += ", '" + model.Item.RELEASE_NAME + "'";
exeQueryStr += ", '" + model.Item.RELEASE_CODE + "'";
exeQueryStr += ", '" + model.Item.MEMO + "'";
exeQueryStr += ", '" + model.Item.DELV_CODE + "'";
exeQueryStr += " ) ";
}
else if (model.act_type != null && model.act_type == "updt")
{
exeQueryStr = " UPDATE conf_release_type SET ";
exeQueryStr += " NATION_CODE = '" + model.Item.NATION_CODE + "'";
exeQueryStr += ", RELEASE_NAME = '" + model.Item.RELEASE_NAME + "'";
exeQueryStr += ", RELEASE_CODE = '" + model.Item.RELEASE_CODE + "'";
exeQueryStr += ", MEMO = '" + model.Item.MEMO + "'";
exeQueryStr += ", DELV_CODE = '" + model.Item.DELV_CODE + "'";
exeQueryStr += " WHERE SEQNO = " + model.Item.SEQNO;
}
else
{
result = "잘못된 접근입니다.";
return(result);
}
if (exeQuery(exeQueryStr, out errorStr))
{
result = "성공.";
}
else
{
result = "실패.";
}
return(result);
}
public ActionResult BaseOutPutType(string msg, BaseOutPutTypeModels model)
{
//권한 체크===================================================
if (!chk.chkPermission("BaseOutPutType", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = null;
if (!string.IsNullOrEmpty(msg))
{
TempData["PublicMsg"] = msg;
}
model = act.GetBaseOutPutTypeList(model);
//SELECT BOX ARRAY 데이터 설정
model.nationArray = comModel.GetCommNationSelectBox();
return(View(model));
}
public ActionResult BaseOutPutTypeView(string seqNo, string Msg)
{
//권한 체크===================================================
if (!chk.chkPermission("BaseOutPutType", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
BaseOutPutTypeModels model = new BaseOutPutTypeModels();
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.GetBaseOutPutTypeView(pSeqNo);
//SELECT BOX ARRAY 데이터 설정
model.nationArray = comModel.GetCommNationSelectBox();
return(View(model));
}
