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