/// <summary>
/// 递归获得用于界面显示的菜单树
/// </summary>
/// <param name="mlist"></param>
/// <param name="pid"></param>
/// <returns></returns>
private List <MenuTreeEntity> MenuTree(IList <Menu> mlist, int pid = 0)
{
var pList = mlist.Where(i => i.ParentId == pid);
if (pList == null || pList.Count() == 0)
{
return(null);
}
List <MenuTreeEntity> list = new List <MenuTreeEntity>();
foreach (var p in pList)
{
var obj = new MenuTreeEntity();
obj.id = p.Id;
string isHide = p.Hiding == true ? "隐藏" : "显示";
string isStop = p.Stopping == true ? "停用" : "启用";
obj.title = p.MenuName + " | " + p.UrlRoute + " | " + p.Icon + " | " + p.Sno + " | " + isHide + " | " + isStop;
var childs = MenuTree(mlist, p.Id);
if (childs != null)
{
obj.children = childs;
}
list.Add(obj);
}
return(list);
}
public ActionResult inserNewMenu(MenuTreeEntity menuEntity)
{
menuEntity.DictionaryID = "";
menuEntity.FormID = "";
menuEntity.MenuID = "";
dynamic showMessageString = string.Empty;
showMessageString = new
{
param1 = 200,
param2 = "insert success"
};
try
{
menuEntity.CREATE_UID = "hieuht";
bool insertResult = MenuTreeAccess.InsertMenu(menuEntity);
if (insertResult == true)
{
Session["list_menu"] = null;
}
return(Json(showMessageString, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var errorMsg = ex.Message.ToString();
showMessageString = new
{
param1 = 404,
param2 = "proccess error"
};
return(Json(showMessageString, JsonRequestBehavior.AllowGet));
}
//return Json(menuEntity, JsonRequestBehavior.AllowGet);
//return Json(showMessageString, "text/plain");
}
public static MenuTreeEntity getMenuDetail(string menu_id)
{
MenuTreeEntity result = new MenuTreeEntity();
result = MenuTreeAccess.GetByMenuID(menu_id);
return(result);
}
public static MenuTreeEntity GetByMenuID(string MenuID)
{
string sqlQuery = "PKOPM_FORMANDMENU.sp_OPM_Menu_get_by_MenuID";
OracleParameter[] sqlParams = new OracleParameter[2];
sqlParams[0] = new OracleParameter("p_MenuID", MenuID);
sqlParams[1] = new OracleParameter("T_TABLE", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
};
DataTable dt = DBHelper.getDataTable_SP(sqlQuery, sqlParams);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
MenuTreeEntity menuEntity = new MenuTreeEntity();
menuEntity.MenuID = dt.Rows[0]["MenuID"].ToString();
menuEntity.MenuName = dt.Rows[0]["MenuName"].ToString();
menuEntity.MotherID = dt.Rows[0]["MotherID"].ToString();
menuEntity.FormID = dt.Rows[0]["FormCode"].ToString();
menuEntity.DictionaryID = dt.Rows[0]["DictionaryID"].ToString();
menuEntity.FilePath = dt.Rows[0]["FilePath"].ToString();
menuEntity.Seq = string.IsNullOrEmpty(dt.Rows[0]["Seq"].ToString())? 0
: int.Parse(dt.Rows[0]["Seq"].ToString());
menuEntity.IsActive = dt.Rows[0]["IsActive"].ToString();
return(menuEntity);
}
// Duy Hung 31/05/2014
public static bool SP_UPDATE_DRAGED_NODE(MenuTreeEntity menuEntity)
{
OracleParameter[] parameters = new OracleParameter[4];
parameters[0] = new OracleParameter("p_MenuID", menuEntity.MenuID);
parameters[1] = new OracleParameter("p_MotherID", menuEntity.MotherID);
parameters[2] = new OracleParameter("p_Seq", menuEntity.Seq);
parameters[3] = new OracleParameter("p_UPDATE_UID", menuEntity.UPDATE_UID);
return(DBHelper.ExecuteNonQuery_SP("PKOPM_FORMANDMENU.SP_UPDATE_DRAGED_NODE", parameters));
}
public static bool UpdateMotherIdMenu(MenuTreeEntity menuEntity)
{
OracleParameter[] sqlParam = new OracleParameter[4];
sqlParam[0] = new OracleParameter("MenuID", menuEntity.MenuID);
sqlParam[1] = new OracleParameter("MotherID", menuEntity.MotherID);
sqlParam[2] = new OracleParameter("Seq", menuEntity.Seq);
sqlParam[3] = new OracleParameter("UPDATE_UID", menuEntity.UPDATE_UID);
return(DBHelper.ExecuteNonQuery_SP("PKOPM_FORMANDMENU.sp_OPM_Menu_Update_MotherID", sqlParam));
}
public JsonResult getMenuDetail(string menu_id)
{
MenuTreeEntity vm = new MenuTreeEntity();
if (!string.IsNullOrEmpty(menu_id))
{
vm = bMenuConfig.getMenuDetail(menu_id);
}
return(Json(vm, JsonRequestBehavior.AllowGet));
}
public static bool InsertMenu(MenuTreeEntity menuEntity)
{
OracleParameter[] sqlParam = new OracleParameter[8];
sqlParam[0] = new OracleParameter("p_MenuID", menuEntity.MenuID);
sqlParam[1] = new OracleParameter("p_MenuName", menuEntity.MenuName);
sqlParam[2] = new OracleParameter("p_MotherID", menuEntity.MotherID);
sqlParam[3] = new OracleParameter("p_Seq", menuEntity.Seq);
sqlParam[4] = new OracleParameter("p_FormCode", menuEntity.FormID);
sqlParam[5] = new OracleParameter("p_DictionaryID", menuEntity.DictionaryID);
sqlParam[6] = new OracleParameter("p_CREATE_UID", menuEntity.CREATE_UID);
sqlParam[7] = new OracleParameter("p_IsActive", menuEntity.IsActive);
return(DBHelper.ExecuteNonQuery_SP("PKOPM_FORMANDMENU.sp_OPM_Menu_Insert", sqlParam));
}
public static bool UpdateMenu(MenuTreeEntity menuEntity)
{
OracleParameter[] sqlParam = new OracleParameter[8];
sqlParam[0] = new OracleParameter("p_MenuID", menuEntity.MenuID);
sqlParam[1] = new OracleParameter("p_MenuName", menuEntity.MenuName);
sqlParam[2] = new OracleParameter("p_MotherID", menuEntity.MotherID);
sqlParam[3] = new OracleParameter("p_Seq", menuEntity.Seq);
sqlParam[4] = new OracleParameter("p_FormCode", menuEntity.FormID);
sqlParam[5] = new OracleParameter("p_DictionaryID", menuEntity.DictionaryID);
sqlParam[6] = new OracleParameter("p_UPDATE_UID", menuEntity.UPDATE_UID);
sqlParam[7] = new OracleParameter("p_IsActive", OracleDbType.Char)
{
Value = menuEntity.IsActive
};
return(DBHelper.ExecuteNonQuery_SP("PKOPM_FORMANDMENU.sp_OPM_Menu_Update", sqlParam));
}
public ActionResult updateMenu(MenuTreeEntity menuEntity)
{
//bool result = MenuTreeAccess.UpdateMenu(menuEntity);
menuEntity.DictionaryID = "";
if (string.IsNullOrEmpty(menuEntity.FormID))
{
menuEntity.FormID = "";
}
dynamic showMessageString = string.Empty;
showMessageString = new
{
param1 = 200,
param2 = "update success"
};
try
{
menuEntity.UPDATE_UID = "hieuht";
bool insertResult = MenuTreeAccess.UpdateMenu(menuEntity);
if (insertResult == true)
{
Session["list_menu"] = null;
}
return(Json(showMessageString, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var errorMsg = ex.Message.ToString();
showMessageString = new
{
param1 = 404,
param2 = "proccess error"
};
return(Json(showMessageString, JsonRequestBehavior.AllowGet));
}
//return Json(menuEntity, JsonRequestBehavior.AllowGet);
}
