public List <int> getUserFun(List <int> listMenuIdC) { string s = string.Empty; foreach (int item in listMenuIdC) { s += item + ","; } s = s.Length > 0 ? s.Remove(s.Length - 1, 1) : s; IDataParameter[] iparaFun = new IDataParameter[] { new SqlParameter("roleId", SqlDbType.Int, 4), new SqlParameter("menuId", SqlDbType.NVarChar, 500) }; iparaFun[0].Value = us.User.personaId; iparaFun[1].Value = s; List <int> listFunId = new List <int>(); //功能ID model.funpermisson funMd = new model.funpermisson(); bll.funPermissonbll funBll = new bll.funPermissonbll(); List <model.funpermisson> listFun = funBll.getFun(iparaFun, "funSelect"); foreach (var item in listFun) { listFunId.Add(item.Id); } if (listFun.Count == 0) { listFunId.Add(9999); } us.FunId = listFunId; return(listFunId); }
/// <summary> /// 获取功能名称 /// </summary> /// <returns></returns> public string getFunName1() { bll.funPermissonbll funPermissonBll = new bll.funPermissonbll(); int id = helpcommon.ParmPerportys.GetNumParms(Request.Form["funId"].ToString()); model.funpermisson mdFunpermisson = funPermissonBll.getFunName(id); return(mdFunpermisson.FunName); }
/// <summary> /// 得到一个对象实体 /// </summary> public List <model.funpermisson> DataRowToModel(DataRowCollection rowCollection) { List <model.funpermisson> list = new List <model.funpermisson>(); foreach (DataRow row in rowCollection) { model.funpermisson modelMd = new model.funpermisson(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { modelMd.Id = int.Parse(row["Id"].ToString()); } if (row["MenuId"] != null && row["MenuId"].ToString() != "") { modelMd.MenuId = int.Parse(row["MenuId"].ToString()); } if (row["FunName"] != null) { modelMd.FunName = row["FunName"].ToString(); } if (row["FunIndex"] != null && row["FunIndex"].ToString() != "") { modelMd.FunIndex = int.Parse(row["FunIndex"].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="id"></param> /// <returns></returns> public ActionResult editFun(int id, int MenuId) { ViewData["MenuId"] = MenuId; bll.funPermissonbll funPermissonBll = new bll.funPermissonbll(); IDataParameter[] ipara = new IDataParameter[] { new SqlParameter("id", SqlDbType.Int, 4) }; ipara[0].Value = id; //List<model.funpermisson> list = funPermissonBll.getFun(ipara, "funpermissonEdit"); model.funpermisson funpermissonMd = new model.funpermisson(); funpermissonMd = funPermissonBll.getFun(ipara, "funpermissonEdit")[0]; //funpermissonMd = list.Where(c => c.Id == id).ToList()[0]; return(View(funpermissonMd)); }
/// <summary> /// 删除功能 /// </summary> /// <param name="id"></param> /// <returns></returns> public string del(int id) { string s = string.Empty; try { model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(); model.funpermisson fun = (from c in context.funpermisson where c.Id == id select c).FirstOrDefault(); context.funpermisson.DeleteOnSubmit(fun); context.SubmitChanges(); s = "删除成功!"; } catch (Exception ex) { s = "删除失败!"; } return(s); }
/// <summary> /// 获取功能名称 /// </summary> /// <param name="id"></param> /// <returns></returns> public model.funpermisson getFunName(int id) { model.funpermisson mdFunpermisson = new model.funpermisson(); //model.ConnectionString md = new model.ConnectionString(); //var s = from c in md.funpermisson where c.Id == id select c; //foreach (var item in s) //{ // mdFunpermisson = item; //} //return mdFunpermisson; model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(); var s = from c in context.funpermisson where c.Id == id select c; foreach (var item in s) { mdFunpermisson = item; } return(mdFunpermisson); }
/// <summary> /// 获取功能名称 /// </summary> /// <param name="funId">功能ID</param> /// <returns></returns> public string getFunName(int funId) { bll.funPermissonbll funPermissonBll = new bll.funPermissonbll(); model.funpermisson mdFunpermisson = funPermissonBll.getFunName(funId); return(mdFunpermisson.FunName); }