public ActionResult EseGradeView(string seqNo, string Msg) { //권한 체크=================================================== if (!chk.chkPermission("EseGrade", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== EseGradeViewModels model = new EseGradeViewModels(); int pSeqNo = 0; if (int.TryParse(seqNo, out pSeqNo)) { model.act_type = "updt"; model.act_key = pSeqNo; } else { model.act_type = "ins"; model.Item.ESE_CODE = (string)Session["ESE_CODE"]; model.Item.GROUP_ID = 0; } if (!String.IsNullOrEmpty(Msg)) { ViewBag.PublicPopupMsg = Msg; } model = act.GetEseGradeView(model); //메뉴명 가져오기 List <schTypeArray> tempGrade = comF.GetGradeList(); for (int i = 0; i < model.Items.Count; i++) { foreach (schTypeArray tempS in tempGrade) { if (tempS.opt_key == model.Items[i].MENU_ID) { model.Items[i].MENU_NAME = tempS.opt_value; } } } return(View(model)); }
public ActionResult EstIframeGradeView(string Msg, string groupId, string estCode) { //권한 체크=================================================== if (!chk.chkPermission("EstInfo", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== EstGradeViewModel model = new EstGradeViewModel(); model = act.GetEstGradeView(groupId, estCode); model.viewEstCode = estCode; model.Item.EST_CODE = model.viewEstCode; int pSeqNo = 0; if (int.TryParse(groupId, out pSeqNo)) { model.act_type = "updt"; } else { model.act_type = "ins"; } if (!String.IsNullOrEmpty(Msg)) { ViewBag.PublicPopupMsg = Msg; } //메뉴명 가져오기 List <schTypeArray> tempGrade = comF.GetGradeList(); for (int i = 0; i < model.Items.Count; i++) { foreach (schTypeArray tempS in tempGrade) { if (tempS.opt_key == model.Items[i].MENU_ID) { model.Items[i].MENU_NAME = tempS.opt_value; } } } return(View(model)); }
public EstGradeViewModel GetEstGradeView(EstGradeViewModel model) { string errorStr = ""; //그룹 가져오기 string listQuery = " SELECT GROUP_ID , GROUP_NAME FROM est_group WHERE EST_CODE"; DataTable listDt = getQueryResult(listQuery, out errorStr); if (listDt != null && listDt.Rows.Count != 0) { model.Item.GROUP_ID = int.Parse(listDt.Rows[0]["GROUP_ID"].ToString().Trim()); model.Item.GROUP_NAME = listDt.Rows[0]["GROUP_NAME"].ToString().Trim(); } //권한 가져오기 listQuery = " SELECT GROUP_ID , EST_CODE, MENU_ID, PER_SELECT, PER_INSERT, PER_UPDATE, PER_DELETE FROM est_group_permission WHERE GROUP_ID = " + model.Item.GROUP_ID; listDt = getQueryResult(listQuery, out errorStr); if (listDt != null && listDt.Rows.Count != 0) { for (int i = 0; i < listDt.Rows.Count; i++) { EstGroupPermisson temp = new EstGroupPermisson(); temp.GROUP_ID = int.Parse(listDt.Rows[i]["GROUP_ID"].ToString().Trim()); temp.EST_CODE = listDt.Rows[i]["EST_CODE"].ToString().Trim(); temp.MENU_ID = listDt.Rows[i]["MENU_ID"].ToString().Trim(); temp.PER_SELECT = int.Parse(listDt.Rows[i]["PER_SELECT"].ToString().Trim()); temp.PER_INSERT = int.Parse(listDt.Rows[i]["PER_INSERT"].ToString().Trim()); temp.PER_UPDATE = int.Parse(listDt.Rows[i]["PER_UPDATE"].ToString().Trim()); temp.PER_DELETE = int.Parse(listDt.Rows[i]["PER_DELETE"].ToString().Trim()); temp.CHK_PER_SELECT = false; if (temp.PER_SELECT == 1) { temp.CHK_PER_SELECT = true; } temp.CHK_PER_INSERT = false; if (temp.PER_INSERT == 1) { temp.CHK_PER_INSERT = true; } temp.CHK_PER_UPDATE = false; if (temp.PER_UPDATE == 1) { temp.CHK_PER_UPDATE = true; } temp.CHK_PER_DELETE = false; if (temp.PER_DELETE == 1) { temp.CHK_PER_DELETE = true; } model.Items.Add(temp); } } else { //등록된 데이터가 없을 경우 CommFunction comF = new CommFunction(); List <schTypeArray> tempGrade = comF.GetGradeList(); foreach (schTypeArray tempItem in tempGrade) { EstGroupPermisson temp = new EstGroupPermisson(); temp.GROUP_ID = model.Item.GROUP_ID; temp.MENU_ID = tempItem.opt_key; temp.MENU_NAME = tempItem.opt_value; temp.PER_DELETE = 0; temp.PER_INSERT = 0; temp.PER_SELECT = 0; temp.PER_UPDATE = 0; temp.CHK_PER_SELECT = true; temp.CHK_PER_INSERT = true; temp.CHK_PER_UPDATE = true; temp.CHK_PER_DELETE = true; model.Items.Add(temp); } } return(model); }