コード例 #1
0
 public bool DeleteUser(string userId)
 {
     try
     {
         if (string.IsNullOrEmpty(userId))
         {
             return(false);
         }
         using (var db = new BCBackContext())
         {
             var temp = db.BackUsers.FirstOrDefault(obj => obj.UserID.Equals(userId));
             IQueryable <ML.BC.BCBackData.Model.UserRole> userrolelist;
             if (null != temp)
             {
                 userrolelist = db.UserRoles.Where(x => x.UserID == temp.UserID);
             }
             //                    db.BackUsers.Attach(temp);
             db.BackUsers.Remove(temp);
             return(0 < db.SaveChanges());
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }
コード例 #2
0
        public string AddRoleFunction(int roleID, string functionID)
        {
            try
            {
                if (string.IsNullOrEmpty(functionID))
                {
                    throw new KnownException("参数无效!");
                }

                using (var db = new BCBackContext())
                {
                    db.RFAAuthorizations.Add(new RFAAuthorization()
                    {
                        RoleID = roleID, FunctionID = functionID, UpdateTime = DateTime.Now
                    });
                    if (1 == db.SaveChanges())
                    {
                        return(functionID);
                    }
                    else
                    {
                        throw new KnownException();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #3
0
 public bool UpdateUser(Account.Dtos.UserDto user)
 {
     try
     {
         using (var db = new BCBackContext())
         {
             var temp = db.BackUsers.First(x => x.UserID == user.UserID);
             if (null == temp)
             {
                 throw new KnownException("该对象不存在");
             }
             temp.Closed = user.Closed;
             temp.Mobile = user.Mobile;
             if (!string.IsNullOrEmpty(user.Password))
             {
                 temp.Password = CryptoService.MD5Encrypt(user.Password);
             }
             temp.Name       = user.Name;
             temp.UpdateTime = DateTime.Now;
             return(0 < db.SaveChanges());
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }
コード例 #4
0
        public bool DeleteRole(int roleId)
        {
            try
            {
                if (0 > roleId)
                {
                    throw new KnownException();
                }

                using (var db = new BCBackContext())
                {
                    var fun  = db.RFAAuthorizations.Where(x => x.RoleID == roleId && !x.Deleted);
                    var role = db.UserRoles.FirstOrDefault(x => x.RoleID == roleId && !x.Deleted);
                    if (role != null)
                    {
                        throw new KnownException("该角色被占用,无法删除");
                    }
                    else
                    {
                        foreach (var f in fun)
                        {
                            f.Deleted = true;
                        }
                        role.Deleted = true;
                    }
                    //db.RFARoles.Attach(del);
                    //db.RFARoles.Remove(del);
                    return(0 < db.SaveChanges());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #5
0
 public bool DeleteRoleFunction(int roleID, string functionID)
 {
     try
     {
         if (string.IsNullOrEmpty(functionID))
         {
             throw new KnownException("参数无效!");
         }
         using (var db = new BCBackContext())
         {
             RFAAuthorization au = new RFAAuthorization {
                 RoleID = roleID, FunctionID = functionID
             };
             db.RFAAuthorizations.Attach(au);
             db.RFAAuthorizations.Remove(au);
             if (1 == db.SaveChanges())
             {
                 return(true);
             }
             else
             {
                 return(false);
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #6
0
 public List <int> GetAllRolesByUserId(string userId)
 {
     try
     {
         if (string.IsNullOrEmpty(userId))
         {
             throw new KnownException("用户id输入有误");
         }
         List <int> list = new List <int>();
         if (string.IsNullOrEmpty(userId))
         {
             return(null);
         }
         using (var db = new BCBackContext())
         {
             list = db.UserRoles.Where(obj => obj.UserID == userId && !obj.Deleted).Select(obj => obj.RoleID).ToList();
             list = db.RFARoles.Where(obj => list.Contains(obj.RoleID) && obj.Available).Select(o => o.RoleID).ToList();
         }
         return(list);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #7
0
 public bool DeleteUserRole(string userID, int roleID)
 {
     try
     {
         if (string.IsNullOrEmpty(userID))
         {
             throw new KnownException("传递参数有误!");
         }
         using (var db = new BCBackContext())
         {
             var del = new UserRole()
             {
                 UserID = userID, RoleID = roleID
             };
             db.UserRoles.Attach(del);
             db.UserRoles.Remove(del);
             if (1 == db.SaveChanges())
             {
                 return(true);
             }
             else
             {
                 return(false);
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #8
0
 public string CreateUser(Account.Dtos.UserDto userDto)
 {
     using (var db = new BCBackContext())
     {
         if (string.IsNullOrEmpty(userDto.Password))
         {
             throw new KnownException("密码不允许为空");
         }
         var uid  = Ioc.GetService <ML.BC.Services.Common.IUniqeIdGenerator>().GeneratorBackUserID();
         var user = new BackUser
         {
             UserID     = uid,
             Name       = userDto.Name,
             Password   = CryptoService.MD5Encrypt(userDto.Password),
             Mobile     = userDto.Mobile,
             RegistDate = DateTime.Now,
             Closed     = userDto.Closed,
             UpdateTime = DateTime.Now
         };
         db.BackUsers.Add(user);
         if (db.SaveChanges() > 0)
         {
             return(user.UserID);
         }
         else
         {
             return(null);
         }
     }
 }
コード例 #9
0
 /// <summary>
 /// 生成后台用户ID
 /// </summary>
 /// <param name="length">字符串长度默认6</param>
 /// <returns></returns>
 public virtual string GeneratorBackUserID(uint length = 6)
 {
     try
     {
         if (string.IsNullOrEmpty(_backUserID))
         {
             using (var db = new BCBackContext())
             {
                 _backUserID = db.BackUsers.Max(x => x.UserID);
                 if (!IsAvailableId(_backUserID))
                 {
                     throw new KnownException("数据库Max值Id不合法,请检查数据库!");
                 }
             }
             //  当数据库不存在任何ID时候,自动生成最小字符串
             if (string.IsNullOrEmpty(_backUserID))
             {
                 length      = length <= 6 ? 6 : length;
                 _backUserID = GetMinString(length);
             }
         }
         lock (_backUserID)
         {
             _backUserID = GetNextStringID(_backUserID);
         }
         return(_backUserID);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #10
0
        public int AddRole(RolesDto role)
        {
            try
            {
                if (null == role)
                {
                    throw new KnownException();
                }

                if (!string.IsNullOrEmpty(role.FunctionIDs))
                {
                    using (var db = new BCBackContext())
                    {
                        //  事务处理RoleFunction表添加成功和RFARole表添加成功需要同时满足。
                        using (TransactionScope transaction = new TransactionScope())
                        {
                            db.RFARoles.Add(role);
                            db.SaveChanges();
                            var roleId = db.RFARoles.Where(obj => obj.Name == role.Name).Select(obj => obj.RoleID).ToList();
                            if (0 >= roleId.First())
                            {
                                throw new KnownException("保存角色失败!");
                            }

                            //  db.SaveChange()已在SetFunctin函数执行
                            var result = SetFunction(roleId.First(), role.FunctionIDs);
                            if (null == result)
                            {
                                throw new KnownException("保存角色功能失败!");
                            }
                            else
                            {
                                transaction.Complete();
                                return(role.RoleID);
                            }
                        }
                    }
                }

                using (var db = new BCBackContext())
                {
                    db.RFARoles.Add(role);
                    if (1 == db.SaveChanges())
                    {
                        return(role.RoleID);
                    }
                    else
                    {
                        throw new KnownException("角色保存失败!");
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #11
0
 public bool CanLogin(string userId, string password)
 {
     using (var db = new BCBackContext())
     {
         var user      = db.BackUsers.FirstOrDefault(n => n.UserID == userId);
         var encedpass = CryptoService.MD5Encrypt(password);
         return(user != null && user.Closed == false &&
                user.Password == encedpass);
     }
 }
コード例 #12
0
 public bool UpdateUserLogin(string userId, string lastIP)
 {
     using (var db = new BCBackContext())
     {
         var user = db.BackUsers.First(n => n.UserID == userId);
         user.LastDate   = DateTime.Now;
         user.LastIP     = lastIP;
         user.UpdateTime = DateTime.Now;
         db.Entry <BackUser>(user).State = System.Data.Entity.EntityState.Modified;
         return(db.SaveChanges() > 0);
     }
 }
コード例 #13
0
        private List <AuthorizationsDto> SetFunction(int roleID, string functionIDs)
        {
            try
            {
                if (0 > roleID || string.IsNullOrEmpty(functionIDs))
                {
                    throw new KnownException("参数无效!");
                }
                //  返回设置完成后的角色功能信息
                var list = new List <AuthorizationsDto>();

                var strS    = functionIDs.Split('|');
                var listFuc = strS.ToList();

                using (var db = new BCBackContext())
                {
                    foreach (var funId in listFuc)
                    {
                        //  更新或者添加功能
                        var au = new RFAAuthorization()
                        {
                            RoleID = roleID, FunctionID = funId, UpdateTime = DateTime.Now
                        };
                        db.RFAAuthorizations.AddOrUpdate(au);
                    }

                    //  删除不再具有的功能
                    var query = db.RFAAuthorizations.Where(obj => obj.RoleID == roleID).Select(obj => obj.FunctionID).ToList();
                    foreach (var f in query)
                    {
                        if (!listFuc.Contains(f))
                        {
                            var del = db.RFAAuthorizations.FirstOrDefault(obj => obj.RoleID == roleID && obj.FunctionID == f);
                            db.RFAAuthorizations.Remove(del);
                        }
                    }

                    if (0 < db.SaveChanges())
                    {
                        foreach (var fun in listFuc)
                        {
                            list.Add(db.RFAAuthorizations.FirstOrDefault(obj => obj.RoleID == roleID && obj.FunctionID == fun));
                        }
                    }
                }
                return(list);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #14
0
 public int GetAmount()
 {
     try
     {
         using (var db = new BCBackContext())
         {
             return(db.RFAFunctions.Count());
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }
コード例 #15
0
 public bool ExistFunction(string funcId)
 {
     try
     {
         using (var db = new BCBackContext())
         {
             return(db.RFAFunctions.Where(obj => obj.FunctionID.Equals(funcId)).Count() == 1);
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }
コード例 #16
0
 public int GetAmount(System.Linq.Expressions.Expression <Func <BackUser, bool> > filter)
 {
     try
     {
         using (var db = new BCBackContext())
         {
             return(db.BackUsers.Count(filter));
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }
コード例 #17
0
        public List <Account.Dtos.UserDto> GetList(int pageNumber, int pageSize, out int amount)
        {
            try
            {
                using (var db = new BCBackContext())
                {
                    var list = db.BackUsers.Select(obj => new Account.Dtos.UserDto
                    {
                        UserID     = obj.UserID,
                        Name       = obj.Name,
                        Mobile     = obj.Mobile,
                        LastIP     = obj.LastIP,
                        LastDate   = obj.LastDate,
                        Password   = obj.Password,
                        UpdateTime = obj.UpdateTime,
                        Closed     = obj.Closed,
                        RegistDate = obj.RegistDate
                    });
                    int pagecount;
                    amount = list.Count();
                    if (pageSize > 0)
                    {
                        // 获取总共页数
                        pagecount = (list.Count() + pageSize - 1) / pageSize;
                    }
                    else
                    {
                        pagecount = 0;
                    }
                    //页码判断,小于1则为1,大于最大页码则为最大页码
                    if (pageNumber > pagecount)
                    {
                        pageNumber = pagecount;
                    }
                    if (pageNumber < 1)
                    {
                        pageNumber = 1;
                    }

                    return(list.OrderBy(x => x.UserID).Skip(pageSize * (pageNumber - 1)).Take(pageSize).ToList());
                }
            }
            catch (Exception e)
            {
                throw e;
            }
        }
コード例 #18
0
        //public int Delete(string FunctionID)
        //{
        //    using (var db = new BCBackContext())
        //    {
        //        RFAFunction temp = db.RFAFunctions.FirstOrDefault(x => x.FunctionID == FunctionID);

        //        if (null == temp)
        //            return 0;

        //        db.RFAFunctions.Remove(temp);

        //        Action<string> deleteChildren = null;
        //        deleteChildren = (parentId) =>
        //        {
        //            List<RFAFunction> list = db.RFAFunctions.Where(x => x.ParentID == FunctionID).ToList<RFAFunction>();
        //            for (int i = 0; i < list.Count; i++)
        //            {
        //                var tempFunction = list[i];
        //                db.RFAFunctions.Remove(tempFunction);
        //                deleteChildren(tempFunction.FunctionID);
        //            }
        //        };
        //        deleteChildren(temp.FunctionID);

        //        return db.SaveChanges();
        //    }
        //}

        public int Add(FunctionDto obj)
        {
            using (var db = new BCBackContext())
            {
                RFAFunction temp = new RFAFunction();

                temp.FunctionID = obj.FunctionID;
                temp.MyID       = obj.MyID;
                temp.Name       = obj.Name;
                temp.ParentID   = obj.ParentID;
                temp.Available  = obj.Available;
                temp.Desription = obj.Desription;

                db.RFAFunctions.Add(temp);
                //                db.Entry<RFAFunction>(temp).State = EntityState.Added;

                return(db.SaveChanges());
            }
        }
コード例 #19
0
        //public List<RFAFunction> Select(Expression<Func<RFAFunction, bool>> foo)
        //{
        //    using (var db = new BCBackContext())
        //    {
        //        List<RFAFunction> list = new List<RFAFunction>();
        //        list = db.RFAFunctions.Where(foo).ToList<RFAFunction>();
        //        return list;
        //    }
        //}

        public int Update(FunctionDto obj)
        {
            using (var db = new BCBackContext())
            {
                RFAFunction temp = db.RFAFunctions.Where(objx => objx.FunctionID.Equals(obj.FunctionID)).First();
                if (temp == null)
                {
                    return(0);
                }
                //temp.FunctionID = obj.FunctionID;
                temp.MyID = obj.MyID;
                temp.Name = obj.Name;
                //temp.ParentID = obj.ParentID;
                temp.Available  = obj.Available;
                temp.Desription = obj.Desription;

                return(db.SaveChanges());
            }
        }
コード例 #20
0
 public Account.Dtos.UserDto Get(string username)
 {
     using (var db = new BCBackContext())
     {
         var user = db.BackUsers.Where(n => n.Name == username)
                    .Select(n => new Account.Dtos.UserDto
         {
             UserID     = n.UserID,
             Name       = n.Name,
             Mobile     = n.Mobile,
             RegistDate = n.RegistDate,
             LastDate   = n.LastDate,
             LastIP     = n.LastIP,
             Closed     = n.Closed,
             UpdateTime = n.UpdateTime,
         }).FirstOrDefault();
         return(user);
     }
 }
コード例 #21
0
        public bool UpdateRole(RolesDto role)
        {
            try
            {
                if (null == role || 0 > role.RoleID)
                {
                    throw new KnownException("关键信息缺失,无法更新!");
                }

                using (var db = new BCBackContext())
                {
                    using (TransactionScope transaction = new TransactionScope())
                    {
                        var temp = db.RFARoles.FirstOrDefault(obj => obj.RoleID == role.RoleID);
                        if (null == temp)
                        {
                            throw new KnownException("不存在该记录,无法更新");
                        }

                        temp.Name        = role.Name;
                        temp.OwnerID     = role.OwnerID;
                        temp.Description = role.Description;
                        temp.Available   = role.Available;
                        db.SaveChanges();

                        var auths = SetFunction(role.RoleID, role.FunctionIDs);
                        if (auths == null || auths.Count <= 0)
                        {
                            throw new KnownException("角色功能信息更新失败!");
                        }

                        transaction.Complete();
                        return(true);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #22
0
        public List <string> GetAllFunctionIDByRoleID(int roleID)
        {
            try
            {
                if (0 > roleID)
                {
                    throw new KnownException("参数无效!");
                }

                var list = new List <string>();
                using (var db = new BCBackContext())
                {
                    list = db.RFAAuthorizations.Where(obj => obj.RoleID == roleID).Select(obj => obj.FunctionID).ToList();
                    return(list);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #23
0
 public List <RolesDto> GetAllRoles()
 {
     try
     {
         using (var db = new BCBackContext())
         {
             var list = db.RFARoles.Where(obj => null != obj && obj.Available).Select(obj => new RolesDto
             {
                 RoleID    = obj.RoleID,
                 Name      = obj.Name,
                 Available = obj.Available,
                 OwnerID   = obj.OwnerID
             }).ToList();
             return(list);
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
コード例 #24
0
        public string AddUserRole(string userID, int roleID)
        {
            try
            {
                if (string.IsNullOrEmpty(userID))
                {
                    throw new KnownException("传递参数有误!");
                }

                using (var db = new BCBackContext())
                {
                    if (!db.BackUsers.Any(obj => obj.UserID == userID))
                    {
                        throw new KnownException("不存在的用户ID无法添加用户角色!");
                    }
                    if (!db.RFARoles.Any(obj => obj.RoleID == roleID))
                    {
                        throw new KnownException("不存在的角色ID无法添加用户角色!");
                    }

                    db.UserRoles.Add(new UserRole()
                    {
                        UserID = userID, RoleID = roleID, UpdateTime = DateTime.Now
                    });
                    var re = db.SaveChanges();
                    if (1 == re)
                    {
                        return(userID);
                    }
                    else
                    {
                        throw new KnownException();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #25
0
        public bool Delete(string FunctionID)
        {
            using (var db = new BCBackContext())
            {
                return(0 < DeleteFunctionsons(db, FunctionID));
                //RFAFunction temp = db.RFAFunctions.FirstOrDefault(x => x.FunctionID == FunctionID);

                //if (null == temp)
                //    return 0;

                //db.RFAFunctions.Remove(temp);

                //List<RFAFunction> list = db.RFAFunctions.Where(x => x.ParentID == FunctionID).ToList<RFAFunction>();

                //for (int i = 0; i < list.Count; i++)
                //{
                //    if (0 == Delete(list[i].FunctionID))
                //        break;
                //}
                //                return db.SaveChanges();
            }
        }
コード例 #26
0
        public bool UpdateRoleFunction(int roleID, string functionID, bool available)
        {
            if (string.IsNullOrEmpty(functionID))
            {
                throw new KnownException("更新信息不全!");
            }
            using (var db = new BCBackContext())
            {
                var q = db.RFAAuthorizations.FirstOrDefault(obj => obj.RoleID == roleID && obj.FunctionID == functionID);
                if (null == q)
                {
                    throw new KnownException("该记录不存在!");
                }

                db.RFAAuthorizations.AddOrUpdate(new RFAAuthorization()
                {
                    RoleID = roleID, FunctionID = functionID, UpdateTime = DateTime.Now
                });

                return(1 == db.SaveChanges());
            }
        }
コード例 #27
0
        private int DeleteFunctionsons(BCBackContext db, string FunctionID)
        {
            RFAFunction temp = db.RFAFunctions.FirstOrDefault(x => x.FunctionID.Equals(FunctionID));

            if (null == temp)
            {
                return(0);
            }

            db.RFAFunctions.Remove(temp);

            List <RFAFunction> list = db.RFAFunctions.Where(x => x.ParentID.Equals(FunctionID)).ToList <RFAFunction>();

            for (int i = 0; i < list.Count; i++)
            {
                if (0 == DeleteFunctionsons(db, list[i].FunctionID))
                {
                    break;
                }
            }
            return(db.SaveChanges());
        }
コード例 #28
0
 public List <FunctionDto> GetAllFunctions()
 {
     try
     {
         using (var db = new BCBackContext())
         {
             var list = db.RFAFunctions.Select(n => new FunctionDto
             {
                 FunctionID = n.FunctionID,
                 MyID       = n.MyID,
                 ParentID   = n.ParentID,
                 Name       = n.Name,
                 Desription = n.Desription,
                 Available  = n.Available
             }).ToList();
             return(list);
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }
コード例 #29
0
        public List <RolesDto> GetRoleList(RolesDto model, int pageSize, int pageIndex, out int count)
        {
            try
            {
                RolesDto m;

                //  为空时,查询所有结果
                if (null == model)
                {
                    m = new RolesDto()
                    {
                        RoleID = 0, Name = "", Description = ""
                    };
                    model = m;
                }

                using (var db = new BCBackContext())
                {
                    var query = db.RFARoles.Where(r =>
                                                  (model.RoleID > 0 ? r.RoleID == model.RoleID : true) &&
                                                  (!string.IsNullOrEmpty(model.Name) ? r.Name.Contains(model.Name) : true) &&
                                                  (!string.IsNullOrEmpty(model.Description) ? r.Description.Contains(model.Description) : true));

                    count = query.Count();
                    int pageTotal;

                    if (pageSize > 0)
                    {
                        pageTotal = (count + pageSize - 1) / pageSize;
                    }
                    else
                    {
                        pageSize  = 10;
                        pageTotal = (count + pageSize - 1) / pageSize;
                    }

                    if (pageIndex > pageTotal)
                    {
                        pageIndex = pageTotal;
                    }
                    if (pageIndex < 1)
                    {
                        pageIndex = 1;
                    }

                    var list = query
                               .OrderBy(obj => obj.RoleID)
                               .Skip(pageSize * (pageIndex - 1))
                               .Take(pageSize)
                               .Select(obj => new RolesDto()
                    {
                        RoleID      = obj.RoleID,
                        Name        = obj.Name,
                        OwnerID     = obj.OwnerID,
                        Description = obj.Description,
                        Available   = obj.Available
                    }).ToList();

                    return(list);

                    #region 注释无用代码


                    //  转为List<RoleDto>并返回
                    //int len = list.Count();
                    //List<RolesDto> listDto = new List<RolesDto>();
                    //
                    //
                    //for (int i = 0; i < len; i++)
                    //{
                    //
                    //    listDto[i] = list[i];
                    //}
                    //return listDto;

                    //List<RolesDto> listDto = new List<RolesDto>();
                    //foreach (var rfaRole in list)
                    //{
                    //    listDto[outCount] = list[outCount];
                    //    outCount++;
                    //}
                    //
                    //count = outCount;
                    //return listDto;
                    #endregion
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #30
0
 public List <FunctionDto> GetAllFunctions(string nameKeyword, int psize, int pageidx)
 {
     try
     {
         using (var db = new BCBackContext())
         {
             if (psize <= 0 || pageidx <= 0)
             {
                 return(new List <FunctionDto>());
             }
             IEnumerable <RFAFunction> tResult;
             if (nameKeyword == null || nameKeyword.Equals(""))
             {
                 tResult = db.RFAFunctions;
             }
             else
             {
                 tResult = db.RFAFunctions.Where(obj => obj.Name.Contains(nameKeyword));
             }
             //tResult.c
             int count     = tResult.Count();
             int pageCount = (count + psize - 1) / psize;
             if (pageCount < pageidx)
             {
                 //if pageidx is overflow return the last page
                 return(tResult.OrderBy(x => x.FunctionID).Skip((pageCount - 1) * psize).Select(n => new FunctionDto
                 {
                     FunctionID = n.FunctionID,
                     MyID = n.MyID,
                     ParentID = n.ParentID,
                     Name = n.Name,
                     Desription = n.Desription,
                     Available = n.Available
                 }).ToList());;
             }
             else
             {
                 //return tResult.
                 return(tResult.OrderBy(x => x.FunctionID).Skip((pageidx - 1) * psize).Take(psize).Select(n => new FunctionDto
                 {
                     FunctionID = n.FunctionID,
                     MyID = n.MyID,
                     ParentID = n.ParentID,
                     Name = n.Name,
                     Desription = n.Desription,
                     Available = n.Available
                 }).ToList());;
             }
             //var list = db.RFAFunctions.Where(lambda).AsEnumerable().Select(n => new FunctionDto
             //{
             //    FunctionID = n.FunctionID,
             //    MyID = n.MyID,
             //    ParentID = n.ParentID,
             //    Name = n.Name,
             //    Desription = n.Desription,
             //    Available = n.Available
             //}).ToList();
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }