/// <summary> /// 分配功能权限 /// </summary> /// <returns></returns> public string allotFun() { string roleId = Request.Form["roleId"]; int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]); string funId = Request.Form["funId"]; if (funId == null) { return("请选择需分配功能"); } string[] funIds = helpcommon.StrSplit.StrSplitData(funId, ','); string s = string.Empty; List <model.personapermisson> list = new List <model.personapermisson>(); bll.personapermissonbll personapermissonBll = new bll.personapermissonbll(); for (int i = 0; i < funIds.Length; i++) { if (!string.IsNullOrWhiteSpace(funIds[i])) { model.personapermisson mdPersonapermisson = new model.personapermisson(); mdPersonapermisson.personaId = helpcommon.ParmPerportys.GetNumParms(roleId); mdPersonapermisson.MemuId = menuId; mdPersonapermisson.FunId = helpcommon.ParmPerportys.GetNumParms(funIds[i]); if (!personapermissonBll.selectFunIsExists(helpcommon.ParmPerportys.GetNumParms(roleId), menuId, helpcommon.ParmPerportys.GetNumParms(funIds[i]))) { list.Add(mdPersonapermisson); } } } s = personapermissonBll.AddRolePersonapermisson(list); personapermissonBll = null; return(s); }
/// <summary> /// 复制角色权限 /// </summary> public string CopyUsers(string Id, string PersonaId) { try { model.pbxdatasourceDataContext context = new model.pbxdatasourceDataContext(); string sql = string.Empty; DataTable dt = new DataTable(); var q = from c in context.personapermisson where c.personaId == Convert.ToInt32(Id) select c; foreach (var item in q) { var person = new model.personapermisson() { personaId = Convert.ToInt32(PersonaId), MemuId = item.MemuId, FunId = item.FunId, FieldId = item.FieldId }; context.personapermisson.InsertOnSubmit(person); //sql = @"insert into personapermisson(personaId,MemuId,FunId,FieldId) values(" + Id + "," + item.MemuId + "," + Convert.ToInt32(item.FunId == null ? 0 : item.FunId) + "," + Convert.ToInt32(item.FieldId == null ? 0 : item.FieldId) + ")"; //DbHelperSQL.ExecuteSql(sql); } context.SubmitChanges(); return("复制成功!"); } catch (Exception ex) { return("复制失败!"); } }