userpermissions.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

            }
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    RoleNodePermissionsInfo item = new RoleNodePermissionsInfo();
                    item.GroupId = reader.GetInt32("GroupID");
                    item.OperateCode = (OperateCode) reader.GetInt32("OperateCode");
                    item.NodeId = reader.GetInt32("NodeID");
                    list.Add(item);
                }
            }
            return list;
        }

        public IList<RoleFieldPermissionsInfo> GetFieldPermissionsById(int id, int modelId, string fieldName, int idType)
        {
            IList<RoleFieldPermissionsInfo> list = new List<RoleFieldPermissionsInfo>();
            Parameters cmdParams = new Parameters();
            string strCommand = "SELECT * FROM PE_GroupFieldPermissions WHERE 1=1 ";
            if (id > 0)
            {
                strCommand = strCommand + " AND GroupID =@GroupID ";
                cmdParams.AddInParameter("@GroupID", DbType.Int32, id);
            }
            if (modelId > 0)
            {
                strCommand = strCommand + " AND ModelId=@ModelId";
                cmdParams.AddInParameter("@ModelId", DbType.Int32, modelId);
            }
            if (!string.IsNullOrEmpty(fieldName))
            {
                strCommand = strCommand + " AND FieldName=@FieldName";
                cmdParams.AddInParameter("@FieldName", DbType.String, fieldName);
            }
            if (idType >= 0)
            {
                strCommand = strCommand + " AND IdType=@IdType ";
                cmdParams.AddInParameter("@IdType", DbType.Int32, idType);
            }
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    RoleFieldPermissionsInfo item = new RoleFieldPermissionsInfo();
                    item.RoleId = reader.GetInt32("GroupID");
                    item.OperateCode = (OperateCode) reader.GetInt32("OperateCode");
                    item.ModelId = reader.GetInt32("ModelID");
                    item.FieldName = reader.GetString("FieldName");
                    list.Add(item);
                }
            }
            return list;
        }

        public IList<int> GetGroupListByOperateCodeSpecialId(OperateCode operateCode, int specialId)
        {
            Parameters parms = new Parameters();
            parms.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            parms.AddInParameter("@SpecialId", DbType.Int32, specialId);
            string strSqlText = "SELECT GroupID FROM  PE_GroupSpecialPermissions WHERE  OperateCode=@OperateCode AND  SpecialId=@SpecialId";
            return CreateRoleList(parms, strSqlText);
        }

        public IList<RoleNodePermissionsInfo> GetNodePermissionsList(int id, int nodeId, OperateCode operateCode, int idType)
        {
            IList<RoleNodePermissionsInfo> list = new List<RoleNodePermissionsInfo>();
            Parameters cmdParams = new Parameters();
            string strCommand = "SELECT * FROM PE_GroupNodePermissions WHERE 1=1 ";
            if (id > 0)
            {
                strCommand = strCommand + " AND GroupID =@GroupID ";
                cmdParams.AddInParameter("@GroupID", DbType.Int32, id);
            }
            if (nodeId >= -1)
            {
                strCommand = strCommand + " AND NodeID =@NodeID ";
                cmdParams.AddInParameter("@NodeID", DbType.Int32, nodeId);
            }
            if (operateCode != OperateCode.None)
            {
                strCommand = strCommand + " AND OperateCode =@OperateCode ";
                cmdParams.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            }
            if (idType >= 0)
            {
                strCommand = strCommand + " AND IdType=@IdType ";
                cmdParams.AddInParameter("@IdType", DbType.Int32, idType);
            }
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    RoleNodePermissionsInfo item = new RoleNodePermissionsInfo();
                    item.GroupId = reader.GetInt32("GroupID");
                    item.OperateCode = (OperateCode) reader.GetInt32("OperateCode");
                    item.NodeId = reader.GetInt32("NodeID");
                    list.Add(item);
                }
            }
            return list;
        }

        public IList<int> GetRoleListByOperateCodeFieldName(OperateCode operateCode, int modelId, string fieldName)
        {
            Parameters parms = new Parameters();
            parms.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            parms.AddInParameter("@ModelID", DbType.Int32, modelId);
            parms.AddInParameter("@FieldName", DbType.String, fieldName);
            string strSqlText = "SELECT GroupId FROM PE_GroupFieldPermissions WHERE OperateCode=@OperateCode AND ModelID=@ModelID AND FieldName=@FieldName";
            return CreateRoleList(parms, strSqlText);
        }

        public IList<int> GetRoleListByOperateCodeNode(OperateCode operateCode, int nodeId)
        {
            Parameters parms = new Parameters();
            parms.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            parms.AddInParameter("@NodeID", DbType.Int32, nodeId);
            string strSqlText = "SELECT GroupID FROM PE_GroupNodePermissions WHERE  OperateCode=@OperateCode AND NodeID=@NodeID";
            return CreateRoleList(parms, strSqlText);
        }

        public IList<int> GetRoleListByOperateCodeNode(OperateCode operateCode, string nodeId)
        {
            Parameters parms = new Parameters();
            parms.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            string strSqlText = "SELECT GroupID FROM PE_GroupNodePermissions WHERE  OperateCode=@OperateCode AND NodeID in (" + nodeId + ")";
            return CreateRoleList(parms, strSqlText);
        }

        public string GetRoleNodeId(int roleId, OperateCode operateCode, int idType)
        {
            string strCommand = "select Distinct NodeID from PE_GroupNodePermissions where GroupID = @GroupID  And OperateCode = @OperateCode And IdType=@idType";
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@GroupID", DbType.Int32, roleId);
            cmdParams.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            cmdParams.AddInParameter("idType", DbType.Int32, idType);
            StringBuilder builder = new StringBuilder();
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    if (builder.Length > 0)
                    {
                        builder.Append("," + reader.GetInt32("NodeID").ToString());
                    }
                    else
                    {
                        builder.Append(reader.GetInt32("NodeID").ToString());
                    }
                }
            }
            return builder.ToString();
        }

        public IList<RoleSpecialPermissionsInfo> GetSpecialPermissionsList(int id, int specialId, OperateCode operateCode, int idType)
        {
            IList<RoleSpecialPermissionsInfo> list = new List<RoleSpecialPermissionsInfo>();
            Parameters cmdParams = new Parameters();
            string strCommand = "SELECT * FROM PE_GroupSpecialPermissions WHERE 1=1";
            if (id > 0)
            {
                strCommand = strCommand + " AND GroupID =@GroupID ";
                cmdParams.AddInParameter("@GroupID", DbType.Int32, id);
            }
            if ((specialId > 0) || (specialId == -1))
            {
                strCommand = strCommand + " AND SpecialID=@SpecialID ";
                cmdParams.AddInParameter("@SpecialID", DbType.Int32, specialId);
            }
            if (operateCode != OperateCode.None)
            {
                strCommand = strCommand + " AND  OperateCode=@OperateCode ";
                cmdParams.AddInParameter("@OperateCode", DbType.Int32, operateCode);
            }
            if (idType >= 0)
            {
                strCommand = strCommand + " AND IdType=@IdType ";
                cmdParams.AddInParameter("@IdType", DbType.Int32, idType);
            }
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    RoleSpecialPermissionsInfo item = new RoleSpecialPermissionsInfo();
                    item.GroupId = reader.GetInt32("GroupID");
                    item.OperateCode = (OperateCode) reader.GetInt32("OperateCode");
                    item.SpecialId = reader.GetInt32("SpecialID");
                    list.Add(item);
                }
            }
            return list;
        }
    }
}