/// <summary>
/// 获取子菜单列表
/// </summary>
/// <returns></returns>
public string getdatamenuC(int menuid)
{
string s = "{\"menu\":[";
bll.menubll menuBll = new bll.menubll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("roleId", SqlDbType.Int, 4),
new SqlParameter("menuid", SqlDbType.Int, 4)
};
ipara[0].Value = userInfo.User.personaId;
ipara[1].Value = menuid;
List <model.menu> list = menuBll.getMenu(ipara, "menuSelectC");
foreach (var item in list)
{
s += "{\"menuid\":\"" + item.Id + "\",\"menuname\":\"" + item.menuName + "\",\"menusrc\":\"" + item.MenuSrc + "\"},";
}
if (list.Count == 0)
{
s += "{\"menuid\":\"" + 0 + "\",\"menuname\":\"" + 0 + "\"},";
}
s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s;
s += "]}";
return(s);
}
/// <summary>
/// 添加功能
/// </summary>
/// <returns></returns>
public string adddata(FormCollection collection)
{
string s = string.Empty;
string funName = Request.Form["funName"].ToString();
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"].ToString());
int funIndex = helpcommon.ParmPerportys.GetNumParms(Request.Form["funIndex"].ToString());
int UserId = userInfo.User.Id;
bll.menubll menuBll = new bll.menubll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("funName", SqlDbType.NVarChar, 20),
new SqlParameter("menuId", SqlDbType.Int, 4),
new SqlParameter("funIndex", SqlDbType.Int, 4),
new SqlParameter("UserId", SqlDbType.Int, 4)
};
ipara[0].Value = funName;
ipara[1].Value = menuId;
ipara[2].Value = funIndex;
ipara[3].Value = UserId;
s = menuBll.Add(ipara, "funPermissonAdd");
return(s);
}
public void getUserMenuC(List <int> listMenuId, out List <int> listMenuIdC)
{
string s = string.Empty;
foreach (int item in listMenuId)
{
s += "'" + item + "',";
}
s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s;
IDataParameter[] iparaMenuC = new IDataParameter[] {
new SqlParameter("roleId", SqlDbType.Int, 4),
new SqlParameter("menuId", SqlDbType.NVarChar, 500)
};
iparaMenuC[0].Value = us.User.personaId;
iparaMenuC[1].Value = s;
listMenuIdC = new List <int>(); //目录ID
model.menu menuMdC = new model.menu();
bll.menubll menuBllC = new bll.menubll();
List <model.menu> listMenuC = menuBllC.getMenu(iparaMenuC, "menuSelectCC");//子菜单
foreach (var item in listMenuC)
{
listMenuIdC.Add(item.Id);
}
if (listMenuC.Count == 0)
{
listMenuIdC.Add(9999);
}
us.MenuIdC = listMenuIdC;
}
/// <summary>
/// 主菜单权限控制
/// </summary>
/// <param name="roleId"></param>
/// <returns></returns>
public List <int> getUserMenuF1(int roleId)
{
IDataParameter[] iparaMenu = new IDataParameter[] {
new SqlParameter("roleId", SqlDbType.Int, 4),
};
iparaMenu[0].Value = roleId;
List <int> listMenuId = new List <int>(); //目录ID
model.menu menuMd = new model.menu();
bll.menubll menuBll = new bll.menubll();
List <model.menu> listMenu = menuBll.getMenu(iparaMenu, "menuSelectFF");//主菜单
foreach (var item in listMenu)
{
listMenuId.Add(item.Id);
}
if (listMenu.Count == 0)
{
listMenuId.Add(9999);
}
menuBll = null;
menuMd = null;
return(listMenuId);
}
/// <summary>
/// 更新菜单
/// </summary>
/// <returns></returns>
public string updatedata()
{
string s = string.Empty;
string menuName = Request.Form["menuName"].ToString();
string MenuSrc = Request.Form["MenuSrc"].ToString();
int MenuLevel = helpcommon.ParmPerportys.GetNumParms(Request.Form["MenuLevel"].ToString());
int MenuIndex = helpcommon.ParmPerportys.GetNumParms(Request.Form["MenuIndex"].ToString());
int UserId = 1;
int id = helpcommon.ParmPerportys.GetNumParms(Request.Form["Id"].ToString());
bll.menubll menuBll = new bll.menubll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("menuName", SqlDbType.NVarChar, 20),
new SqlParameter("MenuSrc", SqlDbType.NVarChar, 500),
new SqlParameter("MenuLevel", SqlDbType.Int, 4),
new SqlParameter("MenuIndex", SqlDbType.Int, 4),
new SqlParameter("UserId", SqlDbType.Int, 4),
new SqlParameter("Id", SqlDbType.Int, 4)
};
ipara[0].Value = menuName;
ipara[1].Value = MenuSrc;
ipara[2].Value = MenuLevel;
ipara[3].Value = MenuIndex;
ipara[4].Value = UserId;
ipara[5].Value = id;
s = menuBll.Update(ipara, "menuUpdate");
return(s);
}
/// <summary>
/// 获取菜单名称
/// </summary>
/// <returns></returns>
public string getMenuName()
{
bll.menubll menuBll = new bll.menubll();
int id = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"].ToString());
model.menu mdMenu = menuBll.getMenuName(id);
return(mdMenu.menuName);
}
//
// GET: /TableFun/
/// <summary>
/// 获取菜单
/// </summary>
/// <returns></returns>
public ActionResult getMenu()
{
bll.menubll menuBll = new bll.menubll();
IDataParameter[] ipara = new IDataParameter[] {
//new SqlParameter("MenuId",SqlDbType.NVarChar,20)
};
//ipara[0].Value = "张三";
List <model.menu> list = menuBll.getMenu(ipara, "menuChild");
return(View(list));
}
/// <summary>
/// 删除菜单
/// </summary>
/// <returns></returns>
public string deldata()
{
string s = string.Empty;
int id = helpcommon.ParmPerportys.GetNumParms(Request.Form["id"]);
bll.menubll menuBll = new bll.menubll();
s = menuBll.del(id);
menuBll = null;
return(s);
}
/// <summary>
/// 获取菜单列表
/// </summary>
/// <returns></returns>
public ActionResult getdata()
{
bll.menubll menuBll = new bll.menubll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("roleId", SqlDbType.Int, 4)
};
ipara[0].Value = userInfo.User.personaId;
//List<model.menu> list = menuBll.getMenu(ipara, "menuSelectF");
List <model.menu> list = menuBll.getMenu(ipara, "menuSelectFList");
return(View(list));
}
/// <summary>
/// 查看菜单详情(子菜单)
/// </summary>
/// <returns></returns>
public ActionResult menuDetails(int id)
{
ViewData["MenuLevel"] = id;
bll.menubll menuBll = new bll.menubll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("roleId", SqlDbType.Int, 4),
new SqlParameter("menuid", SqlDbType.Int, 4)
};
ipara[0].Value = userInfo.User.personaId;
ipara[1].Value = id;
List <model.menu> list = menuBll.getMenu(ipara, "menuSelectC");
return(View(list));
}
/// <summary>
/// 编辑菜单列表
/// </summary>
/// <returns></returns>
public ActionResult editdata(int id)
{
bll.menubll menuBll = new bll.menubll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("id", SqlDbType.Int, 4)
};
ipara[0].Value = id;
List <model.menu> list = menuBll.getMenu(ipara, "menuEdit");
model.menu menuMd = new model.menu();
menuMd = list.Where(c => c.Id == id).ToList()[0];
return(View(menuMd));
}
/// <summary>
/// 删除子菜单
/// </summary>
/// <returns></returns>
public string delSubMenu(int id)
{
string s = string.Empty;
int ids = helpcommon.ParmPerportys.GetNumParms(id);
bll.menubll menubll = new bll.menubll();
IDataParameter[] ipara = new IDataParameter[] {
new SqlParameter("Id", SqlDbType.Int, 4),
new SqlParameter("PersondId", SqlDbType.Int, 4)
};
ipara[0].Value = ids;
ipara[1].Value = userInfo.User.personaId;
s = menubll.Delete(ipara, "DeleteSubMenu");
menubll = null;
return(s);
}
/// <summary>
/// 获取菜单
/// </summary>
/// <returns></returns>
public string getMenu()
{
string s = "{\"menu\":[";
bll.menubll menuBll = new bll.menubll();
IDataParameter[] ipara = new IDataParameter[] {
//new SqlParameter("menuName",SqlDbType.NVarChar,20)
};
List <model.menu> list = menuBll.getMenu(ipara, "menuChild");
foreach (var item in list)
{
s += "{\"menuid\":\"" + item.Id + "\",\"menuname\":\"" + item.menuName + "\"},";
}
s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s;
s += "]}";
menuBll = null;
return(s);
}
public void getUserMenuF(out List <int> listMenuId)
{
IDataParameter[] iparaMenu = new IDataParameter[] {
new SqlParameter("roleId", SqlDbType.Int, 4),
};
iparaMenu[0].Value = us.User.personaId;
listMenuId = new List <int>(); //目录ID
model.menu menuMd = new model.menu();
bll.menubll menuBll = new bll.menubll();
List <model.menu> listMenu = menuBll.getMenu(iparaMenu, "menuSelectFF");//主菜单
foreach (var item in listMenu)
{
listMenuId.Add(item.Id);
}
if (listMenu.Count == 0)
{
listMenuId.Add(9999);
}
us.MenuIdF = listMenuId;
}
/// <summary>
/// 子菜单权限控制
/// </summary>
/// <param name="listMenuId"></param>
/// <param name="roleId"></param>
/// <returns></returns>
public List <int> getUserMenuC1(List <int> listMenuId, int roleId)
{
List <int> listMenuIdC = new List <int>(); //菜单ID
string s = string.Empty;
foreach (int item in listMenuId)
{
s += "'" + item + "',";
}
s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s;
IDataParameter[] iparaMenuC = new IDataParameter[] {
new SqlParameter("roleId", SqlDbType.Int, 4),
new SqlParameter("menuId", SqlDbType.NVarChar, 500)
};
iparaMenuC[0].Value = roleId;
iparaMenuC[1].Value = s;
model.menu menuMdC = new model.menu();
bll.menubll menuBllC = new bll.menubll();
List <model.menu> listMenuC = menuBllC.getMenu(iparaMenuC, "menuSelectCC");//子菜单
foreach (var item in listMenuC)
{
listMenuIdC.Add(item.Id);
}
if (listMenuC.Count == 0)
{
listMenuIdC.Add(9999);
}
menuBllC = null;
menuMdC = null;
return(listMenuIdC);
}
/// <summary>
/// 获取菜单列表
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult allotMenuPermisson(int id)
{
ViewData["roleId"] = id;
int menuId = helpcommon.ParmPerportys.GetNumParms(Request.QueryString["menuId"]);
ViewData["menuId"] = menuId;
PublicHelpController ph = new PublicHelpController();
if (userInfo.User.userName == "sa")
{
funName f = new funName();
System.Reflection.MemberInfo[] properties = f.GetType().GetMembers();
foreach (System.Reflection.MemberInfo item in properties)
{
string value = item.Name;
ViewData[value] = 1;
}
}
else
{
#region 功能列表
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.funList))
{
ViewData["funList"] = 0;//无功能列表权限
}
else
{
ViewData["funList"] = 1;//有功能列表权限
}
#endregion
#region 分配权限
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.menuFPQX))
{
ViewData["menuFPQX"] = 0;//无分配权限
}
else
{
ViewData["menuFPQX"] = 1;//有分配权限
}
#endregion
#region 查询
if (!ph.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), menuId, funName.menuCKQX))
{
List <model.persona> myList = new List <model.persona>();
return(View("../NoPermisson/Index"));
}
#endregion
}
//string menuIdC = getMenuId(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId));
string menuIdC = getMenuId(helpcommon.ParmPerportys.GetNumParms(id));
ViewData["menuIdC"] = menuIdC;
bll.menubll menuBll = new bll.menubll();
IDataParameter[] ipara = new IDataParameter[] {
//new SqlParameter("menuName",SqlDbType.NVarChar,20)
};
//ipara[0].Value = "张三";
List <model.menu> list = menuBll.getMenu(ipara, "menuSelectAllC");
return(View(list));
}
