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