示例#1
0
        public static bool Save(List <RightLkFunctionGroup> insertList, List <RightLkFunctionGroup> deleteList, List <RightLkFunctionGroup> updateList)
        {
            using (var conn = new SqlConnection(Conn.getConn()))
            {
                if (conn.State != ConnectionState.Open)
                {
                    conn.Open();
                }

                using (var trans = conn.BeginTransaction())
                {
                    foreach (var item in insertList)
                    {
                        var result = Insert(item, conn, trans);
                        if (result)
                        {
                            continue;
                        }

                        trans.Rollback();
                        return(false);
                    }
                    foreach (var item in updateList)
                    {
                        var result = Update(item, conn, trans);
                        if (result)
                        {
                            continue;
                        }

                        trans.Rollback();
                        return(false);
                    }
                    foreach (var item in deleteList)
                    {
                        var result = Delete(item, conn, trans);
                        if (result)
                        {
                            continue;
                        }

                        RightDal.Delete(item, conn, trans);

                        trans.Rollback();
                        return(false);
                    }

                    trans.Commit();
                }

                if (conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }

            return(true);
        }
示例#2
0
 public static bool UpdateRight(Right right, out string msg)
 {
     if (!RightDal.Update(right))
     {
         msg = "修改失败";
         return(false);
     }
     msg = "修改成功";
     return(true);
 }
示例#3
0
 public static bool InsertRight(Right right, out string msg)
 {
     if (!RightDal.Insert(right))
     {
         msg = "新增失败";
         return(false);
     }
     msg = "新增成功";
     return(true);
 }
示例#4
0
        public static bool Delete(RightFunction rightFunction)
        {
            using (var conn = new SqlConnection(Conn.getConn()))
            {
                if (conn.State != ConnectionState.Open)
                {
                    conn.Open();
                }

                using (var trans = conn.BeginTransaction())
                {
                    //1、删除功能信息
                    var result = Delete(rightFunction, conn, trans);
                    if (!result)
                    {
                        trans.Rollback();
                        return(false);
                    }
                    //2、删除当前功能对应的功能分组信息
                    RightLkFunctionGroupDal.DeleteByFunctionSysid(new RightLkFunctionGroup {
                        FunctionSysid = rightFunction.Sysid
                    }, conn, trans);

                    //3、删除当前功能对应的功能命令信息
                    RightLkFunctionCommandDal.DeleteByFunctionSysid(new RightLkFunctionCommand {
                        FunctionSysid = rightFunction.Sysid
                    }, conn, trans);

                    //4、删除当前功能对应的权限分配信息
                    RightDal.DeleteByFunctionSysid(new Right {
                        FunctionSysid = rightFunction.Sysid
                    }, conn, trans);

                    trans.Commit();
                }

                if (conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }

            return(true);
        }
示例#5
0
        public static bool Delete(RightUserGroup rightUserGroup)
        {
            using (var conn = new SqlConnection(Conn.getConn()))
            {
                if (conn.State != ConnectionState.Open)
                {
                    conn.Open();
                }

                using (var trans = conn.BeginTransaction())
                {
                    //1、删除用户组
                    var result = Delete(rightUserGroup, conn, trans);
                    if (!result)
                    {
                        trans.Rollback();
                        return(false);
                    }
                    //2、删除当前组对应的用户分组信息
                    RightLkUserGroupDal.DeleteByGroupSysid(new RightLkUserGroup {
                        GroupSysid = rightUserGroup.Sysid
                    }, conn, trans);

                    //3、删除当前组对应的权限分配信息
                    RightDal.DeleteByUserGroupSysid(new Right {
                        UserGroupSysid = rightUserGroup.Sysid
                    }, conn, trans);

                    trans.Commit();
                }

                if (conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }

            return(true);
        }
示例#6
0
 public static List <Right> QueryByCommandSysid(string commandSysid)
 {
     return(RightDal.QueryByCommandSysid(commandSysid));
 }
示例#7
0
 public static bool DeleteRight(Right right)
 {
     return(RightDal.Delete(right));
 }
示例#8
0
 public static Right QuerySingle(string sysid)
 {
     return(RightDal.QuerySingle(sysid));
 }
示例#9
0
 public static List <Right> QueryAll()
 {
     return(RightDal.QueryAll());
 }
示例#10
0
 public static List <Right> QueryByUserGroupSysid(string userGroupSysid)
 {
     return(RightDal.QueryByUserGroupSysid(userGroupSysid));
 }
示例#11
0
 public static List <RightMenu> QueryAllRightMenu()
 {
     return(RightDal.QueryAllRightMenu());
 }
示例#12
0
 public static bool Save(string userGroupSysid, List <Right> rights)
 {
     return(RightDal.Save(userGroupSysid, rights));
 }