Пример #1
0
        public static bool Delete(Right right)
        {
            const string sql = @"
            DELETE FROM T_RIGHT
            WHERE SYSID=@Sysid

            ";

            return Dapper.Save(right, sql);
        }
Пример #2
0
        public static bool DeleteByFunctionSysid(Right right, SqlConnection conn, SqlTransaction trans)
        {
            const string sql = @"
            DELETE FROM T_RIGHT
            WHERE FUNCTION_SYSID=@FunctionSysid

            ";

            return Dapper.Save(right, sql, conn, trans);
        }
Пример #3
0
 public static bool UpdateRight(Right right, out string msg)
 {
     if (!RightDal.Update(right))
     {
         msg = "修改失败";
         return false;
     }
     msg = "修改成功";
     return true;
 }
Пример #4
0
 public static bool InsertRight(Right right, out string msg)
 {
     if (!RightDal.Insert(right))
     {
         msg = "新增失败";
         return false;
     }
     msg = "新增成功";
     return true;
 }
Пример #5
0
        public static bool Insert(Right right)
        {
            const string sql = @"
            INSERT INTO T_RIGHT(SYSID,USER_GROUP_SYSID,FUNCTION_GROUP_SYSID,FUNCTION_SYSID,COMMAND_SYSID,CREATED_ON,CREATED_BY)
            VALUES(@Sysid,@UserGroupSysid,@FunctionGroupSysid,@FunctionSysid,@CommandSysid,CONVERT(NVARCHAR(50),GETDATE(),121),@CreatedBy)

            ";

            return Dapper.Save(right, sql);
        }
Пример #6
0
        public static bool DeleteByUserGroupSysid(Right right, SqlConnection conn, SqlTransaction trans)
        {
            const string sql = @"
            DELETE FROM T_RIGHT
            WHERE USER_GROUP_SYSID=@UserGroupSysid

            ";

            return Dapper.Save(right, sql, conn, trans);
        }
Пример #7
0
        public static bool Update(Right right, SqlConnection conn, SqlTransaction trans)
        {
            const string sql = @"
            UPDATE T_RIGHT
            SET USER_GROUP_SYSID=@UserGroupSysid,FUNCTION_GROUP_SYSID=@FunctionGroupSysid,FUNCTION_SYSID=@FunctionSysid,COMMAND_SYSID=@CommandSysid,CREATED_BY=@CreatedBy
            WHERE SYSID=@Sysid

            ";

            return Dapper.Save(right, sql, conn, trans);
        }
Пример #8
0
 public static bool DeleteRight(Right right)
 {
     return RightDal.Delete(right);
 }
Пример #9
0
        //用编辑框数据填充实体
        /// <summary>
        /// 用编辑框数据填充实体
        /// </summary>
        private List<Right> BuildEntity()
        {
            var rights = new List<Right>();

            var userGroupSysid = UI.GetValue(ddlUserGroup);
            foreach (var groupNode in treeRight.Nodes)
            {
                foreach (var functionNode in groupNode.Nodes)
                {
                    foreach (var commandNode in functionNode.Nodes)
                    {
                        if (!commandNode.Checked)
                            continue;
                        var rightMenu = commandNode.Tag as RightMenu;
                        if (rightMenu == null)
                            continue;
                        var right = new Right
                                        {
                                            Sysid = Sysid.NewId(""),
                                            UserGroupSysid = userGroupSysid,
                                            FunctionGroupSysid = rightMenu.GroupSysid,
                                            FunctionSysid = rightMenu.FunctionSysid,
                                            CommandSysid = rightMenu.CommandSysid,
                                            CreatedBy = GloableData.Instance.UserId
                                        };
                        rights.Add(right);
                    }
                }
            }

            return rights;
        }