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>
public List <model.menu> DataRowToModel(DataRowCollection rowCollection)
{
List <model.menu> list = new List <model.menu>();
foreach (DataRow row in rowCollection)
{
model.menu modelMd = new model.menu();
if (row != null)
{
if (row["Id"].ToString() != null && row["Id"].ToString() != "")
{
modelMd.Id = int.Parse(row["Id"].ToString());
}
if (row["menuName"] != null)
{
modelMd.menuName = row["menuName"].ToString();
}
if (row["MenuSrc"] != null)
{
modelMd.MenuSrc = row["MenuSrc"].ToString();
}
if (row["MenuLevel"] != null && row["MenuLevel"].ToString() != "")
{
modelMd.MenuLevel = int.Parse(row["MenuLevel"].ToString());
}
if (row["MenuIndex"] != null && row["MenuIndex"].ToString() != "")
{
modelMd.MenuIndex = int.Parse(row["MenuIndex"].ToString());
}
if (row["UserId"] != null && row["UserId"].ToString() != "")
{
modelMd.UserId = int.Parse(row["UserId"].ToString());
}
if (row["Def1"] != null)
{
modelMd.Def1 = row["Def1"].ToString();
}
if (row["Def2"] != null)
{
modelMd.Def2 = row["Def2"].ToString();
}
if (row["Def3"] != null)
{
modelMd.Def3 = row["Def3"].ToString();
}
if (row["Def4"] != null)
{
modelMd.Def4 = row["Def4"].ToString();
}
if (row["Def5"] != null)
{
modelMd.Def5 = row["Def5"].ToString();
}
}
list.Add(modelMd);
}
return(list);
}
/// <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 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);
}
public model.menu getMenuName(int id)
{
model.menu mdMenu = new model.menu();
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
var s = from c in context.menu where c.Id == id select c;
foreach (var item in s)
{
mdMenu = item;
}
return(mdMenu);
}
/// <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 del(int id)
{
string s = string.Empty;
try
{
model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext();
model.menu p = (from c in context.menu where c.Id == id select c).FirstOrDefault();
context.menu.DeleteOnSubmit(p);
context.SubmitChanges();
s = "删除成功！";
}
catch (Exception ex)
{
s = "删除失败！";
}
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);
}
